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 DEFAULT_ENCRYPTION
5 def d12 ascii ascii_general_ci 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 DROP DATABASE d12;
13 CREATE DATABASE d12 CHARACTER SET utf8;
14 Warnings:
15 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.
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 d12 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 d12;
26 CREATE DATABASE d12 CHARACTER SET binary;
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 d12 binary binary 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 DROP DATABASE d12;
37 CREATE DATABASE d12 CHARACTER SET swe7;
38 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
39 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
40 def d12 swe7 swe7_swedish_ci NULL NO
41 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
42 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
43 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
44 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
45 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
46 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
47 DROP DATABASE d12;
48 CREATE DATABASE d12 CHARACTER SET cp1251;
49 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
50 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
51 def d12 cp1251 cp1251_general_ci NULL NO
52 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
53 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
54 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
55 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
56 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
57 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
58 DROP DATABASE d12;
59 CREATE SCHEMA d12 CHARACTER SET ascii;
60 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
61 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
62 def d12 ascii ascii_general_ci NULL NO
63 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
64 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
65 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
66 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
67 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
68 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
69 DROP SCHEMA d12;
70 CREATE SCHEMA d12 CHARACTER SET utf8;
71 Warnings:
72 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.
73 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
74 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
75 def d12 utf8mb3 utf8mb3_general_ci NULL NO
76 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
77 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
78 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
79 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
80 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
81 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
82 DROP SCHEMA d12;
83 CREATE SCHEMA d12 CHARACTER SET binary;
84 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
85 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
86 def d12 binary binary NULL NO
87 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
88 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
89 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
90 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
91 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
92 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
93 DROP SCHEMA d12;
94 CREATE SCHEMA d12 CHARACTER SET swe7;
95 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
96 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
97 def d12 swe7 swe7_swedish_ci NULL NO
98 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
99 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
100 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
101 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
102 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
103 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
104 DROP SCHEMA d12;
105 CREATE SCHEMA d12 CHARACTER SET cp1251;
106 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
107 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
108 def d12 cp1251 cp1251_general_ci NULL NO
109 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
110 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
111 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
112 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
113 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
114 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
115 DROP SCHEMA d12;