[CALCITE-2118] RelToSqlConverter should only generate "*" if field names match

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.15.0
• Fix Version/s: 1.16.0
• Component/s: jdbc-adapter
• Assignee: Julian Hyde
• Reporter: Austin Haas
• Created: 04/Jan/18 17:03
• Updated: 27/Feb/24 22:23
• Resolved: 18/Jan/18 23:04

Description

This RelNode tree:

LogicalProject(x=[$0])
  LogicalTableScan(table=[[t]])

is converted to:

SELECT *
FROM `t`

when it should be:

SELECT `a` AS `x`
FROM `t`

See dev list thread.