Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP DATABASE IF EXISTS d11;
3 --enable_warnings
4 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
5 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
6 ALTER DATABASE d11 CHARACTER SET utf8 COLLATE utf8_general_ci;
7 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
8 DROP DATABASE d11;
9 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
10 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
11 ALTER DATABASE d11 CHARACTER SET latin2 COLLATE latin2_general_ci;
12 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
13 DROP DATABASE d11;
14 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
15 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
16 ALTER DATABASE d11 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci;
17 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
18 DROP DATABASE d11;
19 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
20 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
21 ALTER SCHEMA d11 CHARACTER SET utf8 COLLATE utf8_general_ci;
22 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
23 DROP DATABASE d11;
24 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
25 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
26 ALTER SCHEMA d11 CHARACTER SET latin2 COLLATE latin2_general_ci;
27 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
28 DROP DATABASE d11;
29 CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin;
30 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
31 ALTER SCHEMA d11 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci;
32 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
33 DROP DATABASE d11;
34