« Show Previous 30 Entries Showing 61-90 of 740 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
600232011-02-08
21:45
2014-05-22
12:13
MySQL Server: OptimizerVerifiedS55.5.8 , 5.1.51AnyAnyNo Loose Index Scan for GROUP BY / DISTINCT on InnoDB partitioned table
727452014-05-26
4:28
2014-05-26
5:48
MySQL Server: OptimizerVerified
(3616 days)
S25.5.37, 5.5.38AnyAnyWrong Results When Using Intersect
728152014-05-30
11:06
2014-05-31
14:24
MySQL Server: OptimizerVerified
(3612 days)
S55.1, 5.5, 5.6, 5.7AnyAnyUPDATE ... WHERE ... ORDER BY... always does a filesort even if not required
728922014-06-05
16:27
2014-06-09
9:39
MySQL Server: OptimizerVerified
(3602 days)
S3AnyAnyPlease allow multiple ranges in the LIMIT clause
730942014-06-24
12:24
2014-06-25
8:26
MySQL Server: OptimizerVerified
(3586 days)
S25.5, 5.6, 5.6.19, 5.7.5LinuxAnyMySQL uses all partitions instead necessary ones when using CASE THEN ELSE END
732842014-07-13
19:12
2014-07-14
8:47
MySQL Server: OptimizerVerified
(3567 days)
S15.5.35, 5.5.38AnyAnyWrong query result when search from 2 related views
728142014-05-30
9:31
2014-07-18
18:56
MySQL Server: OptimizerVerified
(3609 days)
S35.6.17AnyAnyAssertion `!(ordered_index_usage == ordered_index_void && ... fails
733572014-07-22
14:42
2014-07-22
19:10
MySQL Server: OptimizerVerified
(3559 days)
S35.6, 5.7AnyAnyWrong result on query involving information_schema
739072014-09-12
18:27
2014-09-14
3:51
MySQL Server: OptimizerVerified
(3505 days)
S25.5/5.6/5.7Windows (Server 2008)AnyREGRESSION: Indexes miss on quoted large numeric bigints
698912013-08-01
6:33
2014-09-18
21:25
MySQL Server: OptimizerVerifiedS35.1.31AnyAnysince 5.1.31 REPLACE() function concats it's results under certain conditions
740492014-09-24
8:01
2014-09-24
10:01
MySQL Server: OptimizerVerified
(3495 days)
S35.6.19-67.0, 5.6.22AnyAnyUpdate query use filesort instead of index
741052014-09-26
12:16
2014-09-26
12:55
MySQL Server: OptimizerVerified
(3493 days)
S35.5.38-0ubuntu0.14.04.1, 5.5.41, 5.1.74LinuxAnyQualified comparisons return true when subquery contains nulls
742512014-10-07
14:54
2014-10-07
15:55
MySQL Server: OptimizerVerified
(3482 days)
S35.1/5.5/5.6AnyAnySyntax error when using DUAL dummy table in UNION subselect with ORDER BY
740832014-09-25
18:11
2014-10-09
12:58
MySQL Server: OptimizerVerified
(3480 days)
S55.6.20, 5.6.22Linux (CentOS 6.5)AnyENUM index scan is slower than INT index scan
740782014-09-25
16:15
2014-10-16
19:49
MySQL Server: OptimizerVerified
(3473 days)
S55.6.19/5.5/5.7Linux (Ubuntu 14)Anyjoin of large table to small table is slow if small table has less than 7 rows
744902014-10-22
2:08
2014-10-22
6:57
MySQL Server: OptimizerVerified
(3467 days)
S35.6.20-debug, 5.6.22Linux (CentOS 7)AnyAssertion `table->key_read == 0' failed | sig 6 in close_open_tables
745422014-10-24
10:05
2014-10-24
10:51
MySQL Server: OptimizerVerified
(3465 days)
S35.6/5.7AnyAnyFLUSH TABLES WITH READ LOCK blocks EXPLAIN UPDATE/DELETE/INSERT
744622014-10-20
19:26
2014-11-01
0:57
MySQL Server: OptimizerVerified
(3457 days)
S35.6.21AnyAnyEXPLAIN FORMAT=JSON produces ordering_operation when no ordering takes place.
738252014-09-06
16:45
2014-11-06
11:39
MySQL Server: OptimizerVerified
(3513 days)
S35.1, 5.5, 5.6, 5.7AnyAnyWrong result (extra row) with group by, multi-part key
749622014-11-21
13:24
2014-11-21
14:20
MySQL Server: OptimizerVerified
(3437 days)
S35.5/5.6AnyAnyMatching in char field type is not correct
751212014-12-05
18:25
2014-12-08
8:26
MySQL Server: OptimizerVerified
(3423 days)
S25.6.21Linux (CentOS 5.11)AnyIN clause subquery optimization
752662014-12-18
16:36
2014-12-18
18:19
MySQL Server: OptimizerVerified
(3410 days)
S25.6.19AnyAnySetting sum of decimal field on user defined variable is not working as expected
754472015-01-08
12:59
2015-01-08
13:27
MySQL Server: OptimizerVerified
(3389 days)
S25.6, 5.6.24, 5.7.6AnyAnyINSERT into a view sometimes ignores default values
755102015-01-15
0:36
2015-01-16
9:59
MySQL Server: OptimizerVerified
(3381 days)
S35.6.21AnyAnyMySQL chooses index scan over full table scan
756682015-01-28
16:21
2015-01-28
20:10
MySQL Server: OptimizerVerified
(3369 days)
S25.6.22/5.7FreeBSD (FreeBSD 8.4)AnyUse of Distinct, Group_concat, and Group by together produces 1 NULL row result.
759672015-02-19
12:45
2015-02-20
8:06
MySQL Server: OptimizerVerified
(3346 days)
S35.6, 5.7, 5.6.24AnyAnyWrong result (extra rows) with SQ and comparison to NULL, materialization=off
759922015-02-21
18:29
2015-02-23
9:45
MySQL Server: OptimizerVerified
(3343 days)
S35.6.14-log, 5.6.24Windows (Vista)Anyno warning when, under "ALLOW_INVALID_DATES", an invalid date is discarded
759912015-02-21
18:12
2015-02-23
9:59
MySQL Server: OptimizerVerified
(3343 days)
S35.6.14-log, 5.6.24Windows (Vista)Anywrit of ALLOW_INVALID_DATES
760292015-02-24
14:26
2015-02-24
15:52
MySQL Server: OptimizerVerified
(3342 days)
S35.6.23LinuxAnyIN / NOT IN doesn't return correct result when on-disk temporary table is used
765012015-03-27
6:50
2015-03-27
15:11
MySQL Server: OptimizerVerified
(3311 days)
S35.6.22AnyAny"select + distinct + group by " works incorrectly
« Show Previous 30 Entries Showing 61-90 of 740 (Edit, Save, CSV, Feed) Show Next 30 Entries »