Julian Hyde created CALCITE-673:
-----------------------------------
Summary: Timeout executing joins against MySQL
Key: CALCITE-673
URL: https://issues.apache.org/jira/browse/CALCITE-673
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
Tests JdbcFrontJdbcBackLinqMiddleTest.testJoinGroupByEmpty and
testJoinGroupByOrderBy sometimes time out in MySQL running a query like this:
{code}SELECT COUNT(*) AS `EXPR$0`
FROM (SELECT 0 AS `DUMMY`
FROM (SELECT `customer_id`
FROM `foodmart`.`customer`) AS `t`
INNER JOIN (SELECT `customer_id`
FROM `foodmart`.`sales_fact_1997`) AS `t0` ON `t`.`customer_id` =
`t0`.`customer_id`) AS `t1`{code}
Maybe it's too complicated for MySQL to execute efficiently. Disabling those
tests for now.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
