On Wed, Dec 12, 2001 at 02:35:15PM +0200, Sinisa Milivojevic wrote: : Philip Molter writes: : > >Description: : > : > When I do this: : > : > mysql>create table test_default ( testint int not null default 1 ); : > mysql>desc test_default; : > : > I get: : > : > +---------+---------+------+-----+----------+-------+ : > | Field | Type | Null | Key | Default | Extra | : > +---------+---------+------+-----+----------+-------+ : > | testint | int(11) | | | 16777216 | | : > +---------+---------+------+-----+----------+-------+ : > 1 row in set (0.00 sec) : > : > Why does my default not go in as '1'. I've tried it with and : > without quotes. This is vexing. Is there something obvious that : > I'm just not doing correctly? : > : > >How-To-Repeat: : > : : Hi! : : As there is a binary for your SPARC Solaris 2.8, please try it out : and see if you get the same result.
Yeah, let me amend this. It's not happening with MyISAM tables, only with InnoDB tables, and it is happening with the pre-compiled binaries from the web site. It's definitely an endian issue. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] --------------------------------------------------------------------- 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