21.03.2014 19:31, Norbert wrote: > > 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;
Obviously a bug. Working on it, thanks. Dmitry ------------------------------------------------------------------------------ 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
