| « Show Previous 30 Entries | Showing 31-60 of 740 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 107324 | 2022-05-18 9:50 | 2022-05-18 14:33 | MySQL Server: Optimizer | Verified (702 days) | S2 | 8.0 | Any | Any | Query with exists provides inconsistent result |
| 107337 | 2022-05-19 6:08 | 2023-04-14 13:19 | MySQL Server: Optimizer | Verified (701 days) | S3 | 8.0.27, 5.7, 8.0.29, 8.0.32 | Linux | ARM | IN() does not work correctly for TIME column |
| 107535 | 2022-06-09 22:56 | 2023-08-03 19:35 | MySQL Server: Optimizer | Verified (260 days) | S3 | 8.0.29, 5.7.38 | Any | Any | Group by does not use loose scan unless full prefix is given |
| 107554 | 2022-06-13 20:28 | 2022-06-14 16:02 | MySQL Server: Optimizer | Verified (675 days) | S5 | 8.0.29-0ubuntu0.20.04.3 | Ubuntu (20.04.4 LTS) | x86 | regexp_replace in trigger VERY slow when using unicode category \\p{C} |
| 107569 | 2022-06-15 8:56 | 2022-06-15 9:21 | MySQL Server: Optimizer | Verified (674 days) | S2 | 8.0.29 | Linux | x86 | WHERE clause didn’t work with INNER JOIN, WITH, and UNION ALL. |
| 107576 | 2022-06-16 7:34 | 2022-06-16 9:24 | MySQL Server: Optimizer | Verified (673 days) | S3 | 8.0.29 | Ubuntu (ubuntu 20.04) | x86 | Incorrect result when comparing 0 and -0 when using materialization-lookup |
| 107585 | 2022-06-17 10:29 | 2022-06-17 11:18 | MySQL Server: Optimizer | Verified (672 days) | S3 | 8.0.29 | Ubuntu (ubuntu 20.04) | x86 | Incorrect result in semi-join and left-join |
| 107598 | 2022-06-20 4:40 | 2022-06-20 5:34 | MySQL Server: Optimizer | Verified (669 days) | S2 | 5.7.38 | Any | Any | Optimizer materialization leads to wrong result |
| 107607 | 2022-06-20 9:34 | 2022-06-20 9:51 | MySQL Server: Optimizer | Verified (669 days) | S2 | 8.0.29 | Ubuntu | x86 | left join + semijoin + materialization finds false matches |
| 107629 | 2022-06-22 8:41 | 2022-06-22 10:06 | MySQL Server: Optimizer | Verified (667 days) | S3 | 8.0.29 | Any | Any | Incorrect result when using index and materialization-lookup |
| 107789 | 2022-07-07 3:05 | 2022-07-12 11:50 | MySQL Server: Optimizer | Verified (652 days) | S3 | 8.0 | Ubuntu | x86 | can not get only one row when select where id=round() |
| 107821 | 2022-07-08 18:02 | 2022-07-20 6:36 | MySQL Server: Optimizer | Verified (648 days) | S3 | 8.0, 8.0.29 | Any | Any | Result error : SQL with group by with rollup and const field |
| 107969 | 2022-07-26 3:48 | 2022-07-26 5:29 | MySQL Server: Optimizer | Verified (633 days) | S2 | 8.0.29 | Any | Any | wrong result when search binary columns |
| 107972 | 2022-07-26 7:30 | 2022-07-26 8:39 | MySQL Server: Optimizer | Verified (633 days) | S3 | 8.0.29 | Any | Any | Contribution by Tencent: comment mistake in get_best_ror_intersect |
| 108114 | 2022-08-11 7:59 | 2022-08-11 9:24 | MySQL Server: Optimizer | Verified (617 days) | S3 | 8.0.30 | Any | Any | query return different result with or without index |
| 108116 | 2022-08-11 8:21 | 2022-08-11 9:24 | MySQL Server: Optimizer | Verified (617 days) | S3 | 8.0.29, 8.0.30, 5.7.39 | Any (rhel-7.4) | Any (x86-64) | SQL queries with range of Item_row are not optimized |
| 108127 | 2022-08-12 5:57 | 2022-08-16 13:34 | MySQL Server: Optimizer | Verified (612 days) | S5 | 8.0.29 | Any | Any | MySQL optimizer chooses to a inefficient index . |
| 108150 | 2022-08-16 13:19 | 2023-01-27 16:19 | MySQL Server: Optimizer | Verified (448 days) | S3 | 8.0.30 | Ubuntu (22.04.1) | x86 (x86_x64) | ALL query with UNION and ROLLUP wrong result |
| 108192 | 2022-08-18 13:16 | 2022-08-19 9:06 | MySQL Server: Optimizer | Verified (610 days) | S2 | 8.0.23, 8.0.30 | Any | Any | Different results return when executing the same query with different plans |
| 108233 | 2022-08-23 6:43 | 2022-08-23 7:53 | MySQL Server: Optimizer | Verified (605 days) | S3 | 5.7.39, 8.0.30 | Any | Any | Alias displayed incorrectly with "Use temporary" |
| 108239 | 2022-08-23 8:46 | 2022-09-05 8:03 | MySQL Server: Optimizer | Verified (592 days) | S5 | 8.0 | Any | Any | Optimizer don't choose ICP when using filesort. |
| 108315 | 2022-08-29 8:27 | 2023-06-07 15:17 | MySQL Server: Optimizer | Verified (599 days) | S2 | 8.0, 8.0.30 | Linux | Any | Wrong result with union and small memory tmp table |
| 108516 | 2022-09-16 1:50 | 2022-09-19 13:24 | MySQL Server: Optimizer | Verified (581 days) | S2 | 8.0.21 | Any | Any | Return value of my_b_flush_io_cache(IO_CACHE*, int) not get checked |
| 108520 | 2022-09-16 7:54 | 2022-09-16 8:05 | MySQL Server: Optimizer | Verified (581 days) | S2 | 8.0, 8.0.30, 5.7.39 | Linux | Any | Return different result due to different optimizer switch |
| 108528 | 2022-09-18 10:28 | 2022-09-20 5:25 | MySQL Server: Optimizer | Verified (577 days) | S2 | 8.0.30 | Ubuntu (20.04) | x86 | Inconsistent read and write, which use the same predicate (WHRE clause) |
| 108548 | 2022-09-20 6:37 | 2022-09-20 7:35 | MySQL Server: Optimizer | Verified (577 days) | S2 | 5.7, 5.7.39 | Any | Any | GROUP_CONCAT NOT SET USED_TABLES WHEN DERIVED_MERGE. |
| 108659 | 2022-09-30 7:18 | 2022-09-30 9:54 | MySQL Server: Optimizer | Verified (567 days) | S3 | 8.0.30 | Any | Any | multi-valued index get wrong result |
| 108788 | 2022-10-15 7:34 | 2022-10-17 7:00 | MySQL Server: Optimizer | Verified (550 days) | S3 | 5.7.40 | Linux | Any | The temporary alias is incorrect when the SQL statement is executed. |
| 108833 | 2022-10-20 10:11 | 2022-10-20 12:35 | MySQL Server: Optimizer | Verified (547 days) | S5 | 8.0.31 | Ubuntu (20.04) | x86 | Suspicious Estimated Rows |
| 108851 | 2022-10-22 1:55 | 2022-10-22 5:42 | MySQL Server: Optimizer | Verified (545 days) | S5 | 8.0.31 | Ubuntu (20.04) | x86 | Suspicious Estimated Rows by JOIN |
| « Show Previous 30 Entries | Showing 31-60 of 740 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
