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.
		
			
				
	
	
		
			5 lines
		
	
	
	
		
			439 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			5 lines
		
	
	
	
		
			439 B
		
	
	
	
		
			Text
		
	
	
	
	
	
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;
 |