Fix collation issue in user view

CREATE OR REPLACE VIEW user AS
SELECT
    `global_priv`.`Host` COLLATE utf8mb4_unicode_520_ci AS `Host`,
    `global_priv`.`User` COLLATE utf8mb4_unicode_520_ci AS `User`,

    IF(
        JSON_VALUE(`global_priv`.`Priv`, '$.plugin') IN ('mysql_native_password', 'mysql_old_password'),
        IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.authentication_string'), ''),
        ''
    ) COLLATE utf8mb4_unicode_520_ci AS `Password`,

    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 1, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Select_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 2, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Insert_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 4, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Update_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 8, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Delete_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 16, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Create_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 32, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Drop_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 64, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Reload_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 128, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Shutdown_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 256, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Process_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 512, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `File_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 1024, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Grant_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 2048, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `References_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 4096, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Index_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 8192, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Alter_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 16384, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Show_db_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 32768, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Super_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 65536, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Create_tmp_table_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 131072, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Lock_tables_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 262144, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Execute_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 524288, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Repl_slave_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 1048576, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Repl_client_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 2097152, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Create_view_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 4194304, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Show_view_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 8388608, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Create_routine_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 16777216, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Alter_routine_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 33554432, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Create_user_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 67108864, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Event_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 134217728, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Trigger_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 268435456, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Create_tablespace_priv`,
    IF(JSON_VALUE(`global_priv`.`Priv`, '$.access') & 536870912, 'Y', 'N') COLLATE utf8mb4_unicode_520_ci AS `Delete_history_priv`,

    ELT(
        IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.ssl_type'), 0) + 1,
        '', 'ANY', 'X509', 'SPECIFIED'
    ) COLLATE utf8mb4_unicode_520_ci AS `ssl_type`,

    IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.ssl_cipher'), '') COLLATE utf8mb4_unicode_520_ci AS `ssl_cipher`,
    IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.x509_issuer'), '') COLLATE utf8mb4_unicode_520_ci AS `x509_issuer`,
    IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.x509_subject'), '') COLLATE utf8mb4_unicode_520_ci AS `x509_subject`,

    CAST(IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.max_questions'), 0) AS UNSIGNED) AS `max_questions`,
    CAST(IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.max_updates'), 0) AS UNSIGNED) AS `max_updates`,
    CAST(IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.max_connections'), 0) AS UNSIGNED) AS `max_connections`,
    CAST(IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.max_user_connections'), 0) AS SIGNED) AS `max_user_connections`,

    IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.plugin'), '') COLLATE utf8mb4_unicode_520_ci AS `plugin`,
    IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.authentication_string'), '') COLLATE utf8mb4_unicode_520_ci AS `authentication_string`,

    IF(
        IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.password_last_changed'), 1) = 0,
        'Y',
        'N'
    ) COLLATE utf8mb4_unicode_520_ci AS `password_expired`,

    ELT(
        IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.is_role'), 0) + 1,
        'N', 'Y'
    ) COLLATE utf8mb4_unicode_520_ci AS `is_role`,

    IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.default_role'), '') COLLATE utf8mb4_unicode_520_ci AS `default_role`,

    CAST(
        IFNULL(JSON_VALUE(`global_priv`.`Priv`, '$.max_statement_time'), 0.0) AS DECIMAL(12,6)
    ) AS `max_statement_time`

FROM `global_priv`;