[CALCITE-4674] Excess quotes in generated SQL when STAR is a column alias

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.27.0
• Fix Version/s: 1.28.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Stamatis Zampetakis
• Reporter: Stamatis Zampetakis
• Created: 01/Jul/21 10:10
• Updated: 20/Oct/21 05:24
• Resolved: 12/Jul/21 10:31

Description

The following valid SQL query:

select "customer_id" as "*" from "customer";

changes slightly semantics when it is parsed, optimized, and transformed back to SQL via RelToSqlConverter.

Actual

SELECT "customer_id" AS """*""" FROM "foodmart"."customer";

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

SELECT "customer_id" AS "*" FROM "foodmart"."customer";

Issue Links

• links to: GitHub Pull Request #2450