Server crash on attempt to make a SELECT on two tables while one of
them is empty
Sergey Maloshuk
slsam at tut.by
Tue Feb 27 12:06:26 CST 2007
Hi,
Please reproduce the following situation. We have a server crash on this:
create table t1 (f1 integer, t2 boolean)
create table t2 (f1 integer, t2 boolean)
insert into t1 (f1, f2) values (1, 1)
SELECT t1.f1 from t1, t2
WHERE
t1.f1 = t2.f1
AND t1.f1=1
SELECT leads to server crash with unhandled exception.
Only when "AND t1.f1=1" part of request presents and t2 table is empty.
--
Thanks,
Sergey
More information about the Valentina
mailing list