mirror of
				https://github.com/MariaDB/server.git
				synced 2025-11-03 20:36:16 +01:00 
			
		
		
		
	
		
			
				
	
	
		
			14 lines
		
	
	
	
		
			508 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			14 lines
		
	
	
	
		
			508 B
		
	
	
	
		
			Text
		
	
	
	
	
	
--source include/not_embedded.inc
 | 
						|
--source include/default_charset.inc
 | 
						|
 | 
						|
#
 | 
						|
# MDEV-5553 A view or procedure with a non existing definer can block "SHOW TABLE STATUS" with an unclear error message
 | 
						|
#
 | 
						|
 | 
						|
create database mysqltest1; # all-open privileges on test db desroy the test
 | 
						|
use mysqltest1;
 | 
						|
create table t1(id int primary key);
 | 
						|
create definer=unknownuser@'%' sql security definer view v1 as select t1.id from t1 group by t1.id;
 | 
						|
--replace_column 8 # 12 # 13 # 19 #
 | 
						|
show table status;
 | 
						|
drop database mysqltest1;
 |