[
https://issues.apache.org/jira/browse/DERBY-6947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukas Eder updated DERBY-6947:
------------------------------
Description:
{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}
was:
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
> 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)
