mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-21 19:45:56 +03:00
b53c231ca6
This patch improves handling of NULLs in textual fields in ColumnStore. Previously empty strings were considered NULLs and it could be a problem if data scheme allows for empty strings. It was also one of major reasons of behavior difference between ColumnStore and other engines in MariaDB family. Also, this patch fixes some other bugs and incorrect behavior, for example, incorrect comparison for "column <= ''" which evaluates to constant True for all purposes before this patch.
226 lines
13 KiB
Plaintext
226 lines
13 KiB
Plaintext
--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; |