Bug #20659 Default value provided for datetime column gets prepended and appended with \a

• Submitted: 23 Jun 2006 13:12
• Modified: 25 Jul 2006 15:07
• Reporter: Geoffrey Hoffman
• Status: No Feedback
• Category: MySQL Workbench Preview
• Severity: S2 (Serious)
• Version: 1.0.6 Beta
• OS: Windows (Windows XP)
• Assigned to: Assigned Account
• CPU Architecture: Any

[23 Jun 2006 13:12] Geoffrey Hoffman

Description:
Upon attempting to enter a default date for a column specified as datetime, i.e. '2006-06-23 06:09:53', the program turns the single quotes into \a creating a default value of \a2006-06-23 06:09:53\a

I tried also providing a datetime value without the single quotes, but the \a's re-appeared upon applying changes.

How to repeat:
Create a datetime column and then try to provide a default value.
You may have to save the model file and re-open to see the \a appear.

Suggested fix:
Allow the user to enter numbers or strings for the default value in columns of any datatype with or without explicitly using single quotes and then program the saving and exporting features to apply the correct formatting on export.

[25 Jun 2006 15:07] MySQL Verification Team

Thank you for the bug report. Could you please provide a small project file
which shows the behavior reported (I was unable to repeat on my side).
Thanks in advance.

[25 Jul 2006 23:00] Bugs System

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".