[GitHub] [doris] jacktengg opened a new pull request, #20378: [fix](load) in strict mode, return error for load and insert if datatype convert fails

[via GitHub]

jacktengg opened a new pull request, #20378:
URL: https://github.com/apache/doris/pull/20378

   When in strict mode, for int column,  doris insert succeed even the number 
is out of range, but MySQL report error ``` Out of range value for column 
'timea' at row 3 ```.
   This PR fix this problem.
   
   ```
   CREATE TABLE `test3` (
       `timea` varchar(30) NULL,
       `creatr` varchar(30) NULL
   ) UNIQUE KEY(`timea`) DISTRIBUTED BY HASH(`timea`) BUCKETS 1 PROPERTIES 
("replication_num" = "1");
   
   insert into
       test3
   values
       ("12345678908876643", "a"),
       ("1234567890887664643", "b"),
       ("123456789088766445456", "c");
   
   CREATE TABLE `test4` (`timea` bigint NULL, `creatr` varchar(30) NULL) UNIQUE 
KEY(`timea`) DISTRIBUTED BY HASH(`timea`) BUCKETS 1 PROPERTIES 
("replication_num" = "1");
   
   insert into
       test4
   select
       *
   from
       test3;
   Query OK, 3 rows affected (0.03 sec)
   {'label':'insert_e2c0704a13e241b1_a8a988649a65c64b', 'status':'VISIBLE', 
'txnId':'23500'}
   ```
   
   Revert "[fix](MySQL) the way Doris handles boolean type is consistent with 
MySQL (#19416)"
   
   This reverts commit 68eb420cabe5b26b09d6d4a2724ae12699bdee87.
   
   Since it changed other behaviours, e.g. in strict mode insert into t_int 
values ("a"), it will result 0 is inserted into table, but it should return 
error instead.
   
   ## Proposed changes
   
   Issue Number: close #xxx
   
   <--Describe your changes.-->
   
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at 
[d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you 
chose the solution you did and what alternatives you considered, etc...
   
   


-- 
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

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