Major Description
I see this error on trunk (revision 894516):
ij> create table t(x varchar(100));
0 rows inserted/updated/deleted
ij> insert into t
select * from (select * from sysibm.sysdummy1 order by length(ibmreqd)) t1;
ERROR 42X32: The number of columns in the derived column list must match the number of columns in table 'T1'.
The statement succeeds if I remove the ORDER BY clause:
ij> insert into t select * from (select * from sysibm.sysdummy1) t1;
1 row inserted/updated/deleted