Showing all 12 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
357242008-03-31
22:24
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5503 days)
S2MySQL 5.0.51a-community-nt, 5.1, 6.0 BKAnyAnyNon-found left join data passed as a parameter to a function in WHERE
461352009-07-12
19:03
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4996 days)
S25.0, 5.1, next, 6.0.0, 6.0.2, 5.1.36AnyAnyLIMIT + JOIN problem
581012010-11-10
0:21
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4886 days)
S55.1.38-community-log, 5.1.54-bzrLinuxAnyOptimizer picks wrong order of queries
680722013-01-12
18:02
2013-01-13
15:08
MySQL Server: OptimizerVerified
(4092 days)
S25.1, 5.5Any (Win64, CentOS Linux)AnyMySQL 5.1 issue with timediff, group by on multiple columns, join, primary key
842572016-12-19
9:58
2016-12-19
12:30
MySQL Server: MyISAM storage engineVerified
(2656 days)
S25.7.17Windows (w10 CZECH NATIONALISATION)AnyUpdate of a view made of joined MYISAM tables returns no rows
884652017-11-13
16:34
2017-11-21
4:34
MySQL Server: DMLVerified
(2321 days)
S25.7.20AnyAnyJOIN is performed incorrectly on TIMESTAMP
1058602021-12-10
10:17
2021-12-10
14:17
MySQL Server: DMLVerified
(839 days)
S38.0AnyAnyUNION with JOIN USING puts results under wrong column
1093672022-12-13
16:11
2022-12-14
5:58
MySQL Server: OptimizerVerified
(470 days)
S35.7.22, 8.0.31AnyAnyvalue changed caused by DISTINCT and JOIN
1097262023-01-20
21:35
2023-05-29
12:01
MySQL Server: OptimizerVerified
(430 days)
S28.0.31Ubuntux86Incorrect results with aggregated functions on correlated lateral joins
1106562023-04-11
16:02
2024-01-26
9:27
MySQL Server: OptimizerVerified
(62 days)
S38.0.32Ubuntu (22.04)x86 (x86_64)Join query with wrong result
1131352023-11-20
3:03
2023-11-20
15:34
MySQL Server: DMLVerified
(129 days)
S38.0AnyAnyDISTINCT JOIN ORDER BY statements ignore ORDER BY when tmp_table_size is small
1143012024-03-11
16:40
2024-03-12
16:23
MySQL Server: OptimizerVerified
(16 days)
S38.0AnyAnyIncorrect result with IS NULL predicate in join condition
Showing all 12 (Edit, Save, CSV, Feed)