Obvious stupid question: What happens when you specify the value as 16777216? Since you are running on a SPARC, I'm sure you will end up with the correct value (1) in the space. If that works, there is definitely an endism problem.
Dave Philip Molter wrote: > >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: > > See above > > >Fix: > > Don't know. I'm looking for verification that the problem exists. > > >Submitter-Id: <submitter ID> > >Originator: Philip Molter > >Organization: Texas.Net > >MySQL support: none > >Synopsis: Default 1 == Default 16777216 > >Severity: serious > >Priority: medium > >Category: mysql > >Class: sw-bug > >Release: mysql-3.23.46 (Source distribution) > > >Environment: > System: SunOS 5.8 Generic_108528-12 sun4u sparc SUNW,Ultra-80 > Architecture: sun4 > > Some paths: /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc /usr/ucb/cc > GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs > gcc version 2.95.3 20010315 (release) > Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' > > This build was compiled with the specs used on MySQL's web site for > Solaris (SunOS, actually) builds. > > LIBC: > -rw-r--r-- 1 root bin 1763908 Nov 16 16:42 /lib/libc.a > lrwxrwxrwx 1 root root 11 Nov 20 13:29 /lib/libc.so -> ./libc.so.1 > -rwxr-xr-x 1 root bin 1136748 Nov 16 16:42 /lib/libc.so.1 > -rw-r--r-- 1 root bin 1763908 Nov 16 16:42 /usr/lib/libc.a > lrwxrwxrwx 1 root root 11 Nov 20 13:29 /usr/lib/libc.so -> ./libc.so.1 > -rwxr-xr-x 1 root bin 1136748 Nov 16 16:42 /usr/lib/libc.so.1 > > Configure command: ./configure --prefix=/usr/local/mysql-3.23.46 --with-low-memory >--enable-assembler --enable-assembler --with-innodb > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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