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

is null not working on varchar utf8mb4

    XMLWordPrintable

    Details

      Description

      create table t1(f1 varchar(5)) engine=columnstore default charset utf8mb4;
      select max(f1) is null from t1;
      Should return 1
      But it returns 0

      create table t1(f1 varchar(5)) engine=columnstore default charset utf8mb4;
      select max(f1) is null from t1;
      +-----------------+
      | max(f1) is null |
      +-----------------+
      |               0 |
      +-----------------+
      

      If using utf8, it works

      create table t2(f1 varchar(5)) engine=columnstore default charset utf8;
      select max(f1) is null from t2;
      +-----------------+
      | max(f1) is null |
      +-----------------+
      |               1 |
      +-----------------+
      

        Attachments

          Activity

            People

            Assignee:
            David.Hall David Hall
            Reporter:
            David.Hall David Hall
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration