Bug #22854 MySQL 4.1.21 does not recognize several date_format specifiers

• Submitted: 30 Sep 2006 2:10
• Modified: 30 Sep 2006 12:30
• Reporter: Serge Danilov
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1.21
• OS: Linux (Linux)
• CPU Architecture: Any
• Tags: 4.1.21, date_format

[30 Sep 2006 2:10] Serge Danilov

Description:
MySQL 4.1.21 returns a confusing error message ("Communications links failure...") when executing an SQL that contains several of the documented date_format format specifiers. The unrecognized specifiers are (at least):
%a, %b, %M, %W

How to repeat:
Execute:
select date_format(now(), '%a, %b %e %Y') time_now

[30 Sep 2006 12:30] Valeriy Kravchuk

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. Look:

openxs@suse:~/dbs/4.1> bin/mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select date_format(now(), '%a, %b %e %Y') time_now;
+------------------+
| time_now         |
+------------------+
| Sat, Sep 30 2006 |
+------------------+
1 row in set (0.01 sec)

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html