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

NULL operand ignored in vtable mode when querying view

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.0.10
    • 1.0.12, 1.1.1
    • PrimProc
    • None
    • 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

            dleeyh Daniel Lee (Inactive)
            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.