Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-673

Timeout executing joins against MySQL

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Tests JdbcFrontJdbcBackLinqMiddleTest.testJoinGroupByEmpty and testJoinGroupByOrderBy sometimes time out in MySQL running a query like this:

      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`

      Maybe it's too complicated for MySQL to execute efficiently. Disabling those tests for now.

        Attachments

          Activity

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              julianhyde Julian Hyde
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: