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

Server crashes during join on group-by subquery

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Duplicate
        • Affects Version/s: 5.5.35
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None
        • Environment:
          Windows 7 64-bit

          Description

          With ONLY_FULL_GROUP_BY in sql mode, the following query will cause the server to crash. Nothing is written to error log.

          table definitions:
          create table test1 (a int unsigned not null);
          create table test2 (b int unsigned not null);

          server crash:
          select * from test1 inner join (
          select * from test2 group by b) as test2alias
          on (test1.a = test2alias.b);

            Gliffy Diagrams

              Attachments

                Issue Links

                duplicates

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5617 mysqld crashes when running a query with ONLY_FULL_GROUP_BY

                • Critical - Crashes, loss of data, severe memory leak.
                • Closed

                  Activity

                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Thank you for reporting.

                  This is a duplicate of MDEV-5617. It has the same stack trace and same conditions, started happening with the same revision, and nearly identical test case can be found in this comment to MDEV-5617.

                  Show
                  elenst Elena Stepanova added a comment - Thank you for reporting. This is a duplicate of MDEV-5617 . It has the same stack trace and same conditions, started happening with the same revision, and nearly identical test case can be found in this comment to MDEV-5617 .

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      cconverse Cary Converse
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: