Re: mysql 4.1.1 negative default column values doesn't work

2004-02-06 Thread Arunachalam
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 | +---+-+--

Re: mysql 4.1.1 negative default column values doesn't work

2004-02-06 Thread Victoria Reznichenko
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

mysql 4.1.1 negative default column values doesn't work

2004-02-05 Thread Tedman Leung
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 nul