You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-10-31 18:30:33 +03:00
49 lines
1.7 KiB
Plaintext
49 lines
1.7 KiB
Plaintext
# -------------------------------------------------------------- #
|
|
# Test case migrated from regression test suite: MCOL-1559.sql
|
|
#
|
|
# Author: Daniel Lee, daniel.lee@mariadb.com
|
|
# -------------------------------------------------------------- #
|
|
#
|
|
--source ../include/have_columnstore.inc
|
|
#
|
|
USE tpch1;
|
|
#
|
|
--disable_warnings
|
|
drop table if exists mcol1559;
|
|
--enable_warnings
|
|
|
|
create table mcol1559 (c7nospace char(7), c7space char(7), c20nospace char(20), c20space char(20), vcnospace varchar(20), vcspace varchar(20)) engine=columnstore;
|
|
|
|
insert into mcol1559 values ("ABC", "ABC ", "ABC12345678910", "ABC12345678910 ", "ABC", "ABC ");
|
|
|
|
# All of these should return a row
|
|
select * from mcol1559 where c7nospace = "ABC";
|
|
select * from mcol1559 where c20nospace = "ABC12345678910";
|
|
select * from mcol1559 where c7nospace = "ABC ";
|
|
select * from mcol1559 where c20nospace = "ABC12345678910 ";
|
|
select * from mcol1559 where vcnospace = "ABC";
|
|
select * from mcol1559 where vcnospace = "ABC ";
|
|
|
|
# All of these should return a row
|
|
select * from mcol1559 where c7space = "ABC";
|
|
select * from mcol1559 where c20space = "ABC12345678910";
|
|
select * from mcol1559 where c7space = "ABC ";
|
|
select * from mcol1559 where c20space = "ABC12345678910 ";
|
|
select * from mcol1559 where vcspace = "ABC";
|
|
select * from mcol1559 where vcspace = "ABC ";
|
|
|
|
# should return a row
|
|
select * from mcol1559 where c7nospace LIKE "ABC";
|
|
select * from mcol1559 where c20nospace LIKE "ABC12345678910";
|
|
select * from mcol1559 where vcnospace LIKE "ABC";
|
|
# should not return a row
|
|
select * from mcol1559 where c7nospace LIKE "ABC ";
|
|
select * from mcol1559 where c20nospace LIKE "ABC12345678910 ";
|
|
select * from mcol1559 where vcnospace LIKE "ABC ";
|
|
|
|
--disable_warnings
|
|
drop table if exists mcol1559;
|
|
--enable_warnings
|
|
#
|
|
|