# -------------------------------------------------------------- #
# Test case migrated from regression test suite: MCOL-3448.sql
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE tpch1;
#
--disable_warnings
DROP TABLE IF EXISTS dim_date;
--enable_warnings

create table dim_date(semaine varchar(10), date_jour date, val int) engine=columnstore;

insert into dim_date values 
('2019-S08','2019-02-18',1),
('2019-S08','2019-02-19',2),
('2019-S08','2019-02-20',3),
('2019-S07','2019-02-15',0),
('2019-S07','2019-02-14',5),
('2019-S01','2019-01-01',5);

SELECT * FROM dim_date WHERE SEMAINE IN ('2019-S07') OR (SEMAINE,DATE_JOUR) IN ( ('2019-S08','2019-02-18'), ('2019-S08','2019-02-19') ) order by val;

--disable_warnings
DROP TABLE IF EXISTS dim_date;
--enable_warnings
#