[
https://issues.apache.org/jira/browse/DERBY-6947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16074846#comment-16074846
]
Bryan Pendleton commented on DERBY-6947:
----------------------------------------
Perhaps a duplicate of DERBY-6750?
> 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
>
> {code}
> 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
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)