Adolfo Ochagavía created CALCITE-5067:
-----------------------------------------
Summary: Support using "LANGUAGE" as a variable name (like MySQL)
Key: CALCITE-5067
URL: https://issues.apache.org/jira/browse/CALCITE-5067
Project: Calcite
Issue Type: Improvement
Components: core
Reporter: Adolfo Ochagavía
In MySQL it is possible to use "LANGUAGE" as a variable name. The example below
shows the difference between language (treated as a variable) and other
keywords (which raise a syntax error):
{code:java}
mysql> SELECT LANGUAGE;
ERROR 1054 (42S22): Unknown column 'LANGUAGE' in 'field list'
mysql> SELECT ALTER;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'ALTER' at line 1{code}
See, for context, [this
thread|https://lists.apache.org/thread/lnln25csnbs9yqlskjq2pnqx3f1rdfw5].
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
