[jira] [Commented] (DERBY-6947) Simple query runs forever

["Bryan Pendleton (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-6947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16074809#comment-16074809 ] 

Bryan Pendleton commented on DERBY-6947:
----------------------------------------

Here's a stack trace from 'jstack':


{code:java}
"main" #1 prio=5 os_prio=0 tid=0x0000000002a80800 nid=0xf1c runnable [0x0000000002a3e000]
   java.lang.Thread.State: RUNNABLE
        at org.apache.derby.impl.sql.compile.ColumnReference.getSourceResultSet(ColumnReference.java:1195)
        at org.apache.derby.impl.sql.compile.BinaryRelationalOperatorNode.getScopedOperand(BinaryRelationalOperatorNode.java:1719)
        at org.apache.derby.impl.sql.compile.Predicate.getPredScopedForResultSet(Predicate.java:932)
        at org.apache.derby.impl.sql.compile.SetOperatorNode.pushOptPredicate(SetOperatorNode.java:385)
        at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:260)
        at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:290)
        at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:2036)
        at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1978)
        at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:298)
        at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:594)
        at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:461)
        at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:99)
        at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:1114)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:689)
        - locked <0x00000000d8018dc8> (a org.apache.derby.impl.jdbc.EmbedConnection)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:637)
        at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:372)
        at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:533)
        at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:375)
        at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:251)
        at org.apache.derby.impl.tools.ij.Main.go(Main.java:229)
        at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:184)
        at org.apache.derby.impl.tools.ij.Main.main(Main.java:75)
        at org.apache.derby.tools.ij.main(ij.java:59)
{code}


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