mirror of
				https://github.com/MariaDB/server.git
				synced 2025-11-03 20:36:16 +01:00 
			
		
		
		
	
		
			
				
	
	
		
			21 lines
		
	
	
	
		
			456 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			21 lines
		
	
	
	
		
			456 B
		
	
	
	
		
			Text
		
	
	
	
	
	
#
 | 
						|
# Test that transaction requiring two-phase commit and involving
 | 
						|
# storage engines not supporting it rolls back with a message.
 | 
						|
#
 | 
						|
 | 
						|
--source include/galera_cluster.inc
 | 
						|
--source include/have_innodb.inc
 | 
						|
--source include/have_aria.inc
 | 
						|
 | 
						|
CREATE TABLE t (a INT) ENGINE=Aria;
 | 
						|
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
 | 
						|
 | 
						|
START TRANSACTION;
 | 
						|
INSERT INTO t VALUES ('1');
 | 
						|
INSERT INTO t1 VALUES ('1');
 | 
						|
 | 
						|
--error ER_ERROR_DURING_COMMIT
 | 
						|
COMMIT;
 | 
						|
 | 
						|
DROP TABLE t;
 | 
						|
DROP TABLE t1;
 |