[jira] Updated: (DERBY-4496) Column list size mismatch with ORDER BY in INSERT statement

["Dag H. Wanvik (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-4496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dag H. Wanvik updated DERBY-4496:
---------------------------------

    Attachment: derby-4496.stat
                derby-4496.diff

Attaching a fix for this issue. The issue was yet more occurences of the missing use of visibleSize instead of size on RCLs, now that we have ORDER BY in subqueries.
The fix also adds the repro test case to OrderByInSubqueries. 
Running regressions.


> Column list size mismatch with ORDER BY in INSERT statement
> -----------------------------------------------------------
>
>                 Key: DERBY-4496
>                 URL: https://issues.apache.org/jira/browse/DERBY-4496
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.6.0.0
>            Reporter: Knut Anders Hatlen
>         Attachments: derby-4496.diff, derby-4496.stat
>
>
> I see this error on trunk (revision 894516):
> ij> create table t(x varchar(100));
> 0 rows inserted/updated/deleted
> ij> insert into t(x) 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(x) select * from (select * from sysibm.sysdummy1) t1;
> 1 row inserted/updated/deleted

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.