Hi!
> Some rather major problems with editing tables with ENUMs in them:
>
> 1. Spaces
>
> DROP TABLE IF EXISTS buggy;
> CREATE TABLE buggy (col1 ENUM('foo',' bar'));
>
> Now open the Edit Table window for this table; you'll see
> that MyCC doesn't parse this well at all... Some text ends up
> hanging out in the "Default" text box even.
>
> I imagine this would also occur with a DEFAULT in a DATETIME
> column (0000-00-00 00:00:00), but I haven't tested this.
Thanks, I just fixed this !
> 2. Double quotes
>
> With the same Edit Table box as above, delete the "Default"
> and put the list "foo","bar" in the "Value" box. Commit your
> changes and observe what happens. MyCC adds quotes
> automatically, making the list '"foo"', '"bar"'.
>
I also fixed this !
Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/?ref=mjdc
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Jorge del Conde <jorge@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql.com
