You've already forked mariadb-columnstore-engine
							
							
				mirror of
				https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
				synced 2025-10-31 18:30:33 +03:00 
			
		
		
		
	
		
			
				
	
	
		
			26 lines
		
	
	
		
			629 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
			
		
		
	
	
			26 lines
		
	
	
		
			629 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
| # -------------------------------------------------------------- #
 | |
| # Test case migrated from regression test suite: bug5448.sql
 | |
| #
 | |
| # Author: Daniel Lee, daniel.lee@mariadb.com
 | |
| # -------------------------------------------------------------- #
 | |
| #
 | |
| --source ../include/have_columnstore.inc
 | |
| #
 | |
| USE tpch1;
 | |
| #
 | |
| --disable_warnings
 | |
| drop table if exists bug5448;
 | |
| 
 | |
| create table bug5448 (mst_date datetime) engine=columnstore; 
 | |
| 
 | |
| insert into bug5448 values ('2013-03-01');
 | |
| insert into bug5448 values ('2012-03-01');
 | |
| 
 | |
| select mst_date, date_add(date(mst_date), interval - 30 day) from bug5448;
 | |
| 
 | |
| --disable_warnings
 | |
| drop table if exists bug5448;
 | |
| 
 | |
| #
 | |
| 
 |