[CALCITE-273] Support column alias in WITH queries (common table expressions)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Labels: github-import
• Assignee: Unassigned
• Reporter: GitHub Import
• Created: 18/Jun/14 08:57
• Updated: 18/Jun/14 08:57
• Resolved: 18/Jun/14 08:57

Description

The SQL standard allows columns to be renamed when defining a common table expression. Since (#128 | FLINK-128) we support WITH, and can parse a column list, but the column list is ignored.

Example:

```sql
WITH w (x, y) AS (SELECT deptno, name FROM dept)
SELECT x, y FROM w
```

---------------- Imported from GitHub ----------------
Url: https://github.com/julianhyde/optiq/issues/273
Created by: julianhyde
Labels:
Created at: Wed May 07 22:10:25 CEST 2014
State: closed