Showing 1-30 of 734 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
121132005-07-22
14:23
2014-01-24
12:43
MySQL Server: OptimizerVerified
(3716 days)
S15.0.28-BK, 4.0,5.0AnyAnyComposite index chosen partially for ORDER BY ... LIMIT query.
356332008-03-28
8:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5844 days)
S15.0.54, 5.0.56Linux (2.6.25-rc4)AnyColumn cant be NULL error on SELECT...FROM (SELECT not_null_column, agg_func...)
457412009-06-25
10:46
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5386 days)
S15.0.83, 5.0, 5.1, 5.5.8LinuxAnyMemory of server increases abnormally for sql with mass <> condition
586042010-11-30
21:28
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4865 days)
S15.5.7, 5.5.9, 5.6.1AnyAnycrash in cleanup code of explain partitions after killing connection
640022012-01-11
20:01
2012-01-19
11:52
MySQL Server: OptimizerVerified
(4459 days)
S15.5.19Any (Debian, Windows XP)AnyAggregate queries with multiple columns and no GROUP BY produce bogus results
668492012-09-17
18:49
2013-06-10
19:50
MySQL Server: OptimizerVerified
(3944 days)
S15.5.16, 5.1.70, 5.5.32, 5.6.12LinuxAny[REGRESSION] this query hangs the server (100% CPU for several minutes)
712062013-12-22
17:13
2013-12-31
20:00
MySQL Server: OptimizerVerified
(3748 days)
S15.5.32-0ubuntu0.12.04.1-log, 5.6.15, 5.1.72, 5.5.35, 5.7.3Linux (ubuntu 12.04)AnyGROUP_CONCAT changes GROUP BY behavior
732842014-07-13
19:12
2014-07-14
8:47
MySQL Server: OptimizerVerified
(3545 days)
S15.5.35, 5.5.38AnyAnyWrong query result when search from 2 related views
851262017-02-22
10:42
2017-02-28
7:19
MySQL Server: OptimizerVerified
(2585 days)
S15.6.35AnyAnyDelete by range in presence of partitioning and no PK always picks wrong index
869732017-07-06
13:26
2017-07-07
7:19
MySQL Server: OptimizerVerified
(2456 days)
S15.6, 5.5.56, 5.6.36, 5.7.18AnyAnyBIN() function error
908472018-05-12
16:57
2018-08-18
11:52
MySQL Server: OptimizerVerified
(2145 days)
S15.7.22, 8.0.11Windows (W10 64bit)x86Query returns wrong data if order by is present
913622018-06-21
15:18
2019-02-13
14:05
MySQL Server: OptimizerVerified
(2106 days)
S15.6.36 - 5.6.40 and 5.7.18 - 5.7.22, 5.6.40, 5.7.22AnyAnyIncorrect query results under certain conditions.
992442020-04-14
3:22
2020-04-22
12:45
MySQL Server: OptimizerVerified
(1437 days)
S18.0.19AnyAnybad performance in hash join because join with no join condition between tables
1005042020-08-12
11:58
2020-08-18
2:50
MySQL Server: OptimizerVerified
(1318 days)
S18.0.21, 5.7.31Linux (Arch Linux)x86 (x86_64)Count distinct is inconsistent when swapping two fields being counted.
1022912021-01-19
9:17
2021-01-19
9:58
MySQL Server: OptimizerVerified
(1164 days)
S18.0, 8.0.22, 8.0.23AnyAnySubquery produces wrong result when set big_tables = 1
1046292021-08-16
3:08
2021-08-16
7:09
MySQL Server: OptimizerVerified
(955 days)
S18.0.25,5.7.35, 8.0.26AnyAnywrong result when outer join prune partition tables with is null predicate
1066512022-03-07
4:34
2022-03-11
14:21
MySQL Server: OptimizerVerified
(752 days)
S15.7.*, 5.7.37, 8.0.28AnyAnyQuery wrong result when the condition is "where id ('decimal_a', 'decimal_b')"
1069382022-04-07
2:26
2022-04-08
1:35
MySQL Server: OptimizerVerified
(720 days)
S18.0, 8.0.28AnyAnylateral derived table with LIMIT produces wrong result
1092122022-11-27
8:34
2022-11-27
9:20
MySQL Server: OptimizerVerified
(487 days)
S18.0.30, 8.0.31AnyAnyIncorrect Hash Semijoin Execution
1093112022-12-08
3:40
2022-12-09
3:36
MySQL Server: OptimizerVerified
(475 days)
S18.0.22 8.0.30, 8.0.31AnyAnyWrong result
1097282023-01-21
19:27
2023-09-05
8:45
MySQL Server: OptimizerVerified
(401 days)
S18.0.30AnyAnySELECT statement: Result is not proper with GROUP BY with LIMIT OFFSET
1101252023-02-19
8:48
2023-02-20
5:04
MySQL Server: OptimizerVerified
(402 days)
S18.0.32, 5.7UbuntuAnyUnexpected query result fetched from an indexed column
1105872023-04-03
7:51
2023-04-03
9:37
MySQL Server: OptimizerVerified
(360 days)
S18.0.27, 8.0.32, 5.7.41AnyAnyBit with index range query may produce different results
1109842023-05-11
2:24
2023-05-11
6:59
MySQL Server: OptimizerVerified
(322 days)
S18031, 5.7.42, 8.0.33Linuxx86Subqueries with 'limit 1' cause concat strings to report errors
1110972023-05-22
6:40
2023-05-22
7:54
MySQL Server: OptimizerVerified
(311 days)
S18031, 5.7.42, 8.0.33Linuxx86Query statement results with subqueries are unstable
1121982023-08-28
8:21
2024-03-05
6:06
MySQL Server: OptimizerVerified
(213 days)
S18.0, 8.0.34AnyAnyIncorrect multiple equality optimization causes performance degradation
1135342024-01-02
8:27
2024-01-05
2:27
MySQL Server: OptimizerVerified
(83 days)
S18.0.35AnyAnytable join return Unexpected result when drived table using include join index
184652006-03-23
17:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5298 days)
S25.0.20-BK, 5.0.19, 5.0.85Any (any)AnyOptimizer/execution plan bug with dependent subqueries in ON clauses of JOINs
284042007-05-13
18:33
2018-11-11
14:44
MySQL Server: OptimizerVerified
(1964 days)
S24.0.31, 4.1.25, 4.1.26, 5.0.42-BK, 5.0.46, 5.1.33LinuxAnyOptimizer does not consider index that can be used for ORDER BY
294212007-06-28
13:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6118 days)
S25.1.14-beta/5.0AnyAnyMySQL allows mixing of GROUP columns with no GROUP columns in complex terms
  Showing 1-30 of 734 (Edit, Save, CSV, Feed) Show Next 30 Entries »