| Showing 1-30 of 10684 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 121304 | 2026-09-17 7:51 | 2026-09-17 8:53 | MySQL Server: Optimizer | Verified (1 day) | S2 | 8.4.10 | Any (Docker container) | Any (x86_64) | Incorrect empty result for RIGHT JOIN with always-false EXISTS condition |
| 121303 | 2026-09-17 7:37 | 2026-09-17 7:44 | MySQL Server: Optimizer | Verified (1 day) | S3 | 9.7 | Any | Any | IN() returns 1 instead of NULL when no list element matches the left-hand expression and the list contains NULL |
| 121301 | 2026-09-17 6:12 | 2026-09-17 7:33 | MySQL Server: Optimizer | Verified (1 day) | S3 | 8.4 | MacOS (15.6.1) | ARM (Apple Silicon) | NULLIF() returns different results for a NULL literal and a NULL-valued BIGINT |
| 121300 | 2026-09-17 2:25 | 2026-09-17 7:14 | MySQL Server: Optimizer | Verified (1 day) | S2 | 9.7.2 | Any | Any | `IN` predicate returns `TRUE` even though every corresponding equality comparison returns `FALSE` |
| 121298 | 2026-09-16 16:02 | 2026-09-17 7:08 | MySQL Server: Optimizer | Verified (1 day) | S2 | 9.6.0 | Any | Any | MATCH() AGAINST() returns incorrect (near-random) relevance scores when wrapped in a CASE expression combined with DISTI |
| 121295 | 2026-09-16 13:35 | 2026-09-17 8:58 | MySQL Server: JSON | Verified (1 day) | S3 | Any | Any | JSON_ARRAY() returns different JSON types for equivalent TRUE expressions when one expression is a table-referencing sca | |
| 121292 | 2026-09-16 8:29 | 2026-09-16 10:39 | MySQL Server: Optimizer | Verified (2 days) | S2 | 8.4.11 (LTS), 9.7.2, 26.7.0 (current) — | Any (observed on Linux x86_64, Ubuntu 22.04.2 LTS, kernel 5.15.0-187-generic;) | Any (Any (observed on x86)) | INTERSECT ALL / EXCEPT ALL lose duplicate counts when the hash set operation spills to disk |
| 121290 | 2026-09-16 7:08 | 2026-09-16 11:23 | MySQL Server: DDL | Verified (2 days) | S3 | 8.4.11, 9.7.2, 26.7.0 | Any | Any | CTAS with a JSON expression results in literal NULL default, broken SHOW CREATE TABLE |
| 121281 | 2026-09-14 14:08 | 2026-09-16 15:06 | MySQL Server: Optimizer | Verified (2 days) | S3 | 8.4.11 - 9.4 | Any | Any | Wrong results in multi-join queries due to derived merge |
| 121272 | 2026-09-12 14:16 | 2026-09-14 11:39 | MySQL Server: Optimizer | Verified (4 days) | S3 | 8.0.45 | MacOS (MacOS 26.5.2, using Homebrew) | ARM | Incorrect ORDER BY when using GROUP BY, GROUP_CONCAT() and COUNT(id) OVER() |
| 121270 | 2026-09-12 0:47 | 2026-09-14 11:22 | MySQL Server: Optimizer | Verified (4 days) | S3 | 8.0.45 | Any | Any | COUNT(DISTINCT ...) incorrectly counts a NULL result from AES_ENCRYPT() when its argument is a scalar subquery |
| 121269 | 2026-09-12 0:19 | 2026-09-14 10:55 | MySQL Server: Optimizer | Verified (4 days) | S2 | 9.7 | Any | Any | Incorrect result from IN comparison involving CONCAT() and a scalar subquery |
| 121249 | 2026-09-09 14:28 | 2026-09-17 9:03 | MySQL Server: Optimizer | Verified (8 days) | S2 | 8.0.46, 8.4.11, 9.7.2 | Linux | x86 | With sql_buffer_result=ON, IN / quantified (ANY/ALL/SOME) subquery predicates in the SELECT list evaluate to NULL |
| 121240 | 2026-09-07 3:00 | 2026-09-07 9:15 | MySQL Server: Data Types | Verified (11 days) | S3 | 8.4.11 | Linux (Oracle Linux Server 9.8; mysql:8.4.11 Docker image via Docker Desktop on Windows/WSL2) | x86 (x86_64 / amd64) | Scientific-notation strings: integer casts differ from arithmetic conversion |
| 121239 | 2026-09-07 1:17 | 2026-09-07 7:30 | MySQL Server: Optimizer | Verified (11 days) | S2 | 8.0.46 | Any | Any | Wrong result: the same CTE returns inconsistent cardinality across consumers with UNION/EXCEPT |
| 121226 | 2026-09-03 7:52 | 2026-09-03 13:01 | MySQL Server: Optimizer | Verified (15 days) | S3 | 9.7.2 | Any | Any | WHERE int_col = CAST(decimal AS DOUBLE) index access stores the rounded key and returns wrong rows (literal path correct |
| 121222 | 2026-09-03 7:43 | 2026-09-03 12:31 | MySQL Server: Optimizer | Verified (15 days) | S3 | 9.7.2 | Any | Any | GREATEST/LEAST mixed-type aggregation produces illegal packed dates (16383-15-31 and 7 more) |
| 121221 | 2026-09-03 7:42 | 2026-09-03 12:27 | MySQL Server: Optimizer | Verified (15 days) | S3 | 9.7.2 | Any | Any | BIT column vs BIT literal: comparator path split (column numeric, literal byte-string) |
| 121220 | 2026-09-03 7:41 | 2026-09-03 12:22 | MySQL Server: Optimizer | Verified (15 days) | S3 | 9.7.2 | Any | Any | One DATE constant in an IN list silently disables all other elements ('abc' IN ('abc', DATE'...') cannot find 'abc') |
| 121219 | 2026-09-03 7:40 | 2026-09-03 12:15 | MySQL Server: Optimizer | Verified (15 days) | S3 | 9.7.2 | Any | Any | TIME column BETWEEN contradicts its decomposition: both single-sided =1, AND =1, yet BETWEEN =0 |
| 121218 | 2026-09-03 7:36 | 2026-09-03 12:04 | MySQL Server: Optimizer | Verified (15 days) | S3 | 9.7.2 | Any | Any | TIME column vs TIMESTAMP/DATETIME constant: the constant's date part is silently discarded |
| 121216 | 2026-09-03 7:28 | 2026-09-03 10:13 | MySQL Server: Optimizer | Verified (15 days) | S3 | 8.4 | Any | Any | VARCHAR column vs DATE constant: failed conversion silently acts as a "smallest sentinel" |
| 121214 | 2026-09-03 7:23 | 2026-09-03 9:16 | MySQL Server: Optimizer | Verified (15 days) | S3 | 9.7.2 | Any | Any | TIME column compared with a >= 10^10 integer constant returns inverted results (column vs literal context semantic split |
| 121213 | 2026-09-02 15:24 | 2026-09-04 5:11 | MySQL Server: Optimizer | Verified (14 days) | S2 | 8.0.46, 8.4.11, 9.7.2 | Linux | Any | UNIQUE const-table plan evaluates `GROUPING()=1` before ROLLUP and drops the super-aggregate row |
| 121208 | 2026-09-02 9:04 | 2026-09-04 8:53 | MySQL Server: Optimizer | Verified (14 days) | S3 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | Materializing a shared `UNION` CTE changes a scalar `ORDER BY ... LIMIT` result |
| 121207 | 2026-09-02 9:03 | 2026-09-04 8:43 | MySQL Server: Optimizer | Verified (14 days) | S2 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | Materializing an `EXISTS` input changes a `RIGHT JOIN` result |
| 121206 | 2026-09-02 9:01 | 2026-09-04 7:49 | MySQL Server: Optimizer | Verified (14 days) | S2 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | Materializing a computed derived column changes a false `HAVING` result |
| 121188 | 2026-08-29 13:30 | 2026-09-01 4:50 | MySQL Server: Optimizer | Verified (17 days) | S2 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | Materializing an `IN` subquery changes a `UNION`/`RIGHT JOIN` result |
| 121187 | 2026-08-29 13:28 | 2026-09-01 4:53 | MySQL Server: Optimizer | Verified (17 days) | S2 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | Materializing a `TIME` expression changes comparison with `DATETIME` literals |
| 121184 | 2026-08-28 8:45 | 2026-09-01 4:59 | MySQL Server: Optimizer | Verified (17 days) | S3 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | Adding an unrelated element to a mixed-type temporal IN list flips the match result of other elements |
| Showing 1-30 of 10684 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
