# -------------------------------------------------------------- #
# Test case migrated from regression test suite: bug5267.sql
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE tpch1;
#
select n_nationkey, case when n_nationkey xor n_regionkey then 1 else 0 end case_xor from nation;
select n_nationkey, if(n_nationkey xor n_regionkey, 1, 0) from nation;
select n_nationkey, if(n_nationkey and n_regionkey, 1, 0) from nation;
select n_nationkey, case when n_nationkey or n_regionkey then 1 else 0 end case_xor from nation;

#