Server crash on attempt to make a SELECT on two tables while one of them is empty

[Ruslan Zasukhin]

On 27/2/07 8:06 PM, "Sergey Maloshuk" <slsam at tut.by> wrote:

> 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.

Ivan have test this on latest Vserver -- no problems.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]