Debian Codegraph @

mysql-test/suite/atomic/drop_db.result

raw
1 call mtr.add_suppression("InnoDB: .* does not exist in the InnoDB internal");
2 RESET MASTER;
3 "engine: aria crash point: ddl_log_drop_before_delete_table position: 1"
4 t1v.frm
5 t2.MAD
6 t2.MAI
7 t2.frm
8 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
9 foo STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
10 insert into test.t1 values (42) latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
11 master-bin.000002 # Query # # use `test2`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
12 "engine: aria crash point: ddl_log_drop_before_delete_table position: 2"
13 t1v.frm
14 t2.MAD
15 t2.MAI
16 t2.frm
17 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
18 foo STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
19 insert into test.t1 values (42) latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
20 master-bin.000002 # Query # # use `test2`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
21 master-bin.000002 # Query # # use `test2`; DROP VIEW IF EXISTS `t1v` /* generated by ddl recovery */
22 "engine: aria crash point: ddl_log_drop_before_delete_table position: 3"
23 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
24 foo STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
25 insert into test.t1 values (42) latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
26 master-bin.000002 # Query # # use `test2`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
27 master-bin.000002 # Query # # use `test2`; DROP VIEW IF EXISTS `t1v` /* generated by ddl recovery */
28 "engine: aria crash point: ddl_log_drop_after_drop_tables position: 1"
29 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
30 foo STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
31 insert into test.t1 values (42) latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
32 master-bin.000002 # Query # # use `test2`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
33 master-bin.000002 # Query # # use `test2`; DROP VIEW IF EXISTS `t1v` /* generated by ddl recovery */
34 "engine: aria crash point: ddl_log_drop_before_ha_drop_database position: 1"
35 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
36 "engine: aria crash point: ddl_log_drop_before_drop_db_routines position: 1"
37 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
38 "engine: aria crash point: ddl_log_drop_after_drop_db_routines position: 1"
39 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
40 "engine: aria crash point: ddl_log_drop_before_drop_option_file position: 1"
41 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
42 "engine: aria crash point: ddl_log_drop_before_drop_dir position: 1"
43 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
44 "engine: aria crash point: ddl_log_drop_after_drop_dir position: 1"
45 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
46 "engine: aria crash point: ddl_log_drop_before_binlog position: 1"
47 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
48 "engine: aria crash point: ddl_log_drop_after_binlog position: 1"
49 master-bin.000001 # Query # # DROP DATABASE test2
50 "engine: innodb crash point: ddl_log_drop_before_delete_table position: 1"
51 t1v.frm
52 t2.frm
53 t2.ibd
54 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
55 foo STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
56 insert into test.t1 values (42) latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
57 master-bin.000002 # Query # # use `test2`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
58 "engine: innodb crash point: ddl_log_drop_before_delete_table position: 2"
59 t1v.frm
60 t2.frm
61 t2.ibd
62 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
63 foo STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
64 insert into test.t1 values (42) latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
65 master-bin.000002 # Query # # use `test2`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */
66 master-bin.000002 # Query # # use `test2`; DROP VIEW IF EXISTS `t1v` /* generated by ddl recovery */
67 "engine: innodb crash point: ddl_log_drop_before_delete_table position: 3"
68 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
69 foo STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
70 insert into test.t1 values (42) latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
71 master-bin.000002 # Query # # use `test2`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
72 master-bin.000002 # Query # # use `test2`; DROP VIEW IF EXISTS `t1v` /* generated by ddl recovery */
73 "engine: innodb crash point: ddl_log_drop_after_drop_tables position: 1"
74 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
75 foo STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
76 insert into test.t1 values (42) latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
77 master-bin.000002 # Query # # use `test2`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */
78 master-bin.000002 # Query # # use `test2`; DROP VIEW IF EXISTS `t1v` /* generated by ddl recovery */
79 "engine: innodb crash point: ddl_log_drop_before_ha_drop_database position: 1"
80 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
81 "engine: innodb crash point: ddl_log_drop_before_drop_db_routines position: 1"
82 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
83 "engine: innodb crash point: ddl_log_drop_after_drop_db_routines position: 1"
84 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
85 "engine: innodb crash point: ddl_log_drop_before_drop_option_file position: 1"
86 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
87 "engine: innodb crash point: ddl_log_drop_before_drop_dir position: 1"
88 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
89 "engine: innodb crash point: ddl_log_drop_after_drop_dir position: 1"
90 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
91 "engine: innodb crash point: ddl_log_drop_before_binlog position: 1"
92 master-bin.000002 # Query # # DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
93 "engine: innodb crash point: ddl_log_drop_after_binlog position: 1"
94 master-bin.000001 # Query # # DROP DATABASE test2
95 Warnings:
96 Note 1008 Can't drop database 'test2'; database doesn't exist