[jira] [Commented] (CALCITE-1503) Infinite loop occurs during query planning

["Mridul Chopra (JIRA)" <ji...@apache.org>]

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

Mridul Chopra commented on CALCITE-1503:
----------------------------------------

I observed it in Volcano Planner "Optimizer" phase that the result from RuleQueue.popMatch(RuleQueue.java:479) was taking infinite time to return. Any fix for this bug available?

> Infinite loop occurs during query planning
> ------------------------------------------
>
>                 Key: CALCITE-1503
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1503
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.10.0
>            Reporter: Miguel Oliveira
>            Assignee: Julian Hyde
>         Attachments: output
>
>
> The following query:
> {code}
> SELECT count(*) FROM (
>                 SELECT count(v1.`region_id`) `Count Region`, v6.`fullname` `Customer (Name)`
>                 FROM `foodmart`.`region` v1
>                 JOIN `foodmart`.`store` v3 ON v1.`region_id` = v3.`region_id`
>                 JOIN `foodmart`.`customer` v6 ON v1.`region_id` = v6.`customer_region_id`
>                 JOIN `foodmart`.`sales_fact_1998` v15 ON v3.`store_id` = v15.`store_id` AND v6.`customer_id` = v15.`customer_id`
>                 WHERE v3.`store_name` LIKE '%Grocery%'
>                 GROUP BY v6.`customer_region_id`,v6.`fullname`)  a 
> {code}
> causes an infinite loop during query plan.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)