summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/sql_sequence/replication_drop.test
blob: ca0502463918ca2f4b62c02d944822dbd2fb4457 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
#
# Test for MDEV-15812
# Assertion `m_lock_type == 2' failed in
# handler::~handler on dropping a sequence after
# ER_BINLOG_STMT_MODE_AND_ROW_ENGINE
#

--source include/have_innodb.inc
--source include/have_binlog_format_statement.inc

CREATE SEQUENCE seq ENGINE=InnoDB;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
--error ER_BINLOG_STMT_MODE_AND_ROW_ENGINE
INSERT INTO seq VALUES (1,1,100,1,1,1,1,1);

# Cleanup
DROP SEQUENCE seq;