diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/db_alter_collate_ascii.result')
| -rw-r--r-- | mysql-test/suite/engines/funcs/r/db_alter_collate_ascii.result | 224 |
1 files changed, 112 insertions, 112 deletions
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 a7217ba424e..0b06979ee1d 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 @@ -325,153 +325,153 @@ eucjpms_japanese_nopad_ci eucjpms 1121 # # eucjpms_nopad_bin eucjpms 1122 # # 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 -def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_general_ci NULL +def test latin1 latin1_swedish_ci NULL ALTER DATABASE d9 COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; -CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH -def d9 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_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 -def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_general_ci NULL +def test latin1 latin1_swedish_ci NULL ALTER DATABASE d9 DEFAULT COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; -CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH -def d9 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_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 -def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_general_ci NULL +def test latin1 latin1_swedish_ci NULL ALTER DATABASE d9 COLLATE ascii_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; -CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH -def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_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 -def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_general_ci NULL +def test latin1 latin1_swedish_ci NULL ALTER DATABASE d9 DEFAULT COLLATE ascii_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; -CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH -def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_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 -def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_general_ci NULL +def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d9 COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; -CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH -def d9 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_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 -def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_general_ci NULL +def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d9 DEFAULT COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; -CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH -def d9 ascii ascii_bin NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_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 -def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_general_ci NULL +def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d9 COLLATE ascii_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; -CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH -def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_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 -def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_general_ci NULL +def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d9 DEFAULT COLLATE ascii_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; -CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH -def d9 ascii ascii_general_ci NULL -def information_schema utf8 utf8_general_ci NULL -def mtr latin1 latin1_swedish_ci NULL -def mysql latin1 latin1_swedish_ci NULL -def performance_schema utf8 utf8_general_ci NULL -def test latin1 latin1_swedish_ci NULL +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 mtr latin1 latin1_swedish_ci NULL +def mysql latin1 latin1_swedish_ci NULL +def performance_schema utf8 utf8_general_ci NULL +def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; |