mirror of
				https://github.com/MariaDB/server.git
				synced 2025-11-04 12:56:14 +01:00 
			
		
		
		
	The bug was the we copied the lock type to the underlying engine even when external_lock failed.
		
			
				
	
	
		
			17 lines
		
	
	
	
		
			446 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			17 lines
		
	
	
	
		
			446 B
		
	
	
	
		
			Text
		
	
	
	
	
	
#
 | 
						|
# 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;
 |