Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5721

Using too big key for internal temp tables MariaDB 5.5.35

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.3.12, 5.5.35, 5.5.36, 10.0.8
    • Fix Version/s: 5.5.40, 10.0.14, 5.3.13
    • Component/s: Optimizer
    • Labels:
      None
    • Environment:
      debian 7 wheezy mysql_multi environment

      Description

      We got this error:

      Using too big key for internal temp tables

      it seems that the bug described in https://bugs.launchpad.net/maria/+bug/957409 is not fixed for all cases.

      the testcase described there works.
      But in our case the workaround (SET GLOBAL optimizer_switch = 'derived_with_keys=off';) is needed, so that our complex statement works.

      The statement is a complex statement on innodb-tables with inner selects and substring_index-fkt and group by/order by having count. belonging to three tables.
      Test case and statement delivered. Tables.sql contains select statement which causes the error.

        Attachments

        1. cq-broken.sql.gz
          602 kB
        2. cq-select.sql
          0.2 kB
        3. cq-tables.sql
          0.6 kB
        4. cq-working.sql.gz
          601 kB
        5. example-data.sql
          11 kB
        6. mdev5721.test
          15 kB
        7. my-ticket.cnf
          4 kB
        8. tables.sql
          5 kB

          Issue Links

            Activity

              People

              Assignee:
              igor Igor Babaev
              Reporter:
              Meik Meik Suchlich
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: