Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5755

SELECT GROUP BY is not picking not-NULL values

    XMLWordPrintable

Details

    • 2024-2

    Description

      SELECT GROUP BY is not picking not-NULL values

      Repro
      ------
      create table t1 (t text,c char(10),b blob) engine = columnstore;
      insert into t1 values (NULL,NULL,NULL);
      insert into t1 values ("","","");
      insert into t1 values ("hello","hello","hello");
      insert into t1 values ("HELLO","HELLO","HELLO");
      insert into t1 values ("HELLO MY","HELLO MY","HELLO MY");
      insert into t1 values ("a","a","a");
      insert into t1 values (1,1,1);
      insert into t1 values (NULL,NULL,NULL);
      update t1 set c="",b=null where c="1";
      update t1 set b="NewBlob" where c="a";
      update t1 set t="newhello", c="newhello" where b="hello";

      InnoDB> select b from cst1 group by b;
      ----------

      b
      ----------

      NULL

      HELLO
      HELLO MY
      NewBlob
      hello
      ----------
      6 rows in set (0.001 sec)

      Columnstore> select b from cst1 group by b;
      ------

      b
      ------

      NULL
      ------
      1 row in set (0.047 sec)

      Attachments

        Activity

          People

            sergey.zefirov Sergey Zefirov
            susil.behera Susil Behera
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.