[
https://issues.apache.org/jira/browse/CALCITE-5393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhengqiang Duan updated CALCITE-5393:
-------------------------------------
Description:
Hello, community, I found that in MySQL, VALUE can be used as a synonym for
VALUES when I execute the INSERT INTO ... VALUES(...) statement, but currently
Calcite's parser does not support such syntax, so I hope to add this feature
for MySQL. Considering this is an extension in MySQL, We should allow VALUE
only in MySQL and lenient compliance levels.
For more detailed information, you can refer MySQL insert statement document -
https://dev.mysql.com/doc/refman/8.0/en/insert.html.
was:
Hello, community, I found that in MySQL, VALUE can be used as a synonym for
VALUES when I execute the INSERT INTO ... VALUES(...) statement, but currently
Calcite's parser does not support such syntax, so I hope to add this feature
for MySQL. Considering this is an extension in MySQL, We should allow VALUE
only in MySQL and lenient compliance levels.
> VALUE as an synonym for VALUES keyword (enabled in MySQL conformance)
> ---------------------------------------------------------------------
>
> Key: CALCITE-5393
> URL: https://issues.apache.org/jira/browse/CALCITE-5393
> Project: Calcite
> Issue Type: New Feature
> Reporter: sweetboy
> Assignee: Zhengqiang Duan
> Priority: Major
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Hello, community, I found that in MySQL, VALUE can be used as a synonym for
> VALUES when I execute the INSERT INTO ... VALUES(...) statement, but
> currently Calcite's parser does not support such syntax, so I hope to add
> this feature for MySQL. Considering this is an extension in MySQL, We should
> allow VALUE only in MySQL and lenient compliance levels.
> For more detailed information, you can refer MySQL insert statement document
> - https://dev.mysql.com/doc/refman/8.0/en/insert.html.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
