[FLINK-16609] Promotes the column name representation of SQL-CLI

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Fix Version/s: 1.20.0
• Component/s: Table SQL / Client
• Labels: auto-deprioritized-major auto-unassigned
• Assignee: Unassigned
• Reporter: Danny Chen
• Created: 16/Mar/20 04:29
• Updated: 11/Mar/24 12:43

Description

The SQL-CLI now outputs the column name as the name that comes from the plan, which is not that readable sometimes, i can think of 2 cases that can be promoted:

• Expression like "a + b" should output "a + b" (i.e. the MySQL CLI) instead of "$Expr {index}

  "

• We should always output the alias if it's there, now, the alias in the plan may be dropped because of 2 reasons:
  1. Project remove rule would remove the project without considering the alias
  2. after CALCITE-3713, some CALC/PROJ would be reused while ignoring the column alias