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 |
+---+-+--
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
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