[MDEV-5847] MySQL Bug#13596893 - "ERROR 1690 (22003): BIGINT UNSIGNED VALUE IS OUT OF RANGE" ON DATE OPERATION Created: 2014-03-13  Updated: 2023-11-28

Status: Confirmed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.9, 10.3.5
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Major
Reporter: Sergey Vojtovich Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: patch, tests, upstream-fixed

Attachments: Text File bug13596893.patch    
Issue Links:
PartOf
is part of MDEV-4784 merge test cases from 5.6 Stalled
Relates
relates to MDEV-14910 Unexpected "BIGINT UNSIGNED value is ... Open

 Description   

Test case for MySQL "MySQL Bug#13596893 - "ERROR 1690 (22003): BIGINT UNSIGNED VALUE IS OUT OF RANGE" ON DATE OPERATION" fails in 10.0.

Test diff attached. Please try to apply test case as is unless it is applicable.

 Comments   
Comment by Daniel Black [ 2018-01-19 ]

10.3 branch at 745e6498eadc79bcaf08e822e47a83a0f1d74385 fails this test case too

CURRENT_TEST: main.type_timestamp
 
mysqltest: At line 470: query 'SELECT c2-c1 FROM t1' failed: 1690: BIGINT UNSIGNED value is out of range in '`test`.`t1`.`c2` - `test`.`t1`.`c1`

MySQL commit 199dc8eada49bc97ba9e18bc0f0a26a7062ebdce

Generated at Thu Feb 08 07:07:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.