MySQL Bugs: #35803: subselect_notembedded crashes the server

Bug #35803	subselect_notembedded crashes the server
Submitted:	3 Apr 2008 14:36	Modified:	9 May 2008 18:03
Reporter:	Alexander Nozdrin	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S1 (Critical)
Version:	6.0	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
subselect_notembedded crashes the server:

main.subselect_notembedded     [ fail ]

mysqltest: At line 52: query '$start $end' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 0...

The result from queries just before the failure was:
purge master logs before (select adddate(current_timestamp(), interval -4 day));
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select adddate(current_timestamp(), interval -4 day))' at line 1
purge master logs before adddate(current_timestamp(), interval -4 day);
create table t1(a int,b int,key(a),key(b));
insert into t1(a,b) values (1,2),(2,1),(2,3),(3,4),(5,4),(5,5),
(6,7),(7,4),(5,3);
5
4
3
2
1
26
25
24
23
22
21

More results from queries before failure can be found in /dev/shm/var-ps_stm-121/log/subselect_notembedded.log

Stopping All Servers
Restoring snapshot of databases
Saving core.16012

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.subselect_notembedded

This bug is not repeatable on public 6.0-BK tree. Test passed after enabling it back.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/44867

ChangeSet@1.2617, 2008-04-03 18:52:37+04:00, anozdrin@ibm.opbmk +1 -0
  Disable subselect_notembedded.test (BuG#35803).

Pushed into 6.0.6-alpha

Beleived to be fixed by fix for BUG#32680. Enabled back the disabled testcase.

Pushed into 6.0.7-alpha  (revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (version source revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (pib:3)

Pushed into 6.0.7-alpha  (revid:sergefp@mysql.com-20080726184343-3ppkc70662ly0gv8) (version source revid:john.embretsen@sun.com-20080808091208-ht48kyzsk7rim74g) (pib:3)