diff options
| author | Sreeharsha Ramanavarapu <sreeharsha.ramanavarapu@oracle.com> | 2015-12-31 07:31:12 +0530 |
|---|---|---|
| committer | Sreeharsha Ramanavarapu <sreeharsha.ramanavarapu@oracle.com> | 2015-12-31 07:31:12 +0530 |
| commit | cb15cce746db6c32cb62c70bd356b2db61267fd9 (patch) | |
| tree | a2d122afa60bd1c2c7923edf7a540439e3cdb4a2 /extra | |
| parent | 1ec594dd60aa3b58e7d1c686016695b5b0bc1aa1 (diff) | |
| download | mariadb-git-cb15cce746db6c32cb62c70bd356b2db61267fd9.tar.gz | |
Bug #21564557: INCONSISTENT OUTPUT FROM 5.5 AND 5.6
UNIX_TIMESTAMP(STR_TO_DATE('201506', "%Y%M"
Issue:
-----
When an invalid date is supplied to the UNIX_TIMESTAMP
function from STR_TO_DATE, no check is performed before
converting it to a timestamp value.
SOLUTION:
---------
Add the check_date function and only if it succeeds,
proceed to the timestamp conversion.
No warning will be returned for dates having zero in
month/date, since partial dates are allowed. UNIX_TIMESTAMP
will return only a zero for such values.
The problem has been handled in 5.6+ with WL#946.
Diffstat (limited to 'extra')
0 files changed, 0 insertions, 0 deletions