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

NULLIF function returns -32768 instead of NULL when querying a Columnstore table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 23.02.11, 23.10.2
    • 23.02.15, 23.10.4
    • None
    • None
    • 2025-2

    Description

      Here I compare Columnstore to Innodb. They should return identical values, but they do not:

      create schema if not exists Z213035;
      use Z213035;
      CREATE TABLE `CS_LEG` (`ID` bigint(20) DEFAULT NULL, `sess_count` smallint(6) DEFAULT NULL) ENGINE=Columnstore;
      CREATE TABLE `INNO_LEG` (`ID` bigint(20) DEFAULT NULL, `sess_count` smallint(6) DEFAULT NULL) ENGINE=InnoDB;
      insert into CS_LEG(ID) values(1);
      insert into INNO_LEG(ID) values(1);
      select NULLIF(sess_count,0) from CS_LEG;
      +----------------------+
      | NULLIF(sess_count,0) |
      +----------------------+
      |               -32768 |
      +----------------------+
      select NULLIF(sess_count,0) from INNO_LEG;
      +----------------------+
      | NULLIF(sess_count,0) |
      +----------------------+
      |                 NULL |
      +----------------------+
      

      Attachments

        Issue Links

          Activity

            People

              leonid.fedorov Leonid Fedorov
              edward Edward Stoever
              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.