Debian Codegraph @

storage/myisam/mysql-test/storage_engine/trx/delete.rdiff

raw
1 --- suite/storage_engine/trx/delete.result
2 +++ suite/storage_engine/trx/delete.reject
3 @@ -1,3 +1,15 @@
4 +# -- WARNING ----------------------------------------------------------------
5 +# According to I_S.ENGINES, MyISAM does not support transactions.
6 +# If it is true, the test will most likely fail; you can
7 +# either create an rdiff file, or add the test to disabled.def.
8 +# If transactions should be supported, check the data in Information Schema.
9 +# ---------------------------------------------------------------------------
10 +# -- WARNING ----------------------------------------------------------------
11 +# According to I_S.ENGINES, MyISAM does not support savepoints.
12 +# If it is true, the test will most likely fail; you can
13 +# either create an rdiff file (recommended), or add the test to disabled.def.
14 +# If savepoints should be supported, check the data in Information Schema.
15 +# ---------------------------------------------------------------------------
16 DROP TABLE IF EXISTS t1;
17 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
18 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(6,'f'),(7,'g'),(8,'h'),(10000,'foobar');
19 @@ -46,27 +58,17 @@
20 DELETE FROM t1;
21 RELEASE SAVEPOINT spt1;
22 ROLLBACK;
23 +Warnings:
24 +Warning 1196 Some non-transactional changed tables couldn't be rolled back
25 SELECT a,b FROM t1;
26 a b
27 -10000 foobar
28 -10000 foobar
29 -2 b
30 -2 b
31 -4 d
32 -4 d
33 -5 e
34 -5 e
35 -6 f
36 -6 f
37 -7 g
38 -7 g
39 -8 h
40 -8 h
41 BEGIN;
42 DELETE FROM t1 WHERE a <= 4 ORDER BY b DESC LIMIT 1;
43 SAVEPOINT spt1;
44 DELETE FROM t1;
45 INSERT INTO t1 (a,b) VALUES (1,'a');
46 ROLLBACK TO SAVEPOINT spt1;
47 +Warnings:
48 +Warning 1196 Some non-transactional changed tables couldn't be rolled back
49 COMMIT;
50 DROP TABLE t1;