[CALCITE-5393] VALUE as an synonym for VALUES keyword (enabled in MySQL conformance)

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.33.0
• Labels: pull-request-available
• Assignee: Zhengqiang Duan
• Reporter: sweetboy
• Created: 21/Nov/22 10:00
• Updated: 07/Feb/23 22:33
• Resolved: 06/Dec/22 09:30

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.

 

Issue Links

• links to: GitHub Pull Request #2985