[MDEV-37867] mysqltest : UPPER() produces corrupted output - Jira

XML

Word

Printable

When applying lower("😊HELLO😊") , the output is 😊hello😊 which is the expected behavior

However, when applying upper("😊hello😊") -, the output becomes П��HELLOП��, which is unexpected and appears to be corrupted .

Test Case:

let $lw17 = $(lower("😊HELLO😊"));

-- echo lower("😊HELLO😊") -> $lw17;

let $lw2 = $(upper("😊hello😊"));

-- echo upper("😊hello😊") -> $lw2;

Mysqltest output:

worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 19000..19029

lower("😊HELLO😊") -> 😊hello😊;

upper("😊hello😊") -> П��HELLOП��;

main.l1                                  [ pass ]

Server output:

MariaDB [(none)]> select lower("😊HELLO😊") ;

+------------------+

| lower("?HELLO?") |

+------------------+

| 😊hello😊            |

+------------------+

1 row in set (0.001 sec)

MariaDB [(none)]> select upper("😊hello😊") ;

+------------------+

| upper("?hello?") |

+------------------+

| 😊HELLO😊            |

+------------------+

1 row in set (0.001 sec)

relates to

MDEV-36107 expressions in mysqltest

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.