[CALCITE-176] ORDER BY expression doesn't work with SELECT *

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

Description

`ORDER BY CAST(expression AS TYPE)` does not have the desired effect. The following example (against optiq-csv) illustrates that ORDER BY succeeds if the expression is explicitly in the SELECT clause:

```sql
sqlline> !set outputformat csv
sqlline> !connect jdbc:optiq:model=target/test-classes/bug.json admin ''
0: jdbc:optiq:model=target/test-classes/bug.j> select * from numeric_columns order by cast(empno as integer);
'EMPNO','NAME','DEPTNO','GENDER','CITY','EMPID','AGE','SLACKER','MANAGER','JOINEDAT'
'130','Alice','40','F','Vancouver','2','null','false','true','2007-01-01'
'110','Eric','20','M','San Francisco','3','80','null','false','2001-01-01'
'100','Fred','10','','','30','25','true','false','1996-08-03'
'99','John','40','M','Vancouver','2','null','false','true','2002-05-03'
'120','Wilma','20','F','','1','5','null','true','2005-09-07'
5 rows selected (0.484 seconds)
0: jdbc:optiq:model=target/test-classes/bug.j> select cast(empno as integer) as x, * from numeric_columns order by x;
'X','EMPNO','NAME','DEPTNO','GENDER','CITY','EMPID','AGE','SLACKER','MANAGER','JOINEDAT'
'100','100','Fred','10','','','30','25','true','false','1996-08-03'
'110','110','Eric','20','M','San Francisco','3','80','null','false','2001-01-01'
'120','120','Wilma','20','F','','1','5','null','true','2005-09-07'
'130','130','Alice','40','F','Vancouver','2','null','false','true','2007-01-01'
'99','99','John','40','M','Vancouver','2','null','false','true','2002-05-03'
5 rows selected (0.068 seconds)
```

---------------- Imported from GitHub ----------------
Url: https://github.com/julianhyde/optiq/issues/176
Created by: julianhyde
Labels: bug,
Created at: Tue Mar 11 17:47:53 CET 2014
State: closed