# -------------------------------------------------------------- #
# Test case migrated from regression test suite: bug3911.sql
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE tpch1;
#
select count(n_nationkey) from nation n join region r on n_regionkey = r_regionkey and n_nationkey in (select distinct n_regionkey from nation where n.n_nationkey < 10);

select count(n_nationkey) from nation n join region r on n_regionkey = r_regionkey and n_nationkey in (select distinct n_regionkey from nation where n.n_name <> 'abc');

#