Debian Codegraph @

mysql-test/suite/innodb/t/temp_table.test

raw
1
2 ####################################################################
3 # TC to test temp-table DML optimization changes for correctness #
4 # Sceanrio covered: #
5 # 1. bulk-insert with rollback + commit: this will ensure btree #
6 # node split with rollback and commit. #
7 ####################################################################
8
9 #-------------------------------------------------------------------
10 #
11 # 1. bulk-insert with rollback + commit: this will ensure btree #
12 # node split with rollback and commit. #
13 #
14 create temporary table t1
15 (keyc int, c1 char(100), c2 char(100),
16 primary key(keyc), index sec_index(c1)
17 ) engine = innodb;
18 create temporary table t2
19 (keyc int, c1 char(100), c2 char(100),
20 primary key(keyc), index sec_index(c1)
21 ) engine = innodb;
22 --source suite/innodb/include/dml_ops.inc
23 drop temporary table t1,t2;
24 #
25 --error ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE
26 create temporary table t1
27 (keyc int, c1 char(100), c2 char(100),
28 primary key(keyc), index sec_index(c1)
29 ) engine = innodb key_block_size = 4;
30 create temporary table t1
31 (keyc int, c1 char(100), c2 char(100),
32 primary key(keyc), index sec_index(c1)
33 ) engine = innodb;
34 set innodb_strict_mode=off;
35 --disable_warnings
36 create temporary table t2
37 (keyc int, c1 char(100), c2 char(100),
38 primary key(keyc), index sec_index(c1)
39 ) engine = innodb key_block_size = 8;
40 set innodb_strict_mode=on;
41 --enable_warnings
42 --source suite/innodb/include/dml_ops.inc
43 drop temporary table t1, t2;
44 #
45 create temporary table t1
46 (keyc int, c1 char(100), c2 char(100),
47 primary key(keyc), index sec_index(c1)
48 ) engine = innodb;
49 create temporary table t2
50 (keyc int, c1 char(100), c2 char(100),
51 primary key(keyc), index sec_index(c1)
52 ) engine = innodb;
53 --source suite/innodb/include/dml_ops.inc