Hi! Thank you for a detailed bug report. This bug is already fixed in the source release 3.23.43b available from http://www.innodb.com
You can look at latest bug information at http://www.innodb.com/bugfixes.html Regards, Heikki >Description: > Using the following statement on empyt innobase tables crashes the MySQL-Server: > select MAX(col3) from crashTable where col1 = 1 and col2 =7; >How-To-Repeat: > CREATE TABLE IF NOT EXISTS crashTable ( > col1 SMALLINT UNSIGNED NOT NULL, col2 SMALLINT >UNSIGNED NOT NULL, > col3 INT UNSIGNED NOT NULL, col4 INT >UNSIGNED NOT NULL, > txtLen INT UNSIGNED, txt LONGBLOB, > UNIQUE crashKey(col1, col2, col3, col4) ) TYPE = InnoDB; > select MAX(col3) from crashTable where col1 = 1 and col2 = 7; > Note: this only crashes when the table type is innobase - the select > works fine with MyISAM. > Note2: partial query statements, i.e. "select MAX(col3) from crashTable" > and "select col3 from crashTable where col1 = 1 and col2 = 7" work fine. > Note3: the statement crashes the server only when the table is EMPTY.>Fix: > > Inserting a default record with any values prevents a crash and delivers > a correct result (provided that the default record does not contain values > that might be 'real' and thus read...) > INSERT INTO crashTable VALUES (0, 0, 0, 0, NULL, NULL);>Submitter-Id: Ove > >Originator: Ove >Organization: AdNovum Informatik AG > +---------------------------------------------------------------------+ > Ove Hiltwein mailto:[EMAIL PROTECTED] > Software Architect und Software Engineer dipl. Informatik-Ing. ETH > AdNovum Informatik AG http://www.adnovum.ch phone: ++41 1 272 6111 > Roentgenstrasse 22, CH-8005 Zuerich fax: ++41 1 272 6312 > +---------------------------------------------------------------------+ > AdNovum Software Inc. San Mateo, CA 94404 phone: ++1 650 525 9322 > 1400 Fashion Island Boulevard, Suite 309 fax: ++1 650 525 9324 > +------------------Fight for your right to bare arms------------------+> > >MySQL support: none > >Synopsis: "select MAX(col3) ..." statement on empty innobase table crashes MySQL >server >Severity: non-critical >Priority: low>Category: mysql>Class: sw-bug > >Release: mysql-3.23.43 (Source distribution)>Environment: >System: SunOS lucas 5.6 Generic_105181-26 sun4u sparc SUNW,Ultra-5_10 >Architecture: sun4 >Some paths: /bin/perl /home/ove/.bin/make /opt/pd/bin/gcc /opt/SUNWspro/bin/cc >GCC: Reading specs from /opt/pd/gcc-2.95.3/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs >gcc version 2.95.3 20010315 (release) >Compilation info: CC='/opt/pd/gcc-2.95.2/bin/gcc' CFLAGS='-O3' CXX='/opt/pd/gcc-2.95.2/bin/gcc' > CXXFLAGS='-O3-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''LIBC: >-rw-r--r-- 1 bin bin 1623504 May 25 04:55 /lib/libc.a >lrwxrwxrwx 1 root root 11 Jun 8 19:59 /lib/libc.so -> ./libc.so.1 >-rwxr-xr-x 1 bin bin 1024888 May 25 04:55 /lib/libc.so.1 >-rw-r--r-- 1 bin bin 1623504 May 25 04:55 /usr/lib/libc.a >lrwxrwxrwx 1 root root 11 Jun 8 19:59 /usr/lib/libc.so -> ./libc.so.1 >-rwxr-xr-x 1 bin bin 1024888 May 25 04:55 /usr/lib/libc.so.1 >Configure command: ./configure --prefix=/opt/mysql --localstatedir=$LOCALSTATEDIR >--with-innodb --without-debugPerl: This is perl, version 4.0 --------------------------------------------------------------------- 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
