diff options
Diffstat (limited to 'mysql-test/include/weight_string_l3.inc')
| -rw-r--r-- | mysql-test/include/weight_string_l3.inc | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/include/weight_string_l3.inc b/mysql-test/include/weight_string_l3.inc new file mode 100644 index 00000000..cae1dc3b --- /dev/null +++ b/mysql-test/include/weight_string_l3.inc @@ -0,0 +1,10 @@ +select @@collation_connection; +select hex(weight_string('a' LEVEL 3)); +select hex(weight_string('A' LEVEL 3)); +select hex(weight_string('abc' LEVEL 3)); +select hex(weight_string('abc' as char(2) LEVEL 3)); +select hex(weight_string('abc' as char(3) LEVEL 3)); +select hex(weight_string('Abc' as char(5) LEVEL 3)); +select hex(weight_string('Abc' as char(5) LEVEL 3 REVERSE)); +select hex(weight_string('Abc' as char(5) LEVEL 3 DESC)); +select hex(weight_string('Abc' as char(5) LEVEL 3 DESC REVERSE)); |