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 
			
		
		
		
	
		
			
				
	
	
		
			9 lines
		
	
	
		
			279 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
			
		
		
	
	
			9 lines
		
	
	
		
			279 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
USE tpch1;
 | 
						|
drop table if exists mcol3395;
 | 
						|
create table mcol3395 (c1 char(10), c2 varchar(10), c3 varchar(6))engine=columnstore;
 | 
						|
insert into mcol3395 values ('abc','cde','abc'), ('cde','abc','cde');
 | 
						|
select * from mcol3395 where c2='abc';
 | 
						|
c1	c2	c3
 | 
						|
cde	abc	cde
 | 
						|
drop table mcol3395;
 |