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

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

    XMLWordPrintable

Details

    • 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

              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.