# -------------------------------------------------------------- #
# Test case migrated from regression test suite: bug4386.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 ( companycode integer, FinancialQuarterID integer,
FinancialQuarter integer, FinancialYear integer ) engine=columnstore;
insert into dim_date values (1,1,2,1);
insert into dim_date values (1,3,2,1);
select count(*)     from dim_date x_varDate      where      FinancialQuarterID > CASE      WHEN
x_varDate.FinancialQuarter <= 3 THEN (x_varDate.FinancialYear-1) ELSE (x_varDate.FinancialYear) END ;
select count(*)     from dim_date x_varDate      where      FinancialQuarterID BETWEEN CASE      WHEN
x_varDate.FinancialQuarter <=               3       THEN          ((x_varDate.FinancialYear  - 1) * 10)          +
(1 + x_varDate.FinancialQuarter)       ELSE          (x_varDate.FinancialYear * 10)          +
(x_varDate.FinancialQuarter - 3)         END       AND x_varDate.FinancialQuarterID;

--disable_warnings
drop table dim_date;
--enable_warnings
#