Bug #5084 Date format like #0000-00-00# or #0000-00-00 00:00:00# not longer supportet
Submitted: 18 Aug 2004 9:53 Modified: 18 Aug 2004 21:04
Reporter: Thomas Greiner Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.3b-beta OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[18 Aug 2004 9:53] Thomas Greiner 
Description:
This version of MySQL does not longer support queries with the input format such as 

INSERT INTO myTable (`mydate`,`mydatetime` ) VALUES( '#2004-08-18#', '#2004-08-18 09:50:00#' );

Instead of inserting the correct date like all prior versions did, MySQL 4.1.3b-beta inserts just zero-dates "0000-00-00" etc.

How to repeat:
Try to fire an INSERT or UPDATE query with a structure similar to the following SQL command:

INSERT INTO myTable (`mydate`,`mydatetime` ) VALUES( '#2004-08-18#', '#2004-08-18 09:50:00#' );

Suggested fix:
Change SQL parsing algorithm to cover the date format mentioned above as prior versions did.
[18 Aug 2004 21:04] MySQL Verification Team 
Yes, you have observed correctly.

Behaviour is changed and is documented in Changelog.

You should get a warning now, with SHOW WARNINGs.