Heikki, does this bug affect all versions or just the -max windows versions... we just installed 4.0.3-beta (unix-freebsd) to do some benchmarking/testing tonite on innodb and this would impact us. Thx.
>Rafa, > >----- Original Message ----- >From: <[EMAIL PROTECTED]> >Newsgroups: mailing.database.mysql >Sent: Tuesday, September 10, 2002 1:46 PM >Subject: MySql/InnoDB crashes after a Select...order by DESC... LIMIT... > > >> Hello, >> >> I am working with mysqld-max-nt under windows 2000 and unsing InnoDb >tables. >> >> After running the following select: >> >> Select cod,nom from grupos where cod <'005' order by cod desc limit 1 >> >> mysqld crashes. >> >> Also it crashes whith limit 10, limit 50, or whatever limit you >indicate. >> >> However, the following selects run ok: >> Select cod,nom from grupos where cod <'005' order by cod desc (without >limit) >> Select * from grupos where cod <’D01’ order by cod desc limit 1 >> Select * from grupos where strcmp(cod,’005')<0 order by cod desc >limit 1 >> Select * from grupos where cod < 005 order by cod desc limit 1 >> Select * from grupos where cod <5 order by cod desc limit 1 >> >> This error only occurs with InnoDb tables and MySql 4.0.3 (with Mysql >3.23.52 it runs ok). >> With MyIsam tables it runs ok even under mysql 4.0.3 >> >> I enclose the file grupos.sql with the table definition and data. > >thank you for a very detailed bug report. > >The bug, assertion failure in btr0pcur.ic, happened because InnoDB did not >store the cursor position in this case. The cursor needs to move downward in >the alphabetical order. > >I have now pushed the fix to the 4.0 source tree. > >> Thanks in advance, >> Rafa. >> >> P.D: Sorry for my english. > >Best regards, > >Heikki >Innobase Oy > >sql query > > > >--------------------------------------------------------------------- >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