1# t/cache_innodb.test 2# 3# Last update: 4# 2006-07-26 ML test refactored (MySQL 5.1) 5# main code t/innodb_cache.test --> include/query_cache.inc 6# new wrapper t/cache_innodb.test 7# 8 9--source include/have_query_cache.inc 10 11--source include/have_innodb.inc 12let $engine_type= InnoDB; 13# InnoDB supports FOREIGN KEYs 14let $test_foreign_keys= 1; 15 16--source include/query_cache.inc 17 18# 19# Bug#56452 Assertion failed: thd->transaction.stmt.is_empty() || 20# thd->in_sub_stmt 21# 22CREATE TABLE t1 (a INT) ENGINE=InnoDB; 23BEGIN; 24 INSERT INTO t1 VALUES(1); 25ROLLBACK WORK AND CHAIN NO RELEASE; 26SELECT a FROM t1; 27ROLLBACK WORK AND CHAIN NO RELEASE; 28SELECT a FROM t1; 29ROLLBACK; 30DROP TABLE t1; 31 32