Debian Codegraph @

mysql-test/suite/engines/funcs/t/db_alter_character_set.test

raw
1 --disable_warnings
2 DROP DATABASE IF EXISTS d8;
3 --enable_warnings
4 SHOW CHARACTER SET;
5 CREATE DATABASE d8;
6 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
7 ALTER DATABASE d8 CHARACTER SET ascii;
8 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
9 DROP DATABASE d8;
10 CREATE DATABASE d8;
11 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
12 ALTER DATABASE d8 CHARACTER SET utf8;
13 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
14 DROP DATABASE d8;
15 CREATE DATABASE d8;
16 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
17 ALTER DATABASE d8 CHARACTER SET binary;
18 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
19 DROP DATABASE d8;
20 CREATE DATABASE d8;
21 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
22 ALTER DATABASE d8 CHARACTER SET swe7;
23 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
24 DROP DATABASE d8;
25 CREATE DATABASE d8;
26 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
27 ALTER DATABASE d8 CHARACTER SET cp1251;
28 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
29 DROP DATABASE d8;
30 CREATE DATABASE d8;
31 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
32 ALTER DATABASE d8 DEFAULT CHARACTER SET ascii;
33 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
34 DROP DATABASE d8;
35 CREATE DATABASE d8;
36 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
37 ALTER DATABASE d8 DEFAULT CHARACTER SET utf8;
38 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
39 DROP DATABASE d8;
40 CREATE DATABASE d8;
41 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
42 ALTER DATABASE d8 DEFAULT CHARACTER SET binary;
43 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
44 DROP DATABASE d8;
45 CREATE DATABASE d8;
46 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
47 ALTER DATABASE d8 DEFAULT CHARACTER SET swe7;
48 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
49 DROP DATABASE d8;
50 CREATE DATABASE d8;
51 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
52 ALTER DATABASE d8 DEFAULT CHARACTER SET cp1251;
53 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
54 DROP DATABASE d8;
55 CREATE DATABASE d8;
56 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
57 ALTER SCHEMA d8 CHARACTER SET ascii;
58 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
59 DROP DATABASE d8;
60 CREATE DATABASE d8;
61 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
62 ALTER SCHEMA d8 CHARACTER SET utf8;
63 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
64 DROP DATABASE d8;
65 CREATE DATABASE d8;
66 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
67 ALTER SCHEMA d8 CHARACTER SET binary;
68 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
69 DROP DATABASE d8;
70 CREATE DATABASE d8;
71 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
72 ALTER SCHEMA d8 CHARACTER SET swe7;
73 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
74 DROP DATABASE d8;
75 CREATE DATABASE d8;
76 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
77 ALTER SCHEMA d8 CHARACTER SET cp1251;
78 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
79 DROP DATABASE d8;
80 CREATE DATABASE d8;
81 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
82 ALTER SCHEMA d8 DEFAULT CHARACTER SET ascii;
83 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
84 DROP DATABASE d8;
85 CREATE DATABASE d8;
86 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
87 ALTER SCHEMA d8 DEFAULT CHARACTER SET utf8;
88 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
89 DROP DATABASE d8;
90 CREATE DATABASE d8;
91 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
92 ALTER SCHEMA d8 DEFAULT CHARACTER SET binary;
93 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
94 DROP DATABASE d8;
95 CREATE DATABASE d8;
96 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
97 ALTER SCHEMA d8 DEFAULT CHARACTER SET swe7;
98 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
99 DROP DATABASE d8;
100 CREATE DATABASE d8;
101 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
102 ALTER SCHEMA d8 DEFAULT CHARACTER SET cp1251;
103 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
104 DROP DATABASE d8;
105