Bug #5916 String values for "default" in Edit Table without quotes
Submitted: 6 Oct 2004 9:00 Modified: 3 Dec 2004 17:14
Reporter: Stefan Stammler Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.0.8 beta OS:Windows (WinNT 4)
Assigned to: Assigned Account CPU Architecture:Any

[6 Oct 2004 9:00] Stefan Stammler
Description:
In the "Edit Table" dialog, setting the default value of a column to a string value  (for string or enum column types), the query on "Apply Changes" will fail because of missing single quotes around the string value.

How to repeat:
Edit a table which has a string default value. The default value will appear without single quotes. If without any changes to the default value, the query on "Apply Changes" will fail.
[6 Oct 2004 10:42] Péter Török
Still exists in v1.0.13.  Quite anoying... I suggest to raise the severity.
[3 Nov 2004 17:14] Michael G. Zinner
The problem with adding ' automatically is, that you cannot specify NULL or you also may want to have no ' for numbers.

We could make an option to add '' automatically and place the cursor in between the ' when you edit the field and it is empty.

Would that solve your issue?
[14 Feb 2005 22:54] 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".