Bug #40667 | subselect.test switches connection at line 1464, forgets optimization settings | ||
---|---|---|---|
Submitted: | 12 Nov 2008 13:37 | Modified: | 16 Nov 2010 2:01 |
Reporter: | Roy Lyseng | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Tests: Server | Severity: | S7 (Test Cases) |
Version: | 6.0 | OS: | Any |
Assigned to: | Roy Lyseng | CPU Architecture: | Any |
[12 Nov 2008 13:37]
Roy Lyseng
[17 Nov 2008 13:47]
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/58951 2700 Roy Lyseng 2008-11-17 Bug#40667: subselect.test switches connection at line 1464, forgets optimization settings One test case requires a "new" connection. When that test case is finished, close the new connection and switch back to the default one.
[18 Nov 2008 16:42]
Sergey Petrunya
The posted patch uncovers a problem that the result of several queries is different. It seems we get incorrect result whenever materialization strategy is used.
[18 Nov 2008 16:42]
Sergey Petrunya
The posted patch uncovers a problem that the result of several queries is different. It seems we get incorrect result whenever materialization strategy is used.
[18 Nov 2008 16:46]
Sergey Petrunya
Patch to fix this bug. To be applied after BUG#36752 is fixed.
Attachment: bug40667-fix-after-bug36752.diff (, text), 14.28 KiB.
[18 Nov 2008 16:52]
Sergey Petrunya
If I apply the fix for BUG#36752, then modify subselect.test file as was done in Roy's patch, then the result differences are in EXPLAIN outputs only.
[20 Nov 2008 10:59]
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/59349 2934 Satya B 2008-11-20 Fix of BUG#40667 - Archive tables joined on primary return no result Problem ------- Select queries on archive tables when joined on their primary keys returns no results(empty set) How it was solved ----------------- Archive storage doesn't inform the handler about the fetched record status when it is found. Fixed the archive storage engine to update the record status when it fetches successfully TestCase -------- Modified archive.test testcase to test queries on tables joined by primary key
[20 Nov 2008 15:46]
Timour Katchaounov
FYI: BUG#36752: "subquery materialization produces wrong results when comparing different types" Has been pushed into 6.0-opt, so you can try now the combined effect of this bug fix and that of BUG#36752.
[26 Nov 2008 5:14]
Satya B
Apologies, I have written wrong bug no in commit header for my patch ,when my bug no is 40677. Please discard the patch committed on 20th Nov 2008.
[26 Nov 2008 9:08]
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/59882 2702 Roy Lyseng 2008-11-26 Bug#40667: subselect.test switches connection at line 1464, forgets optimization settings
[29 Dec 2008 15:39]
Bugs System
Pushed into 6.0.10-alpha (revid:sergefp@mysql.com-20081229085854-ui755edl9x4xomen) (version source revid:sergefp@mysql.com-20081126143611-sh4x9pv9vmbnm00v) (merge vers: 6.0.9-alpha) (pib:6)
[2 Feb 2009 16:56]
Sergey Petrunya
Changing status to reflect the reality: this has been pushed some time ago
[15 Apr 2010 14:34]
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/105752 3078 Roy Lyseng 2010-04-15 Bug#40667: subselect.test switches connection at line 1464, forgets optimization settings @ mysql-test/t/subselect.test One test case requires a "new" connection. When that test case is finished, close the new connection and switch back to the default one.
[16 Aug 2010 6:38]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100816062819-bluwgdq8q4xysmlg) (version source revid:alik@sun.com-20100816062612-enatdwnv809iw3s9) (pib:20)
[13 Nov 2010 16:19]
Bugs System
Pushed into mysql-trunk 5.6.99-m5 (revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:vasil.dimov@oracle.com-20100629074804-359l9m9gniauxr94) (merge vers: 5.6.99-m4) (pib:21)
[16 Nov 2010 2:01]
Paul DuBois
Changes to test suite. No changelog entry needed.