[CALCITE-3840] Re-aliasing of VALUES that has column aliases produces wrong SQL in the JDBC adapter

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.21.0
• Fix Version/s: 1.23.0
• Component/s: jdbc-adapter
• Assignee: Unassigned
• Reporter: Christian Beikov
• Created: 04/Mar/20 10:03
• Updated: 09/Jul/20 02:11
• Resolved: 23/Mar/20 09:14

Description

Rendering a VALUES relnode to e.g. PostgreSQL will produce FROM (VALUES((1))) AS t(col_alias) where "t" is a static alias. When e.g. joining with such a VALUES, the RelToSqlConverter tries to re-alias this with a unique alias, but fails because it produces FROM (VALUES((1))) AS t(col_alias) AS newAlias.

The fix is to replace the static table alias instead.

Issue Links

• links to: PR