db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6947) Simple query runs forever
Date Wed, 05 Jul 2017 14:21:00 GMT

    [ 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)

Mime
View raw message