diff options
Diffstat (limited to 'mysql-test/include/weight_string_8FA2C3.inc')
| -rw-r--r-- | mysql-test/include/weight_string_8FA2C3.inc | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/mysql-test/include/weight_string_8FA2C3.inc b/mysql-test/include/weight_string_8FA2C3.inc new file mode 100644 index 00000000..bce5c816 --- /dev/null +++ b/mysql-test/include/weight_string_8FA2C3.inc @@ -0,0 +1,38 @@ +#enable after fix MDEV-29290 +--disable_view_protocol +select collation(cast(0x8FA2C3 as char)); +select hex(weight_string(cast(0x6141 as char))); +select hex(weight_string(cast(0x8FA2C3 as char))); +select hex(weight_string(cast(0x8FA2C3 as char) as char(1))); +select hex(weight_string(cast(0x8FA2C38FA2C3 as char) as char(1))); +select hex(weight_string(cast(0x8FA2C3 as char) as char(3))); +select hex(weight_string(cast(0x8FA2C38FA2C3 as char) as char(3))); +select hex(weight_string(cast(0x408FA2C3 as char) as char(3))); +select hex(weight_string(cast(0x408FA2C38FA2C3 as char) as char(3))); +select hex(weight_string(cast(0x408FA2C38FA2C38FA2C3 as char) as char(3))); +select hex(weight_string(cast(0x40408FA2C38FA2C38FA2C3 as char) as char(3))); + +# Read 2 characters from the source string (the last character is not used) +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 1, 2, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 2, 2, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 3, 2, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 4, 2, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 5, 2, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char),25, 2, 0xC0)); + +# Read 3 characters from the source string (the entire string is used) +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 1, 3, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 2, 3, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 3, 3, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 4, 3, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 5, 3, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char),25, 3, 0xC0)); + +# Read 4 characters from the source string (extra space is added) +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 1, 4, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 2, 4, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 3, 4, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 4, 4, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char), 5, 4, 0xC0)); +select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as char),25, 4, 0xC0)); +--enable_view_protocol |