Debian Codegraph @

mysql-test/suite/storage_engine/trx/insert.test

raw
1 #
2 # Transactional INSERT
3 #
4 --source ../have_engine.inc
5 --source support_transactions.inc
6 --source support_savepoints.inc
7
8 --disable_warnings
9 DROP TABLE IF EXISTS t1;
10 --enable_warnings
11
12 --source ../create_table.inc
13 BEGIN;
14 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(100,'foo');
15 INSERT t1 (a,b) VALUE (10,'foo'),(11,'abc');
16 COMMIT;
17 --sorted_result
18 SELECT a,b FROM t1;
19
20 BEGIN;
21 INSERT INTO t1 (b,a) VALUES ('test',0);
22 SAVEPOINT spt1;
23 INSERT INTO t1 (a,b) VALUES (DEFAULT,DEFAULT);
24 RELEASE SAVEPOINT spt1;
25 INSERT INTO t1 (a,b) VALUES (DEFAULT,DEFAULT);
26 ROLLBACK;
27 --sorted_result
28 SELECT a,b FROM t1;
29
30 BEGIN;
31 INSERT t1 (a) VALUE (10),(20);
32 SAVEPOINT spt1;
33 INSERT INTO t1 SET a = 11, b = 'f';
34 INSERT t1 SET b = DEFAULT;
35 ROLLBACK TO SAVEPOINT spt1;
36 INSERT INTO t1 (b,a) VALUES ('test1',10);
37 COMMIT;
38 --sorted_result
39 SELECT a,b FROM t1;
40
41 DROP TABLE t1;
42
43 --source ../cleanup_engine.inc
44