diff options
Diffstat (limited to 'mysql-test/r/partition_innodb_stmt.result')
| -rw-r--r-- | mysql-test/r/partition_innodb_stmt.result | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/mysql-test/r/partition_innodb_stmt.result b/mysql-test/r/partition_innodb_stmt.result index 22a9f28708c..543d4734216 100644 --- a/mysql-test/r/partition_innodb_stmt.result +++ b/mysql-test/r/partition_innodb_stmt.result @@ -1,4 +1,3 @@ -# connection default SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ; CREATE TABLE t1 ( @@ -21,12 +20,13 @@ id 1 2 3 -#connection con1 +connect con1, localhost, root,,; +connection con1; SET TRANSACTION ISOLATION LEVEL REPEATABLE READ; BEGIN; INSERT INTO t1 VALUES(7); COMMIT; -# connection default +connection default; COMMIT; FLUSH TABLES; # Test REPEATABLE READ -> READ COMMITTED @@ -38,11 +38,13 @@ id 2 3 7 -# connection con1 +connection con1; SET TRANSACTION ISOLATION LEVEL READ COMMITTED; BEGIN; INSERT INTO t1 VALUES(9); ERROR HY000: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED. COMMIT; +disconnect con1; +connection default; COMMIT; DROP TABLE t1; |