MySQL Bugs: #24196: mysqldump.exe and function date

Bug #24196	mysqldump.exe and function date_add
Submitted:	10 Nov 2006 16:40	Modified:	11 Dec 2006 12:54
Reporter:	Ricardo Sander	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5+	OS:
Assigned to:		CPU Architecture:	Any

Description:
It would like to pass two errors for me verified in the use of the MySQL. I wait that they are interested in correcting.

1) 'Mysqldump.exe' is not saving the correct structure of field with auto increment, when used the parameter '--compatible=mysql323', '--compatible=mysql40'

Example with the parameter “--compatible=mysql323”:
  `id` int(10) unsigned NOT NULL,   <-- ?? auto_increment

2) In selects this command with quotations marks in the date does not function
    DATE_ADD(field_date, INTERVAL 5 DAY) <= '20061110')
    To function it must take off the quotations marks:
        DATE_ADD(field_date, INTERVAL 5 DAY) <= 20061110)

How to repeat:
to observe the description

Thank you for problems report. Please, specify exact MySQL server version, 5.0.x, try to repeat with the latest, 5.0.27, and in case of the same problems, provide a complete test case (complete CREATE TABLE for a table to dump in first case, and CREATE TABLE + sample data + complete query + results + expected results description, in second case).

Please, try to report one bug at a time also.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".