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

["Miguel Oliveira (JIRA)" <ji...@apache.org>]

Miguel Oliveira created CALCITE-1503:
----------------------------------------

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