Debian Codegraph @

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

raw
1 --- suite/storage_engine/trx/insert.result
2 +++ suite/storage_engine/trx/insert.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 BEGIN;
19 @@ -21,8 +33,11 @@
20 RELEASE SAVEPOINT spt1;
21 INSERT INTO t1 (a,b) VALUES (DEFAULT,DEFAULT);
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 +0 test
28 1 a
29 10 foo
30 100 foo
31 @@ -31,25 +46,34 @@
32 3 c
33 4 d
34 5 e
35 +NULL NULL
36 +NULL NULL
37 BEGIN;
38 INSERT t1 (a) VALUE (10),(20);
39 SAVEPOINT spt1;
40 INSERT INTO t1 SET a = 11, b = 'f';
41 INSERT t1 SET b = DEFAULT;
42 ROLLBACK TO SAVEPOINT spt1;
43 +Warnings:
44 +Warning 1196 Some non-transactional changed tables couldn't be rolled back
45 INSERT INTO t1 (b,a) VALUES ('test1',10);
46 COMMIT;
47 SELECT a,b FROM t1;
48 a b
49 +0 test
50 1 a
51 10 NULL
52 10 foo
53 10 test1
54 100 foo
55 11 abc
56 +11 f
57 2 b
58 20 NULL
59 3 c
60 4 d
61 5 e
62 +NULL NULL
63 +NULL NULL
64 +NULL NULL
65 DROP TABLE t1;