second condition after a between condition raise error (Invalid usage of
boolean expression)
---------------------------------------------------------------------------------------------
Key: CORE-4227
URL: http://tracker.firebirdsql.org/browse/CORE-4227
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Alpha 1
Environment: Windows 64 bits SuperServer
Reporter: Evelyne Girard
Priority: Minor
With Firebird 3.0 a secondary condition after a between condition is not
accepted (due to new Boolean type presumably) whereas it is accepted 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
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
