You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Miguel Oliveira (JIRA)" <ji...@apache.org> on 2016/11/23 12:44:58 UTC
[jira] [Updated] (CALCITE-1503) Infinite loop occurs during query
planning
[ https://issues.apache.org/jira/browse/CALCITE-1503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Miguel Oliveira updated CALCITE-1503:
-------------------------------------
Attachment: output
Jstack output
> 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)