Debian Codegraph @

mysql-test/suite/innodb/r/create_drop_temp_table_perf_debug.result

raw
1 set global innodb_file_per_table = 0;
2 set global innodb_file_per_table = 1;
3 call mtr.add_suppression("No space left on device");
4 call mtr.add_suppression("table.+ full");
5 call mtr.add_suppression("Cannot create file");
6 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* table .* does not exist "
7 "in the InnoDB internal");
8 set session debug="+d,ib_ddl_crash_during_tablespace_alloc";
9 create temporary table t1
10 (a int, b int, primary key(a), index(b)) engine = innodb;
11 ERROR HY000: Lost connection to MySQL server during query
12 create temporary table t1
13 (a int, b int, primary key(a), index(b)) engine = innodb;
14 insert into t1 values (10, 11);
15 select * from t1;
16 a b
17 10 11
18 drop table t1;
19 set session debug="+d,ib_create_table_fail_at_create_index";
20 create temporary table t1
21 (a int, b int, primary key(a), index(b)) engine = innodb;
22 ERROR HY000: Index column size too large. The maximum column size is 3072 bytes.
23 insert into t1 values (10, 11);
24 ERROR 42S02: Table 'test.t1' doesn't exist
25 set session debug="-d,ib_create_table_fail_at_create_index";
26 create temporary table t1
27 (a int, b int, primary key(a), index(b)) engine = innodb;
28 insert into t1 values (10, 11);
29 drop table t1;
30 drop table if exists parent,child;
31 create temporary table parent ( i int primary key ) engine = innodb;
32 create table child ( j int references parent(i)) engine = innodb;
33 insert into parent values (1),(2),(3),(4);
34 insert into child values (1),(2),(3),(4);
35 insert into child values (5),(6);
36 select * from parent;
37 i
38 1
39 2
40 3
41 4
42 select * from child;
43 j
44 1
45 2
46 3
47 4
48 5
49 6
50 # restart
51 select * from parent ;
52 ERROR 42S02: Table 'test.parent' doesn't exist
53 select * from child ;
54 j
55 1
56 2
57 3
58 4
59 5
60 6
61 drop table child;