--- insert.result 2013-01-22 22:05:05.246633000 +0400 +++ insert.reject 2013-01-23 03:22:35.987662359 +0400 @@ -1,3 +1,15 @@ +# -- WARNING ---------------------------------------------------------------- +# According to I_S.ENGINES, MRG_MYISAM does not support transactions. +# If it is true, the test will most likely fail; you can +# either create an rdiff file, or add the test to disabled.def. +# If transactions should be supported, check the data in Information Schema. +# --------------------------------------------------------------------------- +# -- WARNING ---------------------------------------------------------------- +# According to I_S.ENGINES, MRG_MYISAM does not support savepoints. +# If it is true, the test will most likely fail; you can +# either create an rdiff file (recommended), or add the test to disabled.def. +# If savepoints should be supported, check the data in Information Schema. +# --------------------------------------------------------------------------- DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a , b ) ENGINE= ; BEGIN; @@ -21,8 +33,11 @@ RELEASE SAVEPOINT spt1; INSERT INTO t1 (a,b) VALUES (DEFAULT,DEFAULT); ROLLBACK; +Warnings: +Warning 1196 Some non-transactional changed tables couldn't be rolled back SELECT a,b FROM t1; a b +0 test 1 a 10 foo 100 foo @@ -31,25 +46,34 @@ 3 c 4 d 5 e +NULL NULL +NULL NULL BEGIN; INSERT t1 (a) VALUE (10),(20); SAVEPOINT spt1; INSERT INTO t1 SET a = 11, b = 'f'; INSERT t1 SET b = DEFAULT; ROLLBACK TO SAVEPOINT spt1; +Warnings: +Warning 1196 Some non-transactional changed tables couldn't be rolled back INSERT INTO t1 (b,a) VALUES ('test1',10); COMMIT; SELECT a,b FROM t1; a b +0 test 1 a 10 NULL 10 foo 10 test1 100 foo 11 abc +11 f 2 b 20 NULL 3 c 4 d 5 e +NULL NULL +NULL NULL +NULL NULL DROP TABLE t1;