--source ../include/have_columnstore.inc
--disable_warnings
DROP DATABASE IF EXISTS regr_fe_substr;

--enable_warnings
CREATE DATABASE regr_fe_substr;

USE regr_fe_substr;
--disable_query_log
--source ../include/regression_create_datatypetestm.inc
--enable_query_log

select cidx, CCHAR1, SUBSTR(CCHAR1,1) from datatypetestm;
select cidx, CCHAR1, SUBSTR(CCHAR1,5) from datatypetestm;
select cidx, CCHAR1, SUBSTR(CCHAR1,7) from datatypetestm;
select cidx, CCHAR1, SUBSTR(CCHAR1,8) from datatypetestm;
select cidx, CCHAR1, SUBSTR(CCHAR1,9) from datatypetestm;
select cidx, CCHAR1, SUBSTR(CCHAR1 FROM 5) from datatypetestm;
select cidx, CCHAR1, SUBSTR(CCHAR1 FROM 9) from datatypetestm;
select cidx, CCHAR1, SUBSTR(CCHAR1,5,2) from datatypetestm;
select cidx, CCHAR1, SUBSTR(CCHAR1,9,3) from datatypetestm;
select cidx, CCHAR1, SUBSTR(CCHAR1 FROM 5 FOR 2) from datatypetestm;
select cidx, CCHAR1, SUBSTR(CCHAR1 FROM 9 FOR 3) from datatypetestm;
select cidx, CCHAR2, SUBSTR(CCHAR2,1) from datatypetestm;
select cidx, CCHAR2, SUBSTR(CCHAR2,5) from datatypetestm;
select cidx, CCHAR2, SUBSTR(CCHAR2,7) from datatypetestm;
select cidx, CCHAR2, SUBSTR(CCHAR2,8) from datatypetestm;
select cidx, CCHAR2, SUBSTR(CCHAR2,9) from datatypetestm;
select cidx, CCHAR2, SUBSTR(CCHAR2 FROM 5) from datatypetestm;
select cidx, CCHAR2, SUBSTR(CCHAR2 FROM 9) from datatypetestm;
select cidx, CCHAR2, SUBSTR(CCHAR2,5,2) from datatypetestm;
select cidx, CCHAR2, SUBSTR(CCHAR2,9,3) from datatypetestm;
select cidx, CCHAR2, SUBSTR(CCHAR2 FROM 5 FOR 2) from datatypetestm;
select cidx, CCHAR2, SUBSTR(CCHAR2 FROM 9 FOR 3) from datatypetestm;
select cidx, CCHAR3, SUBSTR(CCHAR3,1) from datatypetestm;
select cidx, CCHAR3, SUBSTR(CCHAR3,5) from datatypetestm;
select cidx, CCHAR3, SUBSTR(CCHAR3,7) from datatypetestm;
select cidx, CCHAR3, SUBSTR(CCHAR3,8) from datatypetestm;
select cidx, CCHAR3, SUBSTR(CCHAR3,9) from datatypetestm;
select cidx, CCHAR3, SUBSTR(CCHAR3 FROM 5) from datatypetestm;
select cidx, CCHAR3, SUBSTR(CCHAR3 FROM 9) from datatypetestm;
select cidx, CCHAR3, SUBSTR(CCHAR3,5,2) from datatypetestm;
select cidx, CCHAR3, SUBSTR(CCHAR3,9,3) from datatypetestm;
select cidx, CCHAR3, SUBSTR(CCHAR3 FROM 5 FOR 2) from datatypetestm;
select cidx, CCHAR3, SUBSTR(CCHAR3 FROM 9 FOR 3) from datatypetestm;
select cidx, CCHAR4, SUBSTR(CCHAR4,1) from datatypetestm;
select cidx, CCHAR4, SUBSTR(CCHAR4,5) from datatypetestm;
select cidx, CCHAR4, SUBSTR(CCHAR4,7) from datatypetestm;
select cidx, CCHAR4, SUBSTR(CCHAR4,8) from datatypetestm;
select cidx, CCHAR4, SUBSTR(CCHAR4,9) from datatypetestm;
select cidx, CCHAR4, SUBSTR(CCHAR4 FROM 5) from datatypetestm;
select cidx, CCHAR4, SUBSTR(CCHAR4 FROM 9) from datatypetestm;
select cidx, CCHAR4, SUBSTR(CCHAR4,5,2) from datatypetestm;
select cidx, CCHAR4, SUBSTR(CCHAR4,9,3) from datatypetestm;
select cidx, CCHAR4, SUBSTR(CCHAR4 FROM 5 FOR 2) from datatypetestm;
select cidx, CCHAR4, SUBSTR(CCHAR4 FROM 9 FOR 3) from datatypetestm;
select cidx, CCHAR5, SUBSTR(CCHAR5,1) from datatypetestm;
select cidx, CCHAR5, SUBSTR(CCHAR5,5) from datatypetestm;
select cidx, CCHAR5, SUBSTR(CCHAR5,7) from datatypetestm;
select cidx, CCHAR5, SUBSTR(CCHAR5,8) from datatypetestm;
select cidx, CCHAR5, SUBSTR(CCHAR5,9) from datatypetestm;
select cidx, CCHAR5, SUBSTR(CCHAR5 FROM 5) from datatypetestm;
select cidx, CCHAR5, SUBSTR(CCHAR5 FROM 9) from datatypetestm;
select cidx, CCHAR5, SUBSTR(CCHAR5,5,2) from datatypetestm;
select cidx, CCHAR5, SUBSTR(CCHAR5,9,3) from datatypetestm;
select cidx, CCHAR5, SUBSTR(CCHAR5 FROM 5 FOR 2) from datatypetestm;
select cidx, CCHAR5, SUBSTR(CCHAR5 FROM 9 FOR 3) from datatypetestm;
select cidx, CCHAR6, SUBSTR(CCHAR6,1) from datatypetestm;
select cidx, CCHAR6, SUBSTR(CCHAR6,5) from datatypetestm;
select cidx, CCHAR6, SUBSTR(CCHAR6,7) from datatypetestm;
select cidx, CCHAR6, SUBSTR(CCHAR6,8) from datatypetestm;
select cidx, CCHAR6, SUBSTR(CCHAR6,9) from datatypetestm;
select cidx, CCHAR6, SUBSTR(CCHAR6 FROM 5) from datatypetestm;
select cidx, CCHAR6, SUBSTR(CCHAR6 FROM 9) from datatypetestm;
select cidx, CCHAR6, SUBSTR(CCHAR6,5,2) from datatypetestm;
select cidx, CCHAR6, SUBSTR(CCHAR6,9,3) from datatypetestm;
select cidx, CCHAR6, SUBSTR(CCHAR6 FROM 5 FOR 2) from datatypetestm;
select cidx, CCHAR6, SUBSTR(CCHAR6 FROM 9 FOR 3) from datatypetestm;
select cidx, CCHAR7, SUBSTR(CCHAR7,1) from datatypetestm;
select cidx, CCHAR7, SUBSTR(CCHAR7,5) from datatypetestm;
select cidx, CCHAR7, SUBSTR(CCHAR7,7) from datatypetestm;
select cidx, CCHAR7, SUBSTR(CCHAR7,8) from datatypetestm;
select cidx, CCHAR7, SUBSTR(CCHAR7,9) from datatypetestm;
select cidx, CCHAR7, SUBSTR(CCHAR7 FROM 5) from datatypetestm;
select cidx, CCHAR7, SUBSTR(CCHAR7 FROM 9) from datatypetestm;
select cidx, CCHAR7, SUBSTR(CCHAR7,5,2) from datatypetestm;
select cidx, CCHAR7, SUBSTR(CCHAR7,9,3) from datatypetestm;
select cidx, CCHAR7, SUBSTR(CCHAR7 FROM 5 FOR 2) from datatypetestm;
select cidx, CCHAR7, SUBSTR(CCHAR7 FROM 9 FOR 3) from datatypetestm;
select cidx, CCHAR8, SUBSTR(CCHAR8,1) from datatypetestm;
select cidx, CCHAR8, SUBSTR(CCHAR8,5) from datatypetestm;
select cidx, CCHAR8, SUBSTR(CCHAR8,7) from datatypetestm;
select cidx, CCHAR8, SUBSTR(CCHAR8,8) from datatypetestm;
select cidx, CCHAR8, SUBSTR(CCHAR8,9) from datatypetestm;
select cidx, CCHAR8, SUBSTR(CCHAR8 FROM 5) from datatypetestm;
select cidx, CCHAR8, SUBSTR(CCHAR8 FROM 9) from datatypetestm;
select cidx, CCHAR8, SUBSTR(CCHAR8,5,2) from datatypetestm;
select cidx, CCHAR8, SUBSTR(CCHAR8,9,3) from datatypetestm;
select cidx, CCHAR8, SUBSTR(CCHAR8 FROM 5 FOR 2) from datatypetestm;
select cidx, CCHAR8, SUBSTR(CCHAR8 FROM 9 FOR 3) from datatypetestm;
select cidx, CCHAR9, SUBSTR(CCHAR9,1) from datatypetestm;
select cidx, CCHAR9, SUBSTR(CCHAR9,5) from datatypetestm;
select cidx, CCHAR9, SUBSTR(CCHAR9,7) from datatypetestm;
select cidx, CCHAR9, SUBSTR(CCHAR9,8) from datatypetestm;
select cidx, CCHAR9, SUBSTR(CCHAR9,9) from datatypetestm;
select cidx, CCHAR9, SUBSTR(CCHAR9 FROM 5) from datatypetestm;
select cidx, CCHAR9, SUBSTR(CCHAR9 FROM 9) from datatypetestm;
select cidx, CCHAR9, SUBSTR(CCHAR9,5,2) from datatypetestm;
select cidx, CCHAR9, SUBSTR(CCHAR9,9,3) from datatypetestm;
select cidx, CCHAR9, SUBSTR(CCHAR9 FROM 5 FOR 2) from datatypetestm;
select cidx, CCHAR9, SUBSTR(CCHAR9 FROM 9 FOR 3) from datatypetestm;
select cidx, CCHAR255, SUBSTR(CCHAR255,1) from datatypetestm;
select cidx, CCHAR255, SUBSTR(CCHAR255,5) from datatypetestm;
select cidx, CCHAR255, SUBSTR(CCHAR255,7) from datatypetestm;
select cidx, CCHAR255, SUBSTR(CCHAR255,8) from datatypetestm;
select cidx, CCHAR255, SUBSTR(CCHAR255,9) from datatypetestm;
select cidx, CCHAR255, SUBSTR(CCHAR255 FROM 5) from datatypetestm;
select cidx, CCHAR255, SUBSTR(CCHAR255 FROM 9) from datatypetestm;
select cidx, CCHAR255, SUBSTR(CCHAR255,5,2) from datatypetestm;
select cidx, CCHAR255, SUBSTR(CCHAR255,9,3) from datatypetestm;
select cidx, CCHAR255, SUBSTR(CCHAR255 FROM 5 FOR 2) from datatypetestm;
select cidx, CCHAR255, SUBSTR(CCHAR255 FROM 9 FOR 3) from datatypetestm;
select cidx, CVCHAR1, SUBSTR(CVCHAR1,1) from datatypetestm;
select cidx, CVCHAR1, SUBSTR(CVCHAR1,5) from datatypetestm;
select cidx, CVCHAR1, SUBSTR(CVCHAR1,7) from datatypetestm;
select cidx, CVCHAR1, SUBSTR(CVCHAR1,8) from datatypetestm;
select cidx, CVCHAR1, SUBSTR(CVCHAR1,9) from datatypetestm;
select cidx, CVCHAR1, SUBSTR(CVCHAR1 FROM 5) from datatypetestm;
select cidx, CVCHAR1, SUBSTR(CVCHAR1 FROM 9) from datatypetestm;
select cidx, CVCHAR1, SUBSTR(CVCHAR1,5,2) from datatypetestm;
select cidx, CVCHAR1, SUBSTR(CVCHAR1,9,3) from datatypetestm;
select cidx, CVCHAR1, SUBSTR(CVCHAR1 FROM 5 FOR 2) from datatypetestm;
select cidx, CVCHAR1, SUBSTR(CVCHAR1 FROM 9 FOR 3) from datatypetestm;
select cidx, CVCHAR2, SUBSTR(CVCHAR2,1) from datatypetestm;
select cidx, CVCHAR2, SUBSTR(CVCHAR2,5) from datatypetestm;
select cidx, CVCHAR2, SUBSTR(CVCHAR2,7) from datatypetestm;
select cidx, CVCHAR2, SUBSTR(CVCHAR2,8) from datatypetestm;
select cidx, CVCHAR2, SUBSTR(CVCHAR2,9) from datatypetestm;
select cidx, CVCHAR2, SUBSTR(CVCHAR2 FROM 5) from datatypetestm;
select cidx, CVCHAR2, SUBSTR(CVCHAR2 FROM 9) from datatypetestm;
select cidx, CVCHAR2, SUBSTR(CVCHAR2,5,2) from datatypetestm;
select cidx, CVCHAR2, SUBSTR(CVCHAR2,9,3) from datatypetestm;
select cidx, CVCHAR2, SUBSTR(CVCHAR2 FROM 5 FOR 2) from datatypetestm;
select cidx, CVCHAR2, SUBSTR(CVCHAR2 FROM 9 FOR 3) from datatypetestm;
select cidx, CVCHAR3, SUBSTR(CVCHAR3,1) from datatypetestm;
select cidx, CVCHAR3, SUBSTR(CVCHAR3,5) from datatypetestm;
select cidx, CVCHAR3, SUBSTR(CVCHAR3,7) from datatypetestm;
select cidx, CVCHAR3, SUBSTR(CVCHAR3,8) from datatypetestm;
select cidx, CVCHAR3, SUBSTR(CVCHAR3,9) from datatypetestm;
select cidx, CVCHAR3, SUBSTR(CVCHAR3 FROM 5) from datatypetestm;
select cidx, CVCHAR3, SUBSTR(CVCHAR3 FROM 9) from datatypetestm;
select cidx, CVCHAR3, SUBSTR(CVCHAR3,5,2) from datatypetestm;
select cidx, CVCHAR3, SUBSTR(CVCHAR3,9,3) from datatypetestm;
select cidx, CVCHAR3, SUBSTR(CVCHAR3 FROM 5 FOR 2) from datatypetestm;
select cidx, CVCHAR3, SUBSTR(CVCHAR3 FROM 9 FOR 3) from datatypetestm;
select cidx, CVCHAR4, SUBSTR(CVCHAR4,1) from datatypetestm;
select cidx, CVCHAR4, SUBSTR(CVCHAR4,5) from datatypetestm;
select cidx, CVCHAR4, SUBSTR(CVCHAR4,7) from datatypetestm;
select cidx, CVCHAR4, SUBSTR(CVCHAR4,8) from datatypetestm;
select cidx, CVCHAR4, SUBSTR(CVCHAR4,9) from datatypetestm;
select cidx, CVCHAR4, SUBSTR(CVCHAR4 FROM 5) from datatypetestm;
select cidx, CVCHAR4, SUBSTR(CVCHAR4 FROM 9) from datatypetestm;
select cidx, CVCHAR4, SUBSTR(CVCHAR4,5,2) from datatypetestm;
select cidx, CVCHAR4, SUBSTR(CVCHAR4,9,3) from datatypetestm;
select cidx, CVCHAR4, SUBSTR(CVCHAR4 FROM 5 FOR 2) from datatypetestm;
select cidx, CVCHAR4, SUBSTR(CVCHAR4 FROM 9 FOR 3) from datatypetestm;
select cidx, CVCHAR5, SUBSTR(CVCHAR5,1) from datatypetestm;
select cidx, CVCHAR5, SUBSTR(CVCHAR5,5) from datatypetestm;
select cidx, CVCHAR5, SUBSTR(CVCHAR5,7) from datatypetestm;
select cidx, CVCHAR5, SUBSTR(CVCHAR5,8) from datatypetestm;
select cidx, CVCHAR5, SUBSTR(CVCHAR5,9) from datatypetestm;
select cidx, CVCHAR5, SUBSTR(CVCHAR5 FROM 5) from datatypetestm;
select cidx, CVCHAR5, SUBSTR(CVCHAR5 FROM 9) from datatypetestm;
select cidx, CVCHAR5, SUBSTR(CVCHAR5,5,2) from datatypetestm;
select cidx, CVCHAR5, SUBSTR(CVCHAR5,9,3) from datatypetestm;
select cidx, CVCHAR5, SUBSTR(CVCHAR5 FROM 5 FOR 2) from datatypetestm;
select cidx, CVCHAR5, SUBSTR(CVCHAR5 FROM 9 FOR 3) from datatypetestm;
select cidx, CVCHAR6, SUBSTR(CVCHAR6,1) from datatypetestm;
select cidx, CVCHAR6, SUBSTR(CVCHAR6,5) from datatypetestm;
select cidx, CVCHAR6, SUBSTR(CVCHAR6,7) from datatypetestm;
select cidx, CVCHAR6, SUBSTR(CVCHAR6,8) from datatypetestm;
select cidx, CVCHAR6, SUBSTR(CVCHAR6,9) from datatypetestm;
select cidx, CVCHAR6, SUBSTR(CVCHAR6 FROM 5) from datatypetestm;
select cidx, CVCHAR6, SUBSTR(CVCHAR6 FROM 9) from datatypetestm;
select cidx, CVCHAR6, SUBSTR(CVCHAR6,5,2) from datatypetestm;
select cidx, CVCHAR6, SUBSTR(CVCHAR6,9,3) from datatypetestm;
select cidx, CVCHAR6, SUBSTR(CVCHAR6 FROM 5 FOR 2) from datatypetestm;
select cidx, CVCHAR6, SUBSTR(CVCHAR6 FROM 9 FOR 3) from datatypetestm;
select cidx, CVCHAR7, SUBSTR(CVCHAR7,1) from datatypetestm;
select cidx, CVCHAR7, SUBSTR(CVCHAR7,5) from datatypetestm;
select cidx, CVCHAR7, SUBSTR(CVCHAR7,7) from datatypetestm;
select cidx, CVCHAR7, SUBSTR(CVCHAR7,8) from datatypetestm;
select cidx, CVCHAR7, SUBSTR(CVCHAR7,9) from datatypetestm;
select cidx, CVCHAR7, SUBSTR(CVCHAR7 FROM 5) from datatypetestm;
select cidx, CVCHAR7, SUBSTR(CVCHAR7 FROM 9) from datatypetestm;
select cidx, CVCHAR7, SUBSTR(CVCHAR7,5,2) from datatypetestm;
select cidx, CVCHAR7, SUBSTR(CVCHAR7,9,3) from datatypetestm;
select cidx, CVCHAR7, SUBSTR(CVCHAR7 FROM 5 FOR 2) from datatypetestm;
select cidx, CVCHAR7, SUBSTR(CVCHAR7 FROM 9 FOR 3) from datatypetestm;
select cidx, CVCHAR8, SUBSTR(CVCHAR8,1) from datatypetestm;
select cidx, CVCHAR8, SUBSTR(CVCHAR8,5) from datatypetestm;
select cidx, CVCHAR8, SUBSTR(CVCHAR8,7) from datatypetestm;
select cidx, CVCHAR8, SUBSTR(CVCHAR8,8) from datatypetestm;
select cidx, CVCHAR8, SUBSTR(CVCHAR8,9) from datatypetestm;
select cidx, CVCHAR8, SUBSTR(CVCHAR8 FROM 5) from datatypetestm;
select cidx, CVCHAR8, SUBSTR(CVCHAR8 FROM 9) from datatypetestm;
select cidx, CVCHAR8, SUBSTR(CVCHAR8,5,2) from datatypetestm;
select cidx, CVCHAR8, SUBSTR(CVCHAR8,9,3) from datatypetestm;
select cidx, CVCHAR8, SUBSTR(CVCHAR8 FROM 5 FOR 2) from datatypetestm;
select cidx, CVCHAR8, SUBSTR(CVCHAR8 FROM 9 FOR 3) from datatypetestm;
select cidx, CVCHAR255, SUBSTR(CVCHAR255,1) from datatypetestm;
select cidx, CVCHAR255, SUBSTR(CVCHAR255,5) from datatypetestm;
select cidx, CVCHAR255, SUBSTR(CVCHAR255,7) from datatypetestm;
select cidx, CVCHAR255, SUBSTR(CVCHAR255,8) from datatypetestm;
select cidx, CVCHAR255, SUBSTR(CVCHAR255,9) from datatypetestm;
select cidx, CVCHAR255, SUBSTR(CVCHAR255 FROM 5) from datatypetestm;
select cidx, CVCHAR255, SUBSTR(CVCHAR255 FROM 9) from datatypetestm;
select cidx, CVCHAR255, SUBSTR(CVCHAR255,5,2) from datatypetestm;
select cidx, CVCHAR255, SUBSTR(CVCHAR255,9,3) from datatypetestm;
select cidx, CVCHAR255, SUBSTR(CVCHAR255 FROM 5 FOR 2) from datatypetestm;
select cidx, CVCHAR255, SUBSTR(CVCHAR255 FROM 9 FOR 3) from datatypetestm;
select cidx, CCHAR1 from datatypetestm where SUBSTR(CCHAR1,1) <> CCHAR1;
select cidx, CCHAR1 from datatypetestm where SUBSTR(CCHAR1,5) <> CCHAR1;
select cidx, CCHAR1 from datatypetestm where SUBSTR(CCHAR1,7) <> CCHAR1;

DROP DATABASE regr_fe_substr;