
select 'all';
select 'key, arrayJoin(arr) in (1, 1)';
select 'key, arrayJoin(arr) in ((1, 1), (2, 2))';
select '(key, left array join arr) in (1, 1)';
select '(key, left array join arr) in ((1, 1), (2, 2))';
select 'all';
select 'key, arrayJoin(n.x) in (1, 1)';
select 'key, arrayJoin(n.x) in ((1, 1), (2, 2))';
select '(key, left array join n.x) in (1, 1)';
select '(key, left array join n.x) in ((1, 1), (2, 2))';
select 'max(key) from tab_00612 where (key, left array join n.x) in (1, 1)';
select 'max(key) from tab_00612 where (key, left array join n.x) in ((1, 1), (2, 2))';
select 'max(key) from tab_00612 any left join (select key, arrayJoin(n.x) as val from tab_00612) using key where (key, val) in (1, 1)';
select 'max(key) from tab_00612 any left join (select key, arrayJoin(n.x) as val from tab_00612) using key where (key, val) in ((1, 1), (2, 2))';
