Table created with out any error in MySQL 4.0.17-max-debug win mysql> create table foo (id int not null default -1); Query OK, 0 rows affected (0.22 sec)
mysql> explain foo; +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | id | int(11) | | | -1 | | +-------+---------+------+-----+---------+-------+ 1 row in set (0.11 sec) Then Why its become bug in 4.1.1., I don't know.... regards, Arun. --- Victoria Reznichenko <[EMAIL PROTECTED]> wrote: > Tedman Leung <[EMAIL PROTECTED]> wrote: > > I've been unable to find any information on this issue so I'm not quite > > sure if it's a bug or a new restriction. In either case I think it's a bug > > due to it's inconsistency with itself. > > > > create table foo (id int not null default -1) > > does not work > > > > create table foo (id int not null default '-1') > > does work. > > > > anyone have any information on this? > > It's a known bug: > http://bugs.mysql.com/bug.php?id=2075 > > > -- > 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 > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > ________________________________________________________________________ Yahoo! India Mobile: Download the latest polyphonic ringtones. Go to http://in.mobile.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]