diff options
| author | Alexander Barkov <bar@mnogosearch.org> | 2013-10-23 20:25:52 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mnogosearch.org> | 2013-10-23 20:25:52 +0400 |
| commit | 426d246f5b8a4c598a913838b625e05e63ccb41f (patch) | |
| tree | 16792dd3268c0ec0fb02837c761a535af1938b1f /mysql-test/include/weight_string_l3.inc | |
| parent | de8e306b6921ab32aedde957594e570166a7fce1 (diff) | |
| download | mariadb-git-426d246f5b8a4c598a913838b625e05e63ccb41f.tar.gz | |
MDEV-5163 Merge WEIGHT_STRING function from MySQL-5.6
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 00000000000..cae1dc3bf30 --- /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)); |