summaryrefslogtreecommitdiffstats
path: root/mysql-test/include/weight_string_l1.inc
blob: 20b353c72bfe5d4242d30dd82a647f7a6fb053d7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
#enable after fix MDEV-29290
--disable_view_protocol
select @@collation_connection;
select hex(weight_string('a' LEVEL 1));
select hex(weight_string('A' LEVEL 1));
select hex(weight_string('abc' LEVEL 1));
select hex(weight_string('abc' as char(2) LEVEL 1));
select hex(weight_string('abc' as char(3) LEVEL 1));
select hex(weight_string('abc' as char(5) LEVEL 1));
select hex(weight_string('abc' as char(5) LEVEL 1 REVERSE));
select hex(weight_string('abc' as char(5) LEVEL 1 DESC));
select hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE));
--enable_view_protocol