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

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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.