diff options
Diffstat (limited to 'mysql-test/main/information_schema_routines.result')
-rw-r--r-- | mysql-test/main/information_schema_routines.result | 110 |
1 files changed, 55 insertions, 55 deletions
diff --git a/mysql-test/main/information_schema_routines.result b/mysql-test/main/information_schema_routines.result index ddb5ea00024..90768765883 100644 --- a/mysql-test/main/information_schema_routines.result +++ b/mysql-test/main/information_schema_routines.result @@ -32,11 +32,11 @@ ROUTINES CREATE TEMPORARY TABLE `ROUTINES` ( `LAST_ALTERED` datetime NOT NULL, `SQL_MODE` varchar(8192) NOT NULL, `ROUTINE_COMMENT` longtext NOT NULL, - `DEFINER` varchar(189) NOT NULL, + `DEFINER` varchar(384) NOT NULL, `CHARACTER_SET_CLIENT` varchar(32) NOT NULL, `COLLATION_CONNECTION` varchar(32) NOT NULL, `DATABASE_COLLATION` varchar(32) NOT NULL -) DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci +) DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci SELECT * FROM information_schema.columns WHERE table_schema = 'information_schema' AND table_name = 'routines' @@ -54,8 +54,8 @@ CHARACTER_OCTET_LENGTH 192 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(64) COLUMN_KEY EXTRA @@ -76,8 +76,8 @@ CHARACTER_OCTET_LENGTH 1536 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(512) COLUMN_KEY EXTRA @@ -98,8 +98,8 @@ CHARACTER_OCTET_LENGTH 192 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(64) COLUMN_KEY EXTRA @@ -120,8 +120,8 @@ CHARACTER_OCTET_LENGTH 192 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(64) COLUMN_KEY EXTRA @@ -142,8 +142,8 @@ CHARACTER_OCTET_LENGTH 39 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(13) COLUMN_KEY EXTRA @@ -164,8 +164,8 @@ CHARACTER_OCTET_LENGTH 192 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(64) COLUMN_KEY EXTRA @@ -296,8 +296,8 @@ CHARACTER_OCTET_LENGTH 192 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(64) COLUMN_KEY EXTRA @@ -318,8 +318,8 @@ CHARACTER_OCTET_LENGTH 192 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(64) COLUMN_KEY EXTRA @@ -340,8 +340,8 @@ CHARACTER_OCTET_LENGTH 4294967295 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE longtext COLUMN_KEY EXTRA @@ -362,8 +362,8 @@ CHARACTER_OCTET_LENGTH 24 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(8) COLUMN_KEY EXTRA @@ -384,8 +384,8 @@ CHARACTER_OCTET_LENGTH 4294967295 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE longtext COLUMN_KEY EXTRA @@ -406,8 +406,8 @@ CHARACTER_OCTET_LENGTH 192 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(64) COLUMN_KEY EXTRA @@ -428,8 +428,8 @@ CHARACTER_OCTET_LENGTH 192 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(64) COLUMN_KEY EXTRA @@ -450,8 +450,8 @@ CHARACTER_OCTET_LENGTH 24 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(8) COLUMN_KEY EXTRA @@ -472,8 +472,8 @@ CHARACTER_OCTET_LENGTH 9 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(3) COLUMN_KEY EXTRA @@ -494,8 +494,8 @@ CHARACTER_OCTET_LENGTH 192 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(64) COLUMN_KEY EXTRA @@ -516,8 +516,8 @@ CHARACTER_OCTET_LENGTH 192 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(64) COLUMN_KEY EXTRA @@ -538,8 +538,8 @@ CHARACTER_OCTET_LENGTH 21 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(7) COLUMN_KEY EXTRA @@ -604,8 +604,8 @@ CHARACTER_OCTET_LENGTH 24576 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(8192) COLUMN_KEY EXTRA @@ -626,8 +626,8 @@ CHARACTER_OCTET_LENGTH 4294967295 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE longtext COLUMN_KEY EXTRA @@ -643,14 +643,14 @@ ORDINAL_POSITION 28 COLUMN_DEFAULT NULL IS_NULLABLE NO DATA_TYPE varchar -CHARACTER_MAXIMUM_LENGTH 189 -CHARACTER_OCTET_LENGTH 567 +CHARACTER_MAXIMUM_LENGTH 384 +CHARACTER_OCTET_LENGTH 1152 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci -COLUMN_TYPE varchar(189) +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci +COLUMN_TYPE varchar(384) COLUMN_KEY EXTRA PRIVILEGES # @@ -670,8 +670,8 @@ CHARACTER_OCTET_LENGTH 96 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(32) COLUMN_KEY EXTRA @@ -692,8 +692,8 @@ CHARACTER_OCTET_LENGTH 96 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(32) COLUMN_KEY EXTRA @@ -714,8 +714,8 @@ CHARACTER_OCTET_LENGTH 96 NUMERIC_PRECISION NULL NUMERIC_SCALE NULL DATETIME_PRECISION NULL -CHARACTER_SET_NAME utf8 -COLLATION_NAME utf8_general_ci +CHARACTER_SET_NAME utf8mb3 +COLLATION_NAME utf8mb3_general_ci COLUMN_TYPE varchar(32) COLUMN_KEY EXTRA @@ -752,7 +752,7 @@ CREATED datetime NO NULL LAST_ALTERED datetime NO NULL SQL_MODE varchar(8192) NO NULL ROUTINE_COMMENT longtext NO NULL -DEFINER varchar(189) NO NULL +DEFINER varchar(384) NO NULL CHARACTER_SET_CLIENT varchar(32) NO NULL COLLATION_CONNECTION varchar(32) NO NULL DATABASE_COLLATION varchar(32) NO NULL @@ -849,5 +849,5 @@ RETURN CONCAT('XYZ, ' ,s); SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'i_s_routines_test' AND ROUTINE_NAME = 'test_func5'; SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION -test_func5 def i_s_routines_test test_func5 FUNCTION varchar 30 90 NULL NULL NULL utf8 utf8_general_ci varchar(30) SQL RETURN CONCAT('XYZ, ' ,s) NULL NULL SQL NO CONTAINS SQL NULL DEFINER <created> <modified> root@localhost latin1 latin1_swedish_ci utf8_general_ci +test_func5 def i_s_routines_test test_func5 FUNCTION varchar 30 90 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(30) SQL RETURN CONCAT('XYZ, ' ,s) NULL NULL SQL NO CONTAINS SQL NULL DEFINER <created> <modified> root@localhost latin1 latin1_swedish_ci utf8mb3_general_ci DROP DATABASE i_s_routines_test; |