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

NULL operand ignored in vtable mode when querying view

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.10
    • Fix Version/s: 1.0.12, 1.1.1
    • Component/s: PrimProc
    • Labels:
      None
    • Sprint:
      2017-19, 2017-20, 2017-21

      Description

      With the example below, columnstore return a number instead of NULL in the addition when there is a if in the view and using vtable=0 gives NULL.

      use test;
      create table test_bug(a float default null, b float default null) engine=Columnstore;
      insert into test.test_bug values (rand(),rand()),(rand(),rand()),(rand(),rand()),(rand(),rand());
      create or replace view test_bug_view (a,b,c) as select a,b,(abs(a*2.6+b*38.7))*1.16+if(a>0.5,a,1.0 -(a*0.1)) as c from test.test_bug;
      set infinidb_vtable_mode=1;
      select c+NULL as t,c from test.test_bug_view;
      set infinidb_vtable_mode=0;
      select c+NULL as t,c from test.test_bug_view;

        Attachments

          Activity

            People

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            plinel patrice
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.