[MCOL-4498] LIKE is not collation aware - Jira

XML

Word

Printable

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a CHAR(3) CHARACTER SET utf8) ENGINE=ColumnStore;

INSERT INTO t1 VALUES ('A'),('a');

SELECT * FROM t1 WHERE a LIKE 'a';

+------+

| a    |

+------+

| a    |

+------+

Notice, it returns only one row ignoring the fact that the collations is utf8_general_ci, which is case insensitive.

It should return two rows like MyISAM does:

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a CHAR(3) CHARACTER SET utf8) ENGINE=MyISAM;

INSERT INTO t1 VALUES ('A'),('a');

SELECT * FROM t1 WHERE a LIKE 'a';

+------+

| a    |

+------+

| A    |

| a    |

+------+

relates to

MCOL-495 Make string comparison not case sensitive

MCOL-3536 Order by with UTF

MCOL-4064 Make JOIN collation aware

MCOL-4065 DISTINCT is case sensitive

MCOL-4388 Equality does not respect the NOPAD collation attribute

MCOL-4417 Non-equality comparison operators do not work well with NOPAD collations

MCOL-4499 NOT LIKE is not compatible with MariaDB on explicit NULL

MCOL-4539 WHERE short_char_column='literal' ignores the collation on a huge table

(3 relates to)

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