List:GUI Tools« Previous MessageNext Message »
From:Jorge del Conde Date:June 11 2002 3:27am
Subject:RE: ENUMs in Edit Table window
View as plain text  
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


Thread
ENUMs in Edit Table windowAdam Hooper11 Jun
  • RE: ENUMs in Edit Table windowJorge del Conde11 Jun