On 17/09/2013 16:44, Evelyne Girard wrote: > > Hi, > > > > With Firebird 3.0 a secondary condition after a between condition is > not accepted (due to new Boolean type presumably) whereas it was in > Firebird 2.5 > > I do not know if it is « as designed » but I did not see any warning > about this in the release notes. > > > > select * from rdb$database where rdb$relation_id between 1 and 500 and > rdb$description is null; --Is working in FB2.5 and give « Invalid > usage of boolean expression. » in Firebird 3.0 > > select * from rdb$database where rdb$description is null and > rdb$relation_id between 1 and 500; -- Is working in both versions. > > > > Fixed. Please test in the next snapshot.
Adriano ------------------------------------------------------------------------------ LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel