SQL;
```
SELECT u.ID, u.NAME
FROM USERS u
ORDER BY u.AGE
```

PLAN:
```
LogicalSort(sort0=[$2], dir0=[ASC])
  LogicalProject(ID=[$0], NAME=[$1], AGE=[$2])
    EnumerableTableScan(table=[[RECR, USERS]])
```
Plan's row type: RecordType(INTEGER ID, VARCHAR NAME, INTEGER AGE)

But the SQL only project ID and NAME, there should be a LogicalProject
(ID, NAME) on LogicalSort. Is this by design? And what about this extra
column?



Regards!

Aron Tao

Reply via email to