Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
5.5.37, 5.5.38, 5.5.39
-
None
-
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.