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 
			
		
		
		
	
		
			
				
	
	
		
			30 lines
		
	
	
		
			688 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
			
		
		
	
	
			30 lines
		
	
	
		
			688 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
| # -------------------------------------------------------------- #
 | |
| # Test case migrated from regression test suite: bug3021.sql
 | |
| #
 | |
| # Author: Daniel Lee, daniel.lee@mariadb.com
 | |
| # -------------------------------------------------------------- #
 | |
| #
 | |
| --source ../include/have_columnstore.inc
 | |
| #
 | |
| USE tpch1;
 | |
| #
 | |
| select date('2010-02-01') into @xxx;
 | |
| select @xxx;
 | |
| 
 | |
| --disable_warnings
 | |
| drop table if exists bug3021;
 | |
| --enable_warnings
 | |
| 
 | |
| create table bug3021(c1 date)engine=columnstore;
 | |
| insert into bug3021 values ('2001-01-01');
 | |
| update bug3021 set c1=@xxx;
 | |
| select * from bug3021;
 | |
| update bug3021 set c1=date('2010-11-14');
 | |
| select * from bug3021;
 | |
| 
 | |
| --disable_warnings
 | |
| drop table bug3021;
 | |
| --enable_warnings
 | |
| #
 | |
| 
 |