Debian Codegraph @

mysql-test/suite/storage_engine/trx/delete.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 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(6,'f'),(7,'g'),(8,'h'),(10000,'foobar');
4 INSERT INTO t1 (a,b) SELECT a, b FROM t1;
5 BEGIN;
6 DELETE FROM t1 WHERE b IN ('c');
7 SELECT a,b FROM t1;
8 a b
9 1 a
10 1 a
11 10000 foobar
12 10000 foobar
13 2 b
14 2 b
15 4 d
16 4 d
17 5 e
18 5 e
19 6 f
20 6 f
21 7 g
22 7 g
23 8 h
24 8 h
25 DELETE FROM t1 WHERE a < 0 OR b = 'a';
26 COMMIT;
27 SELECT a,b FROM t1;
28 a b
29 10000 foobar
30 10000 foobar
31 2 b
32 2 b
33 4 d
34 4 d
35 5 e
36 5 e
37 6 f
38 6 f
39 7 g
40 7 g
41 8 h
42 8 h
43 BEGIN;
44 DELETE FROM t1 WHERE a <= 4 ORDER BY b DESC LIMIT 1;
45 SAVEPOINT spt1;
46 DELETE FROM t1;
47 RELEASE SAVEPOINT spt1;
48 ROLLBACK;
49 SELECT a,b FROM t1;
50 a b
51 10000 foobar
52 10000 foobar
53 2 b
54 2 b
55 4 d
56 4 d
57 5 e
58 5 e
59 6 f
60 6 f
61 7 g
62 7 g
63 8 h
64 8 h
65 BEGIN;
66 DELETE FROM t1 WHERE a <= 4 ORDER BY b DESC LIMIT 1;
67 SAVEPOINT spt1;
68 DELETE FROM t1;
69 INSERT INTO t1 (a,b) VALUES (1,'a');
70 ROLLBACK TO SAVEPOINT spt1;
71 COMMIT;
72 DROP TABLE t1;