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

Crash MariaDB when querying PIVOT table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.7, 10.0.9
    • 10.0.11
    • None
    • $ lsb_release -a
      No LSB modules are available.
      Distributor ID: Ubuntu
      Description: Ubuntu 12.04.4 LTS
      Release: 12.04
      Codename: precise

    Description

      A simple PIVOT table test crashes the server while trying to connect back to execute the pivot query.

      Started with a clean MariaDB installation from the MariaDB repositories for Ubuntu Precise release.

      1. CREATE DATABASE test_pivot
      2. Create the empty table using the file 'test_pivot_2.sql' in the attached tarball.
      3. Load the data using LOAD DATA INFILE from the 'test_pivot_2.txt' file in the attached tarball.
      4. Create the pivot table using the 'my_pivot_2.sql' file in the tarball.
      5. Execute SELECT * FROM my_pivot_2;

      The client will show the following error message:
      ERROR 2013 (HY000): Lost connection to MySQL server during query

      See attached error log: bart-05.err

      Attachments

        1. bart-05.err
          9 kB
          Gerardo Narvaja
        2. pivot.tgz
          1 kB
          Gerardo Narvaja

        Issue Links

          Activity

            People

              bertrandop Olivier Bertrand
              gerry Gerardo Narvaja (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.