You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Lukas Eder (JIRA)" <ji...@apache.org> on 2017/07/05 12:10:00 UTC
[jira] [Created] (DERBY-6947) Simple query runs forever
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)