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

XML

Word

Printable

Error happened with set infinidb_vtable_mode 1 and 2.

Prepare:

set infinidb_vtable_mode= 2;

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

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

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));

#ERROR 1815 (HY000): Internal error: IDB-1000: 'cs1' and 'cs3' are not joined.

Error message is different with a condition before the case condition in the where clause.

select count(1) from cs1 where exists (select 1 from cs2 where cs1.t = cs2.t and cs1.t = (case cs2.t when 0 then cs1.t else cs2.t end));

#ERROR 1815 (HY000): Internal error: IDB-3034: Query is not supported.  Unknown column '' in subquery.

relates to

MCOL-2165 Autoswitch broken in some cases in 1.2.2

MCOL-1531 ColumnStore fails to make inner join if using CASE in predicate.

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

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

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