Bug #41059 Left Join cause date format not recognized in where clause
Submitted: 26 Nov 2008 16:21 Modified: 3 Dec 2008 17:47
Reporter: Thomas Lee Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Compiling Severity:S2 (Serious)
Version:5.1.29 OS:Windows (XP ver 2002, SP2)
Assigned to: CPU Architecture:Any
Tags: Left Join Issue

[26 Nov 2008 16:21] Thomas Lee 
Description:
SELECT * from Logroll Where LogWorkDate=#11/26/2007#;    work ok.
But 
SELECT * FROM LogRoll LEFT JOIN ConsJC ON LogRoll.LogRollID=ConsJC.ConsRollId
WHERE LogRoll.LogWorkDate=#11/26/2007#;   failed with where line error

How to repeat:
Follow above example and put date format in field of table will do it.
[26 Nov 2008 21:42] MySQL Verification Team 
Thank you for the bug report. Could you please provide the create table and insert data commands and the queries output you get with mysql.exe client. Thanks in advance.
[3 Dec 2008 17:13] Thomas Lee 
I re-test it. ok. not a bug.
[3 Dec 2008 17:14] Thomas Lee 
Pls drop the case.