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

GROUP_CONCAT(DISTINCT ...) may produce a non-distinct list

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
    • 10.5.4, 10.3.24, 10.4.14
    • Optimizer
    • None
    • 10.2.4-5, 10.2.7-1

    Description

      Here is a simple test case demonstrating the problem. This problem is hit only in the case when records from all
      the rows cannot fit in the Unique object

      create table t1 (
      		 
      a VARCHAR(1000),
      		 
      b int
      		 
      );
      		 
      insert into t1 values
      		 
      ( 0 , 1 ),
      		 
      ( 1 , 2 ),
      		 
      ( 2 , 3 ),
      		 
      ( 3 , 4 ),
      		 
      ( 4 , 5 ),
      		 
      ( 5 , 6 ),
      		 
      ( 0 , 11 ),
      		 
      ( 5 , 16 );
      		 
      set tmp_table_size=1024;
      		 
      select group_concat(distinct a) from t1;
      		 
      drop table t1;

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21879 GROUP_CONCAT(DISTINCT) with little memory

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

          Task - A task that needs to be done. MDEV-11297 Add support for LIMIT clause in GROUP_CONCAT()

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22011 DISTINCT with JSON_ARRAYAGG gives wrong results

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22089 Group concat returns incorrect result when using DISTINCT and ORDER BY

          • Major - Major loss of function.
          • Stalled
          links to

          Web Link Bug report (MySQL)

          Activity

            People

              varun Varun Gupta (Inactive)
              varun Varun Gupta (Inactive)
              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.