Yes, this is correct. SQL specification defines this behaviour.
On 2016.12.07. 14:24, Slavomir Skopalik wrote: > Hi, > > is it correct that empty string '' in comparison with one space string ' > ' is evaluated as true? > > SELECT * FROM rdb$database WHERE ''=' ' > > FB 2.5.6, database dialect 1 > > Slavek > > ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today.http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
