Bug #27014 Imperfect error/warning message for STR_TO_DATE for invalid datetime value

Description:
When STR_TO_DATE is offered an argument value that cannot be parsed using the argument formatstring, a warning (or error depending on the sql_mode) is returned. However, the message refers to the function "str_to_time". That is incorrect and should be str_to_date.

How to repeat:
(%k is invalid in comination with %p and provokes the error)

select str_to_date(date_format(now(),'%b %e, %Y %k:%i%p'),'%b %e, %Y %k:%i%p');
+-------------------------------------------------------------------------+
| str_to_date(date_format(now(),'%b %e, %Y %k:%i%p'),'%b %e, %Y %k:%i%p') |
+-------------------------------------------------------------------------+
| NULL                                                                    |
+-------------------------------------------------------------------------+
1 row in set, 1 warning (0.00 sec)

Error (Code 1411): Incorrect datetime value: 'Mar 9, 2007 21:49PM' for function str_to_time

Suggested fix:
Please make the message read "str_to_date" instead of "str_to_time"

Thank you for a bug report. Verified just as described. 5.0.27 returns the same error message.

Suggested fix: extend extract_datetime with another parameter, "const char *function_name"

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/33504

ChangeSet@1.2595, 2007-08-30 23:57:39-06:00, tsmith@ramayana.hindu.god +1 -0
  Bug #27014: Imperfect error/warning message for STR_TO_DATE for invalid datetime value
  
  Fix name of function in warning message.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/33508

ChangeSet@1.2596, 2007-08-31 01:28:42-06:00, tsmith@ramayana.hindu.god +1 -0
  Fix test results for bug #27014

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/33523

ChangeSet@1.2597, 2007-08-31 05:21:12-06:00, tsmith@ramayana.hindu.god +1 -0
  Correct test result file for bug #27014

Pushed into 5.1.23-beta

Noted in 5.1.23 changelog.

STR_TO_DATE() displayed an error message that referred to
STR_TO_TIME().