[
https://issues.apache.org/jira/browse/CALCITE-1759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-1759:
---------------------------------
Description:
Add SQL:2014 reserved words to parser.
SQL:2014 added the following reserved words (over SQL:2011):
ARRAY_MAX_CARDINALITY, BEGIN_FRAME, BEGIN_PARTITION, CLASSIFIER, CURRENT_ROW,
DEFINE, EMPTY, END_FRAME, END_PARTITION, FRAME_ROW, GROUPS, INITIAL, MATCHES,
MATCH_NUMBER, MATCH_RECOGNIZE, OMIT, ONE, PATTERN, PER, PERCENT, PERIOD,
PORTION, RUNNING, SEEK, SHOW, SKIP, SUBSET, SYSTEM_TIME, VALUE_OF. With this
change, all of these are now reserved in Calcite. Some of them were reserved
already (e.g. due to CALCITE-1641).
SQL:2014 removed: DAYS, FOREVER, HOURS, KEEP, MAX_CARDINALITY, MINUTES,
SECONDS. None of these were reserved in Calcite, and that remains the case.
The following became reserved in SQL:2011, and are now reserved in Calcite:
LAG, LEAG, LIKE_REGEX, NTH_VALUE, NTILE, OCCURRENCES_REGEX, POSITION_REGEX,
SUBSTRING_REGEX, TRANSLATE_REGEX, TRIM_ARRAY, TRUNCATE, VERSIONING.
was:
Add SQL:2014 reserved words to parser.
SQL:2014 added the following reserved words (over SQL:2011):
ARRAY_MAX_CARDINALITY, BEGIN_FRAME, BEGIN_PARTITION, CLASSIFIER, CURRENT_ROW,
DEFINE, EMPTY, END_FRAME, END_PARTITION, FRAME_ROW, GROUPS, INITIAL, MATCHES,
MATCH_NUMBER, MATCH_RECOGNIZE, OMIT, ONE, PATTERN, PER, PERCENT, PERIOD,
PORTION, RUNNING, SEEK, SHOW, SKIP, SUBSET, SYSTEM_TIME, VALUE_OF. With this
change, all of these are now reserved in Calcite. Some of them were reserved
already (e.g. due to CALCITE-1641).
SQL:2014 removed: DAYS, FOREVER, HOURS, KEEP, MAX_CARDINALITY, MINUTES,
SECONDS. None of these were reserved in Calcite.
> Add SQL:2014 reserved words to parser
> -------------------------------------
>
> Key: CALCITE-1759
> URL: https://issues.apache.org/jira/browse/CALCITE-1759
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Fix For: 1.13.0
>
>
> Add SQL:2014 reserved words to parser.
> SQL:2014 added the following reserved words (over SQL:2011):
> ARRAY_MAX_CARDINALITY, BEGIN_FRAME, BEGIN_PARTITION, CLASSIFIER, CURRENT_ROW,
> DEFINE, EMPTY, END_FRAME, END_PARTITION, FRAME_ROW, GROUPS, INITIAL, MATCHES,
> MATCH_NUMBER, MATCH_RECOGNIZE, OMIT, ONE, PATTERN, PER, PERCENT, PERIOD,
> PORTION, RUNNING, SEEK, SHOW, SKIP, SUBSET, SYSTEM_TIME, VALUE_OF. With this
> change, all of these are now reserved in Calcite. Some of them were reserved
> already (e.g. due to CALCITE-1641).
> SQL:2014 removed: DAYS, FOREVER, HOURS, KEEP, MAX_CARDINALITY, MINUTES,
> SECONDS. None of these were reserved in Calcite, and that remains the case.
> The following became reserved in SQL:2011, and are now reserved in Calcite:
> LAG, LEAG, LIKE_REGEX, NTH_VALUE, NTILE, OCCURRENCES_REGEX, POSITION_REGEX,
> SUBSTRING_REGEX, TRANSLATE_REGEX, TRIM_ARRAY, TRUNCATE, VERSIONING.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
