Bug #107002 Setting invalid collation prevents show variables

• Submitted: 13 Apr 2022 9:08
• Modified: 13 Apr 2022 9:45
• Reporter: Geert Vanderkelen
• Status: Verified
• Category: MySQL Server: Document Store: X Plugin
• Severity: S3 (Non-critical)
• Version: 8.0.28
• OS: Any
• CPU Architecture: Any

[13 Apr 2022 9:08] Geert Vanderkelen

Description:
When setting an invalid collation (not utf8mb4_*) using the mysqlsh, prevents the use of SHOW VARIABLES.

How to repeat:
Using mysqlsh:

> SHOW VARIABLES LIKE 'collation%';
# all is well

> SET @@collation_connection = utf32_danish_ci;
# no error

> SHOW VARIABLES LIKE 'collation%';
# Empty set; no error

> SET @@collation_connection = 'utf8mb4_czech_ci';
# all is well again

[13 Apr 2022 9:45] MySQL Verification Team

Hello Geert,

Thank you for the report and feedback.
Verified as described.

Regards,
Umesh