Stamatis Zampetakis created CALCITE-4674: --------------------------------------------
Summary: Excess quotes in generated SQL when STAR is a column alias Key: CALCITE-4674 URL: https://issues.apache.org/jira/browse/CALCITE-4674 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.27.0 Reporter: Stamatis Zampetakis Assignee: Stamatis Zampetakis Fix For: 1.28.0 The following valid SQL query: {code:sql} select "customer_id" as "*" from "customer"; {code} changes slightly semantics when it is parsed, optimized, and transformed back to SQL via {{RelToSqlConverter}}. +Actual+ {code:sql} SELECT "customer_id" AS """*""" FROM "foodmart"."customer"; {code} Note the extra quotes appearing in the {{AS}} clause. Aliasing columns differently is undesirable and can have an impact when this query pattern appears as part of a larger query and there are usages of the alias. +Expected+ {code:sql} SELECT "customer_id" AS "*" FROM "foodmart"."customer"; {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)