mirror of
				https://github.com/MariaDB/server.git
				synced 2025-11-04 04:46:15 +01:00 
			
		
		
		
	
		
			
				
	
	
		
			25 lines
		
	
	
	
		
			714 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			25 lines
		
	
	
	
		
			714 B
		
	
	
	
		
			Text
		
	
	
	
	
	
source include/federated.inc;
 | 
						|
 | 
						|
connection master;
 | 
						|
#
 | 
						|
# MDEV-388 Creating a federated table with a non-existing server returns a random error code
 | 
						|
#
 | 
						|
--error 1
 | 
						|
CREATE TABLE t1 (a INT) ENGINE=FEDERATED CONNECTION='non_existing';
 | 
						|
--replace_result "Not owner" "Operation not permitted"
 | 
						|
SHOW WARNINGS;
 | 
						|
 | 
						|
#
 | 
						|
# MDEV-4468 Assertion `error != 0' fails or timeout occurs on select from a FEDERATED table which points at a non-existent table
 | 
						|
#
 | 
						|
 | 
						|
create table t1 (a int);
 | 
						|
--replace_result $MASTER_MYPORT MASTER_PORT
 | 
						|
eval create table fed (a int) engine=Federated CONNECTION='mysql://root@127.0.0.1:$MASTER_MYPORT/test/t1';
 | 
						|
drop table t1;
 | 
						|
--error 1146,1431
 | 
						|
select * from fed;
 | 
						|
drop table fed;
 | 
						|
 | 
						|
source include/federated_cleanup.inc;
 | 
						|
 |