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