David, Tuesday, June 11, 2002, 3:28:52 PM, you wrote: DH> I have encountered a strange problem with the enum type in version DH> 3.23.49. It may be a bug, but I'd be grateful to hear comments.
DH> Here's a short example which illustrates the problem. First, I create DH> a table with an enum column whose allowed elements are single letters, DH> including a single space: DH> CREATE TABLE cats ( DH> name VARCHAR(12) NOT NULL, DH> gender ENUM(' ', 'F', 'M') NOT NULL, DH> PRIMARY KEY(name) DH> ); [skip] DH> Notice that the table definition statement now explicitly states that DH> the default value for the "gender" column is ' '. I didn't specify DH> this explicitly when I defined the table originally. DH> Now, when I try to read the backup file back into MySQL, I get this DH> error: DH> ERROR 1067 at line 12: Invalid default value for 'gender' DH> But *why* should this happen? MySQL seems to be happy enough to DH> let me include a single space as an element of the enumeration, DH> but it won't let me specify it explicitly as the default value. DH> This behaviour can be replicated at will in versions 3.23.38 and DH> 3.23.49 of MySQL, running on both Compaq Alpha OSF5.1 and Red DH> Hat Linux 7.2 for i386. It was a bug that was fixed. In 4.0.2 and 3.23.51. ' ' is a valid value, too. DH> Thanks in advance DH> David Harper -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php