Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.0.10, 10.2(EOL), 10.3(EOL)
Description
mysql> SET NAMES utf8;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
mysql> SELECT hex('��'), char_length('��'), octet_length('��');
|
+-------------+---------------------+----------------------+
|
| hex('��') | char_length('��') | octet_length('��') |
|
+-------------+---------------------+----------------------+
|
| F09F9881 | 4 | 4 |
|
+-------------+---------------------+----------------------+
|
1 row in set (0.00 sec)
|
Notice, I use "SET NAMES utf8" (which is a 3-byte character set
and supports only BMP characters), but then input a 4-byte character.
The result of CHAR_LENGTH() is wrong.
0xF09F9881 is a wrong byte sequence of utf8 (it's correct for utf8mb4 only)
The expected result would be:
- either return error for the entire query
- or replace the character to '?' and thus make CHAR_LENGTH() return 1.
Attachments
Issue Links
- relates to
-
MDEV-6643 Improve performance of string processing in the parser
-
- Stalled
-