Bug #105911 | Please add a warning when max_sort_length is reached. | ||
---|---|---|---|
Submitted: | 15 Dec 2021 20:43 | Modified: | 16 Dec 2021 5:56 |
Reporter: | Jean-François Gagné | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Options | Severity: | S4 (Feature request) |
Version: | 5.7.36 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[15 Dec 2021 20:43]
Jean-François Gagné
[16 Dec 2021 5:56]
MySQL Verification Team
Hello Jean-François, Thank you for the feature request! regards, Umesh
[20 Dec 2021 13:22]
Tor Didriksen
Posted by developer: In 8.0, this is relevant only for the old PAD SPACE collations, which have all been deprecated. Try this in 8.0: select * from information_schema.collations; +----------------------------+--------------------+-----+------------+-------------+---------+---------------+ | COLLATION_NAME | CHARACTER_SET_NAME | ID | IS_DEFAULT | IS_COMPILED | SORTLEN | PAD_ATTRIBUTE | +----------------------------+--------------------+-----+------------+-------------+---------+---------------+ | armscii8_general_ci | armscii8 | 32 | Yes | Yes | 1 | PAD SPACE | | armscii8_bin | armscii8 | 64 | | Yes | 1 | PAD SPACE | | ascii_general_ci | ascii | 11 | Yes | Yes | 1 | PAD SPACE | | ascii_bin | ascii | 65 | | Yes | 1 | PAD SPACE | | big5_chinese_ci | big5 | 1 | Yes | Yes | 1 | PAD SPACE | | big5_bin | big5 | 84 | | Yes | 1 | PAD SPACE | | binary | binary | 63 | Yes | Yes | 1 | NO PAD | ... | latin1_swedish_ci | latin1 | 8 | Yes | Yes | 1 | PAD SPACE | ... | utf8mb4_0900_ai_ci | utf8mb4 | 255 | Yes | Yes | 0 | NO PAD | ...
[20 Dec 2021 13:24]
Tor Didriksen
Posted by developer: In MySQL 8.0: mysql> show variables like "character%"; +--------------------------+---------------------------------------------+ | Variable_name | Value | +--------------------------+---------------------------------------------+ | character_set_client | utf8mb4 | | character_set_connection | utf8mb4 | | character_set_database | utf8mb4 | | character_set_filesystem | binary | | character_set_results | utf8mb4 | | character_set_server | utf8mb4 | | character_set_system | utf8mb3 | In 5.7: mysql> show variables like "character%"; +--------------------------+------------------------------------------------+ | Variable_name | Value | +--------------------------+------------------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | latin1 | | character_set_system | utf8 |