Bug #2266 | Crash if stored procedure containing subquery, after INSERT | ||
---|---|---|---|
Submitted: | 3 Jan 2004 7:59 | Modified: | 31 May 2004 11:27 |
Reporter: | Peter Gulutzan | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | MySQL 5.0.0 | OS: | Linux (SuSE 8.2) |
Assigned to: | Oleksandr Byelkin | CPU Architecture: | Any |
[3 Jan 2004 7:59]
Peter Gulutzan
[13 Jan 2004 3:39]
Per-Erik Martin
The problem is that the member variable 'join' is set to 'new JOIN(...)' in subselect_single_select_engine::prepare() at the first call, and then reused; but the join the is allocated in the caller's mem_root which is freed after each call. The solution is to write a cleanup() method when this cset (hf's) is pushed.
[20 May 2004 1:08]
Oleksandr Byelkin
ChangeSet 1.1683 04/05/20 02:02:49 bell@sanja.is.com.ua +22 -0 PS and SP made compatible in mechanism used for preparing query for rexecutions (Bug #2266)
[31 May 2004 11:27]
Oleksandr Byelkin
Thank you for bugreport. This bug is fixed, patch is pushed in our internal repository and will be present in next server release.