You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-11-03 17:13:17 +03:00
57 lines
2.9 KiB
Plaintext
57 lines
2.9 KiB
Plaintext
USE tpch1;
|
|
drop table if exists mcol1559;
|
|
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 ");
|
|
select * from mcol1559 where c7nospace = "ABC";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where c20nospace = "ABC12345678910";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where c7nospace = "ABC ";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where c20nospace = "ABC12345678910 ";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where vcnospace = "ABC";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where vcnospace = "ABC ";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where c7space = "ABC";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where c20space = "ABC12345678910";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where c7space = "ABC ";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where c20space = "ABC12345678910 ";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where vcspace = "ABC";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where vcspace = "ABC ";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where c7nospace LIKE "ABC";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where c20nospace LIKE "ABC12345678910";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where vcnospace LIKE "ABC";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
ABC ABC ABC12345678910 ABC12345678910 ABC ABC
|
|
select * from mcol1559 where c7nospace LIKE "ABC ";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
select * from mcol1559 where c20nospace LIKE "ABC12345678910 ";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
select * from mcol1559 where vcnospace LIKE "ABC ";
|
|
c7nospace c7space c20nospace c20space vcnospace vcspace
|
|
drop table if exists mcol1559;
|