Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4496

Column list size mismatch with ORDER BY in INSERT statement

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.6.1.0
    • 10.6.1.0
    • SQL
    • None
    • Repro attached

    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

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            dagw Dag H. Wanvik
            knutanders Knut Anders Hatlen
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment