Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP DATABASE IF EXISTS d9;
3 --enable_warnings
4 --replace_column 5 # 6 #
5 SHOW COLLATION;
6 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
7 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
8 ALTER DATABASE d9 COLLATE ascii_bin;
9 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
10 DROP DATABASE d9;
11 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
12 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
13 ALTER DATABASE d9 DEFAULT COLLATE ascii_bin;
14 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
15 DROP DATABASE d9;
16 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
17 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
18 ALTER DATABASE d9 COLLATE ascii_general_ci;
19 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
20 DROP DATABASE d9;
21 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
22 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
23 ALTER DATABASE d9 DEFAULT COLLATE ascii_general_ci;
24 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
25 DROP DATABASE d9;
26 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
27 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
28 ALTER SCHEMA d9 COLLATE ascii_bin;
29 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
30 DROP DATABASE d9;
31 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
32 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
33 ALTER SCHEMA d9 DEFAULT COLLATE ascii_bin;
34 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
35 DROP DATABASE d9;
36 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
37 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
38 ALTER SCHEMA d9 COLLATE ascii_general_ci;
39 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
40 DROP DATABASE d9;
41 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
42 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
43 ALTER SCHEMA d9 DEFAULT COLLATE ascii_general_ci;
44 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
45 DROP DATABASE d9;
46