Debian Codegraph @

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

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