Bug #68046 IN() clause with many constant values does not perform
| Submitted: | 7 Jan 2013 9:29 | Modified: | 22 Jan 2013 14:04 |
|---|---|---|---|
| Reporter: | Martijn Otto | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Optimizer | Severity: | S2 (Serious) |
| Version: | 5.6-rc9 | OS: | Any (Ubuntu 12.04) |
| Assigned to: | Jørgen Løland | CPU Architecture: | Any |
[7 Jan 2013 9:29]
Martijn Otto
[7 Jan 2013 9:46]
Shane Bester
testcase. 5.5.29 takes < 0.1 seconds, 5.6.10 takes > 4 seconds.
Attachment: bug68046.sql (application/octet-stream, text), 194.98 KiB.
[7 Jan 2013 9:59]
Shane Bester
5.6.5 is fast. 5.6.6+ is slow....
[13 Jan 2013 13:09]
Shane Bester
The fix for http://bugs.mysql.com/bug.php?id=58731 introduced this bug. Code that was previously only run only in debug builds (function: test_rb_tree) was now running in optimized builds by mistake.
[22 Jan 2013 14:04]
Paul DuBois
Noted in 5.6.11, 5.7.1 changelogs. Queries with many values in a IN() clause were slow due to inclusion of debugging code in non-debugging builds.
[1 Apr 2013 14:37]
Shane Bester
Bug #68818 was a duplicate
[1 Apr 2013 16:16]
Shane Bester
bug #68748 was a duplicate of this
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.057 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.