--- delete.result 2013-01-22 22:05:05.246633000 +0400 +++ delete.reject 2013-01-23 03:22:35.419669500 +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 <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(6,'f'),(7,'g'),(8,'h'),(10000,'foobar'); @@ -46,27 +58,17 @@ DELETE FROM t1; RELEASE SAVEPOINT spt1; ROLLBACK; +Warnings: +Warning 1196 Some non-transactional changed tables couldn't be rolled back SELECT a,b FROM t1; a b -10000 foobar -10000 foobar -2 b -2 b -4 d -4 d -5 e -5 e -6 f -6 f -7 g -7 g -8 h -8 h BEGIN; DELETE FROM t1 WHERE a <= 4 ORDER BY b DESC LIMIT 1; SAVEPOINT spt1; DELETE FROM t1; INSERT INTO t1 (a,b) VALUES (1,'a'); ROLLBACK TO SAVEPOINT spt1; +Warnings: +Warning 1196 Some non-transactional changed tables couldn't be rolled back COMMIT; DROP TABLE t1;