Bug #35803 subselect_notembedded crashes the server
Submitted: 3 Apr 16:36 Modified: 9 May 20:03
Reporter: Alexander Nozdrin
Status: Duplicate
Category:Server: Optimizer Severity:S1 (Critical)
Version:6.0 OS:Any
Assigned to: Sergey Petrunia Target Version:6.0
Triage: D3 (Medium)

[3 Apr 16:36] Alexander Nozdrin 
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
[3 Apr 16:46] Valeriy Kravchuk 
This bug is not repeatable on public 6.0-BK tree. Test passed after enabling it back.
[3 Apr 16:51] Bugs System 
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).
[20 Apr 15:01] Bugs System 
Pushed into 6.0.6-alpha
[9 May 20:02] Sergey Petrunia 
Beleived to be fixed by fix for BUG#32680. Enabled back the disabled testcase.
[28 Aug 22:15] Bugs System 
Pushed into 6.0.7-alpha  (revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (version
source revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (pib:3)
[14 Sep 1:40] Bugs System 
Pushed into 6.0.7-alpha  (revid:sergefp@mysql.com-20080726184343-3ppkc70662ly0gv8)
(version source revid:john.embretsen@sun.com-20080808091208-ht48kyzsk7rim74g) (pib:3)