You've already forked mariadb-columnstore-engine
							
							
				mirror of
				https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
				synced 2025-11-03 17:13:17 +03:00 
			
		
		
		
	* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
		
			
				
	
	
		
			22 lines
		
	
	
		
			514 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
			
		
		
	
	
			22 lines
		
	
	
		
			514 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
#
 | 
						|
# Test case migrated from regression test suite:
 | 
						|
# ./mysql/queries/100GB/dataValidation/dataval.005.sql
 | 
						|
#
 | 
						|
# Author: Susil, susil.behera@mariadb.com
 | 
						|
#
 | 
						|
 | 
						|
-- source ../include/have_columnstore.inc
 | 
						|
 | 
						|
USE tpch1;
 | 
						|
 | 
						|
# Validate 90,000 of the 150 million orders.  
 | 
						|
 | 
						|
select * from orders 
 | 
						|
where 
 | 
						|
round(o_orderkey,-4) + 1024 = o_orderkey or
 | 
						|
round(o_orderkey,-4) + 2048 = o_orderkey or
 | 
						|
round(o_orderkey,-4) + 4096 = o_orderkey or
 | 
						|
round(o_orderkey,-4) + 6144 = o_orderkey or
 | 
						|
round(o_orderkey,-4) + 8192 = o_orderkey
 | 
						|
order by 1;
 |