Skip to content

expression: fix compatibility behaviors in zero datetime with MySQL#21220

Merged
lzmhhh123 merged 14 commits intopingcap:masterfrom
lzmhhh123:bug-fix/fix_zero_datetime
Dec 7, 2020
Merged

expression: fix compatibility behaviors in zero datetime with MySQL#21220
lzmhhh123 merged 14 commits intopingcap:masterfrom
lzmhhh123:bug-fix/fix_zero_datetime

Conversation

@lzmhhh123
Copy link
Contributor

What problem does this PR solve?

Issue Number: close #9728

What is changed and how it works?

How it Works:

Related changes

  • Need to cherry-pick to the release branch

Check List

Tests

  • Unit test
  • Integration test

Side effects

  • Performance regression
    • Consumes more CPU

Release note

  • fix compatibility behaviors in zero datetime with MySQL.

@lzmhhh123 lzmhhh123 requested a review from a team as a code owner November 23, 2020 09:40
@lzmhhh123 lzmhhh123 requested review from wshwsh12 and removed request for a team November 23, 2020 09:40
@lzmhhh123
Copy link
Contributor Author

/cc @qw4990

@ti-srebot ti-srebot requested a review from qw4990 November 23, 2020 09:40
@lzmhhh123
Copy link
Contributor Author

/cc @ichn-hu

@lzmhhh123
Copy link
Contributor Author

/run-all-tests

@lzmhhh123
Copy link
Contributor Author

/run-all-tests

@lzmhhh123
Copy link
Contributor Author

/run-unit-test

ichn-hu
ichn-hu previously approved these changes Dec 1, 2020
Copy link
Contributor

@ichn-hu ichn-hu left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

@ti-srebot ti-srebot added the status/LGT1 Indicates that a PR has LGTM 1. label Dec 1, 2020
Copy link
Contributor

@wshwsh12 wshwsh12 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I think vectorized code should also be modified.

@lzmhhh123 lzmhhh123 linked an issue Dec 4, 2020 that may be closed by this pull request
Signed-off-by: lzmhhh123 <lzmhhh123@gmail.com>
Signed-off-by: lzmhhh123 <lzmhhh123@gmail.com>
Signed-off-by: lzmhhh123 <lzmhhh123@gmail.com>
Signed-off-by: lzmhhh123 <lzmhhh123@gmail.com>
Signed-off-by: lzmhhh123 <lzmhhh123@gmail.com>
Copy link
Contributor

@wshwsh12 wshwsh12 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

(b *builtinExtractDatetimeSig) vecEvalInt should also be modified.

@lzmhhh123
Copy link
Contributor Author

builtinExtractDatetimeSig

No, builtinExtractDatetimeSig has another implementation. And it's right.

Signed-off-by: lzmhhh123 <lzmhhh123@gmail.com>
@wshwsh12
Copy link
Contributor

wshwsh12 commented Dec 7, 2020

lgtm

@ti-srebot ti-srebot removed the status/LGT1 Indicates that a PR has LGTM 1. label Dec 7, 2020
@ghost
Copy link

ghost commented Dec 7, 2020

There is no reward for this challenge pull request, so you can request a reward from @SunRunAway.

Details

Tip : About reward you can refs to reward-command.

Warning: None

@ti-srebot ti-srebot added the status/LGT2 Indicates that a PR has LGTM 2. label Dec 7, 2020
@lzmhhh123
Copy link
Contributor Author

/merge

@ti-srebot ti-srebot added the status/can-merge Indicates a PR has been approved by a committer. label Dec 7, 2020
@ti-srebot
Copy link
Contributor

/run-all-tests

@ti-srebot
Copy link
Contributor

@lzmhhh123 merge failed.

@lzmhhh123 lzmhhh123 merged commit 0deb0a3 into pingcap:master Dec 7, 2020
@lzmhhh123 lzmhhh123 deleted the bug-fix/fix_zero_datetime branch December 7, 2020 06:13
ti-srebot pushed a commit to ti-srebot/tidb that referenced this pull request Dec 7, 2020
Signed-off-by: ti-srebot <ti-srebot@pingcap.com>
@ti-srebot
Copy link
Contributor

cherry pick to release-3.0 in PR #21524

ti-srebot pushed a commit to ti-srebot/tidb that referenced this pull request Dec 7, 2020
Signed-off-by: ti-srebot <ti-srebot@pingcap.com>
@ti-srebot
Copy link
Contributor

cherry pick to release-4.0 in PR #21525

ti-srebot added a commit that referenced this pull request Jan 26, 2021
…21220) (#21525)

Signed-off-by: ti-srebot <ti-srebot@pingcap.com>
Signed-off-by: lzmhhh123 <lzmhhh123@gmail.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

component/expression sig/execution SIG execution status/can-merge Indicates a PR has been approved by a committer. status/LGT2 Indicates that a PR has LGTM 2. type/bugfix This PR fixes a bug.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Function DAY/DAYOFMONTH should do type conversation dayofmonth month quarter and year are not compatible with Mysql

4 participants