# -------------------------------------------------------------- #
# Test case migrated from regression test suite: bug2813.sql
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE ssb1;
#
select distinct(d_sellingseason) from dateinfo where d_sellingseason like 'F%' order by 1;
select distinct(d_sellingseason) from dateinfo where d_sellingseason like 'F%' or d_sellingseason like 'W%' order by 1;
select distinct(d_sellingseason) from dateinfo where d_sellingseason like '%r' order by 1;
select distinct(d_sellingseason) from dateinfo where d_sellingseason like '%r' or d_sellingseason like '%r' order by 1;
select distinct(d_sellingseason) from dateinfo where d_sellingseason like '%r' or d_sellingseason like '%g' order by 1;





#