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

Simple query runs forever

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

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.13.1.1
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None
    • Urgency:
      Normal

      Description

      select 
        X1.A as A1, 
        X2.A as A2
      from (
        select *
        from (
          select 1 as A
          from SYSIBM.SYSDUMMY1
        ) x
        union all 
        select *
        from (
          select 2 as A
          from SYSIBM.SYSDUMMY1
        ) x
      ) as X1
        join (
          select *
          from (
            select 2 as A
            from SYSIBM.SYSDUMMY1
          ) x
          union all 
          select *
          from (
            select 3 as A
            from SYSIBM.SYSDUMMY1
          ) x
        ) as X2
        on X1.A = X2.A
      order by A1
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              lukas.eder Lukas Eder

              Dates

              • Created:
                Updated:

                Issue deployment