>Description: After fixing a table with myisamcheck on Linux, the auto_increment on Solaris was completely off (very large 9-digit integer instead of around 50,000). My suspicion is that this has to do with an endianness issue.
(I had to use Linux since the Solaris version of myisamcheck just hangs.) >How-To-Repeat: Check table containing AUTO_INCREMENT on Linux, then use Solaris. >Fix: No fix know, except use SET INSERT_ID afterwards to fix. >Submitter-Id: <submitter ID> >Originator: Henning Schulzrinne >Organization: Dept. of Computer Science, Columbia University >MySQL support: [none | licence | email support | extended email support ] >Synopsis: AUTO_INCREMENT wrong >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.54 (Official MySQL binary) >Environment: System: SunOS signal.cs.columbia.edu 5.8 Generic_108528-17 sun4u sparc SUNW,UltraAX-i2 Architecture: sun4 Some paths: /usr/bin/perl /usr/local/gnu/bin/make /usr/local/gnu/bin/gmake /usr/local/gnu/bin/gcc /import/pkg/SUNWspro/bin//cc GCC: Reading specs from /usr/local/gnu/bin/../lib/gcc-lib/sparc-sun-solaris2.8/3.2.1/specs Configured with: /src/unpack/gnu/gcc-3.2.1/configure --prefix=/opt/CUCSgnu --with-gnu-as --with-as=/opt/CUCSgnu/bin/as --with-gnu-ld --with-ld=/opt/CUCSgnu/bin/ld --enable-languages=c,c++,f77,objc Thread model: posix gcc version 3.2.1 Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1788196 Sep 21 00:52 /lib/libc.a lrwxrwxrwx 1 root root 11 Jan 29 03:49 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 root bin 1157872 Sep 21 00:52 /lib/libc.so.1 -rw-r--r-- 1 root bin 1788196 Sep 21 00:52 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jan 29 03:49 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 root bin 1157872 Sep 21 00:52 /usr/lib/libc.so.1 Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official MySQL binary' '--with-extra-charsets=complex' '--with-server-suffix=' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--with-named-z-libs=no' '--with-named-curses-libs=-lcurses' '--disable-shared' '--without-innodb' 'CC=gcc' 'CFLAGS=-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' 'CXX=gcc' --------------------------------------------------------------------- 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