Debian Codegraph @

mysql-test/suite/engines/funcs/r/db_alter_character_set_collate.result

raw
1 DROP DATABASE IF EXISTS d11;
2 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
3 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
4 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
5 def d11 ascii ascii_bin NULL NO
6 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
7 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
8 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
9 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
10 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
11 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
12 ALTER DATABASE d11 CHARACTER SET utf8 COLLATE utf8_general_ci;
13 Warnings:
14 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
15 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
16 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
17 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
18 def d11 utf8mb3 utf8mb3_general_ci NULL NO
19 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
20 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
21 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
22 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
23 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
24 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
25 DROP DATABASE d11;
26 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
27 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
28 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
29 def d11 ascii ascii_bin NULL NO
30 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
31 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
32 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
33 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
34 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
35 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
36 ALTER DATABASE d11 CHARACTER SET latin2 COLLATE latin2_general_ci;
37 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
38 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
39 def d11 latin2 latin2_general_ci NULL NO
40 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
41 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
42 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
43 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
44 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
45 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
46 DROP DATABASE d11;
47 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
48 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
49 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
50 def d11 ascii ascii_bin NULL NO
51 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
52 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
53 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
54 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
55 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
56 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
57 ALTER DATABASE d11 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci;
58 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
59 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
60 def d11 cp1250 cp1250_croatian_ci NULL NO
61 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
62 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
63 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
64 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
65 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
66 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
67 DROP DATABASE d11;
68 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
69 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
70 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
71 def d11 ascii ascii_bin NULL NO
72 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
73 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
74 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
75 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
76 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
77 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
78 ALTER SCHEMA d11 CHARACTER SET utf8 COLLATE utf8_general_ci;
79 Warnings:
80 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
81 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
82 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
83 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
84 def d11 utf8mb3 utf8mb3_general_ci NULL NO
85 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
86 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
87 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
88 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
89 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
90 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
91 DROP DATABASE d11;
92 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
93 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
94 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
95 def d11 ascii ascii_bin NULL NO
96 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
97 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
98 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
99 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
100 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
101 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
102 ALTER SCHEMA d11 CHARACTER SET latin2 COLLATE latin2_general_ci;
103 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
104 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
105 def d11 latin2 latin2_general_ci NULL NO
106 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
107 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
108 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
109 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
110 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
111 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
112 DROP DATABASE d11;
113 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
114 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
115 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
116 def d11 ascii ascii_bin NULL NO
117 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
118 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
119 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
120 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
121 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
122 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
123 ALTER SCHEMA d11 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci;
124 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
125 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
126 def d11 cp1250 cp1250_croatian_ci NULL NO
127 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
128 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
129 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
130 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
131 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
132 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
133 DROP DATABASE d11;