Cascading/lingual — pull request #11 by osolliec (2014-01-15 16:11:13+00:00)
Title: Planner throws CannotPlanException when running 'select into ordered values' queries

Insert into statements with ordered values will throw
example :
insert into test.results select empno, name from sales.emps order by name
```
org.eigenbase.relopt.RelOptPlanner$CannotPlanException: Node [rel#15375:Subset#3.ENUMERABLE.[1 Ascending]] could not be implemented; planner state:

Root: rel#15375:Subset#3.ENUMERABLE.[1 Ascending]
Original rel:
AbstractConverter(subset=[rel#15375:Subset#3.ENUMERABLE.[1 Ascending]], convention=[ENUMERABLE], sort=[[1 Ascending]])
CascadingTableModificationRel(subset=[rel#15374:Subset#3.CASCADING.[1 Ascending]], table=[[TEST, RESULTS]], operation=[INSERT], updateColumnList=[[]], flattened=[false])
AbstractConverter(subset=[rel#15371:Subset#2.CASCADING.[1 Ascending]], convention=[CASCADING], sort=[[1 Ascending]])
SortRel(subset=[rel#15370:Subset#2.NONE.[1 Ascending]], sort0=[$1], dir0=[Ascending])
ProjectRel(subset=[rel#15368:Subset#1.NONE.[]], EMPNO=[$0], NAME=[$1])
CascadingTableAccessRel(subset=[rel#15366:Subset#0.CASCADING.[]], table=[[SALES, EMPS]])
```