diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r')
16 files changed, 2496 insertions, 2229 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..252b7d40090 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 @@ -22,7 +22,7 @@ cp1250 Windows Central European cp1250_general_ci 1 gbk GBK Simplified Chinese gbk_chinese_ci 2 latin5 ISO 8859-9 Turkish latin5_turkish_ci 1 armscii8 ARMSCII-8 Armenian armscii8_general_ci 1 -utf8 UTF-8 Unicode utf8_general_ci 3 +utf8mb3 UTF-8 Unicode utf8mb3_general_ci 3 ucs2 UCS-2 Unicode ucs2_general_ci 2 cp866 DOS Russian cp866_general_ci 1 keybcs2 DOS Kamenicky Czech-Slovak keybcs2_general_ci 1 @@ -45,379 +45,419 @@ CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d8 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d8 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 binary binary NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 swe7 swe7_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 cp1251 cp1251_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d8 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d8 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 binary binary NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 swe7 swe7_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 cp1251 cp1251_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d8 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d8 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 binary binary NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 swe7 swe7_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 cp1251 cp1251_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d8 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d8 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 binary binary NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 swe7 swe7_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d8; CREATE DATABASE d8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 latin1 latin1_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d8 cp1251 cp1251_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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..b6ba5d6e54d 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 @@ -3,113 +3,125 @@ CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d11 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d11 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d11 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d11; CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d11 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d11 latin2 latin2_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d11; CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d11 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d11 cp1250 cp1250_croatian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d11; CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d11 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d11 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d11 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d11; CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d11 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d11 latin2 latin2_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d11; CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d11 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d11 cp1250 cp1250_croatian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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..b86c28e7344 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 @@ -97,40 +97,40 @@ armscii8_general_ci armscii8 32 Yes # # armscii8_bin armscii8 64 # # armscii8_general_nopad_ci armscii8 1056 # # armscii8_nopad_bin armscii8 1088 # # -utf8_general_ci utf8 33 Yes # # -utf8_bin utf8 83 # # -utf8_unicode_ci utf8 192 # # -utf8_icelandic_ci utf8 193 # # -utf8_latvian_ci utf8 194 # # -utf8_romanian_ci utf8 195 # # -utf8_slovenian_ci utf8 196 # # -utf8_polish_ci utf8 197 # # -utf8_estonian_ci utf8 198 # # -utf8_spanish_ci utf8 199 # # -utf8_swedish_ci utf8 200 # # -utf8_turkish_ci utf8 201 # # -utf8_czech_ci utf8 202 # # -utf8_danish_ci utf8 203 # # -utf8_lithuanian_ci utf8 204 # # -utf8_slovak_ci utf8 205 # # -utf8_spanish2_ci utf8 206 # # -utf8_roman_ci utf8 207 # # -utf8_persian_ci utf8 208 # # -utf8_esperanto_ci utf8 209 # # -utf8_hungarian_ci utf8 210 # # -utf8_sinhala_ci utf8 211 # # -utf8_german2_ci utf8 212 # # -utf8_croatian_mysql561_ci utf8 213 # # -utf8_unicode_520_ci utf8 214 # # -utf8_vietnamese_ci utf8 215 # # -utf8_general_mysql500_ci utf8 223 # # -utf8_croatian_ci utf8 576 # # -utf8_myanmar_ci utf8 577 # # -utf8_thai_520_w2 utf8 578 # # -utf8_general_nopad_ci utf8 1057 # # -utf8_nopad_bin utf8 1107 # # -utf8_unicode_nopad_ci utf8 1216 # # -utf8_unicode_520_nopad_ci utf8 1238 # # +utf8mb3_general_ci utf8mb3 33 Yes # # +utf8mb3_bin utf8mb3 83 # # +utf8mb3_unicode_ci utf8mb3 192 # # +utf8mb3_icelandic_ci utf8mb3 193 # # +utf8mb3_latvian_ci utf8mb3 194 # # +utf8mb3_romanian_ci utf8mb3 195 # # +utf8mb3_slovenian_ci utf8mb3 196 # # +utf8mb3_polish_ci utf8mb3 197 # # +utf8mb3_estonian_ci utf8mb3 198 # # +utf8mb3_spanish_ci utf8mb3 199 # # +utf8mb3_swedish_ci utf8mb3 200 # # +utf8mb3_turkish_ci utf8mb3 201 # # +utf8mb3_czech_ci utf8mb3 202 # # +utf8mb3_danish_ci utf8mb3 203 # # +utf8mb3_lithuanian_ci utf8mb3 204 # # +utf8mb3_slovak_ci utf8mb3 205 # # +utf8mb3_spanish2_ci utf8mb3 206 # # +utf8mb3_roman_ci utf8mb3 207 # # +utf8mb3_persian_ci utf8mb3 208 # # +utf8mb3_esperanto_ci utf8mb3 209 # # +utf8mb3_hungarian_ci utf8mb3 210 # # +utf8mb3_sinhala_ci utf8mb3 211 # # +utf8mb3_german2_ci utf8mb3 212 # # +utf8mb3_croatian_mysql561_ci utf8mb3 213 # # +utf8mb3_unicode_520_ci utf8mb3 214 # # +utf8mb3_vietnamese_ci utf8mb3 215 # # +utf8mb3_general_mysql500_ci utf8mb3 223 # # +utf8mb3_croatian_ci utf8mb3 576 # # +utf8mb3_myanmar_ci utf8mb3 577 # # +utf8mb3_thai_520_w2 utf8mb3 578 # # +utf8mb3_general_nopad_ci utf8mb3 1057 # # +utf8mb3_nopad_bin utf8mb3 1107 # # +utf8mb3_unicode_nopad_ci utf8mb3 1216 # # +utf8mb3_unicode_520_nopad_ci utf8mb3 1238 # # ucs2_general_ci ucs2 35 Yes # # ucs2_bin ucs2 90 # # ucs2_unicode_ci ucs2 128 # # @@ -327,151 +327,167 @@ CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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..6aa05538a32 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 @@ -97,40 +97,40 @@ armscii8_general_ci armscii8 32 Yes # # armscii8_bin armscii8 64 # # armscii8_general_nopad_ci armscii8 1056 # # armscii8_nopad_bin armscii8 1088 # # -utf8_general_ci utf8 33 Yes # # -utf8_bin utf8 83 # # -utf8_unicode_ci utf8 192 # # -utf8_icelandic_ci utf8 193 # # -utf8_latvian_ci utf8 194 # # -utf8_romanian_ci utf8 195 # # -utf8_slovenian_ci utf8 196 # # -utf8_polish_ci utf8 197 # # -utf8_estonian_ci utf8 198 # # -utf8_spanish_ci utf8 199 # # -utf8_swedish_ci utf8 200 # # -utf8_turkish_ci utf8 201 # # -utf8_czech_ci utf8 202 # # -utf8_danish_ci utf8 203 # # -utf8_lithuanian_ci utf8 204 # # -utf8_slovak_ci utf8 205 # # -utf8_spanish2_ci utf8 206 # # -utf8_roman_ci utf8 207 # # -utf8_persian_ci utf8 208 # # -utf8_esperanto_ci utf8 209 # # -utf8_hungarian_ci utf8 210 # # -utf8_sinhala_ci utf8 211 # # -utf8_german2_ci utf8 212 # # -utf8_croatian_mysql561_ci utf8 213 # # -utf8_unicode_520_ci utf8 214 # # -utf8_vietnamese_ci utf8 215 # # -utf8_general_mysql500_ci utf8 223 # # -utf8_croatian_ci utf8 576 # # -utf8_myanmar_ci utf8 577 # # -utf8_thai_520_w2 utf8 578 # # -utf8_general_nopad_ci utf8 1057 # # -utf8_nopad_bin utf8 1107 # # -utf8_unicode_nopad_ci utf8 1216 # # -utf8_unicode_520_nopad_ci utf8 1238 # # +utf8mb3_general_ci utf8mb3 33 Yes # # +utf8mb3_bin utf8mb3 83 # # +utf8mb3_unicode_ci utf8mb3 192 # # +utf8mb3_icelandic_ci utf8mb3 193 # # +utf8mb3_latvian_ci utf8mb3 194 # # +utf8mb3_romanian_ci utf8mb3 195 # # +utf8mb3_slovenian_ci utf8mb3 196 # # +utf8mb3_polish_ci utf8mb3 197 # # +utf8mb3_estonian_ci utf8mb3 198 # # +utf8mb3_spanish_ci utf8mb3 199 # # +utf8mb3_swedish_ci utf8mb3 200 # # +utf8mb3_turkish_ci utf8mb3 201 # # +utf8mb3_czech_ci utf8mb3 202 # # +utf8mb3_danish_ci utf8mb3 203 # # +utf8mb3_lithuanian_ci utf8mb3 204 # # +utf8mb3_slovak_ci utf8mb3 205 # # +utf8mb3_spanish2_ci utf8mb3 206 # # +utf8mb3_roman_ci utf8mb3 207 # # +utf8mb3_persian_ci utf8mb3 208 # # +utf8mb3_esperanto_ci utf8mb3 209 # # +utf8mb3_hungarian_ci utf8mb3 210 # # +utf8mb3_sinhala_ci utf8mb3 211 # # +utf8mb3_german2_ci utf8mb3 212 # # +utf8mb3_croatian_mysql561_ci utf8mb3 213 # # +utf8mb3_unicode_520_ci utf8mb3 214 # # +utf8mb3_vietnamese_ci utf8mb3 215 # # +utf8mb3_general_mysql500_ci utf8mb3 223 # # +utf8mb3_croatian_ci utf8mb3 576 # # +utf8mb3_myanmar_ci utf8mb3 577 # # +utf8mb3_thai_520_w2 utf8mb3 578 # # +utf8mb3_general_nopad_ci utf8mb3 1057 # # +utf8mb3_nopad_bin utf8mb3 1107 # # +utf8mb3_unicode_nopad_ci utf8mb3 1216 # # +utf8mb3_unicode_520_nopad_ci utf8mb3 1238 # # ucs2_general_ci ucs2 35 Yes # # ucs2_bin ucs2 90 # # ucs2_unicode_ci ucs2 128 # # @@ -326,1596 +326,1764 @@ eucjpms_nopad_bin eucjpms 1122 # # CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_bin NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_bin NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_bin NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_bin NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_unicode_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_unicode_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_unicode_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_unicode_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_icelandic_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_icelandic_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_icelandic_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_icelandic_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_latvian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_latvian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_latvian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_latvian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_romanian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_romanian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_romanian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_romanian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_slovenian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_slovenian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_slovenian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_slovenian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_polish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_polish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_polish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_polish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_estonian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_estonian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_estonian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_estonian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_spanish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_spanish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_spanish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_spanish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_swedish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_swedish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_turkish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_turkish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_turkish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_turkish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_czech_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_czech_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_czech_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_czech_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_danish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_danish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_danish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_danish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_lithuanian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_lithuanian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_lithuanian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_lithuanian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_slovak_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_slovak_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_slovak_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_slovak_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_spanish2_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_spanish2_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_spanish2_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_spanish2_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_roman_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_roman_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_roman_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_roman_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_persian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_persian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_persian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_persian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_esperanto_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_esperanto_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_esperanto_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_esperanto_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_hungarian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_hungarian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_hungarian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_hungarian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_bin NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_bin NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_bin NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_bin NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_unicode_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_unicode_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_unicode_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_unicode_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_icelandic_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_icelandic_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_icelandic_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_icelandic_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_latvian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_latvian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_latvian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_latvian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_romanian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_romanian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_romanian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_romanian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_slovenian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_slovenian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_slovenian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_slovenian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_polish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_polish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_polish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_polish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_estonian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_estonian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_estonian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_estonian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_spanish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_spanish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_spanish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_spanish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_swedish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_swedish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_turkish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_turkish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_turkish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_turkish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_czech_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_czech_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_czech_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_czech_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_danish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_danish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_danish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_danish_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_lithuanian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_lithuanian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_lithuanian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_lithuanian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_slovak_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_slovak_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_slovak_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_slovak_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_spanish2_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_spanish2_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_spanish2_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_spanish2_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_roman_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_roman_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_roman_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_roman_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_persian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_persian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_persian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_persian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_esperanto_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_esperanto_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_esperanto_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_esperanto_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_hungarian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_hungarian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d10; CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d10 utf8 utf8_hungarian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d10 utf8mb3 utf8mb3_hungarian_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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..c7386d77168 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 @@ -3,99 +3,109 @@ CREATE DATABASE d12 CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d12 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d12; CREATE DATABASE d12 CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d12 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d12 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d12; CREATE DATABASE d12 CHARACTER SET binary; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d12 binary binary NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d12; CREATE DATABASE d12 CHARACTER SET swe7; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d12 swe7 swe7_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d12; CREATE DATABASE d12 CHARACTER SET cp1251; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d12 cp1251 cp1251_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d12; CREATE SCHEMA d12 CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d12 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d12; CREATE SCHEMA d12 CHARACTER SET utf8; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d12 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d12 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d12; CREATE SCHEMA d12 CHARACTER SET binary; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d12 binary binary NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d12; CREATE SCHEMA d12 CHARACTER SET swe7; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d12 swe7 swe7_swedish_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d12; CREATE SCHEMA d12 CHARACTER SET cp1251; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d12 cp1251 cp1251_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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..6bdcdba696b 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 @@ -2,60 +2,66 @@ DROP DATABASE IF EXISTS d13; CREATE DATABASE d13 CHARACTER SET utf8 COLLATE utf8_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d13 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d13 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d13; CREATE DATABASE d13 CHARACTER SET latin2 COLLATE latin2_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d13 latin2 latin2_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d13; CREATE DATABASE d13 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d13 cp1250 cp1250_croatian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d13; CREATE SCHEMA d13 CHARACTER SET utf8 COLLATE utf8_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT -def d13 utf8 utf8_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def d13 utf8mb3 utf8mb3_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d13; CREATE SCHEMA d13 CHARACTER SET latin2 COLLATE latin2_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d13 latin2 latin2_general_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP SCHEMA d13; CREATE SCHEMA d13 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT def d13 cp1250 cp1250_croatian_ci NULL -def information_schema utf8 utf8_general_ci NULL +def information_schema utf8mb3 utf8mb3_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 performance_schema utf8mb3 utf8mb3_general_ci NULL +def sys utf8mb3 utf8mb3_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 diff --git a/mysql-test/suite/engines/funcs/r/rpl_loaddata_m.result b/mysql-test/suite/engines/funcs/r/rpl_loaddata_m.result index 8e2bc2f0b1c..fdb5ca31e94 100644 --- a/mysql-test/suite/engines/funcs/r/rpl_loaddata_m.result +++ b/mysql-test/suite/engines/funcs/r/rpl_loaddata_m.result @@ -23,6 +23,7 @@ mtr mysql mysqltest performance_schema +sys test USE test; SHOW TABLES; diff --git a/mysql-test/suite/engines/funcs/r/rpl_server_id1.result b/mysql-test/suite/engines/funcs/r/rpl_server_id1.result index 001d1151843..33d1abb39c6 100644 --- a/mysql-test/suite/engines/funcs/r/rpl_server_id1.result +++ b/mysql-test/suite/engines/funcs/r/rpl_server_id1.result @@ -14,7 +14,7 @@ start slave; insert into t1 values (1); include/wait_for_slave_param.inc [Last_IO_Errno] Last_IO_Errno = '1593' -Last_IO_Error = 'Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).' +Last_IO_Error = 'Fatal error: The slave I/O thread stops because master and slave have equal MariaDB server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).' include/stop_slave.inc reset slave; reset master; diff --git a/mysql-test/suite/engines/funcs/r/rpl_sp.result b/mysql-test/suite/engines/funcs/r/rpl_sp.result index 004608691ce..71177d6a2f5 100644 --- a/mysql-test/suite/engines/funcs/r/rpl_sp.result +++ b/mysql-test/suite/engines/funcs/r/rpl_sp.result @@ -189,7 +189,7 @@ select * from t2; a 23 connection master; -drop function fn1; +drop function fn1| create function fn1() returns int no sql diff --git a/mysql-test/suite/engines/funcs/r/se_join_default.result b/mysql-test/suite/engines/funcs/r/se_join_default.result index a825ad314f3..cc1271020bc 100644 --- a/mysql-test/suite/engines/funcs/r/se_join_default.result +++ b/mysql-test/suite/engines/funcs/r/se_join_default.result @@ -14,47 +14,47 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1; c1 c1 0 1 0 2 -1 2 0 3 -1 3 -2 3 0 4 -1 4 -2 4 -3 4 0 5 -1 5 -2 5 -3 5 -4 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 0 9 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 5 +4 6 +4 7 +4 8 4 9 +5 6 +5 7 +5 8 5 9 +6 7 +6 8 6 9 +7 8 7 9 8 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -73,47 +73,47 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1; c1 c1 0 1 0 2 -1 2 0 3 -1 3 -2 3 0 4 -1 4 -2 4 -3 4 0 5 -1 5 -2 5 -3 5 -4 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 0 9 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 5 +4 6 +4 7 +4 8 4 9 +5 6 +5 7 +5 8 5 9 +6 7 +6 8 6 9 +7 8 7 9 8 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -132,47 +132,47 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1; c1 c1 0 1 0 2 -1 2 0 3 -1 3 -2 3 0 4 -1 4 -2 4 -3 4 0 5 -1 5 -2 5 -3 5 -4 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 0 9 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 5 +4 6 +4 7 +4 8 4 9 +5 6 +5 7 +5 8 5 9 +6 7 +6 8 6 9 +7 8 7 9 8 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -191,47 +191,47 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1; c1 c1 0 1 0 2 -1 2 0 3 -1 3 -2 3 0 4 -1 4 -2 4 -3 4 0 5 -1 5 -2 5 -3 5 -4 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 0 9 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 5 +4 6 +4 7 +4 8 4 9 +5 6 +5 7 +5 8 5 9 +6 7 +6 8 6 9 +7 8 7 9 8 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -250,47 +250,47 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1; c1 c1 0 1 0 2 -1 2 0 3 -1 3 -2 3 0 4 -1 4 -2 4 -3 4 0 5 -1 5 -2 5 -3 5 -4 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 0 9 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 5 +4 6 +4 7 +4 8 4 9 +5 6 +5 7 +5 8 5 9 +6 7 +6 8 6 9 +7 8 7 9 8 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -309,47 +309,47 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1; c1 c1 0 1 0 2 -1 2 0 3 -1 3 -2 3 0 4 -1 4 -2 4 -3 4 0 5 -1 5 -2 5 -3 5 -4 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 0 9 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 5 +4 6 +4 7 +4 8 4 9 +5 6 +5 7 +5 8 5 9 +6 7 +6 8 6 9 +7 8 7 9 8 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -1214,57 +1214,57 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1; c1 c1 0 0 0 1 -1 1 0 2 -1 2 -2 2 0 3 -1 3 -2 3 -3 3 0 4 -1 4 -2 4 -3 4 -4 4 0 5 -1 5 -2 5 -3 5 -4 5 -5 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -6 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -7 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -8 8 0 9 +1 1 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 2 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 3 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 4 +4 5 +4 6 +4 7 +4 8 4 9 +5 5 +5 6 +5 7 +5 8 5 9 +6 6 +6 7 +6 8 6 9 +7 7 +7 8 7 9 +8 8 8 9 9 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -1283,57 +1283,57 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1; c1 c1 0 0 0 1 -1 1 0 2 -1 2 -2 2 0 3 -1 3 -2 3 -3 3 0 4 -1 4 -2 4 -3 4 -4 4 0 5 -1 5 -2 5 -3 5 -4 5 -5 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -6 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -7 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -8 8 0 9 +1 1 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 2 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 3 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 4 +4 5 +4 6 +4 7 +4 8 4 9 +5 5 +5 6 +5 7 +5 8 5 9 +6 6 +6 7 +6 8 6 9 +7 7 +7 8 7 9 +8 8 8 9 9 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -1352,57 +1352,57 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1; c1 c1 0 0 0 1 -1 1 0 2 -1 2 -2 2 0 3 -1 3 -2 3 -3 3 0 4 -1 4 -2 4 -3 4 -4 4 0 5 -1 5 -2 5 -3 5 -4 5 -5 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -6 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -7 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -8 8 0 9 +1 1 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 2 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 3 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 4 +4 5 +4 6 +4 7 +4 8 4 9 +5 5 +5 6 +5 7 +5 8 5 9 +6 6 +6 7 +6 8 6 9 +7 7 +7 8 7 9 +8 8 8 9 9 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -1421,57 +1421,57 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1; c1 c1 0 0 0 1 -1 1 0 2 -1 2 -2 2 0 3 -1 3 -2 3 -3 3 0 4 -1 4 -2 4 -3 4 -4 4 0 5 -1 5 -2 5 -3 5 -4 5 -5 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -6 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -7 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -8 8 0 9 +1 1 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 2 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 3 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 4 +4 5 +4 6 +4 7 +4 8 4 9 +5 5 +5 6 +5 7 +5 8 5 9 +6 6 +6 7 +6 8 6 9 +7 7 +7 8 7 9 +8 8 8 9 9 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -1490,57 +1490,57 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1; c1 c1 0 0 0 1 -1 1 0 2 -1 2 -2 2 0 3 -1 3 -2 3 -3 3 0 4 -1 4 -2 4 -3 4 -4 4 0 5 -1 5 -2 5 -3 5 -4 5 -5 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -6 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -7 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -8 8 0 9 +1 1 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 2 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 3 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 4 +4 5 +4 6 +4 7 +4 8 4 9 +5 5 +5 6 +5 7 +5 8 5 9 +6 6 +6 7 +6 8 6 9 +7 7 +7 8 7 9 +8 8 8 9 9 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -1559,57 +1559,57 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1; c1 c1 0 0 0 1 -1 1 0 2 -1 2 -2 2 0 3 -1 3 -2 3 -3 3 0 4 -1 4 -2 4 -3 4 -4 4 0 5 -1 5 -2 5 -3 5 -4 5 -5 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -6 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -7 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -8 8 0 9 +1 1 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 2 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 3 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 4 +4 5 +4 6 +4 7 +4 8 4 9 +5 5 +5 6 +5 7 +5 8 5 9 +6 6 +6 7 +6 8 6 9 +7 7 +7 8 7 9 +8 8 8 9 9 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -3014,57 +3014,57 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1; c1 c1 0 0 1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 1 1 +2 0 2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 2 2 +3 0 +3 1 3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 3 3 +4 0 +4 1 +4 2 4 3 -5 3 -6 3 -7 3 -8 3 -9 3 4 4 +5 0 +5 1 +5 2 +5 3 5 4 -6 4 -7 4 -8 4 -9 4 5 5 +6 0 +6 1 +6 2 +6 3 +6 4 6 5 -7 5 -8 5 -9 5 6 6 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 7 6 -8 6 -9 6 7 7 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 8 7 -9 7 8 8 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 9 8 9 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -3083,57 +3083,57 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1; c1 c1 0 0 1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 1 1 +2 0 2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 2 2 +3 0 +3 1 3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 3 3 +4 0 +4 1 +4 2 4 3 -5 3 -6 3 -7 3 -8 3 -9 3 4 4 +5 0 +5 1 +5 2 +5 3 5 4 -6 4 -7 4 -8 4 -9 4 5 5 +6 0 +6 1 +6 2 +6 3 +6 4 6 5 -7 5 -8 5 -9 5 6 6 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 7 6 -8 6 -9 6 7 7 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 8 7 -9 7 8 8 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 9 8 9 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -3152,57 +3152,57 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1; c1 c1 0 0 1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 1 1 +2 0 2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 2 2 +3 0 +3 1 3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 3 3 +4 0 +4 1 +4 2 4 3 -5 3 -6 3 -7 3 -8 3 -9 3 4 4 +5 0 +5 1 +5 2 +5 3 5 4 -6 4 -7 4 -8 4 -9 4 5 5 +6 0 +6 1 +6 2 +6 3 +6 4 6 5 -7 5 -8 5 -9 5 6 6 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 7 6 -8 6 -9 6 7 7 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 8 7 -9 7 8 8 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 9 8 9 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -3221,57 +3221,57 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1; c1 c1 0 0 1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 1 1 +2 0 2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 2 2 +3 0 +3 1 3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 3 3 +4 0 +4 1 +4 2 4 3 -5 3 -6 3 -7 3 -8 3 -9 3 4 4 +5 0 +5 1 +5 2 +5 3 5 4 -6 4 -7 4 -8 4 -9 4 5 5 +6 0 +6 1 +6 2 +6 3 +6 4 6 5 -7 5 -8 5 -9 5 6 6 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 7 6 -8 6 -9 6 7 7 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 8 7 -9 7 8 8 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 9 8 9 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -3290,57 +3290,57 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1; c1 c1 0 0 1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 1 1 +2 0 2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 2 2 +3 0 +3 1 3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 3 3 +4 0 +4 1 +4 2 4 3 -5 3 -6 3 -7 3 -8 3 -9 3 4 4 +5 0 +5 1 +5 2 +5 3 5 4 -6 4 -7 4 -8 4 -9 4 5 5 +6 0 +6 1 +6 2 +6 3 +6 4 6 5 -7 5 -8 5 -9 5 6 6 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 7 6 -8 6 -9 6 7 7 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 8 7 -9 7 8 8 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 9 8 9 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -3359,57 +3359,57 @@ SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1; c1 c1 0 0 1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 1 1 +2 0 2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 2 2 +3 0 +3 1 3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 3 3 +4 0 +4 1 +4 2 4 3 -5 3 -6 3 -7 3 -8 3 -9 3 4 4 +5 0 +5 1 +5 2 +5 3 5 4 -6 4 -7 4 -8 4 -9 4 5 5 +6 0 +6 1 +6 2 +6 3 +6 4 6 5 -7 5 -8 5 -9 5 6 6 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 7 6 -8 6 -9 6 7 7 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 8 7 -9 7 8 8 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 9 8 9 9 DROP TABLE t1,t2,t3,t4,t5,t6; @@ -3912,96 +3912,96 @@ INSERT INTO t4 (c1) VALUES(10); INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1; c1 c1 -1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 0 1 -2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 0 2 -1 2 -3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 0 3 -1 3 -2 3 -4 3 -5 3 -6 3 -7 3 -8 3 -9 3 0 4 -1 4 -2 4 -3 4 -5 4 -6 4 -7 4 -8 4 -9 4 0 5 -1 5 -2 5 -3 5 -4 5 -6 5 -7 5 -8 5 -9 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -7 6 -8 6 -9 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -8 7 -9 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -9 8 0 9 +1 0 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 0 +2 1 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 0 +3 1 +3 2 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 0 +4 1 +4 2 +4 3 +4 5 +4 6 +4 7 +4 8 4 9 +5 0 +5 1 +5 2 +5 3 +5 4 +5 6 +5 7 +5 8 5 9 +6 0 +6 1 +6 2 +6 3 +6 4 +6 5 +6 7 +6 8 6 9 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 +7 6 +7 8 7 9 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 +8 7 8 9 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 +9 8 DROP TABLE t1,t2,t3,t4,t5,t6; CREATE TABLE t1 (c1 SMALLINT NOT NULL); CREATE TABLE t2 (c1 SMALLINT NOT NULL); @@ -4016,96 +4016,96 @@ INSERT INTO t4 (c1) VALUES(10); INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1; c1 c1 -1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 0 1 -2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 0 2 -1 2 -3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 0 3 -1 3 -2 3 -4 3 -5 3 -6 3 -7 3 -8 3 -9 3 0 4 -1 4 -2 4 -3 4 -5 4 -6 4 -7 4 -8 4 -9 4 0 5 -1 5 -2 5 -3 5 -4 5 -6 5 -7 5 -8 5 -9 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -7 6 -8 6 -9 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -8 7 -9 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -9 8 0 9 +1 0 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 0 +2 1 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 0 +3 1 +3 2 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 0 +4 1 +4 2 +4 3 +4 5 +4 6 +4 7 +4 8 4 9 +5 0 +5 1 +5 2 +5 3 +5 4 +5 6 +5 7 +5 8 5 9 +6 0 +6 1 +6 2 +6 3 +6 4 +6 5 +6 7 +6 8 6 9 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 +7 6 +7 8 7 9 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 +8 7 8 9 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 +9 8 DROP TABLE t1,t2,t3,t4,t5,t6; CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); @@ -4120,96 +4120,96 @@ INSERT INTO t4 (c1) VALUES(10); INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1; c1 c1 -1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 0 1 -2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 0 2 -1 2 -3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 0 3 -1 3 -2 3 -4 3 -5 3 -6 3 -7 3 -8 3 -9 3 0 4 -1 4 -2 4 -3 4 -5 4 -6 4 -7 4 -8 4 -9 4 0 5 -1 5 -2 5 -3 5 -4 5 -6 5 -7 5 -8 5 -9 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -7 6 -8 6 -9 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -8 7 -9 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -9 8 0 9 +1 0 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 0 +2 1 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 0 +3 1 +3 2 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 0 +4 1 +4 2 +4 3 +4 5 +4 6 +4 7 +4 8 4 9 +5 0 +5 1 +5 2 +5 3 +5 4 +5 6 +5 7 +5 8 5 9 +6 0 +6 1 +6 2 +6 3 +6 4 +6 5 +6 7 +6 8 6 9 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 +7 6 +7 8 7 9 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 +8 7 8 9 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 +9 8 DROP TABLE t1,t2,t3,t4,t5,t6; CREATE TABLE t1 (c1 INT NOT NULL); CREATE TABLE t2 (c1 INT NOT NULL); @@ -4224,96 +4224,96 @@ INSERT INTO t4 (c1) VALUES(10); INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1; c1 c1 -1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 0 1 -2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 0 2 -1 2 -3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 0 3 -1 3 -2 3 -4 3 -5 3 -6 3 -7 3 -8 3 -9 3 0 4 -1 4 -2 4 -3 4 -5 4 -6 4 -7 4 -8 4 -9 4 0 5 -1 5 -2 5 -3 5 -4 5 -6 5 -7 5 -8 5 -9 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -7 6 -8 6 -9 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -8 7 -9 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -9 8 0 9 +1 0 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 0 +2 1 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 0 +3 1 +3 2 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 0 +4 1 +4 2 +4 3 +4 5 +4 6 +4 7 +4 8 4 9 +5 0 +5 1 +5 2 +5 3 +5 4 +5 6 +5 7 +5 8 5 9 +6 0 +6 1 +6 2 +6 3 +6 4 +6 5 +6 7 +6 8 6 9 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 +7 6 +7 8 7 9 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 +8 7 8 9 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 +9 8 DROP TABLE t1,t2,t3,t4,t5,t6; CREATE TABLE t1 (c1 INTEGER NOT NULL); CREATE TABLE t2 (c1 INTEGER NOT NULL); @@ -4328,96 +4328,96 @@ INSERT INTO t4 (c1) VALUES(10); INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1; c1 c1 -1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 0 1 -2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 0 2 -1 2 -3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 0 3 -1 3 -2 3 -4 3 -5 3 -6 3 -7 3 -8 3 -9 3 0 4 -1 4 -2 4 -3 4 -5 4 -6 4 -7 4 -8 4 -9 4 0 5 -1 5 -2 5 -3 5 -4 5 -6 5 -7 5 -8 5 -9 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -7 6 -8 6 -9 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -8 7 -9 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -9 8 0 9 +1 0 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 0 +2 1 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 0 +3 1 +3 2 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 0 +4 1 +4 2 +4 3 +4 5 +4 6 +4 7 +4 8 4 9 +5 0 +5 1 +5 2 +5 3 +5 4 +5 6 +5 7 +5 8 5 9 +6 0 +6 1 +6 2 +6 3 +6 4 +6 5 +6 7 +6 8 6 9 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 +7 6 +7 8 7 9 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 +8 7 8 9 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 +9 8 DROP TABLE t1,t2,t3,t4,t5,t6; CREATE TABLE t1 (c1 BIGINT NOT NULL); CREATE TABLE t2 (c1 BIGINT NOT NULL); @@ -4432,96 +4432,96 @@ INSERT INTO t4 (c1) VALUES(10); INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1; c1 c1 -1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 0 1 -2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 0 2 -1 2 -3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 0 3 -1 3 -2 3 -4 3 -5 3 -6 3 -7 3 -8 3 -9 3 0 4 -1 4 -2 4 -3 4 -5 4 -6 4 -7 4 -8 4 -9 4 0 5 -1 5 -2 5 -3 5 -4 5 -6 5 -7 5 -8 5 -9 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -7 6 -8 6 -9 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -8 7 -9 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -9 8 0 9 +1 0 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 0 +2 1 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 0 +3 1 +3 2 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 0 +4 1 +4 2 +4 3 +4 5 +4 6 +4 7 +4 8 4 9 +5 0 +5 1 +5 2 +5 3 +5 4 +5 6 +5 7 +5 8 5 9 +6 0 +6 1 +6 2 +6 3 +6 4 +6 5 +6 7 +6 8 6 9 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 +7 6 +7 8 7 9 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 +8 7 8 9 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 +9 8 DROP TABLE t1,t2,t3,t4,t5,t6; CREATE TABLE t1 (c1 TINYINT NOT NULL); CREATE TABLE t2 (c1 TINYINT NOT NULL); @@ -5502,96 +5502,96 @@ INSERT INTO t4 (c1) VALUES(10); INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1; c1 c1 -1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 0 1 -2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 0 2 -1 2 -3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 0 3 -1 3 -2 3 -4 3 -5 3 -6 3 -7 3 -8 3 -9 3 0 4 -1 4 -2 4 -3 4 -5 4 -6 4 -7 4 -8 4 -9 4 0 5 -1 5 -2 5 -3 5 -4 5 -6 5 -7 5 -8 5 -9 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -7 6 -8 6 -9 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -8 7 -9 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -9 8 0 9 +1 0 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 0 +2 1 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 0 +3 1 +3 2 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 0 +4 1 +4 2 +4 3 +4 5 +4 6 +4 7 +4 8 4 9 +5 0 +5 1 +5 2 +5 3 +5 4 +5 6 +5 7 +5 8 5 9 +6 0 +6 1 +6 2 +6 3 +6 4 +6 5 +6 7 +6 8 6 9 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 +7 6 +7 8 7 9 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 +8 7 8 9 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 +9 8 DROP TABLE t1,t2,t3,t4,t5,t6; CREATE TABLE t1 (c1 SMALLINT NOT NULL); CREATE TABLE t2 (c1 SMALLINT NOT NULL); @@ -5606,96 +5606,96 @@ INSERT INTO t4 (c1) VALUES(10); INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1; c1 c1 -1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 0 1 -2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 0 2 -1 2 -3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 0 3 -1 3 -2 3 -4 3 -5 3 -6 3 -7 3 -8 3 -9 3 0 4 -1 4 -2 4 -3 4 -5 4 -6 4 -7 4 -8 4 -9 4 0 5 -1 5 -2 5 -3 5 -4 5 -6 5 -7 5 -8 5 -9 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -7 6 -8 6 -9 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -8 7 -9 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -9 8 0 9 +1 0 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 0 +2 1 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 0 +3 1 +3 2 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 0 +4 1 +4 2 +4 3 +4 5 +4 6 +4 7 +4 8 4 9 +5 0 +5 1 +5 2 +5 3 +5 4 +5 6 +5 7 +5 8 5 9 +6 0 +6 1 +6 2 +6 3 +6 4 +6 5 +6 7 +6 8 6 9 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 +7 6 +7 8 7 9 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 +8 7 8 9 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 +9 8 DROP TABLE t1,t2,t3,t4,t5,t6; CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); @@ -5710,96 +5710,96 @@ INSERT INTO t4 (c1) VALUES(10); INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1; c1 c1 -1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 0 1 -2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 0 2 -1 2 -3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 0 3 -1 3 -2 3 -4 3 -5 3 -6 3 -7 3 -8 3 -9 3 0 4 -1 4 -2 4 -3 4 -5 4 -6 4 -7 4 -8 4 -9 4 0 5 -1 5 -2 5 -3 5 -4 5 -6 5 -7 5 -8 5 -9 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -7 6 -8 6 -9 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -8 7 -9 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -9 8 0 9 +1 0 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 0 +2 1 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 0 +3 1 +3 2 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 0 +4 1 +4 2 +4 3 +4 5 +4 6 +4 7 +4 8 4 9 +5 0 +5 1 +5 2 +5 3 +5 4 +5 6 +5 7 +5 8 5 9 +6 0 +6 1 +6 2 +6 3 +6 4 +6 5 +6 7 +6 8 6 9 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 +7 6 +7 8 7 9 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 +8 7 8 9 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 +9 8 DROP TABLE t1,t2,t3,t4,t5,t6; CREATE TABLE t1 (c1 INT NOT NULL); CREATE TABLE t2 (c1 INT NOT NULL); @@ -5814,96 +5814,96 @@ INSERT INTO t4 (c1) VALUES(10); INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1; c1 c1 -1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 0 1 -2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 0 2 -1 2 -3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 0 3 -1 3 -2 3 -4 3 -5 3 -6 3 -7 3 -8 3 -9 3 0 4 -1 4 -2 4 -3 4 -5 4 -6 4 -7 4 -8 4 -9 4 0 5 -1 5 -2 5 -3 5 -4 5 -6 5 -7 5 -8 5 -9 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -7 6 -8 6 -9 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -8 7 -9 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -9 8 0 9 +1 0 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 0 +2 1 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 0 +3 1 +3 2 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 0 +4 1 +4 2 +4 3 +4 5 +4 6 +4 7 +4 8 4 9 +5 0 +5 1 +5 2 +5 3 +5 4 +5 6 +5 7 +5 8 5 9 +6 0 +6 1 +6 2 +6 3 +6 4 +6 5 +6 7 +6 8 6 9 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 +7 6 +7 8 7 9 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 +8 7 8 9 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 +9 8 DROP TABLE t1,t2,t3,t4,t5,t6; CREATE TABLE t1 (c1 INTEGER NOT NULL); CREATE TABLE t2 (c1 INTEGER NOT NULL); @@ -5918,96 +5918,96 @@ INSERT INTO t4 (c1) VALUES(10); INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1; c1 c1 -1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 0 1 -2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 0 2 -1 2 -3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 0 3 -1 3 -2 3 -4 3 -5 3 -6 3 -7 3 -8 3 -9 3 0 4 -1 4 -2 4 -3 4 -5 4 -6 4 -7 4 -8 4 -9 4 0 5 -1 5 -2 5 -3 5 -4 5 -6 5 -7 5 -8 5 -9 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -7 6 -8 6 -9 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -8 7 -9 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -9 8 0 9 +1 0 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 0 +2 1 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 0 +3 1 +3 2 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 0 +4 1 +4 2 +4 3 +4 5 +4 6 +4 7 +4 8 4 9 +5 0 +5 1 +5 2 +5 3 +5 4 +5 6 +5 7 +5 8 5 9 +6 0 +6 1 +6 2 +6 3 +6 4 +6 5 +6 7 +6 8 6 9 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 +7 6 +7 8 7 9 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 +8 7 8 9 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 +9 8 DROP TABLE t1,t2,t3,t4,t5,t6; CREATE TABLE t1 (c1 BIGINT NOT NULL); CREATE TABLE t2 (c1 BIGINT NOT NULL); @@ -6022,96 +6022,96 @@ INSERT INTO t4 (c1) VALUES(10); INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1; c1 c1 -1 0 -2 0 -3 0 -4 0 -5 0 -6 0 -7 0 -8 0 -9 0 0 1 -2 1 -3 1 -4 1 -5 1 -6 1 -7 1 -8 1 -9 1 0 2 -1 2 -3 2 -4 2 -5 2 -6 2 -7 2 -8 2 -9 2 0 3 -1 3 -2 3 -4 3 -5 3 -6 3 -7 3 -8 3 -9 3 0 4 -1 4 -2 4 -3 4 -5 4 -6 4 -7 4 -8 4 -9 4 0 5 -1 5 -2 5 -3 5 -4 5 -6 5 -7 5 -8 5 -9 5 0 6 -1 6 -2 6 -3 6 -4 6 -5 6 -7 6 -8 6 -9 6 0 7 -1 7 -2 7 -3 7 -4 7 -5 7 -6 7 -8 7 -9 7 0 8 -1 8 -2 8 -3 8 -4 8 -5 8 -6 8 -7 8 -9 8 0 9 +1 0 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 1 9 +2 0 +2 1 +2 3 +2 4 +2 5 +2 6 +2 7 +2 8 2 9 +3 0 +3 1 +3 2 +3 4 +3 5 +3 6 +3 7 +3 8 3 9 +4 0 +4 1 +4 2 +4 3 +4 5 +4 6 +4 7 +4 8 4 9 +5 0 +5 1 +5 2 +5 3 +5 4 +5 6 +5 7 +5 8 5 9 +6 0 +6 1 +6 2 +6 3 +6 4 +6 5 +6 7 +6 8 6 9 +7 0 +7 1 +7 2 +7 3 +7 4 +7 5 +7 6 +7 8 7 9 +8 0 +8 1 +8 2 +8 3 +8 4 +8 5 +8 6 +8 7 8 9 +9 0 +9 1 +9 2 +9 3 +9 4 +9 5 +9 6 +9 7 +9 8 DROP TABLE t1,t2,t3,t4,t5,t6; CREATE TABLE t1 (c1 TINYINT NOT NULL); CREATE TABLE t2 (c1 TINYINT NOT NULL); |