[CALCITE-3430] JDBC adapter generates extra alias for VALUES when used in join

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.21.0
• Component/s: jdbc-adapter
• Labels: sql
• Assignee: Unassigned
• Reporter: Jess Balint
• Created: 18/Oct/19 16:01
• Updated: 26/Oct/19 23:21

Description

For Postgres and other DBs which support this, the generated SQL is (values (1, 'a'), (2, 'bb')) as t(x, y). When it's used in a join the SqlImplementor adds a unique alias and winds up rendering as (values (1, 'a'), (2, 'bb')) as t(x, y) as t0. Perhaps it just needs wrapped in parens, or we could create a unique alias in RelToSqlConverter and avoid generating another one in the result() method.

Issue Links

• is caused by: CALCITE-3191 In JDBC adapter for MySQL, implement Values by generating SELECT without FROM