Debian Codegraph @

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

raw
1 --- suite/storage_engine/trx/update.result
2 +++ suite/storage_engine/trx/update.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'),(10000,'foobar');
19 @@ -24,25 +36,29 @@
20 UPDATE t1 SET b = 'update' WHERE a <= 4 ORDER BY a DESC, b ASC LIMIT 3;
21 UPDATE t1 SET b = '';
22 ROLLBACK;
23 +Warnings:
24 +Warning 1196 Some non-transactional changed tables couldn't be rolled back
25 BEGIN;
26 UPDATE t1 SET b = 'update2' WHERE a <= 100;
27 SAVEPOINT spt1;
28 UPDATE t1 SET b = '';
29 ROLLBACK TO SAVEPOINT spt1;
30 +Warnings:
31 +Warning 1196 Some non-transactional changed tables couldn't be rolled back
32 UPDATE t1 SET b = 'upd' WHERE a = 10050;
33 COMMIT;
34 SELECT a,b FROM t1;
35 a b
36 10050 upd
37 10050 upd
38 -51 update2
39 -51 update2
40 -52 update2
41 -52 update2
42 -53 update2
43 -53 update2
44 -54 update2
45 -54 update2
46 -55 update2
47 -55 update2
48 +51
49 +51
50 +52
51 +52
52 +53
53 +53
54 +54
55 +54
56 +55
57 +55
58 DROP TABLE t1;