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

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

    XMLWordPrintable

    Details

    • Sprint:
      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

            Activity

              People

              Assignee:
              varun Varun Gupta
              Reporter:
              varun Varun Gupta
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: