Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean
expresions
----------------------------------------------------------------------------------------
Key: CORE-4791
URL: http://tracker.firebirdsql.org/browse/CORE-4791
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Affects Versions: 3.0 Beta 1, 3.0 Alpha 2, 3.0 Alpha 1
Reporter: Adriano dos Santos Fernandes
Boolean expressions was created with this bad ambiguity:
For compatibility reasons, the names INSERTING, UPDATING and DELETING (which
aren't keywords)
work (like in 2.5 and previous) as boolean expressions and work as values
(column or
variable) in non-booleans expressions. For example, in:
SELECT INSERTING, NOT INSERTING FROM TEST WHERE INSERTING AND INSERTING IS TRUE
the INSERTING's are respectively recognized as value, keyword, keyword and
value.
Now, making these words reserved removes the boolean expression problem, so
that:
- Non trigger-usage (column, variable, parameter name) of these words must be
quoted
- Database restored preserve the functionality until the code is manually
changed
Compatibility note:
- Who uses them in triggers outside of boolean expressions, will have a code
meaning a different thing, as the previous usage as column/variable/parameter
name will be transformed to a boolean expression related to the trigger action.
Double quoting them in this context makes the code work as before.
--
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
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
