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>
		
			
				
	
	
		
			11 lines
		
	
	
		
			515 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
			
		
		
	
	
			11 lines
		
	
	
		
			515 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
USE tpch1;
 | 
						|
select count(*) from region a inner join nation b on (a.r_regionkey=b.n_regionkey) right outer join customer c on (b.n_name and b.n_nationkey = c.c_nationkey);
 | 
						|
count(*)
 | 
						|
150000
 | 
						|
select * from region where r_regionkey;
 | 
						|
r_regionkey	r_name	r_comment
 | 
						|
1	AMERICA	hs use ironic, even requests. s
 | 
						|
2	ASIA	ges. thinly even pinto beans ca
 | 
						|
3	EUROPE	ly final courts cajole furiously final excuse
 | 
						|
4	MIDDLE EAST	uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
 |