Salut, WI-T6.3.0.30932 Firebird 3.0 Alpha 2
on CENTOS 6.5 and W7 create table test ( id integer generated by default as identity primary key, siteid integer not null); create index ix_test_siteid on test (siteid); insert into test ( siteid ) values (3); insert into test ( siteid ) values (2); insert into test ( siteid ) values (1); select first 1 * from test where siteid =-1 or ( -1 = -1) order by siteid; result null null; select first 1 * from test where siteid =-1 or ( -1 = -1); result 1 3 select first 1 * from test where siteid =-1 or ( -1 = -1) why ?? Norbert -- .. TetraSys http://www.tetrasys.eu ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
