[MCOL-2165] Autoswitch broken in some cases in 1.2.2 - Jira

XML

Word

Printable

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.

relates to

MCOL-1963 GROUP BY doesn't process IN + correlate subquery.

MCOL-1964 GROUP BY doesn't process NOT IN + correlate subquery with aggregates

MCOL-1672 ColumnStore in auto-switch operational mode fail to process query with Internal error and aggregation data overflow

MCOL-2147 Semi-join with correllated subquery case .. when ... end in the join key.

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