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>
		
			
				
	
	
		
			14 lines
		
	
	
		
			520 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
			
		
		
	
	
			14 lines
		
	
	
		
			520 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
USE tpch1;
 | 
						|
select count(*),max(l_quantity),max(l_extendedprice),max(l_discount),
 | 
						|
max(l_tax),max(l_shipinstruct),max(l_commitdate),max(l_receiptdate)
 | 
						|
from lineitem 
 | 
						|
where 		l_orderkey < 7009
 | 
						|
and l_suppkey < 70000
 | 
						|
and l_linenumber < 5
 | 
						|
and l_partkey < 7000
 | 
						|
and l_tax < 70500
 | 
						|
and l_extendedprice < 70500
 | 
						|
and l_discount < 28 ;
 | 
						|
count(*)	max(l_quantity)	max(l_extendedprice)	max(l_discount)	max(l_tax)	max(l_shipinstruct)	max(l_commitdate)	max(l_receiptdate)
 | 
						|
179	50.00	70275.00	0.10	0.08	TAKE BACK RETURN	1998-10-03	1998-09-30
 |