Showing all 187 (Edit, Save, CSV, Feed) |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
118495 | 2025-06-20 7:40 | 2025-06-20 10:32 | MySQL Server: DML | Verified (1 day) | S3 | 8.0.41 | Linux | x86 | The query returned wrong result with l"imit offset" |
118493 | 2025-06-20 6:54 | 2025-06-20 10:38 | MySQL Server: Partitions | Verified (1 day) | S3 | 8.0, 8.0.42 | Any | Any | Subpartitions can not be pruned by conditions derived from equal propagation |
118492 | 2025-06-20 3:07 | 2025-06-20 18:32 | MySQL Server: DML | Verified (1 day) | S3 | 8.0.41, 8.0.42 | Linux | x86 | The result returned by the DIAMETER_TZ function is incorrect. The time after conversion is expected. |
118490 | 2025-06-19 13:00 | 2025-06-20 5:21 | MySQL Server: Optimizer | Verified (1 day) | S3 | master, 8.4 | Any | Any | hypergraph optimizer const folding caused inequivalent for join_cond_optim in Table_ref |
118486 | 2025-06-19 10:07 | 2025-06-19 14:18 | MySQL Server: Optimizer | Verified (2 days) | S5 | 8.4.3, 8.4.5, 9.3.0 | Any (AWS RDS) | Any | Index is ignored in case of multiple values in "select" and the length of any one value is more than column length |
118481 | 2025-06-18 20:04 | 2025-06-18 20:04 | MySQL Server: Optimizer | Open | S3 | Mysql 8.4.5 | Linux (Amazon Linux (AWS RDS managed)) | Any | MySQL 8.4.5 chooses suboptimal index for UPDATE query, leading to deadlocks and performance degradation |
118476 | 2025-06-18 8:45 | 2025-06-20 20:10 | MySQL Server: DDL | Verified (3 days) | S2 | 8.0, 8.4 | Red Hat | x86 | Unable to create partition with name '1e3fRQM2GhI' |
118475 | 2025-06-18 7:58 | 2025-06-18 8:40 | MySQL Server: DML | Verified (3 days) | S3 | 8.0.41, 8.4.5 | Any | Any | When the IF function is invoked to replace the specified column name, the returned results are inconsistent. |
118469 | 2025-06-17 9:38 | 2025-06-17 10:33 | MySQL Server: Documentation | Verified (4 days) | S3 | 9.3 | Any | Any | Connection attributes for Connector/NET are incomplete/incorrect |
118465 | 2025-06-17 7:42 | 2025-06-17 9:02 | MySQL Server: DML | Duplicate (4 days) | S3 | 8.0.41 | Any | Any | Inserting into a float value exceeding the precision, using IF function and using the column return different result. |
118464 | 2025-06-17 7:24 | 2025-06-17 9:29 | MySQL Server: DML | Analyzing (4 days) | S3 | 8.0.41 | Any | Any | Inserting into a float value exceeding the precision, using IF function and using the column return different result. |
118462 | 2025-06-17 2:56 | 2025-06-17 7:01 | MySQL Server: Replication | Analyzing (4 days) | S3 | 8.0.39 | Red Hat (Rocky Linux 8.10) | x86 (AMD EPYC 7R32) | Executed SQL on replica is different from source |
118455 | 2025-06-16 9:52 | 2025-06-17 12:05 | MySQL Server: DML | Not a Bug (4 days) | S3 | 8.0.41 | Linux | x86 | Cannot query JSON type data using BETWEEN '{"key1": 1}' AND '{"key1": 1}' |
118447 | 2025-06-13 22:52 | 2025-06-16 5:30 | MySQL Server: Security: Privileges | Verified (5 days) | S3 | 8.4 | Any | Any | MySQL 8.4 always uses caching_sha2_password in the initial connection handshake |
118422 | 2025-06-12 2:54 | 2025-06-12 23:46 | MySQL Server: InnoDB storage engine | Can't repeat (9 days) | S2 | 8.0.41 | Any | Any | Assertion failure happens in page_is_comp(get_block->frame) == page_is_comp(page) |
118403 | 2025-06-09 17:10 | 2025-06-20 10:13 | MySQL Server: InnoDB storage engine | Verified (1 day) | S3 | 8.0.37, 8.0.42 | Any | Any | innodb_fill_factor is not honored for InnoDB Compressed Tables |
118402 | 2025-06-09 13:38 | 2025-06-09 14:12 | MySQL Server: DML | Duplicate (12 days) | S3 | 8.0.41 | Linux | x86 | When innodb_buffer_pool_size is set a small value , the update value is abnormal. |
118401 | 2025-06-09 13:37 | 2025-06-10 6:32 | MySQL Server: DML | Verified (12 days) | S3 | 8.0.41 | Linux | x86 | When innodb_buffer_pool_size is set a small value , the update value is abnormal. |
118400 | 2025-06-09 13:34 | 2025-06-10 10:43 | MySQL Server: DML | Verified (12 days) | S3 | 8.0.41 | Linux | x86 | ERROR 3854 (HY000): Cannot convert string '\xF0\x9F\x98\xA6\xF0\x9F...' from utf8mb4 to latin1 |
118399 | 2025-06-09 12:35 | 2025-06-09 12:46 | MySQL Server: DML | Verified (12 days) | S3 | 8.0.41 | Linux | x86 | multijoin and related subqueries are used, the query result is incorrect during optimizer_switch="derived_merge=on" |
118398 | 2025-06-09 8:00 | 2025-06-11 12:40 | MySQL Server: DML | Verified (10 days) | S3 | 8.0.41 | Any | Any | Using temporary with avg cause wrong result |
118394 | 2025-06-09 2:04 | 2025-06-09 5:57 | MySQL Server: DML | Analyzing (12 days) | S3 | 8.0.41 | Any | Any | while (NOT XX NOT IN ()) return 0, the query with where (NOT XX NOT IN ()) returns a wrong result. |
118393 | 2025-06-09 1:36 | 2025-06-09 5:57 | MySQL Server: DML | Analyzing (12 days) | S3 | 8.0.41 | Any | Any | while the having subquery return NULL actually, the query using this having query returns a wrong result. |
118391 | 2025-06-08 16:43 | 2025-06-10 12:23 | MySQL Server: DML | Verified (12 days) | S3 | 8.4.2, 8.0 | Any | Any | Inconsistent BIGINT overflow behavior with unary minus operator in multiplication |
118390 | 2025-06-08 8:04 | 2025-06-10 11:11 | MySQL Server: DML | Not a Bug (11 days) | S3 | 8.0.41 | Linux | x86 | When the time type is compared with the datetime type, the returned result is error |
118375 | 2025-06-06 3:41 | 2025-06-06 3:58 | MySQL Server: DML | Analyzing (15 days) | S3 | 8.0.41 | Any | Any | while (NOT ((t0.c1) >= (t1.c2))) returns 1 actually, the query return an empty result set. |
118369 | 2025-06-05 11:21 | 2025-06-05 13:08 | MySQL Server: DML | Analyzing (16 days) | S3 | 8.0.41 | Any | Any | "having column" and "having MIN(column)" return different result.something wrong during Aggregate using temporary table |
118363 | 2025-06-04 18:00 | 2025-06-16 12:33 | MySQL Server: InnoDB storage engine | Verified (10 days) | S3 | mysql-8.0.41 | Any | Any | Another Potential Optimization in row_ins_sec_index_entry_low() |
118359 | 2025-06-04 13:43 | 2025-06-16 12:33 | MySQL Server: InnoDB storage engine | Verified (10 days) | S2 | mysql-8.0.41 | Any | Any | False-negative result in row_vers_impl_x_locked_low() — may miss identifying the active transaction on a secondary rec |
118358 | 2025-06-04 12:04 | 2025-06-11 15:34 | MySQL Server: InnoDB storage engine | Analyzing (10 days) | S2 | 8.0.42, 8.4.5 9.3.0 | Any | Any | Startup without Signs of Progress when Rolling-Back Big Transaction. |
118356 | 2025-06-04 11:58 | 2025-06-11 6:22 | MySQL Server: Replication | Verified (10 days) | S2 | 8.0.42, 8.4.5 9.3.0 | Any | Any | MySQL attempts committing transaction not fitting on disk, then crashes. |
118355 | 2025-06-04 7:41 | 2025-06-10 13:59 | MySQL Server: InnoDB Plugin storage engine | Verified (11 days) | S3 | 8.0.42 | Any | Any | Temporary file write failure when creating an index |
118352 | 2025-06-04 4:38 | 2025-06-04 8:51 | MySQL Server: Charsets | Verified (17 days) | S3 | 8.0, 8.4 | Any | Any | Illegal mix of collations when modify collation_connection |
118351 | 2025-06-04 2:24 | 2025-06-04 6:34 | MySQL Server: DML | Verified (17 days) | S3 | 8.0.41 | Linux | x86 | When Backward index scan is used for query SQL statements, the returned result is incorrect. |
118350 | 2025-06-04 2:03 | 2025-06-04 6:32 | MySQL Server: Optimizer | Verified (17 days) | S3 | 9.x | Any | Any | Contribution: Adding fuzz directory and modifications to support it. |
118349 | 2025-06-04 2:03 | 2025-06-04 19:16 | MySQL Server: Optimizer | Verified (17 days) | S3 | 9.x | Any | Any | Contribution: fuzz: parse_sql target |
118348 | 2025-06-04 1:52 | 2025-06-04 11:35 | MySQL Server: DML | Duplicate (17 days) | S3 | 8.0.41 | Any | Any | using force index(i0) and ignore index(i0) for the same query, the result set changed |
118347 | 2025-06-03 17:23 | 2025-06-11 4:41 | MySQL Server: DDL | Need Feedback (10 days) | S3 | 8.4.5 | Any | Any | 8.4.5 functions in constraints, partitions, or virtual columns may have failed |
118336 | 2025-06-03 8:24 | 2025-06-03 8:30 | MySQL Server: DML | Analyzing (18 days) | S3 | 8.0.41 | Any | Any | after adding a having clause equivalent to "having 1", the returned result set is wrong |
118322 | 2025-06-01 4:47 | 2025-06-19 16:32 | MySQL Server: Replication | Need Feedback (2 days) | S2 | 8.0.20 | Any | x86 | Result of `show master status` is not correct !!! |
118320 | 2025-05-31 1:14 | 2025-06-16 12:33 | MySQL Server: Command-line Clients | Verified (9 days) | S2 | 8.0.41, 8.4.5 | Any | Any | Invalid UTF-8 bytes can be returned by SHOW PROCESSLIST |
118313 | 2025-05-30 9:17 | 2025-05-30 10:19 | MySQL Server: Optimizer | Verified (22 days) | S3 | 8.0.41, 8.0.42, 8.4.5, 9.3.0 | Any | Any | The query result is incorrect. |
118312 | 2025-05-30 8:12 | 2025-05-30 10:32 | MySQL Server: DML | Verified (22 days) | S2 | 8.0.42, 8.4.5, 9.3.0 | Any | Any | Inconsistent results when evaluating `EXCEPT` or `INTERSECT` operations involving `NULL` |
118310 | 2025-05-30 3:36 | 2025-05-30 4:34 | MySQL Server: DML | Analyzing (22 days) | S3 | 8.0.41 | Any | Any | a query with a impossile having clause, return wrong results |
118302 | 2025-05-29 16:46 | 2025-05-30 4:26 | MySQL Server: InnoDB storage engine | Verified (22 days) | S3 | 9.0.0, 9.3.0 | Any | Any | Contribution: Adding \'sb\' instruction to spin_delay() for ARM v8.5 onward |
118299 | 2025-05-29 6:57 | 2025-05-29 11:33 | MySQL Server: InnoDB storage engine | Verified (23 days) | S2 | 8.0.42, 8.4.5 | Any | Any | Multi-valued Index on Composite Key Returns Incomplete Results for Rows with Empty JSON Array('[]') |
118298 | 2025-05-29 2:46 | 2025-05-29 5:03 | MySQL Server: DML | Analyzing (23 days) | S3 | 8.0.41 | Any | Any | "(t1.c4)<-(-1.7976931348623157E308)" and "(t1.c4)<(1.7976931348623157E308)" in where clause return different results |
118297 | 2025-05-29 2:39 | 2025-05-29 12:53 | MySQL Server: Security: Privileges | Verified (23 days) | S3 | 8.0.42, 8.4.5 | Any | Any | password expire and password expire interval when create user is not both work |
118296 | 2025-05-29 2:32 | 2025-05-29 6:03 | MySQL Server: DML | Verified (23 days) | S3 | 8.0.41 | Linux | x86 | When join_buffer_size is set to a different value, the query returns different results. |
118281 | 2025-05-27 15:24 | 2025-05-28 4:42 | MySQL Server: InnoDB storage engine | Verified (24 days) | S3 | 9.3.0 | Any | Any | Contribution: Fix incorrect byte size in mlog read_1_bytes comment |
118278 | 2025-05-27 8:29 | 2025-05-27 9:56 | MySQL Server: DML | Analyzing (25 days) | S3 | 8.0.41 | Any | Any | two query SQL statements filling with opposite semantics in the where clause, result same result |
118277 | 2025-05-27 8:02 | 2025-05-27 8:08 | MySQL Server: DML | Analyzing (25 days) | S3 | 8.0.41 | Any | Any | When a constant value is replaced by the IFNULL(NULL, CONST_VALUE) function, the sql returns different value; |
118269 | 2025-05-26 9:41 | 2025-05-26 12:29 | MySQL Server: Optimizer | Closed (26 days) | S2 | Any | Any | The result of anti disk hash join is wrong | |
118268 | 2025-05-26 7:47 | 2025-05-27 3:30 | MySQL Server: DML | Analyzing (25 days) | S3 | 8.0.41 | Any | Any | The returned results of two queries with the same semantics are inconsistent. |
118266 | 2025-05-26 2:29 | 2025-05-30 7:03 | MySQL Server: Options | Not a Bug (22 days) | S3 | 8.0 | Any | Any | We can't set some session variable even have super privilege |
118265 | 2025-05-25 23:12 | 2025-06-19 16:35 | MySQL Server: InnoDB storage engine | Verified (4 days) | S1 | 9.3.0 | MacOS (15.4.1 (24E263)) | x86 (Quad-Core Intel Core i7) | mysqld hangs durning startup |
118264 | 2025-05-25 15:04 | 2025-05-25 15:04 | MySQL Server: Optimizer | Open | S2 | 9.3.0 | Ubuntu | Any | Performance bug in SEMI JOIN with empty tables |
118252 | 2025-05-22 12:28 | 2025-05-22 13:15 | MySQL Server: DML | Need Feedback (30 days) | S3 | 8.0.41 | Any | Any | When the same table is imported to different databases, the results of the same selection are different. |
118249 | 2025-05-22 9:51 | 2025-05-23 4:14 | MySQL Server: Charsets | Analyzing (29 days) | S3 | 8.0.41 | Linux | Any | Cannot convert string '\xF0\x9F\x98\xA6\xF0\x9F...' from utf8mb4 to latin1 |
118247 | 2025-05-22 6:26 | 2025-05-28 8:41 | MySQL Server: Documentation | Verified (24 days) | S3 | 5.7, 8.0, 8.4, 9.0 | Any | Any | (Documentation)The descriptions for "M" parameter not matched in different chapters |
118239 | 2025-05-21 13:05 | 2025-05-29 13:12 | MySQL Server: DML | Verified (23 days) | S3 | 9.3.0 | Ubuntu (22.04) | Any | Logical Inconsistency in MySQL String Comparison with LIKE and NOT LIKE Operators |
118238 | 2025-05-21 10:46 | 2025-06-02 11:31 | MySQL Server: FULLTEXT search | Verified (19 days) | S3 | 9.3.0,8.0.40, 8.0.42 | Any | Any | Ngram parser boolean phrase search fails with CJK punctuation |
118237 | 2025-05-21 8:44 | 2025-05-21 10:48 | MySQL Server: Charsets | Analyzing (31 days) | S3 | 9.2 | Any | Any | Inconsistent results when using prepared statement or session variables |
118233 | 2025-05-20 13:54 | 2025-05-20 15:04 | MySQL Server: DDL | Verified (32 days) | S2 | 8.0.42 | Any | Any | Fixed a bug in the DDL for invisible indexes. |
118230 | 2025-05-20 2:24 | 2025-06-11 11:02 | MySQL Server: DML | Can't repeat (10 days) | S3 | 8.0.41 | Linux | x86 | When innodb_buffer_pool_size is set to 134217728, the update value is abnormal. |
118224 | 2025-05-19 2:46 | 2025-06-03 6:43 | MySQL Server: DML | Analyzing (18 days) | S3 | 8.0.41 | Any | Any | When a constant value is replaced by the LEST function, the sql returns different value; |
118219 | 2025-05-16 18:03 | 2025-05-19 6:56 | MySQL Server: DDL | Analyzing (33 days) | S3 | 8, 9 | Linux | x86 | Name of constraint affects order of deletion, causing on delete/cascade to fail unexpectedly |
118217 | 2025-05-16 16:11 | 2025-05-26 10:17 | MySQL Server: Optimizer | Analyzing (26 days) | S1 | 8.4.5 | Ubuntu | x86 | Issues with the NULLIF function. |
118210 | 2025-05-16 10:15 | 2025-05-18 16:43 | MySQL Server: Replication | Verified (34 days) | S3 | 8.0.42 | Any | Any | Invisible Index Binlog Replay Bugfix |
118206 | 2025-05-15 13:21 | 2025-05-19 21:21 | MySQL Server: Optimizer | Not a Bug (33 days) | S5 | 8.0.42 | Ubuntu (8.0.42-0ubuntu0.20.04.1) | Any | The optimizer has chosen a poor execution plan. |
118204 | 2025-05-15 7:41 | 2025-05-19 21:22 | MySQL Server: Optimizer | Not a Bug (33 days) | S5 | 8.0.42 | Ubuntu (8.0.42-0ubuntu0.20.04.1) | Any | A poor execution plan can lead to a performance loss of nearly a hundred times. |
118200 | 2025-05-15 1:51 | 2025-05-20 12:12 | MySQL Server: DML | Duplicate (32 days) | S3 | 8.0.41 | Any | Any | The query result using index is different with not used index |
118198 | 2025-05-14 14:16 | 2025-05-19 22:49 | MySQL Server: Optimizer | Verified (33 days) | S2 | 9.3.0 | Ubuntu (22.04) | Any | Different intersection orders lead to more than 20,000 times performance gap |
118197 | 2025-05-14 13:50 | 2025-05-19 21:17 | MySQL Server: Optimizer | Duplicate (33 days) | S3 | 9.3.0 | Ubuntu (22.04) | Any | The opposite ON clause intersects and is always an empty set. |
118196 | 2025-05-14 13:42 | 2025-05-19 21:16 | MySQL Server: Optimizer | Duplicate (33 days) | S2 | 9.3.0 | Ubuntu (22.04) | Any | The opposite HAVING clause intersects and is always an empty set. |
118195 | 2025-05-14 13:34 | 2025-05-20 8:23 | MySQL Server: Optimizer | Not a Bug (32 days) | S2 | 9.3.0 | Ubuntu (22.04) | Any | The opposite WHERE clause intersects and is always an empty set. |
118193 | 2025-05-14 12:26 | 2025-05-18 16:38 | MySQL Server: Tests | Verified (34 days) | S3 | 8.0.42 | MacOS (15.5) | ARM | Test innodb.partition_upgrade_5727_mac_lctn_2 failing with a result difference |
118192 | 2025-05-14 12:05 | 2025-05-19 19:48 | MySQL Server: DML | Analyzing (33 days) | S5 | 8.0.42 | Ubuntu (22.04) | x86 | Performance regression occurs with update statements after 6ba1fef |
118186 | 2025-05-13 15:34 | 2025-05-19 11:51 | MySQL Server: Row Based Replication ( RBR ) | Can't repeat (33 days) | S2 | 8.0.22 | Linux | Any | With row‑based replication (binlog_format = ROW), the function generates duplicate sequence values; in mixed mode (binlo |
118181 | 2025-05-13 12:36 | 2025-05-13 12:47 | MySQL Server: DML | Analyzing (39 days) | S5 | 8.0.42 | Linux | x86 | Performance regression on query statements after commit 0fa789a |
118180 | 2025-05-13 12:18 | 2025-05-13 12:48 | MySQL Server: Command-line Clients | Verified (39 days) | S3 | 8.0.42 | Any | Any | mysql client got segmentation fault since the mysql.charset is null during restarting |
118177 | 2025-05-13 8:53 | 2025-05-22 6:28 | MySQL Server: Optimizer | Verified (30 days) | S3 | 8.0.35 | Any | Any | Unnecessary filter operator in the execution plan |
118174 | 2025-05-13 6:43 | 2025-05-14 7:18 | MySQL Server: Optimizer | Verified (38 days) | S3 | 8.0 | Any | Any | Skip Scan doesn't support non-covering key scan |
118173 | 2025-05-13 6:42 | 2025-05-13 12:46 | MySQL Server: DML | Analyzing (39 days) | S5 | 8.0.42 | Ubuntu (22.04) | x86 | The insert statement suffers a performance penalty after commit cd66c5c. |
118172 | 2025-05-13 3:54 | 2025-05-15 7:52 | MySQL Server: Command-line Clients | Analyzing (39 days) | S3 | 8.0.31 | Windows | x86 ( x86_64) | 猜测间隙锁可以加到普通索引上,导致只能防止插入操作而不能防止select ...for update操作 |
118169 | 2025-05-12 12:38 | 2025-05-15 11:56 | MySQL Server: Tests | Verified (37 days) | S3 | 8.0.42, 8.4.5 | MacOS (15.4.1) | ARM | Test innodb.partition_upgrade_8019_mac_lctn_2_debug failing |
118168 | 2025-05-12 12:27 | 2025-05-13 14:42 | MySQL Server: Replication | Verified (39 days) | S1 | 8.0.41 | Any | Any | MySQL data dictionary fails to upgrade at startup with lock timeout on ALTER TABLE |
118164 | 2025-05-12 8:38 | 2025-05-12 13:01 | MySQL Server: DML | Verified (40 days) | S3 | 8.0.41 | Linux | x86 | When sort_buffer_size is set to a different value, group_concat returns different results. |
118159 | 2025-05-10 2:12 | 2025-05-13 7:37 | MySQL Server: DML | Duplicate (39 days) | S2 | 8.4.3 | Any | Any | recursive CTE with float returns error: Out of range value |
118158 | 2025-05-09 20:09 | 2025-05-12 12:05 | MySQL Server: Optimizer | Verified (40 days) | S5 | 8.4.5 | Any | Any | Endless loop while executing some CTE |
118152 | 2025-05-09 8:45 | 2025-05-09 9:47 | MySQL Server: Stored Routines | Verified (43 days) | S3 | 8.0.42,8.4.5,9.2.0 | Any | Any | BEFORE UPDATE trigger does not use correct NEW.val when val is ON UPDATE CURRENT_TIMESTAMP |
118151 | 2025-05-09 8:35 | 2025-06-11 5:04 | MySQL Server: DDL | Verified (10 days) | S2 | 8.4.5 | Ubuntu (22.04) | x86 | When creating an index: ERROR 1553 (HY000): Cannot drop index '<unknown key name>': needed in a foreign key constraint |
118144 | 2025-05-08 23:35 | 2025-05-14 10:18 | MySQL Server: Optimizer | Verified (38 days) | S5 | 8.0.40, 8.0.42 | Red Hat (RHEL9) | x86 | Performance regression at 8.0.40 related to record buffer usage |
118137 | 2025-05-08 11:49 | 2025-05-08 12:10 | MySQL Server: DML | Verified (44 days) | S3 | 9.3, 8.0, 8.4 | Any | Any | Contradictory query results for decimal data type |
118136 | 2025-05-08 10:10 | 2025-05-08 10:37 | MySQL Server: DDL | Verified (44 days) | S5 | 8.0 | Any | Any | 8.0.27 DDL performance degradation - Flush Observer |
118133 | 2025-05-08 8:40 | 2025-05-08 10:01 | MySQL Server: DDL | Verified (44 days) | S5 | 8.0 | Any | Any | 8.0.27 DDL performance degradation - Scan PK |
118132 | 2025-05-08 8:30 | 2025-05-13 16:01 | MySQL Server: Logging | Verified (39 days) | S3 | 8.0 | Any | Any | Alter general log takes a lot of time during upgrade |
118130 | 2025-05-08 6:53 | 2025-05-08 10:00 | MySQL Server: DDL | Verified (44 days) | S5 | 8.0 | Any | Any | 8.0.27 DDL performance degradation - Merge Sort |
118129 | 2025-05-08 5:01 | 2025-05-19 11:44 | MySQL Server: DDL | Not a Bug (33 days) | S3 | MySQL 8.0 | Any | Any | Is the timing of index statistics update asynchronous when changing the column type with an index? |
118123 | 2025-05-07 8:37 | 2025-05-12 11:22 | MySQL Server: Optimizer | Not a Bug (40 days) | S3 | Any | Any | ORDER BY func(col_name) is bound to the wrong column | |
118121 | 2025-05-06 14:40 | 2025-05-13 8:47 | MySQL Server: InnoDB storage engine | Verified (39 days) | S3 | 8.0.37, 8.0.42 | Any | Any | lob pages leak when mysqld crashed |
118116 | 2025-05-05 17:41 | 2025-06-20 1:00 | MySQL Server: Replication | No Feedback (2 days) | S1 | 8.0.41 | Any | Any | HA_ERR_CORRUPT_EVENT on replication from datetime -> datetime(6) |
118114 | 2025-05-05 12:38 | 2025-05-05 13:01 | MySQL Server: Performance Schema | Verified (47 days) | S3 | 8.0.42 | Any | Any | INFO column in processlist tables truncates long queries despite using longtext type |
118109 | 2025-05-03 12:57 | 2025-05-06 10:52 | MySQL Server: Documentation | Verified (49 days) | S3 | 8.4 | Any | Any | mysqlrouter's routing_strategy is not optional |
118093 | 2025-04-30 7:13 | 2025-04-30 18:06 | MySQL Server: FULLTEXT search | Verified (52 days) | S2 | 8.0.42 | Any | Any | Huge memory usage when inserting into a FTS table with a single transaction. |
118092 | 2025-04-30 3:31 | 2025-06-04 11:36 | MySQL Server: DML | Verified (52 days) | S2 | 8.0.41, 8.0.42, 8.4.5, 9.3.0 | Linux | Any | The query result using index is different with not used index |
118090 | 2025-04-29 17:33 | 2025-05-07 11:55 | MySQL Server: Optimizer | Can't repeat (45 days) | S1 | 9.3 | MacOS | Any | Wrong inner join result with the subquery contain -0 |
118089 | 2025-04-29 14:56 | 2025-05-08 13:57 | MySQL Server: Optimizer | Verified (52 days) | S3 | 8.0.42, 8.4.5, 9.3.0 | Any | Any | COALESCE with BIT field may return wrong values |
118088 | 2025-04-29 14:06 | 2025-04-30 5:27 | MySQL Server: DDL | Verified (53 days) | S5 | 8.0.42 | Any | Any | Optimize DDL handling for redundant invisible index changes |
118085 | 2025-04-29 12:14 | 2025-04-29 13:43 | MySQL Server: Optimizer | Verified (53 days) | S1 | 9.3,9.0,8.0,8.0.42, 8.4.5 | Any | Any | Wrong right join result involving subquery |
118083 | 2025-04-29 9:36 | 2025-04-29 10:25 | MySQL Server: DDL | Verified (53 days) | S5 | 8.0.42 | Any | Any | optimize for invisible indexes ddl |
118080 | 2025-04-29 6:51 | 2025-04-29 8:08 | MySQL Server: Optimizer | Verified (53 days) | S3 | 8.0.42 | Any | Any | The execution plan for the view with UNION ALL uses a full table scan instead of an index. |
118076 | 2025-04-29 3:35 | 2025-04-29 6:50 | MySQL Server: Logging | Verified (53 days) | S3 | 8.0.36, 8.0.42 | Linux (AlmaLinux release 9.2) | Any | When MySQL explains a primary key query for a table that has a varbinary field, show warnings is truncated by the binary |
118074 | 2025-04-28 17:23 | 2025-06-08 1:00 | MySQL Server: InnoDB storage engine | No Feedback (14 days) | S1 | 8.0.40 | Any | x86 | Frequent MySQL Failovers After Upgrade to 8.0.40 |
118073 | 2025-04-28 15:10 | 2025-04-29 6:29 | MySQL Server: Optimizer | Verified (53 days) | S1 | 9.3,9.0,8.0, 8.0.42 | Any | Any | Wrong Inner Join Result |
118072 | 2025-04-28 14:10 | 2025-04-28 14:24 | MySQL Server: DDL | Verified (54 days) | S5 | 8.0 | Any | Any | Optimize DDL operations involving AUTO_INCREMENT columns |
118071 | 2025-04-28 13:09 | 2025-04-28 14:07 | MySQL Server: Optimizer | Verified (54 days) | S2 | 8.0.41, 8.0.42, 8.4.5, 9.3.0 | Any | Any | Indexed table fails WHERE filtering with different charset value |
118069 | 2025-04-28 9:28 | 2025-06-10 20:43 | MySQL Server: Security: Privileges | Verified (11 days) | S3 | 8.0.42 | Any | Any | Inappropriate error message about passwords policies when revoking rights from an non-existing user |
118068 | 2025-04-28 9:23 | 2025-04-28 10:40 | MySQL Server: Documentation | Verified (54 days) | S3 | 8.4 | Any | Any | Documentation typo for versions |
118063 | 2025-04-27 19:02 | 2025-04-28 7:39 | MySQL Server: Optimizer | Verified (54 days) | S1 | 9.0, 8.0, 8.0.42, 8.4.5, 9.3.0 | Any | Any | Wrong Join Result after creating index on expressions |
118061 | 2025-04-26 13:02 | 2025-04-28 7:40 | MySQL Server: Optimizer | Verified (54 days) | S1 | 9.3, 8.4.5, 8.0.42 | Any | Any | wrong inner join result when adding an additional true expression |
118058 | 2025-04-25 9:48 | 2025-04-25 13:04 | MySQL Server: DDL | Duplicate (57 days) | S5 | 8.0 | Any | Any | optimize for check_promoted_index |
118057 | 2025-04-25 9:48 | 2025-04-25 13:05 | MySQL Server: DDL | Verified (57 days) | S5 | 8.0 | Any | Any | optimize for check_promoted_index |
118056 | 2025-04-25 9:14 | 2025-04-25 9:25 | MySQL Server: DDL | Verified (57 days) | S5 | 8.0 | Any | Any | optimzie for alter index |
118054 | 2025-04-24 16:23 | 2025-05-07 15:55 | MySQL Server: InnoDB storage engine | Verified (46 days) | S5 | Any | Any | Potential optimization in row_ins_sec_index_entry_low(): avoid second btr_cur_search_to_nth_level() under certain condit | |
118053 | 2025-04-24 15:47 | 2025-05-19 2:25 | MySQL Server: DML | Verified (57 days) | S2 | 8.4.3, 9.3.0, 8.4.5, 8.0.42 | CentOS | Any | cast((NULLIF) as datetime) returns incorrect result |
118048 | 2025-04-24 4:27 | 2025-06-05 13:01 | MySQL Server: DDL | Not a Bug (16 days) | S3 | 8.0.41 | Any | Any | create partition table has same part field name with variable report error |
118046 | 2025-04-23 21:21 | 2025-05-22 10:34 | MySQL Server: Stored Routines | Verified (30 days) | S2 | 8.0 | Any | Any | KILL (QUERY) should check thread ownership against the security context that initiated the current operation |
118040 | 2025-04-23 11:35 | 2025-04-23 13:00 | MySQL Server: Replication | Verified (59 days) | S5 | 8.0 | Any | Any | Reduce Redundant init_and_set_log_file_name Calls |
118037 | 2025-04-23 8:56 | 2025-05-02 7:22 | MySQL Server: DML | Duplicate (50 days) | S3 | 8.4.3 | CentOS | Any | column with numeric type doesn't work expected in condition |
118033 | 2025-04-22 14:51 | 2025-04-23 8:09 | MySQL Server: Optimizer | Verified (59 days) | S2 | 9.3.0 | Any | Any | Wrong Result of an and expression |
118024 | 2025-04-21 12:46 | 2025-04-23 8:07 | MySQL Server: Optimizer | Verified (61 days) | S1 | 9.3.0 | Any | Any | Wrong Right Join involving a predicate containing IFNULL and IN |
118022 | 2025-04-21 4:12 | 2025-04-28 12:23 | MySQL Server: DML | Not a Bug (54 days) | S2 | Any | Any | between date and str_TO_DATE in select where returns incorrect result | |
118020 | 2025-04-20 23:23 | 2025-05-19 14:51 | MySQL Server: Optimizer | Verified (33 days) | S1 | 9.2.0, 9.3.0 | Any (22.04) | Any | A critical logic bug and performance bug |
118019 | 2025-04-20 16:30 | 2025-04-21 7:56 | MySQL Server: Optimizer | Verified (61 days) | S2 | 9.0, 8.0, 9.3.0, 8.4.5, 8.0.42 | Any | Any | Wrong Right Join with a subquery containing distinct and wrong NULL-value expression optimization |
118018 | 2025-04-20 13:49 | 2025-05-19 14:53 | MySQL Server: Optimizer | Verified (33 days) | S1 | 9.2.0, 9.3.0 | Ubuntu (22.04) | Any | A query expose a logic bug and performance bug |
118017 | 2025-04-20 10:59 | 2025-05-19 14:53 | MySQL Server: Optimizer | Verified (33 days) | S5 | 9.2.0, 9.3.0 | Ubuntu (22.04) | Any | A very serious performance bug |
118016 | 2025-04-20 10:34 | 2025-04-21 12:52 | MySQL Server: Optimizer | Verified (62 days) | S2 | 9.3, 9.0, 8.0, 8.0.42 | Any | Any | Wrong inner join result involving subquery containing distinct |
118015 | 2025-04-20 7:18 | 2025-05-19 14:52 | MySQL Server: Optimizer | Verified (33 days) | S5 | 9.2.0, 9.3.0 | Ubuntu (22.04) | Any | The query which always return a empty result should not comsume executing time |
118014 | 2025-04-19 16:53 | 2025-04-20 13:53 | MySQL Server: Optimizer | Verified (62 days) | S2 | 9.3.0,8.0, 8.0.42, 8.4.5, 9.3.0 | Any | Any | Wrong Left Join Result |
118011 | 2025-04-18 13:26 | 2025-04-24 0:26 | MySQL Server: Data Types | Verified (59 days) | S3 | 8.0.41 | Any | Any | Timestamp literals with fractional seconds and time zone offset do not convert correctly |
118010 | 2025-04-18 9:46 | 2025-04-24 0:27 | MySQL Server: Options | Verified (59 days) | S2 | 8.0.39 | FreeBSD (13.3/14.1) | Any | "Could not increase number of max_open_files to more than 32768" |
118009 | 2025-04-18 7:13 | 2025-05-20 12:12 | MySQL Server: Optimizer | Verified (64 days) | S5 | 8.4.5, 9.3.0 | Debian (12) | x86 (amd64) | SELECT query on primary key column deteriorates to full table scan when filter involves too long string |
118007 | 2025-04-18 2:24 | 2025-04-25 13:30 | MySQL Server: DML | Not a Bug (57 days) | S2 | 8.4.3 | Any | Any | str_TO_DATE( '1980-07-06','YYYY-MM-DD HH24:MI:SS') in dml reports error |
118001 | 2025-04-17 4:15 | 2025-04-21 12:26 | MySQL Server: DML | Verified (61 days) | S2 | 8.4.3, 8.4.5 | Any | Any | delete sql returns error: Temporary file write failure. |
117998 | 2025-04-16 9:49 | 2025-04-16 12:27 | MySQL Server: Documentation | Verified (66 days) | S3 | 8.0, 8.4 | Any | Any | The SERVICE_CONNECTION_ADMIN privilege is not in the index. |
117994 | 2025-04-16 8:58 | 2025-04-17 10:45 | MySQL Server: Documentation | Closed (65 days) | S3 | 8.0.42, 8.4.5, 9.3.0 | Any | Any | Incorrect bug ref in 8.0.42 release notes |
117964 | 2025-04-14 6:21 | 2025-04-16 12:02 | MySQL Server: DDL | Verified (66 days) | S2 | 8.0.41, 8.0.42 | Any | Any | Inconsistent Query Results Between Primary Key and Secondary Index After Online DDL Execution |
117962 | 2025-04-13 15:19 | 2025-04-13 17:26 | MySQL Server: InnoDB storage engine | Verified (69 days) | S3 | 8.0.37, 8.0.41, 9.2.0 | Any | Any | ibd2sdi failed when table COMPRESSION='lz4' |
117961 | 2025-04-13 9:26 | 2025-04-14 19:39 | MySQL Server: Documentation | Closed (68 days) | S3 | 8.0, 8.4, 9.2 | Any | Any | --flush only affects MyISAM storage engine, but RefMan doesn't describe it |
117959 | 2025-04-13 0:31 | 2025-04-13 16:37 | MySQL Server: Optimizer | Verified (69 days) | S2 | 9.2.0 | Ubuntu (22.04) | Any | PRIMARY KEY leads to incorrect INTERSECT result |
117950 | 2025-04-11 13:46 | 2025-04-15 13:02 | MySQL Server: Security: Privileges | Closed (67 days) | S3 | 8.4.4 | Any (OL9) | Any (OL9.5) | Grant statements using netmasks don't support subnets other than those ending with a decimal 0 |
117945 | 2025-04-11 11:10 | 2025-04-11 12:23 | MySQL Server: Optimizer | Verified (71 days) | S2 | 9.2.0 | Ubuntu (22.04) | Any | UNION operation may return wrong result[ |
117943 | 2025-04-11 8:07 | 2025-05-13 12:31 | MySQL Server: InnoDB storage engine | Verified (46 days) | S3 | 8.4.4, 9.2.0 | Any | Any | Startup ibd-file validation uses too much CPU threads |
117941 | 2025-04-10 13:29 | 2025-04-10 14:45 | MySQL Server: Optimizer | Verified (72 days) | S2 | 8.0.41, 8.4.4, 9.2.0 | Any | Any | Inconsistent query results with / without NOT NULL for BLOB type |
117931 | 2025-04-10 9:57 | 2025-05-16 1:00 | MySQL Server: InnoDB storage engine | No Feedback (37 days) | S3 | 8.0.22 | Any | Any | virtual column index record wrong data |
117930 | 2025-04-10 8:29 | 2025-04-11 16:53 | MySQL Server: Optimizer | Not a Bug (71 days) | S2 | 9.2.0, 8.4.4, 8.0.41 | Ubuntu (22.04) | Any | INTERSECT operation fails on INT ZEROFILL column type. |
117926 | 2025-04-09 19:08 | 2025-04-11 21:03 | MySQL Server: Optimizer | Not a Bug (71 days) | S2 | 8.0.41, 9.2.0, 8.4.4 | Ubuntu (22.04) | Any | INTERSECT may incorrectly eliminate duplicate |
117917 | 2025-04-08 16:01 | 2025-05-10 1:00 | MySQL Server: InnoDB storage engine | No Feedback (43 days) | S1 | 8.0.32、5.7.44 | Linux | x86 | InnoDB: Failing assertion: lock->lock_word == X_LOCK_DECR |
117911 | 2025-04-08 12:06 | 2025-04-08 14:45 | MySQL Server: Optimizer | Verified (74 days) | S2 | 9.2.0 | Ubuntu (22.04) | Any | INTERSECT operation return wrong result |
117907 | 2025-04-08 8:02 | 2025-05-15 15:30 | MySQL Server: Optimizer | Closed (37 days) | S5 | 8.4.4, 9.2.0 | Any | Any | Performance degradation in MySQL>=8.4 vs MySQL 8.0 due to redundant condition not optimized away |
117898 | 2025-04-07 8:26 | 2025-05-08 10:10 | MySQL Server: InnoDB storage engine | Verified (51 days) | S3 | 8.0.41 | Any | Any | User Records may be skipped when Persistent Cursor restores Infimum and Supremum Record |
117878 | 2025-04-03 17:41 | 2025-04-04 12:01 | MySQL Server: Row Based Replication ( RBR ) | Unsupported (78 days) | S1 | MySQL 8.0.28 | Linux | Any | Update Ignore and Replace Into Statements fails to replicate on Replica in MySQL 8.0.28 |
117867 | 2025-04-03 8:32 | 2025-04-09 10:19 | MySQL Server: Optimizer | Verified (73 days) | S5 | 8.0.41 | Any | Any | use distinct+left join, MySQL 8.0 excute long time than MySQL 5.7 |
117860 | 2025-04-02 10:44 | 2025-05-12 12:20 | MySQL Server: Optimizer | Verified (40 days) | S2 | 9.2.0 | Any (Ubuntu 22.04) | Any | Read another insertion WITH CONSISTENT SNAPSHOT |
117856 | 2025-04-02 7:42 | 2025-04-02 8:01 | MySQL Server: Optimizer | Verified (80 days) | S2 | 9.1.0, 8.0.41, 8.4.4, 9.2.0 | Ubuntu (20.04) | Any | REPEAT Function Causes Row Loss in WHERE Clause |
117855 | 2025-04-02 7:37 | 2025-04-02 8:15 | MySQL Server: Optimizer | Verified (80 days) | S2 | 9.1.0 , 8.0.41, 8.4.4, 9.2.0 | Ubuntu (20.04) | Any | QUOTE Function Incorrectly Handles NULL Values |
117854 | 2025-04-02 7:31 | 2025-04-02 8:35 | MySQL Server: Optimizer | Verified (80 days) | S2 | 9.1.0, 8.0.41, 8.4.4, 9.2.0 | Ubuntu (20.04) | Any | Incorrect Filtering Behavior of MAKE_SET Function |
117853 | 2025-04-02 7:23 | 2025-04-02 9:27 | MySQL Server: Optimizer | Verified (80 days) | S2 | 9.1.0, 8.0.41, 8.4.4, 9.2.0 | Ubuntu (20.04) | Any | Incorrect Result When Using LEFT OUTER JOIN with Subquery |
117852 | 2025-04-02 7:14 | 2025-04-08 15:00 | MySQL Server: Optimizer | Verified (80 days) | S2 | 9.1.0, 8.0.41, 8.4.4, 9.2.0 | Ubuntu (20.04) | Any | Incorrect Handling of NULL Values with FIELD Function in SQL Query |
117851 | 2025-04-02 7:05 | 2025-04-02 9:45 | MySQL Server: Optimizer | Verified (80 days) | S2 | 9.1.0, 8.0.41, 8.4.4, 9.2.0 | Ubuntu (20.04) | Any | Incorrect Behavior of EXISTS Condition with OR in SQL Query |
117849 | 2025-04-02 6:52 | 2025-04-02 9:48 | MySQL Server: Optimizer | Verified (80 days) | S2 | 9.1.0, 8.0.41, 8.4.4, 9.2.0 | Ubuntu (20.04) | Any | Incorrect Query Results When Using Nested String Operation Functions with Conditional Expressions as Inner Parameters |
117848 | 2025-04-02 6:37 | 2025-04-02 9:50 | MySQL Server: Optimizer | Verified (80 days) | S2 | 9.1.0, 8.0.41, 8.4.4, 9.2.0 | Ubuntu (20.04) | Any | INTERVAL Function Incorrectly Filters Results in WHERE Clause |
117847 | 2025-04-02 6:29 | 2025-04-02 7:47 | MySQL Server: Optimizer | Verified (80 days) | S2 | 9.1.0 , 8.0.41, 8.4.4, 9.2.0 | Ubuntu (20.04) | Any | NULLIF Filtering Fails in WHERE Clause |
117845 | 2025-04-01 18:15 | 2025-04-14 21:10 | MySQL Server: Optimizer | Closed (68 days) | S3 | 8.0.41 | Ubuntu | Any | WHERE ... IN Returning Unexpected Row |
117835 | 2025-03-31 10:44 | 2025-05-12 12:18 | MySQL Server: InnoDB storage engine | Verified (40 days) | S2 | 9.2.0 | Any (Ubuntu 22.04) | Any | Non Repeatable Read WITH CONSISTENT SNAPSHOT |
117834 | 2025-03-31 3:43 | 2025-04-01 7:20 | MySQL Server: Optimizer | Verified (81 days) | S3 | 9.2, 8.0.41, 8.4.4 | Ubuntu | x86 | Double negation on booleans incorrectly returns negated value |
117811 | 2025-03-27 15:19 | 2025-04-03 14:22 | MySQL Server: Optimizer | Verified (85 days) | S1 | 8.4.4, 8.0.41, 9.2.0 | Any | Any | Incorrect query results for BLOB type |
117809 | 2025-03-27 13:06 | 2025-03-27 20:10 | MySQL Server: Optimizer | Verified (86 days) | S5 | Any | Any | Statistics update failed. | |
117808 | 2025-03-27 7:21 | 2025-03-27 10:01 | MySQL Server: Prepared statements | Verified (86 days) | S3 | 8.0.41, 8.4.2 | Any | Any | Unexpected JSON column DML error with prepare statement |
117797 | 2025-03-26 5:55 | 2025-06-04 2:18 | MySQL Server: Optimizer | Not a Bug (17 days) | S1 | 9.2.0 | Any (Ubuntu 22.04) | Any | Lost Update WITH CONSISTENT SNAPSHOT |
117791 | 2025-03-25 13:30 | 2025-03-25 13:48 | MySQL Server: Optimizer | Verified (88 days) | S3 | 8.0, 8.4, 9.2 | Any | Any | FORCE INDEX does not skip records_in_range() for 'x IS NULL' |
117783 | 2025-03-25 8:45 | 2025-03-26 8:20 | MySQL Server: Optimizer | Verified (87 days) | S2 | 8.0.32, 8.0.41 | Any | Any | optimizer selects the wrong index due to the "low_limit" mechanism |
117782 | 2025-03-25 2:54 | 2025-03-25 9:42 | MySQL Server: Replication | Won't fix (88 days) | S3 | 5.7.44 | Any | Any | Semi-synchronous replication causes significant performance degradation |
117778 | 2025-03-24 10:23 | 2025-05-12 9:23 | MySQL Server: InnoDB storage engine | Verified (89 days) | S3 | 8.0, 8.4, 9.2 | Any | Any | AHI hash table memory is invisible to Performance Schema |
117777 | 2025-03-24 9:15 | 2025-03-26 5:03 | MySQL Server: InnoDB storage engine | Can't repeat (87 days) | S1 | 8.0.31 | Any | Any | mysql crash Assertion failure: rec.cc:384 |
117776 | 2025-03-24 5:01 | 2025-03-24 7:46 | MySQL Server: Optimizer | Verified (89 days) | S3 | 8.0, 8.4, 9.2 | Any | Any | Index statistics is unexpectedly used to estimate eq ranges with null part |
Showing all 187 (Edit, Save, CSV, Feed) |