mirror of
				https://github.com/MariaDB/server.git
				synced 2025-11-04 04:46:15 +01:00 
			
		
		
		
	
		
			
				
	
	
		
			22 lines
		
	
	
	
		
			573 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			22 lines
		
	
	
	
		
			573 B
		
	
	
	
		
			Text
		
	
	
	
	
	
-- source include/not_embedded.inc
 | 
						|
-- source ../include/ps_truncate_all_tables.inc
 | 
						|
# Tests for sys schema
 | 
						|
# Verify the sys.statement_analysis view
 | 
						|
 | 
						|
# Ensure structure changes don't slip in
 | 
						|
DESC sys.statement_analysis;
 | 
						|
 | 
						|
# Make sure view select does not error, but ignore results
 | 
						|
--disable_result_log
 | 
						|
SELECT * FROM sys.statement_analysis;
 | 
						|
--enable_result_log
 | 
						|
 | 
						|
 | 
						|
# Ensure structure changes don't slip in
 | 
						|
DESC sys.x$statement_analysis;
 | 
						|
 | 
						|
# Make sure view select does not error, but ignore results
 | 
						|
--disable_result_log
 | 
						|
SELECT * FROM sys.x$statement_analysis;
 | 
						|
--enable_result_log
 | 
						|
 |