Debian Codegraph @

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

raw
1 DROP DATABASE IF EXISTS d12;
2 CREATE DATABASE d12 CHARACTER SET ascii;
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 d12 ascii ascii_general_ci 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 DROP DATABASE d12;
13 CREATE DATABASE d12 CHARACTER SET utf8;
14 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
15 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
16 def d12 utf8mb3 utf8mb3_uca1400_ai_ci NULL
17 def information_schema utf8mb3 utf8mb3_general_ci NULL
18 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
19 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
20 def performance_schema utf8mb3 utf8mb3_general_ci NULL
21 def sys utf8mb3 utf8mb3_general_ci NULL
22 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
23 DROP DATABASE d12;
24 CREATE DATABASE d12 CHARACTER SET binary;
25 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
26 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
27 def d12 binary binary NULL
28 def information_schema utf8mb3 utf8mb3_general_ci NULL
29 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
30 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
31 def performance_schema utf8mb3 utf8mb3_general_ci NULL
32 def sys utf8mb3 utf8mb3_general_ci NULL
33 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
34 DROP DATABASE d12;
35 CREATE DATABASE d12 CHARACTER SET swe7;
36 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
37 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
38 def d12 swe7 swe7_swedish_ci NULL
39 def information_schema utf8mb3 utf8mb3_general_ci NULL
40 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
41 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
42 def performance_schema utf8mb3 utf8mb3_general_ci NULL
43 def sys utf8mb3 utf8mb3_general_ci NULL
44 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
45 DROP DATABASE d12;
46 CREATE DATABASE d12 CHARACTER SET cp1251;
47 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
48 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
49 def d12 cp1251 cp1251_general_ci NULL
50 def information_schema utf8mb3 utf8mb3_general_ci NULL
51 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
52 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
53 def performance_schema utf8mb3 utf8mb3_general_ci NULL
54 def sys utf8mb3 utf8mb3_general_ci NULL
55 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
56 DROP DATABASE d12;
57 CREATE SCHEMA d12 CHARACTER SET ascii;
58 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
59 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
60 def d12 ascii ascii_general_ci NULL
61 def information_schema utf8mb3 utf8mb3_general_ci NULL
62 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
63 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
64 def performance_schema utf8mb3 utf8mb3_general_ci NULL
65 def sys utf8mb3 utf8mb3_general_ci NULL
66 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
67 DROP SCHEMA d12;
68 CREATE SCHEMA d12 CHARACTER SET utf8;
69 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
70 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
71 def d12 utf8mb3 utf8mb3_uca1400_ai_ci NULL
72 def information_schema utf8mb3 utf8mb3_general_ci NULL
73 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
74 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
75 def performance_schema utf8mb3 utf8mb3_general_ci NULL
76 def sys utf8mb3 utf8mb3_general_ci NULL
77 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
78 DROP SCHEMA d12;
79 CREATE SCHEMA d12 CHARACTER SET binary;
80 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
81 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
82 def d12 binary binary NULL
83 def information_schema utf8mb3 utf8mb3_general_ci NULL
84 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
85 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
86 def performance_schema utf8mb3 utf8mb3_general_ci NULL
87 def sys utf8mb3 utf8mb3_general_ci NULL
88 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
89 DROP SCHEMA d12;
90 CREATE SCHEMA d12 CHARACTER SET swe7;
91 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
92 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
93 def d12 swe7 swe7_swedish_ci NULL
94 def information_schema utf8mb3 utf8mb3_general_ci NULL
95 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
96 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
97 def performance_schema utf8mb3 utf8mb3_general_ci NULL
98 def sys utf8mb3 utf8mb3_general_ci NULL
99 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
100 DROP SCHEMA d12;
101 CREATE SCHEMA d12 CHARACTER SET cp1251;
102 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
103 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
104 def d12 cp1251 cp1251_general_ci NULL
105 def information_schema utf8mb3 utf8mb3_general_ci NULL
106 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
107 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
108 def performance_schema utf8mb3 utf8mb3_general_ci NULL
109 def sys utf8mb3 utf8mb3_general_ci NULL
110 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
111 DROP SCHEMA d12;