[#MCOL-5418] LIKE appears not to work with short (<8) string columns

It was discovered when working on ~~MCOL-271~~. So I use slightly modified script and results from the comments there.

use test;

drop table if exists ti;

drop table if exists tcs;

create table ti(d1 char(6), d2 char(6)) engine=innodb;

create table tcs(d1 char(6), d2 char(6)) engine=columnstore;

insert into ti(d1, d2) values (NULL,NULL), (NULL, ''), (NULL, 'a'), ('', NULL), ('',''), ('', 'a'), ('a',NULL), ('a',''), ('a','a');

insert into tcs(d1, d2) values (NULL,NULL), (NULL, ''), (NULL, 'a'), ('', NULL), ('',''), ('', 'a'), ('a',NULL), ('a',''), ('a','a');

select 'innodb like', d1, d2 from ti where (d1 like d2);

select 'columnstore like', d1, d2 from tcs where (d1 like d2);

select 'innodb not like', d1, d2 from ti where (d1 not like d2);

select 'columnstore not like', d1, d2 from tcs where (d1 not like d2);

select 'innodb not (like)', d1, d2 from ti where not (d1 like d2);

select 'columnstore not (like)', d1, d2 from tcs where not (d1 like d2);

# mysql <0.sql

innodb like     d1      d2

innodb like

innodb like     a       a

innodb not like d1      d2

innodb not like         a

innodb not like a

innodb not (like)       d1      d2

innodb not (like)               a

innodb not (like)       a

Notice the absence of Columnstore's output for (NOT) LIKE queries. LIKE does not work properly under current develop, it seems.

[MCOL-5418] LIKE appears not to work with short (<8) string columns Created: 2023-02-08 Updated: 2023-09-22 Resolved: 2023-05-23
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	None
Affects Version/s:	None
Fix Version/s:	23.10.0