# -------------------------------------------------------------- #
# Test case migrated from regression test suite: bug1903.sql
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE tpch1;
#
#-- Bug 1903.  Test queries that do constant propagation optimization.

select n_regionkey, r_regionkey
from nation, region
where n_regionkey = r_regionkey and
      r_regionkey = 3
order by 1, 2;

#