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

Autoswitch broken in some cases in 1.2.2

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.2
    • Fix Version/s: 1.2.3
    • Component/s: None
    • Labels:
      None
    • Sprint:
      2019-02, 2019-03

      Description

      Testcase from MCOL-2147

      create table cs1 (t varchar(2) , i int) engine = columnstore;
      create table cs2(t varchar(2) , i int) engine = columnstore;
      

      set infinidb_vtable_mode= 2;
      select calSetTrace(1);
      select count(1) from cs1 where exists (select 1 from cs2 where cs1.t = (case cs2.t when 0 then cs1.t else cs2.t end));
      select calGetTrace();
      

      runs with MCS 1.1.6, because it autoswitch to vtable-mode 0 .

      Result of the calGetTrace() is

      Desc Mode Table TableOID ReferencedColumns PIO LIO PBE Elapsed Rows
      BPS PM cs1 3009 (t) 0 1 0 0.002 0
      

      The same output like with vtable = 0 and the join was not executed by the columnstore engine.

      With vtable = 1 an error occured, so it is likely, that columnstore engine throw an error and autoswitch to vtable= 0

      With 1.2.2 the autoswitch was not happened, the error occured like in vtable=1 and no autoswitch was happened.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              Richard Richard Stracke
              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.