Showing all 20 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
1199552026-02-27
5:03
2026-06-04
8:37
MySQL Server: OptimizerVerified
(12 days)
S28.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)Semantically equivalent scalar expressions yield different result sets in WHERE clause involving RPAD()
1201522026-03-25
8:50
2026-06-04
8:38
MySQL Server: OptimizerVerified
(12 days)
S28.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)Unexpected behavior of LEFT JOIN + empty subquery with NULL comparison in WHERE clause
1201592026-03-26
11:41
2026-06-04
8:38
MySQL Server: OptimizerVerified
(12 days)
S28.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)RIGHT JOIN + Complex Subqueries Returns Extra Rows
1201612026-03-26
14:19
2026-03-27
4:56
MySQL Server: OptimizerDuplicate
(81 days)
S38.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)Incorrect partial row duplication with RIGHT JOIN and empty subquery
1201622026-03-26
14:19
2026-03-26
14:27
MySQL ServerClosed
(82 days)
S38.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)Incorrect partial row duplication with RIGHT JOIN and empty subquery
1201792026-03-30
10:54
2026-06-04
8:39
MySQL Server: OptimizerVerified
(12 days)
S28.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)NoREC Test: COUNT(*) vs SUM(CASE...) produces inconsistent results with RIGHT JOIN + LEFT JOIN
1201802026-03-30
13:32
2026-06-04
8:39
MySQL ServerOpen
(12 days)
S28.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)NoREC Bug: COUNT(*) and SUM(CASE WHEN ...) return inconsistent results with string-length expression and NULL-sensitive
1201872026-03-31
11:46
2026-06-04
8:40
MySQL ServerOpen
(12 days)
S28.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)Bug: COUNT(*) vs SUM(CASE WHEN ...) returns inconsistent results with NULL-sensitive joins
1201892026-03-31
12:43
2026-06-04
8:40
MySQL ServerOpen
(12 days)
S28.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)TLP Bug: COUNT(*) on orders returns 5, but equivalent TLP-style with complex NULLIF and CASE expressions return 10
1201902026-03-31
13:04
2026-06-04
8:40
MySQL ServerOpen
(12 days)
S28.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)TLP Bug: COUNT(*) returns 20, while TLP-partitioned queries return 0 under RIGHT JOIN with LATERAL subqueries
1201912026-03-31
13:32
2026-06-04
8:41
MySQL ServerOpen
(12 days)
S28.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)TLP bug: Incorrect result under Ternary Logic Partitioning (TLP) with complex RIGHT JOIN chains
1202242026-04-07
12:25
2026-06-04
8:41
MySQL Server: OptimizerVerified
(12 days)
S28.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)Inconsistent row counts for DELETE vs SELECT with EXISTS and lateral subquery on the same table
1202252026-04-07
13:40
2026-06-04
8:41
MySQL Server: OptimizerVerified
(12 days)
S28.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)Inconsistent behavior between SELECT and DELETE/UPDATE with EXISTS and LEFT JOIN subquery
1202712026-04-15
10:54
2026-06-04
8:42
MySQL Server: OptimizerVerified
(12 days)
S28.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)Logic error: EXISTS subquery treated as constant TRUE yields different result than literal TRUE
1202792026-04-17
7:23
2026-06-04
8:42
MySQL Server: OptimizerVerified
(12 days)
S28.0.43 (MySQL Community Server - GPL)AnyAnySevere performance degradation with window function + joins (works fast in PostgreSQL/DuckDB/TiDB)
1203402026-04-24
9:13
2026-06-04
8:42
MySQL ServerOpen
(12 days)
S28.0.43 (MySQL Community Server - GPL)AnyAnyInconsistent evaluation of NULLIF(ROUND(VAR_SAMP(...)), const) <= value between MySQL and PostgreSQL/DuckDB causes diffe
1203632026-04-28
6:58
2026-06-04
8:42
MySQL Server: OptimizerVerified
(12 days)
S28.0.43Any (Docker container)Any (x86_64)LEFT JOIN ON FALSE causes incorrect NULL comparison result in MySQL
1203662026-04-28
11:17
2026-04-30
9:00
MySQL ServerNot a Bug
(47 days)
S38.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)Inconsistent query result caused by SUBSTR zero-based index handling and BIT_LENGTH evaluation in MySQL
1203772026-04-29
8:45
2026-06-04
8:43
MySQL Server: OptimizerVerified
(12 days)
S28.0.43 (MySQL Community Server - GPL)Any (Docker container)Any (x86_64)Incorrect row count in MySQL when using LATERAL derived table with DISTINCT and CASE
1204722026-05-14
4:07
2026-06-04
8:43
MySQL Server: OptimizerVerified
(12 days)
S28.0.43AnyAnyWrong Result After Removing Semantically Redundant RIGHT JOIN ... ON FALSE
Showing all 20 (Edit, Save, CSV, Feed)