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
