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; |