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 SCHEMA_COMMENT
5 def d11 ascii ascii_bin NULL
6 def information_schema utf8mb3 utf8mb3_general_ci NULL
7 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
8 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
9 def performance_schema utf8mb3 utf8mb3_general_ci NULL
10 def sys utf8mb3 utf8mb3_general_ci NULL
11 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
12 ALTER DATABASE d11 CHARACTER SET utf8 COLLATE utf8_general_ci;
13 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
14 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
15 def d11 utf8mb3 utf8mb3_general_ci NULL
16 def information_schema utf8mb3 utf8mb3_general_ci NULL
17 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
18 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
19 def performance_schema utf8mb3 utf8mb3_general_ci NULL
20 def sys utf8mb3 utf8mb3_general_ci NULL
21 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
22 DROP DATABASE d11;
23 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
24 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
25 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
26 def d11 ascii ascii_bin NULL
27 def information_schema utf8mb3 utf8mb3_general_ci NULL
28 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
29 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
30 def performance_schema utf8mb3 utf8mb3_general_ci NULL
31 def sys utf8mb3 utf8mb3_general_ci NULL
32 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
33 ALTER DATABASE d11 CHARACTER SET latin2 COLLATE latin2_general_ci;
34 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
35 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
36 def d11 latin2 latin2_general_ci NULL
37 def information_schema utf8mb3 utf8mb3_general_ci NULL
38 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
39 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
40 def performance_schema utf8mb3 utf8mb3_general_ci NULL
41 def sys utf8mb3 utf8mb3_general_ci NULL
42 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
43 DROP DATABASE d11;
44 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
45 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
46 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
47 def d11 ascii ascii_bin NULL
48 def information_schema utf8mb3 utf8mb3_general_ci NULL
49 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
50 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
51 def performance_schema utf8mb3 utf8mb3_general_ci NULL
52 def sys utf8mb3 utf8mb3_general_ci NULL
53 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
54 ALTER DATABASE d11 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci;
55 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
56 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
57 def d11 cp1250 cp1250_croatian_ci NULL
58 def information_schema utf8mb3 utf8mb3_general_ci NULL
59 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
60 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
61 def performance_schema utf8mb3 utf8mb3_general_ci NULL
62 def sys utf8mb3 utf8mb3_general_ci NULL
63 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
64 DROP DATABASE d11;
65 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
66 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
67 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
68 def d11 ascii ascii_bin NULL
69 def information_schema utf8mb3 utf8mb3_general_ci NULL
70 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
71 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
72 def performance_schema utf8mb3 utf8mb3_general_ci NULL
73 def sys utf8mb3 utf8mb3_general_ci NULL
74 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
75 ALTER SCHEMA d11 CHARACTER SET utf8 COLLATE utf8_general_ci;
76 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
77 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
78 def d11 utf8mb3 utf8mb3_general_ci NULL
79 def information_schema utf8mb3 utf8mb3_general_ci NULL
80 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
81 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
82 def performance_schema utf8mb3 utf8mb3_general_ci NULL
83 def sys utf8mb3 utf8mb3_general_ci NULL
84 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
85 DROP DATABASE d11;
86 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
87 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
88 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
89 def d11 ascii ascii_bin NULL
90 def information_schema utf8mb3 utf8mb3_general_ci NULL
91 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
92 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
93 def performance_schema utf8mb3 utf8mb3_general_ci NULL
94 def sys utf8mb3 utf8mb3_general_ci NULL
95 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
96 ALTER SCHEMA d11 CHARACTER SET latin2 COLLATE latin2_general_ci;
97 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
98 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
99 def d11 latin2 latin2_general_ci NULL
100 def information_schema utf8mb3 utf8mb3_general_ci NULL
101 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
102 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
103 def performance_schema utf8mb3 utf8mb3_general_ci NULL
104 def sys utf8mb3 utf8mb3_general_ci NULL
105 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
106 DROP DATABASE d11;
107 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
108 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
109 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
110 def d11 ascii ascii_bin NULL
111 def information_schema utf8mb3 utf8mb3_general_ci NULL
112 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
113 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
114 def performance_schema utf8mb3 utf8mb3_general_ci NULL
115 def sys utf8mb3 utf8mb3_general_ci NULL
116 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
117 ALTER SCHEMA d11 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci;
118 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
119 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
120 def d11 cp1250 cp1250_croatian_ci NULL
121 def information_schema utf8mb3 utf8mb3_general_ci NULL
122 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
123 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
124 def performance_schema utf8mb3 utf8mb3_general_ci NULL
125 def sys utf8mb3 utf8mb3_general_ci NULL
126 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
127 DROP DATABASE d11;