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

main.group_by fails with incorrectly ordered rows

    XMLWordPrintable

Details

    • Unexpected results

    Description

      @@ -2623,8 +2623,8 @@
      		 
       SET sql_mode='ONLY_FULL_GROUP_BY';
      		 
       SELECT 1 AS test UNION SELECT 2 AS test ORDER BY test IS NULL ASC;
      		 
       test
      		 
      -1
      		 
       2
      		 
      +1
      		 
       SET sql_mode='';
      		 
       #
      		 
       # MDEV-6484: Assertion `tab->ref.use_count' failed on query with joins, constant table, multi-part key
      		 
       
      		 
      Result content mismatch

      Cross-reference shows that this failure occurs in multiple 10.11 PRs.

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-36647 No red leaves in the forest

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21565 main.group_by failed in buildbot with wrong result

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29360 Crash when pushing condition with always false IS NULL into derived

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Johnston Rex Johnston
              ParadoxV5 Jimmy Hú
              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.