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

Scalar vectoring code does not always work (certain where clause values combo)

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Critical
    • Resolution: Unresolved
    • None
    • 23.10
    • None
    • None

    Description

      use test;
      drop table if exists t;
      create table t(c6 CHAR(6)) engine=columnstore;
      insert into t(c6) values ('a'), ('b'), ('c');
      select count(*) from t where (c6 <= 'b' or c6 is null);
      

      The query returns 3 instead of 2.

      internal note
      We have two code paths for filtering: scalar and vectorized. Vectorized one is preferred and scalar one is used as fallback.

      The following little snippet works differently when executed with vectorized code enabled and disabled:

      Attachments

        Activity

          People

            sergey.zefirov Sergey Zefirov
            sergey.zefirov Sergey Zefirov
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.