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
[[email protected]](mailto:[email protected]) 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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
