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
Triage: D3 (Medium)

[3 Apr 2008 14: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 2008 14:46] Valeriy Kravchuk
This bug is not repeatable on public 6.0-BK tree. Test passed after enabling it back.
[3 Apr 2008 14: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 2008 13:01] Bugs System
Pushed into 6.0.6-alpha
[9 May 2008 18:02] Sergey Petrunya
Beleived to be fixed by fix for BUG#32680. Enabled back the disabled testcase.
[28 Aug 2008 20: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)
[13 Sep 2008 23: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)