Jess Balint created CALCITE-3430: ------------------------------------ Summary: JDBC adapter generates extra alias for VALUES when used in join Key: CALCITE-3430 URL: https://issues.apache.org/jira/browse/CALCITE-3430 Project: Calcite Issue Type: Bug Components: jdbc-adapter Affects Versions: 1.21.0 Reporter: Jess Balint
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, of we could create a unique alias in RelToSqlConverter and avoid generating another one in the {{result()}} method. -- This message was sent by Atlassian Jira (v8.3.4#803005)