[CALCITE-3191] In JDBC adapter for MySQL, implement Values by generating SELECT without FROM

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.21.0
• Assignee: Unassigned
• Reporter: Julian Hyde
• Created: 12/Jul/19 00:47
• Updated: 12/Aug/21 01:35
• Resolved: 04/Aug/19 04:19

Description

In JDBC adapter, generate implement Values relational operator by generating SELECT without a FROM clause. (For most dialects we generate VALUES, but MySQL does not support VALUES in a query.)

Issue Links

• causes: CALCITE-3430 JDBC adapter generates extra alias for VALUES when used in join
• is duplicated by: CALCITE-2834 VALUES Clause support for dialects which don't support VALUES clause
• relates to: CALCITE-3155 AssertionError in RelToSqlConverter when visiting empty Values node
• relates to: CALCITE-4724 In JDBC adapter for ClickHouse, implement Values by generating SELECT without FROM