1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-06-13 16:01:32 +03:00
Files
mariadb-columnstore-engine/mysql-test/columnstore/bugfixes/mcol-4741-strings-ranges-are-unsigned.test
Sergey Zefirov c58136a32d MCOL-4741 in/like/equal(=) operations differ in results
This is due to signedness in the string range comparison in extentmap
and unsignedness everywhere else.
2021-07-02 19:22:46 +03:00

18 lines
559 B
Plaintext

--disable_warnings
DROP DATABASE IF EXISTS db4741;
--enable_warnings
CREATE DATABASE db4741;
USE db4741;
CREATE TABLE t (x VARCHAR(5) DEFAULT '') engine = columnstore;
--replace_result $MTR_SUITE_DIR MTR_SUITE_DIR
--eval LOAD DATA LOCAL infile '$MTR_SUITE_DIR/../std_data/mcol-4741-part-1-strings-and-nulls.txt' INTO TABLE t
SELECT COUNT(*) FROM t WHERE x='val';
--replace_result $MTR_SUITE_DIR MTR_SUITE_DIR
--eval LOAD DATA LOCAL infile '$MTR_SUITE_DIR/../std_data/mcol-4741-part-2-empty-strings.txt' INTO TABLE t
SELECT COUNT(*) FROM t WHERE x='val';