Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.6.24
-
None
-
None
Description
mysqltest implicitly casts the binary result of REVERSE() to a numeric context, which interprets the reversed binary bytes as a number (0x563412 → 6403911).
However MySQL server, treats the output as a binary string, displaying printable characters ('V', '4') and leaving non-printable bytes invisible.
Test Case:
let $rv45 = $(reverse(0x123456));
|
-- echo reverse(0x123456) -> $rv45; |
Mysqltest output:
worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 19000..19029 |
reverse(0x123456) -> 6403911;
|
main.rev [ pass ]
|
Server output:
MariaDB [(none)]> select reverse(0x123456); |
+-------------------+ |
| reverse(0x123456) |
|
+-------------------+ |
| V4 |
|
+-------------------+ |
1 row in set (0.001 sec) |
Attachments
Issue Links
- relates to
-
MDEV-36107 expressions in mysqltest
-
- Open
-