diff options
Diffstat (limited to 'mysql-test/suite/engines')
12 files changed, 266 insertions, 0 deletions
diff --git a/mysql-test/suite/engines/funcs/r/db_alter_character_set.result b/mysql-test/suite/engines/funcs/r/db_alter_character_set.result index ad0cf41bdf1..f42928d66f9 100644 --- a/mysql-test/suite/engines/funcs/r/db_alter_character_set.result +++ b/mysql-test/suite/engines/funcs/r/db_alter_character_set.result @@ -49,6 +49,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d8 CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -58,6 +59,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -68,6 +70,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d8 CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -77,6 +80,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -87,6 +91,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d8 CHARACTER SET binary; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -96,6 +101,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -106,6 +112,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d8 CHARACTER SET swe7; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -115,6 +122,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -125,6 +133,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d8 CHARACTER SET cp1251; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -134,6 +143,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -144,6 +154,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d8 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -153,6 +164,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -163,6 +175,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d8 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -172,6 +185,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -182,6 +196,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d8 DEFAULT CHARACTER SET binary; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -191,6 +206,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -201,6 +217,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d8 DEFAULT CHARACTER SET swe7; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -210,6 +227,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -220,6 +238,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d8 DEFAULT CHARACTER SET cp1251; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -229,6 +248,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -239,6 +259,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d8 CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -248,6 +269,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -258,6 +280,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d8 CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -267,6 +290,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -277,6 +301,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d8 CHARACTER SET binary; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -286,6 +311,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -296,6 +322,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d8 CHARACTER SET swe7; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -305,6 +332,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -315,6 +343,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d8 CHARACTER SET cp1251; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -324,6 +353,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -334,6 +364,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d8 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -343,6 +374,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -353,6 +385,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d8 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -362,6 +395,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -372,6 +406,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d8 DEFAULT CHARACTER SET binary; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -381,6 +416,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -391,6 +427,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d8 DEFAULT CHARACTER SET swe7; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -400,6 +437,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; @@ -410,6 +448,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d8 DEFAULT CHARACTER SET cp1251; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -419,5 +458,6 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; diff --git a/mysql-test/suite/engines/funcs/r/db_alter_character_set_collate.result b/mysql-test/suite/engines/funcs/r/db_alter_character_set_collate.result index d01b85d9039..d3e86c6649f 100644 --- a/mysql-test/suite/engines/funcs/r/db_alter_character_set_collate.result +++ b/mysql-test/suite/engines/funcs/r/db_alter_character_set_collate.result @@ -7,6 +7,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d11 CHARACTER SET utf8 COLLATE utf8_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -16,6 +17,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d11; CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; @@ -26,6 +28,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d11 CHARACTER SET latin2 COLLATE latin2_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -35,6 +38,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d11; CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; @@ -45,6 +49,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d11 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -54,6 +59,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d11; CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; @@ -64,6 +70,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d11 CHARACTER SET utf8 COLLATE utf8_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -73,6 +80,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d11; CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; @@ -83,6 +91,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d11 CHARACTER SET latin2 COLLATE latin2_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -92,6 +101,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d11; CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; @@ -102,6 +112,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d11 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -111,5 +122,6 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d11; diff --git a/mysql-test/suite/engines/funcs/r/db_alter_collate_ascii.result b/mysql-test/suite/engines/funcs/r/db_alter_collate_ascii.result index 0b06979ee1d..7a809529f59 100644 --- a/mysql-test/suite/engines/funcs/r/db_alter_collate_ascii.result +++ b/mysql-test/suite/engines/funcs/r/db_alter_collate_ascii.result @@ -331,6 +331,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d9 COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -340,6 +341,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; @@ -350,6 +352,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d9 DEFAULT COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -359,6 +362,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; @@ -369,6 +373,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d9 COLLATE ascii_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -378,6 +383,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; @@ -388,6 +394,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d9 DEFAULT COLLATE ascii_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -397,6 +404,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; @@ -407,6 +415,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d9 COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -416,6 +425,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; @@ -426,6 +436,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d9 DEFAULT COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -435,6 +446,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; @@ -445,6 +457,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d9 COLLATE ascii_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -454,6 +467,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; @@ -464,6 +478,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d9 DEFAULT COLLATE ascii_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -473,5 +488,6 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; diff --git a/mysql-test/suite/engines/funcs/r/db_alter_collate_utf8.result b/mysql-test/suite/engines/funcs/r/db_alter_collate_utf8.result index 1b875962417..852e9066761 100644 --- a/mysql-test/suite/engines/funcs/r/db_alter_collate_utf8.result +++ b/mysql-test/suite/engines/funcs/r/db_alter_collate_utf8.result @@ -331,6 +331,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -340,6 +341,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -350,6 +352,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -359,6 +362,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -369,6 +373,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -378,6 +383,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -388,6 +394,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -397,6 +404,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -407,6 +415,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_unicode_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -416,6 +425,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -426,6 +436,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_unicode_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -435,6 +446,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -445,6 +457,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_icelandic_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -454,6 +467,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -464,6 +478,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_icelandic_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -473,6 +488,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -483,6 +499,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_latvian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -492,6 +509,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -502,6 +520,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_latvian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -511,6 +530,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -521,6 +541,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_romanian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -530,6 +551,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -540,6 +562,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_romanian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -549,6 +572,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -559,6 +583,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_slovenian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -568,6 +593,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -578,6 +604,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_slovenian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -587,6 +614,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -597,6 +625,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_polish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -606,6 +635,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -616,6 +646,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_polish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -625,6 +656,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -635,6 +667,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_estonian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -644,6 +677,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -654,6 +688,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_estonian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -663,6 +698,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -673,6 +709,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_spanish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -682,6 +719,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -692,6 +730,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_spanish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -701,6 +740,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -711,6 +751,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_swedish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -720,6 +761,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -730,6 +772,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_swedish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -739,6 +782,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -749,6 +793,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_turkish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -758,6 +803,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -768,6 +814,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_turkish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -777,6 +824,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -787,6 +835,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_czech_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -796,6 +845,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -806,6 +856,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_czech_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -815,6 +866,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -825,6 +877,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_danish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -834,6 +887,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -844,6 +898,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_danish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -853,6 +908,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -863,6 +919,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_lithuanian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -872,6 +929,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -882,6 +940,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_lithuanian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -891,6 +950,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -901,6 +961,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_slovak_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -910,6 +971,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -920,6 +982,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_slovak_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -929,6 +992,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -939,6 +1003,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_spanish2_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -948,6 +1013,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -958,6 +1024,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_spanish2_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -967,6 +1034,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -977,6 +1045,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_roman_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -986,6 +1055,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -996,6 +1066,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_roman_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1005,6 +1076,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1015,6 +1087,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_persian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1024,6 +1097,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1034,6 +1108,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_persian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1043,6 +1118,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1053,6 +1129,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_esperanto_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1062,6 +1139,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1072,6 +1150,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_esperanto_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1081,6 +1160,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1091,6 +1171,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 COLLATE utf8_hungarian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1100,6 +1181,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1110,6 +1192,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d10 DEFAULT COLLATE utf8_hungarian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1119,6 +1202,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1129,6 +1213,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1138,6 +1223,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1148,6 +1234,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1157,6 +1244,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1167,6 +1255,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1176,6 +1265,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1186,6 +1276,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1195,6 +1286,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1205,6 +1297,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_unicode_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1214,6 +1307,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1224,6 +1318,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_unicode_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1233,6 +1328,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1243,6 +1339,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_icelandic_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1252,6 +1349,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1262,6 +1360,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_icelandic_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1271,6 +1370,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1281,6 +1381,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_latvian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1290,6 +1391,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1300,6 +1402,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_latvian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1309,6 +1412,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1319,6 +1423,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_romanian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1328,6 +1433,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1338,6 +1444,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_romanian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1347,6 +1454,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1357,6 +1465,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_slovenian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1366,6 +1475,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1376,6 +1486,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_slovenian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1385,6 +1496,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1395,6 +1507,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_polish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1404,6 +1517,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1414,6 +1528,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_polish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1423,6 +1538,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1433,6 +1549,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_estonian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1442,6 +1559,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1452,6 +1570,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_estonian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1461,6 +1580,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1471,6 +1591,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_spanish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1480,6 +1601,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1490,6 +1612,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_spanish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1499,6 +1622,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1509,6 +1633,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_swedish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1518,6 +1643,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1528,6 +1654,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_swedish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1537,6 +1664,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1547,6 +1675,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_turkish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1556,6 +1685,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1566,6 +1696,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_turkish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1575,6 +1706,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1585,6 +1717,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_czech_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1594,6 +1727,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1604,6 +1738,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_czech_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1613,6 +1748,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1623,6 +1759,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_danish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1632,6 +1769,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1642,6 +1780,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_danish_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1651,6 +1790,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1661,6 +1801,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_lithuanian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1670,6 +1811,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1680,6 +1822,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_lithuanian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1689,6 +1832,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1699,6 +1843,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_slovak_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1708,6 +1853,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1718,6 +1864,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_slovak_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1727,6 +1874,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1737,6 +1885,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_spanish2_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1746,6 +1895,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1756,6 +1906,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_spanish2_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1765,6 +1916,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1775,6 +1927,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_roman_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1784,6 +1937,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1794,6 +1948,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_roman_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1803,6 +1958,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1813,6 +1969,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_persian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1822,6 +1979,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1832,6 +1990,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_persian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1841,6 +2000,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1851,6 +2011,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_esperanto_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1860,6 +2021,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1870,6 +2032,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_esperanto_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1879,6 +2042,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1889,6 +2053,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 COLLATE utf8_hungarian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1898,6 +2063,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; @@ -1908,6 +2074,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d10 DEFAULT COLLATE utf8_hungarian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; @@ -1917,5 +2084,6 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; diff --git a/mysql-test/suite/engines/funcs/r/db_create_character_set.result b/mysql-test/suite/engines/funcs/r/db_create_character_set.result index 3c3d99bfba2..445e309effe 100644 --- a/mysql-test/suite/engines/funcs/r/db_create_character_set.result +++ b/mysql-test/suite/engines/funcs/r/db_create_character_set.result @@ -7,6 +7,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d12; CREATE DATABASE d12 CHARACTER SET utf8; @@ -17,6 +18,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d12; CREATE DATABASE d12 CHARACTER SET binary; @@ -27,6 +29,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d12; CREATE DATABASE d12 CHARACTER SET swe7; @@ -37,6 +40,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d12; CREATE DATABASE d12 CHARACTER SET cp1251; @@ -47,6 +51,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d12; CREATE SCHEMA d12 CHARACTER SET ascii; @@ -57,6 +62,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d12; CREATE SCHEMA d12 CHARACTER SET utf8; @@ -67,6 +73,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d12; CREATE SCHEMA d12 CHARACTER SET binary; @@ -77,6 +84,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d12; CREATE SCHEMA d12 CHARACTER SET swe7; @@ -87,6 +95,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d12; CREATE SCHEMA d12 CHARACTER SET cp1251; @@ -97,5 +106,6 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d12; diff --git a/mysql-test/suite/engines/funcs/r/db_create_character_set_collate.result b/mysql-test/suite/engines/funcs/r/db_create_character_set_collate.result index 236973a34fd..85fe4014b39 100644 --- a/mysql-test/suite/engines/funcs/r/db_create_character_set_collate.result +++ b/mysql-test/suite/engines/funcs/r/db_create_character_set_collate.result @@ -7,6 +7,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d13; CREATE DATABASE d13 CHARACTER SET latin2 COLLATE latin2_general_ci; @@ -17,6 +18,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d13; CREATE DATABASE d13 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci; @@ -27,6 +29,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d13; CREATE SCHEMA d13 CHARACTER SET utf8 COLLATE utf8_general_ci; @@ -37,6 +40,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d13; CREATE SCHEMA d13 CHARACTER SET latin2 COLLATE latin2_general_ci; @@ -47,6 +51,7 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d13; CREATE SCHEMA d13 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci; @@ -57,5 +62,6 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL +def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d13; diff --git a/mysql-test/suite/engines/funcs/r/db_create_drop.result b/mysql-test/suite/engines/funcs/r/db_create_drop.result index 85a871cf135..908327be8e7 100644 --- a/mysql-test/suite/engines/funcs/r/db_create_drop.result +++ b/mysql-test/suite/engines/funcs/r/db_create_drop.result @@ -7,6 +7,7 @@ information_schema mtr mysql performance_schema +sys test SHOW DATABASES LIKE 'd%'; Database (d%) @@ -18,6 +19,7 @@ information_schema mtr mysql performance_schema +sys test USE d1; DROP DATABASE d1; @@ -29,6 +31,7 @@ information_schema mtr mysql performance_schema +sys test SHOW SCHEMAS LIKE 'd%'; Database (d%) @@ -40,6 +43,7 @@ information_schema mtr mysql performance_schema +sys test USE d1; DROP SCHEMA d1; diff --git a/mysql-test/suite/engines/funcs/r/db_create_error.result b/mysql-test/suite/engines/funcs/r/db_create_error.result index d18fe7ee5fd..3b7934a140a 100644 --- a/mysql-test/suite/engines/funcs/r/db_create_error.result +++ b/mysql-test/suite/engines/funcs/r/db_create_error.result @@ -7,6 +7,7 @@ information_schema mtr mysql performance_schema +sys test CREATE DATABASE d4; ERROR HY000: Can't create database 'd4'; database exists @@ -17,4 +18,5 @@ information_schema mtr mysql performance_schema +sys test diff --git a/mysql-test/suite/engines/funcs/r/db_create_error_reserved.result b/mysql-test/suite/engines/funcs/r/db_create_error_reserved.result index 571ac0ea1ff..066209c39c9 100644 --- a/mysql-test/suite/engines/funcs/r/db_create_error_reserved.result +++ b/mysql-test/suite/engines/funcs/r/db_create_error_reserved.result @@ -4,6 +4,7 @@ information_schema mtr mysql performance_schema +sys test CREATE DATABASE mysql; ERROR HY000: Can't create database 'mysql'; database exists @@ -13,4 +14,5 @@ information_schema mtr mysql performance_schema +sys test diff --git a/mysql-test/suite/engines/funcs/r/db_create_if_not_exists.result b/mysql-test/suite/engines/funcs/r/db_create_if_not_exists.result index 2637087da5b..0a4c54622d0 100644 --- a/mysql-test/suite/engines/funcs/r/db_create_if_not_exists.result +++ b/mysql-test/suite/engines/funcs/r/db_create_if_not_exists.result @@ -10,6 +10,7 @@ information_schema mtr mysql performance_schema +sys test USE d2; DROP DATABASE d2; @@ -27,6 +28,7 @@ information_schema mtr mysql performance_schema +sys test USE d2; DROP SCHEMA d2; diff --git a/mysql-test/suite/engines/funcs/r/db_drop_error.result b/mysql-test/suite/engines/funcs/r/db_drop_error.result index 24a51768103..a5dc1f8ed31 100644 --- a/mysql-test/suite/engines/funcs/r/db_drop_error.result +++ b/mysql-test/suite/engines/funcs/r/db_drop_error.result @@ -7,6 +7,7 @@ information_schema mtr mysql performance_schema +sys test DROP DATABASE nond5; ERROR HY000: Can't drop database 'nond5'; database doesn't exist @@ -17,4 +18,5 @@ information_schema mtr mysql performance_schema +sys test diff --git a/mysql-test/suite/engines/funcs/r/db_use_error.result b/mysql-test/suite/engines/funcs/r/db_use_error.result index c2fce4f0acf..a7c76e69b0d 100644 --- a/mysql-test/suite/engines/funcs/r/db_use_error.result +++ b/mysql-test/suite/engines/funcs/r/db_use_error.result @@ -7,6 +7,7 @@ information_schema mtr mysql performance_schema +sys test USE DATABASE nond6; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DATABASE nond6' at line 1 @@ -17,4 +18,5 @@ information_schema mtr mysql performance_schema +sys test |