[GitHub] [doris] zhangy5 opened a new issue, #11429: [Bug] [daily]update set datetime column 10020-01-01, expect failed

[GitBox]

zhangy5 opened a new issue, #11429:
URL: https://github.com/apache/doris/issues/11429

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### Version
   
   master
   trunk-27a1911
   
   ### What's Wrong?
   
   [
   <img width="1440" alt="image" 
src="https://user-images.githubusercontent.com/10826066/182309557-f2a3f462-cdc1-42db-8e4e-692e7d97291a.png";>
   ](url)
   
   ### What You Expected?
   
   update failed
   
   ### How to Reproduce?
   
   CREATE DATABASE test_sys_update_basic_test_update_datetime_db;
   
   CREATE TABLE 
test_sys_update_basic_test_update_datetime_db.test_sys_update_basic_test_update_datetime_tb
 ( k1 DATETIME NOT NULL, v1 DATETIME NOT NULL, v2 DATETIME NOT NULL, v3 
DATETIME NOT NULL ) UNIQUE KEY(k1) DISTRIBUTED BY HASH(k1) BUCKETS 5;
   
   insert into test_sys_update_basic_test_update_datetime_tb values("2000-01-01 
00:00:00", "2000-01-02 01:00:00", "2000-01-03 00:00:00", "2000-01-04 00:00:01");
   
   insert into test_sys_update_basic_test_update_datetime_tb 
values("10020-01-01 00:00:00", "2000-01-01 00:00:00", "2000-01-01 00:00:00", 
"2000-01-01 00:00:00");
   
   UPDATE test_sys_update_basic_test_update_datetime_tb SET v1="10020-01-01 
00:00:00" WHERE k1="2000-01-01 00:00:00";
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org