Bug #7934 Wrong SQL when editing a field with default values
Submitted: 15 Jan 2005 21:28 Modified: 25 Aug 2005 10:25
Reporter: Steen Rabol Email Updates:
Status: Closed Impact on me:
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.5 OS:Windows (Windows XP SP2)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[15 Jan 2005 21:28] Steen Rabol
If you rename a text/char/varchar field on a table with a default value, then QB generates wrong SQL (Missing quotes)

ALTER TABLE `test`.`test` CHANGE COLUMN `textfield` `newname` VARCHAR(45) NOT NULL DEFAULT test;

As you can see, quotes is missing around the default value.

How to repeat:
Create a table with at text field and a default value
Rename the field.
[25 Aug 2005 10:25] Vladimir Kolesnikov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at