On Friday 22 June 2001 08:47, Ken Menzel wrote:
> 1) I can upload the table, but be aware it is created from the mysql
> sql_bench directory. You can run the program ./sql_bench/test-insert,
> however I am aware the table generated on FreeBSD may be different.
> 2) How do you want me to send the table? IE mysqldump it? or do you
> want the directory tared, zipped and sent?
> 3) I will e-mail you privately in a moment.
> 4) I will be out the rest of the weekend /day (I am a ham radio
> operator and this weekend we have a national ham radio event called
> 'field day'. )
I have tested it on two systems - mine and yours. On yours, it coredumps. On
mine (Linux), it just gives an empty result set, which is wrong. I have been
able to narrow down the problem a bit - the bug happens when you order by on
a key while selecting something outside of that key, order by is solved with
filesort, and filesort overflows the sort buffer.
I will write a test case for it, commit it to the repository and Monty or
Sergei will fix it - that's their code.
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <sasha@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA