[ https://issues.apache.org/jira/browse/CALCITE-1503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15687374#comment-15687374 ]
Julian Hyde commented on CALCITE-1503: -------------------------------------- Do you know where the loop occurs? > 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 > > 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)