[CALCITE-3733] In JDBC adapter, when generating SQL for MYSQL, generate TIMESTAMP type as DATETIME for CAST

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.23.0
• Component/s: jdbc-adapter
• Labels: pull-request-available
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 14/Jan/20 17:14
• Updated: 24/May/20 11:59
• Resolved: 14/Apr/20 02:24

Description

Queries containing cast timestamp literal is rewritten into cast as TIMESTAMP. This syntax is not supported with MySql. Since TIMESTAMP is equivalent to DATETIME it should be rewritten into CAST as DATETIME.

I will provide a test case later.

Issue Links

• links to: GitHub Pull Request #1900