Lukas Eder created DERBY-6947: --------------------------------- Summary: Simple query runs forever Key: DERBY-6947 URL: https://issues.apache.org/jira/browse/DERBY-6947 Project: Derby Issue Type: Bug Components: SQL Affects Versions: 10.13.1.1 Reporter: Lukas Eder
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 -- This message was sent by Atlassian JIRA (v6.4.14#64029)