Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 BEGIN;
4 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(100,'foo');
5 INSERT t1 (a,b) VALUE (10,'foo'),(11,'abc');
6 COMMIT;
7 SELECT a,b FROM t1;
8 a b
9 1 a
10 10 foo
11 100 foo
12 11 abc
13 2 b
14 3 c
15 4 d
16 5 e
17 BEGIN;
18 INSERT INTO t1 (b,a) VALUES ('test',0);
19 SAVEPOINT spt1;
20 INSERT INTO t1 (a,b) VALUES (DEFAULT,DEFAULT);
21 RELEASE SAVEPOINT spt1;
22 INSERT INTO t1 (a,b) VALUES (DEFAULT,DEFAULT);
23 ROLLBACK;
24 SELECT a,b FROM t1;
25 a b
26 1 a
27 10 foo
28 100 foo
29 11 abc
30 2 b
31 3 c
32 4 d
33 5 e
34 BEGIN;
35 INSERT t1 (a) VALUE (10),(20);
36 SAVEPOINT spt1;
37 INSERT INTO t1 SET a = 11, b = 'f';
38 INSERT t1 SET b = DEFAULT;
39 ROLLBACK TO SAVEPOINT spt1;
40 INSERT INTO t1 (b,a) VALUES ('test1',10);
41 COMMIT;
42 SELECT a,b FROM t1;
43 a b
44 1 a
45 10 NULL
46 10 foo
47 10 test1
48 100 foo
49 11 abc
50 2 b
51 20 NULL
52 3 c
53 4 d
54 5 e
55 DROP TABLE t1;