mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-05-25 13:42:31 +03:00
a2d7a21196
This WHERE part will be performed with FilterCommand, which did not had LIKE operator implemented until now.
22 lines
559 B
Plaintext
22 lines
559 B
Plaintext
# This test tests the (NOT) LIKE test in filters that is added
|
|
# to a FilterCommand in primproc.
|
|
# This is a very rare situation, yet somehow I managed to trigger it.
|
|
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS mcol5418;
|
|
--enable_warnings
|
|
|
|
CREATE DATABASE mcol5418;
|
|
|
|
USE mcol5418;
|
|
|
|
CREATE TABLE tcs(d1 CHAR(6), d2 CHAR(6)) ENGINE=columnstore;
|
|
|
|
INSERT INTO tcs(d1, d2) VALUES ('a','a'), ('a', 'b');
|
|
|
|
SELECT 'columnstore like', d1, d2 FROM tcs WHERE (d1 LIKE d2);
|
|
|
|
SELECT 'columnstore not like', d1, d2 FROM tcs WHERE (d1 NOT LIKE d2);
|
|
|
|
DROP DATABASE mcol5418;
|