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

[Florian Bogeschdorfer]

In vstudio? Have nothing else... 

Florian Bogeschdorfer
——————————————————————————————
e-mail  fb at memedia.de 
fon(E)  +34 680 75 19 77 (nur bei Aufenthalt in Spanien)
fon(D)  +49 173 58 44 26 0 (nur bei Aufenthalt außerhalb Spaniens)
skype   florian.bogeschdorfer
skype.in  +49 561 98 77 84 0
——————————————————————————————
m e m e d i a
Agentur für Neue Medien
Weinbauernstraße 12a
D-81539 München 

e-mail  info at memedia.de
fon     089 – 899 480 9 – 48 
fax     089 – 899 480 9 – 49
—————————————————————————————


>-----Original Message-----
>From: valentina-bounces at lists.macserve.net [mailto:valentina-
>bounces at lists.macserve.net] On Behalf Of Sergey Maloshuk
>Sent: Tuesday, February 27, 2007 7:06 PM
>To: valentina at lists.macserve.net
>Subject: Server crash on attempt to make a SELECT on two tables while one
>ofthem is empty
>
>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
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina