[DERBY-6947] Simple query runs forever

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.13.1.1
• Component/s: SQL
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Lukas Eder
• Created: 05/Jul/17 12:09
• Updated: 05/Jul/17 14:20

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