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? -- Being normal is vastly over rated : Ted Leung -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]