BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported" ---------------------------------------------------------------------------------------
Key: CORE-3530 URL: http://tracker.firebirdsql.org/browse/CORE-3530 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.1.4 Reporter: Sean Leyne Using BETWEEN operand/clause against a COMPUTED column in a SELECT statement results in the engine reporting "feature is not supported". Yet, other comparisons work with COMPUTED columns without issue. For example: A_Computed_Column > 1, or A_Computed_Column => 1, or A_Computed_Column < 12, or A_Computed_Column <= 12, or A_Computed_Column LIKE '1%', or A_Computed_Column STARTING WITH '1', or A_Computed_Column ENDING WITH '1', or A_Computed_Column CONTAINING '1' are valid and executed by the engine. But A_Computed_Column BETWEEN 1 AND 12 is rejected. -- 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 ------------------------------------------------------------------------------ EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel