--- suite/storage_engine/trx/delete.result 2012-07-12 23:06:18.946113626 +0400 +++ suite/storage_engine/trx/delete.reject 2012-07-15 16:55:46.108397219 +0400 @@ -1,3 +1,15 @@ +# -- WARNING ---------------------------------------------------------------- +# According to I_S.ENGINES, 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, 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= ; 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;