Closed ti-chi-bot closed 2 weeks ago
[APPROVALNOTIFIER] This PR is APPROVED
This pull-request has been approved by: Defined2014, tangenta
The full list of commands accepted by this bot can be found here.
The pull request process is described here
Timeline:
2024-04-30 07:44:16.343853313 +0000 UTC m=+343210.100988886
: :ballot_box_with_check: agreed by Defined2014.2024-04-30 07:52:12.684475919 +0000 UTC m=+343686.441611490
: :ballot_box_with_check: agreed by tangenta.
This is an automated cherry-pick of #52988
What problem does this PR solve?
Issue Number: close https://github.com/pingcap/tidb/issues/52972, close https://github.com/pingcap/tidb/issues/51320
Problem Summary: Case1:
Case2:
Now the TiDB behaviors:
@@sql_mode
isSTRICT_TRANS_TABLES
(Case1) the result isInvalid default value for 'b'
.@@sql_mode
is''
(Case2) the result is successful.Now the MySQL(MySQL 5.7.44 and 8.0.18 MySQL) behaviors:
Invalid default value for 'b'
.What changed and how does it work?
Check List
Tests
Side effects
Documentation
Release note
Please refer to Release Notes Language Style Guide to write a quality release note.