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

Some GROUP BY commands fail with -DUSER_ARIA_FOR_TMP_TABLES=OFF

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.5.37, 5.5.38, 5.5.39
    • Fix Version/s: 10.0.6
    • Component/s: Compiling, Optimizer
    • Labels:
      None
    • Environment:
      CentOS 6.5 x-86-64 running MariaDB if cmake uses options -DUSER_ARIA_FOR_TMP_TABLES=OFF and -DWITH_ARIA_STORAGE_ENGINE=ON. Noticed when running Joomla application.

      Description

      A customer's query (see mysql-test/suite/betterlinux/t/bl_aria_group.test) that consists of nested joins and a GROUP BY clause fails and displays this message: "failed: 126: Incorrect key file for table '/var/tmp/#sql_5b8d_1'; try to repair it". If both Aria options are defined when invoking cmake, the failure doesn't occur. Run test case betterlinux.bl_aria_group.test (in mariadb-bug-aria-joomla-GROUP_BY.tgz uploaded to ftp.askmonty.org) with no ARIA-related definisions, and the test case runs successfully. Repeat with cmake options -DUSER_ARIA_FOR_TMP_TABLES=OFF and -DWITH_ARIA_STORAGE_ENGINE=ON and the test case fails.

        Attachments

          Activity

            People

            Assignee:
            elenst Elena Stepanova
            Reporter:
            wwhipple Weldon Whipple
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: