Details
- 
    
Bug
 - 
    Status: Closed (View Workflow)
 - 
    
Minor
 - 
    Resolution: Duplicate
 - 
    10.0.3, 5.5.32, 5.3.12
 - 
    None
 - 
    None
 
Description
There is some inconsistency between
MAKETIME(0,0, negative_integer_number) and
MAKETIME(0,0, negative_decimal_number)
					SELECT MAKETIME(0,0,-1), MAKETIME(0, 0, -0.1);
			 | 
		
					+------------------+----------------------+
			 | 
		
					| MAKETIME(0,0,-1) | MAKETIME(0, 0, -0.1) |
			 | 
		
					+------------------+----------------------+
			 | 
		
					| NULL             | 00:00:00             |
			 | 
		
					+------------------+----------------------+
			 | 
		
The expression with the negative decimal number should also return NULL.
MySQL-5.5 exhibits the same behaviour.
MySQL-5.6 returns NULL for both expressions.