Showing 1-30 of 458 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
601852011-02-20
15:58
2011-03-03
8:35
MySQL Server: OptimizerVerified
(3622 days)
S35.0.51, 5.5.11LinuxAnyindex DEPENDENT SUBQUERY
604942011-03-16
17:26
2011-03-19
9:43
MySQL Server: OptimizerVerified
(3597 days)
S35.1.36-community, 5.1.57AnyAnyOrder By produces wrong order
268322007-03-04
18:17
2011-04-05
14:46
MySQL Server: OptimizerVerified
(3578 days)
S55.5AnyAnyENUM types not optimized
607022011-03-30
23:25
2011-04-05
14:55
MySQL Server: OptimizerVerified
(3583 days)
S55.1.57AnyAnyGROUP BY orders when used inside a UNION query, though it should not
615512011-06-17
12:26
2011-06-18
8:34
MySQL Server: OptimizerVerified
(3505 days)
S35.1.56AnyAnyLoose index scan is not used for select COUNT(distinct a)
619362011-07-21
6:27
2011-07-31
15:28
MySQL Server: OptimizerVerified
(3470 days)
S25.1.48, 5.5.13, 5.5.16Linux (x86_64)AnySTRAIGHT_JOIN has no effect on query with subquery in FROM clause
623072011-08-31
1:54
2011-09-01
21:29
MySQL Server: OptimizerVerified
(3429 days)
S35.5.15AnyAnyCondition "TIME = '19:20'" does not use index in sjis
635632011-12-03
14:09
2011-12-05
7:50
MySQL Server: OptimizerVerified
(3335 days)
S25.5.17AnyAnyBinary operator now causes a full scan
638682011-12-28
19:34
2011-12-30
15:41
MySQL Server: OptimizerVerified
(3310 days)
S35.1.60, 5.5.20Linux (Centos 5 x64)AnyLeft outer join with user defined function on NULL column gives wrong results
640362012-01-15
15:51
2012-01-15
19:07
MySQL Server: OptimizerVerified
(3293 days)
S3AnyAnyUse non-materializing loose-scan-merge for certain subqueries in FROM with LIMIT
639052012-01-02
23:47
2012-01-16
18:35
MySQL Server: OptimizerVerified
(3292 days)
S55.1.60Microsoft WindowsAnyhandler_read_next is suprisingly high and slows queries
640162012-01-12
19:38
2012-01-19
11:48
MySQL Server: OptimizerVerified
(3295 days)
S35.5.19AnyAnyOptimizer doesn't seem to take into account enum definition
640022012-01-11
20:01
2012-01-19
11:52
MySQL Server: OptimizerVerified
(3296 days)
S15.5.19Any (Debian, Windows XP)AnyAggregate queries with multiple columns and no GROUP BY produce bogus results
643162012-02-14
12:04
2012-02-14
15:50
MySQL Server: OptimizerVerified
(3263 days)
S25.1.49-3\5.5.21Linux (Debian)Anysearch with decimal value on INT field with index gives wrong result with LIMIT
633752011-11-22
5:36
2012-02-24
10:52
MySQL Server: OptimizerVerified
(3253 days)
S35.1,5.5AnyAnyChange the state from "Sending data" when running do_select
646342012-03-13
13:11
2012-04-01
10:56
MySQL Server: OptimizerVerified
(3216 days)
S35.6.4-m7AnyAnyNo result when binding to same field with different trailing spaces
657922012-07-03
2:19
2012-07-04
9:54
MySQL Server: OptimizerVerified
(3123 days)
S55.1,5.5AnyAnyan unecessary Using temporary in distinct query
668252012-09-14
22:38
2012-09-15
18:02
MySQL Server: OptimizerVerified
(3049 days)
S35.5.27AnyAny5.5 ignores an index if BINARY is used
668962012-09-20
20:24
2012-09-21
0:12
MySQL Server: OptimizerVerified
(3043 days)
S25.5.24Linux (ubuntu 12.04)AnyDistinct not distinguishing 0 from NULL when GROUP BY is used
676382012-11-19
17:00
2012-11-26
17:24
MySQL Server: OptimizerVerified
(2977 days)
S35.6.8AnyAnyOdd optimizer choice for UPDATE .. ORDER BY ... LIMIT query
678152012-12-05
8:51
2012-12-06
6:15
MySQL Server: OptimizerVerified
(2967 days)
S35.5.28, 5.6.7LinuxAnyMySQL consistently uses a low cardinality non-referenced column in a index scan
680442013-01-06
22:02
2013-01-07
1:30
MySQL Server: OptimizerVerified
(2935 days)
S35.5.30AnyAnyA minor bug in check_simple_equality()
680722013-01-12
18:02
2013-01-13
15:08
MySQL Server: OptimizerVerified
(2929 days)
S25.1, 5.5Any (Win64, CentOS Linux)AnyMySQL 5.1 issue with timediff, group by on multiple columns, join, primary key
679802012-12-27
14:54
2013-01-19
10:52
MySQL Server: OptimizerVerified
(2923 days)
S35.5.28AnyAnyMySQL not utilising full index because of possible bad cardinality stats
688522013-04-03
9:27
2013-04-03
9:41
MySQL Server: OptimizerVerified
(2849 days)
S35.5.28AnyAnyWrong behavior with aggregate functions, dates and between
688992013-04-09
9:38
2013-04-10
11:00
MySQL Server: OptimizerVerified
(2842 days)
S35.5.30, 5.6.10LinuxAnyHigh join_buffer_size prevents use of spatial index on joined tables
689192013-04-10
14:25
2013-04-10
14:33
MySQL Server: OptimizerVerified
(2842 days)
S55.6.10AnyAnyPerformance regression when DS-MRR is used for query with small limit
692192013-05-13
20:14
2013-05-13
20:32
MySQL Server: OptimizerVerified
(2809 days)
S55.6.12AnyAnyCREATE TEMPORARY TABLE ... SELECT is slower on 5.6 than on 5.1
692852013-05-20
3:48
2013-06-10
10:28
MySQL Server: OptimizerVerified
(2781 days)
S35.5+AnyAnycount upon not null field can not treated as count(*)
668492012-09-17
18:49
2013-06-10
19:50
MySQL Server: OptimizerVerified
(2781 days)
S15.5.16, 5.1.70, 5.5.32, 5.6.12LinuxAny[REGRESSION] this query hangs the server (100% CPU for several minutes)
  Showing 1-30 of 458 (Edit, Save, CSV, Feed) Show Next 30 Entries »