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

XML

Word

Printable

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

The script:

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);

The answer for current develop:

# 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.

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.