Bug #53434 MySQL 5.5 not selecting date with "relaxed" syntax

• Submitted: 5 May 2010 12:42
• Modified: 5 May 2010 13:49
• Reporter: Tomas Randa
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.5.4
• OS: FreeBSD (8.0 AMD64)
• CPU Architecture: Any
• Tags: date select relaxed syntax

[5 May 2010 12:42] Tomas Randa

Description:
MySQL 5.5.4 returns zero rows when selecting date with "/" delimiter. For example:

select * from XXX where date > '2010/01/01';

this works OK on MySQL 5.0

How to repeat:
select * from XXX where date > '2010/01/01';

[5 May 2010 13:25] MySQL Verification Team

See bug: http://bugs.mysql.com/bug.php?id=53433.

[5 May 2010 13:28] MySQL Verification Team

Looks like duplicate of bug prior commented. Do you agree?

C:\DBS>c:\dbs\5.5\bin\mysql -uroot --port=3540 --prompt="mysql 5.5 >"
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.99-m4-Win X64 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 5.5 >use test
Database changed
mysql 5.5 >select * from foo where col = '2010/05/05';
Empty set (0.00 sec)

mysql 5.5 >exit
Bye

C:\DBS>51

C:\DBS>c:\dbs\5.1\bin\mysql -uroot --port=3306 --prompt="mysql 5.1 >"
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.46-Win X64-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 5.1 >use test
Database changed
mysql 5.1 >select * from foo where col = '2010/05/05';
+------------+
| col        |
+------------+
| 2010-05-05 |
+------------+
1 row in set (0.00 sec)

mysql 5.1 >

[5 May 2010 13:47] Tomas Randa

Yes, It look as a same error, but I did not found this ticker first.

Thanks.

[5 May 2010 13:49] Tomas Randa

http://bugs.mysql.com/bug.php?id=53433

[5 May 2010 13:49] MySQL Verification Team

Thank you for the feedback. Duplicate of bug: http://bugs.mysql.com/bug.php?id=53433.