mirror of
				https://github.com/MariaDB/server.git
				synced 2025-10-31 10:56:12 +01:00 
			
		
		
		
	 0bfd45f634
			
		
	
	
	0bfd45f634
	
	
	
		
			
			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;
 |