[#MDEV-29776] collation_connection and db_collation are too short in mysql.proc and mysql.event

The patch for ~~MDEV-27009~~ changed the maximum collation name size from 32 to 64:

-#define MY_CS_NAME_SIZE                        32

+#define MY_CS_CHARACTER_SET_NAME_SIZE   32

+#define MY_CS_COLLATION_NAME_SIZE       64

INFORMATION_SCHEMA tables were fixed accordinly. However, tables mysql.proc and mysql.event were forgotten:

SELECT table_schema, table_name, column_name, column_type

FROM information_schema.columns WHERE column_name LIKE '%colla%';

+--------------------+---------------------------------------+------------------------+-------------+

| table_schema       | table_name                            | column_name            | column_type |

+--------------------+---------------------------------------+------------------------+-------------+

| mysql              | proc                                  | collation_connection   | char(32)    |

| mysql              | proc                                  | db_collation           | char(32)    |

| mysql              | event                                 | collation_connection   | char(32)    |

| mysql              | event                                 | db_collation           | char(32)    |

| information_schema | CHARACTER_SETS                        | DEFAULT_COLLATE_NAME   | varchar(64) |

| information_schema | COLLATIONS                            | COLLATION_NAME         | varchar(64) |

| information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | COLLATION_NAME         | varchar(64) |

| information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | FULL_COLLATION_NAME    | varchar(64) |

| information_schema | COLUMNS                               | COLLATION_NAME         | varchar(64) |

| information_schema | EVENTS                                | COLLATION_CONNECTION   | varchar(64) |

| information_schema | EVENTS                                | DATABASE_COLLATION     | varchar(64) |

| information_schema | PARAMETERS                            | COLLATION_NAME         | varchar(64) |

| information_schema | ROUTINES                              | COLLATION_NAME         | varchar(64) |

| information_schema | ROUTINES                              | COLLATION_CONNECTION   | varchar(64) |

| information_schema | ROUTINES                              | DATABASE_COLLATION     | varchar(64) |

| information_schema | SCHEMATA                              | DEFAULT_COLLATION_NAME | varchar(64) |

| information_schema | STATISTICS                            | COLLATION              | varchar(1)  |

| information_schema | TABLES                                | TABLE_COLLATION        | varchar(64) |

| information_schema | TRIGGERS                              | COLLATION_CONNECTION   | varchar(64) |

| information_schema | TRIGGERS                              | DATABASE_COLLATION     | varchar(64) |

| information_schema | VIEWS                                 | COLLATION_CONNECTION   | varchar(64) |

+--------------------+---------------------------------------+------------------------+-------------+

SET NAMES 'utf8mb3' COLLATE 'utf8mb3_uca1400_swedish_nopad_ai_ci';

CREATE FUNCTION f1() RETURNS INT RETURN 1;

ERROR 1607 (HY000): Cannot create stored routine `f1`. Check warnings

+---------+------+--------------------------------------------------------------+

| Level   | Code | Message                                                      |

+---------+------+--------------------------------------------------------------+

| Warning | 1265 | Data truncated for column 'collation_connection' at row 3226 |

| Error   | 1607 | Cannot create stored routine `f1`. Check warnings            |

+---------+------+--------------------------------------------------------------+

Definitions for mysql.proc and mysql.event should be updated to use char(64) as the data type for the mentioned columns.

[MDEV-29776] collation_connection and db_collation are too short in mysql.proc and mysql.event Created: 2022-10-12 Updated: 2022-10-14 Resolved: 2022-10-14
Status:	Closed
Project:	MariaDB Server
Component/s:	Character Sets, Data types
Affects Version/s:	None
Fix Version/s:	10.10.2, 10.11.1