Hi all,

I found a bug in Firebird (both 1.0.0.796 and 1.0.2) which is similar with
[ 483795 ] Query using VIEW with UNION causes crash

483795 is fixed by Claudio, but I have even simpler case, that crashes the server. Here's it is:

create table test1
(
id char(10) not null,
primary key(id)
);

create table test2
(
id char(10) not null,
primary key(id)
);

create table test3
(
id char(10) not null,
primary key(id)
);

create view testview (id)
as
select id from test1
union all
select id from test2;

commit;

select * from test3 where id not in (select id from testview);

And the server crashes. Client looses connection.

I consider this a serous bug, it looks like one cannot use IN with Views.
I someone can confirm this bug so I should add it to the bug-tracker.

Milan Babuskov
http://fbexport.sourceforge.net




[Non-text portions of this message have been removed]