Bug #19072 Server aborts (crashes) on a prepared join

• Submitted: 13 Apr 2006 7:37
• Modified: 18 Apr 2006 7:51
• Reporter: David Walker
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: mysql-max-5.0.20
• OS: Linux (Linux Redhat 7.2,Windows)
• CPU Architecture: Any

[13 Apr 2006 7:37] David Walker

Description:
On certain prepared queries that use a combination of right join and inner join, the server crashes. (Actually, it aborts (signal 6) as opposed to seg faulting.) It seems similar to bug #14026, but that was fixed a while ago. The table type doesn't affect the problem.

Note: It only dies on the 2nd execution of the statement.

How to repeat:
use test;
drop table if exists CRASH_TEST;
create table CRASH_TEST (col int not null);

prepare test from 'select 1 from CRASH_TEST t1 right join CRASH_TEST t2 on 1 right join CRASH_TEST t3 on t2.col=t3.col join CRASH_TEST on 1';
execute test;
execute test;

[13 Apr 2006 8:21] MySQL Verification Team

Crashed 5.0.20-nt with:
runtime error R6025
- pure virtual function call

Will post more information shortly, after testing against latest source on Linux.

[13 Apr 2006 9:50] MySQL Verification Team

crashes on 5.0.20.

Attachment: stack_5.0.20-linux-windows.txt (plain/text, text), 5.77 KiB.

[13 Apr 2006 10:41] MySQL Verification Team

I haven't managed to crash today's bk source of 5.0 on Linux, built using ./BUILD/compile-pentium-debug-max-no-ndb

[18 Apr 2006 7:31] MySQL Verification Team

I can't repeat this crash using a recent snapshot of the source. 5.0.21 doesn't crash on windows or linux.  Trying to find out when this might have been fixed.

[18 Apr 2006 7:51] David Walker

Well, it's good that it got fixed, I guess. I'll upgrade to 5.0.21 when it's released.