# -------------------------------------------------------------- #
# Test case migrated from regression test suite: bug2810.sql
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE tpch1;
#
select 'q1', sub1.* from sub1 where c1 not in (select c1 from sub2 where sub1.c3 =
sub2.c3) order by 1, 2, 3;

select 'q2', c1,c3,c2 from sub1 where (c1,c3) not in (select c1,c3 from sub2 where sub1.c2 = sub2.c2) order by 1, 2, 3;

#select 'q3', c1,c3 from sub1 where (c1,c3) not in (select c1,c3 from sub2) order by 1, 2, 3;

select 'q4', c1 from sub1 where c1 not in (select c2 from sub2) order by 1, 2;
#