USE tpch1;
drop table if exists mcol1403a;
drop table if exists mcol1403b;
create table mcol1403a (a int, b varchar(4)) engine=columnstore;
create table mcol1403b (a int, b char(20), c varchar(20)) engine=columnstore;
insert into mcol1403a values (1, 'ABC ');
select * from mcol1403a where b = 'ABC';
a	b
1	ABC 
select * from mcol1403a where b like 'ABC';
a	b
select a, hex(b) from mcol1403a;
a	hex(b)
1	41424320
insert into mcol1403b values (1, 'Majestic12 ', 'Majestic12 ');
select * from mcol1403b where lower(b) like 'majestic12 ';
a	b	c
select * from mcol1403b where lower(c) like 'majestic12 ';
a	b	c
1	Majestic12	Majestic12 
select concat(b, '#') from mcol1403b where b like '% ';
concat(b, '#')
select concat(c, '#') from mcol1403b where c like '% ';
concat(c, '#')
Majestic12 #
drop table mcol1403a;
drop table mcol1403b;