search

you06 / cherry-pick-playground

0 stars 4 forks source link

A long description about add hotfix31 (#69) #71

Closed you06-pingcap closed 4 years ago

you06-pingcap commented 5 years ago

cherry-pick #69 to release-1.0

What problem does this PR solve?

Fixes https://github.com/pingcap/tidb/issues/11319

What is changed and how it works?

The results of this PR like MySQL 5.7 has same result.

SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL -2.2 MINUTE_MICROSECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL -2.2 SECOND_MICROSECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL -2.2 HOUR_MICROSECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL -2.2 DAY_MICROSECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL -2.2 SECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL -2.2 HOUR_SECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL -2.2 DAY_SECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL -2.2 MINUTE_SECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL -2.2 MINUTE);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL -2.2 DAY_MINUTE);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL -2.2 HOUR_MINUTE);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL -2.2 DAY_HOUR);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL -2.2 YEAR_MONTH);

SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL 2.2 MINUTE_MICROSECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL 2.2 SECOND_MICROSECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL 2.2 HOUR_MICROSECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL 2.2 DAY_MICROSECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL 2.2 SECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL 2.2 HOUR_SECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL 2.2 DAY_SECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL 2.2 MINUTE_SECOND);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL 2.2 MINUTE);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL 2.2 DAY_MINUTE);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL 2.2 HOUR_MINUTE);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL 2.2 DAY_HOUR);
SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL 2.2 YEAR_MONTH);
sre-bot commented 5 years ago

Hi contributor, thanks for your PR.

This patch needs to be approved by someone of admins. They should reply with "/ok-to-test" to accept this PR for running test automatically.

you06 commented 5 years ago

/merge

you06-pingcap commented 5 years ago

/run-all-tests

you06-pingcap commented 5 years ago

/merge

you06-pingcap commented 5 years ago

/run-all-tests

you06 commented 5 years ago

/merge

you06-pingcap commented 5 years ago

Sorry @you06, you don't have permission to trigger auto merge event on this branch.

you06 commented 5 years ago

/run-auto-merge

you06 commented 5 years ago

/run-auto-merge

you06-pingcap commented 5 years ago

Sorry @you06, you don't have permission to trigger auto merge event on this branch.

you06-pingcap commented 5 years ago

PTAL.

you06-pingcap commented 5 years ago

PTAL.

you06-pingcap commented 5 years ago

@you06, PTAL.

you06-pingcap commented 5 years ago

@you06, PTAL.

you06 commented 5 years ago

/merge

you06 commented 5 years ago

/run-auto-merge

you06 commented 5 years ago

/merge

you06 commented 5 years ago

Your auto merge job has been accepted, waiting for #54, #67, #67, #68, #68

you06 commented 5 years ago

Your auto merge job has been accepted, waiting for #54, #67, #67, #68, #68

you06 commented 5 years ago

@you06, PTAL.

you06 commented 5 years ago

/ok-to-test

you06 commented 5 years ago

@you06, PTAL.

you06 commented 5 years ago

@you06, PTAL.