summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/sql_sequence/replication_drop.result
blob: 1cd7022765ee3cca2ba258cb571a61040f6c2c0b (plain)
1
2
3
4
5
CREATE SEQUENCE seq ENGINE=InnoDB;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
INSERT INTO seq VALUES (1,1,100,1,1,1,1,1);
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.
DROP SEQUENCE seq;