mirror of
				https://github.com/MariaDB/server.git
				synced 2025-11-03 20:36:16 +01:00 
			
		
		
		
	
		
			
				
	
	
		
			9 lines
		
	
	
	
		
			239 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			9 lines
		
	
	
	
		
			239 B
		
	
	
	
		
			Text
		
	
	
	
	
	
#
 | 
						|
# MDEV-454 Addition of a time interval reduces the resulting value
 | 
						|
#
 | 
						|
create table t1 (d date);
 | 
						|
insert into t1 values ('2012-00-00');
 | 
						|
select * from t1;
 | 
						|
update ignore t1 set d = adddate(d, interval 1 day);
 | 
						|
select * from t1;
 | 
						|
drop table t1;
 |