mariadb/mysql-test/suite/sys_vars/r/debug_dbug_utf16le.result
Alexander Barkov 9fb8881ef8 MDEV-28366 GLOBAL debug_dbug setting affected by collation_connection=utf16...
When the system variables @@debug_dbug was assigned to
some expression, Sys_debug_dbug::do_check() did not properly
convert the value from the expression character set to utf8.
So the value was erroneously re-interpretted as utf8 without
conversion. In case of a tricky expression character set
(e.g. utf16le), this led to unexpected results.

Fix:

Re-using Sys_var_charptr::do_string_check() in Sys_debug_dbug::do_check().
2024-04-10 06:09:45 +04:00

31 lines
560 B
Text

#
# Start of 10.5 tests
#
#
# MDEV-28366 GLOBAL debug_dbug setting affected by collation_connection=utf16...
#
SET NAMES utf8;
SET collation_connection=utf16le_general_ci;
SET debug_dbug='d,any_random_string';
SELECT @@debug_dbug;
@@debug_dbug
d,any_random_string
SET debug_dbug=CONCAT('d,', _latin1 0xDF);
SELECT @@debug_dbug;
@@debug_dbug
d,ß
SELECT HEX(@@debug_dbug);
HEX(@@debug_dbug)
642CC39F
SET @@debug_dbug=NULL;
SELECT @@debug_dbug;
@@debug_dbug
SET @@debug_dbug=DEFAULT;
SELECT @@debug_dbug;
@@debug_dbug
SET NAMES latin1;
#
# End of 10.5 tests
#