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

Server crashes on SQL select containing more group by and left join statements using innodb tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.1.67, 5.2.14, 5.3.12, 5.5.35, 5.5.36, 10.0.8
    • 5.5.37, 10.0.10
    • None
    • None
    • Linux, Fedora 20

    Description

      Originally reported as (1) and please see the reproducer there as well.

      It's easily reproducible on my Fedora 20 machine as well with SQL command from comment #15 (1) and a command from comment #0 (1); also crashes with a bit simplified following SQL command:

      SELECT Count(*)
      FROM   bpsocial_post AS tbl
             LEFT JOIN bpsocial_profile_object_option a
                    ON a.spoo_uid = sspo_uid
                       AND a.spoo_option_id = 1
             LEFT JOIN bpsocial_profile_object_option b
                    ON b.spoo_uid = sspo_uid
                       AND b.spoo_option_id = 2
             LEFT JOIN bpsocial_profile_object_option c
                    ON c.spoo_uid = sspo_uid
                       AND c.spoo_option_id = 3
             LEFT JOIN bpsocial_profile_object_option d
                    ON d.spoo_uid = sspo_uid
                       AND d.spoo_option_id = 5
             LEFT JOIN bpsocial_profile_object_option e
                    ON e.spoo_uid = sspo_uid
                       AND e.spoo_option_id = 4
             LEFT JOIN bpsocial_profile_object_option f
                    ON f.spoo_uid = sspo_uid
                       AND f.spoo_option_id = 11
             LEFT JOIN bpsocial_profile_object_option g
                    ON g.spoo_uid = sspo_uid
                       AND g.spoo_option_id = 7
             LEFT JOIN bpsocial_profile_object_option h
                    ON h.spoo_uid = sspo_uid
                       AND h.spoo_option_id = 10
             LEFT JOIN bpsocial_profile_object_option i
                    ON i.spoo_uid = sspo_uid
                       AND i.spoo_option_id = 18
             LEFT JOIN bpsocial_profile_object_option j
                    ON j.spoo_uid = sspo_uid
                       AND j.spoo_option_id = 6
      GROUP  BY a.spoo_value,
                b.spoo_value,
                c.spoo_value,
                d.spoo_value,
                e.spoo_value,
                f.spoo_value,
                g.spoo_value,
                h.spoo_value,
                i.spoo_value,
                j.spoo_value;

      Surprisingly, it doesn't crash with community mysql-5.5.35, so it is probably a MariaDB-only bug.

      (1) https://bugzilla.redhat.com/show_bug.cgi?id=1065676

      Attachments

        Activity

          People

            monty Michael Widenius
            hhorak Honza Horak
            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.