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>
		
			
				
	
	
		
			10 lines
		
	
	
		
			414 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
			
		
		
	
	
			10 lines
		
	
	
		
			414 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
USE tpch1;
 | 
						|
select * from sub1 LEFT OUTER JOIN (select * from sub2) Meal on(sub1.c1=Meal.c1 and sub1.c2=Meal.c2) order by 1;
 | 
						|
c1	c2	c3	s1	s2	s3	c1	c2	c3	s1	s2	s3
 | 
						|
1	1	1	1	1	1	1	1	1	1	1	1
 | 
						|
2	2	2	2	2	2	NULL	NULL	NULL	NULL	NULL	NULL
 | 
						|
3	3	3	3	3	3	NULL	NULL	NULL	NULL	NULL	NULL
 | 
						|
4	1	1	1	1	1	NULL	NULL	NULL	NULL	NULL	NULL
 | 
						|
5	99	99	99	99	99	NULL	NULL	NULL	NULL	NULL	NULL
 | 
						|
6	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
 |