Showing 1-30 of 745 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
105899 | 2021-12-15 3:23 | 2022-01-25 15:43 | MySQL Server: Optimizer | Verified (861 days) | S2 | 8.0.27, 5.7 | Any | Any | Result mismatch when derived_merge |
105975 | 2021-12-25 3:13 | 2023-11-28 9:44 | MySQL Server: Optimizer | Verified (851 days) | S2 | 8.0.22,8.0.27 | Linux | Any | When I set duplicateweedout=ON,I got an incorrect query result. |
106003 | 2021-12-29 20:06 | 2022-11-29 7:53 | MySQL Server: Optimizer | Verified (846 days) | S3 | 8.0.27/5.7 | Any | Any | MySQL does not use indexes correctly for backwards ORDER BY conditions |
106090 | 2022-01-07 4:45 | 2022-01-07 6:42 | MySQL Server: Optimizer | Verified (838 days) | S2 | 8.0, 5.7.36, 8.0.27 | Any | Any | query through *prefix index defined on virutal column* may see unexpected result |
106155 | 2022-01-13 7:19 | 2022-01-13 8:34 | MySQL Server: Optimizer | Verified (832 days) | S2 | mysql Ver 8.0.27 for Linux on x86_64 (M | Any | Any | subquery return wrong record when use expression index |
106208 | 2022-01-19 7:37 | 2022-01-21 9:27 | MySQL Server: Optimizer | Verified (826 days) | S3 | 8.0.27, 8.0.28, 5.7.37 | Any | Any | IF function with DECIMAL get different precision result |
106264 | 2022-01-24 16:33 | 2022-01-25 15:07 | MySQL Server: Optimizer | Verified (820 days) | S2 | 5.7 | Any | Any | Contribution by Tencent: Prevent badly stale rec_per_key for query optimization |
106297 | 2022-01-26 22:39 | 2022-01-27 6:00 | MySQL Server: Optimizer | Verified (818 days) | S2 | 8.0.27, 8.0.28 | Ubuntu (Ubuntu 20.04.3 LTS) | x86 (x86 (Intel(R) Core(TM) i7-10700 CPU @ 2.90GHz)) | Incorrect outputs when combine unique index with NULL |
106312 | 2022-01-27 18:14 | 2022-02-09 13:20 | MySQL Server: Optimizer | Verified (817 days) | S3 | 5.7 | Any (Ubuntu 20.04.3 LTS) | Any (Intel(R) Core(TM) i7-10700 CPU @ 2.90GHz) | Huge value in GROUP BY clause cause unexpected output |
106428 | 2022-02-09 22:31 | 2022-02-10 7:23 | MySQL Server: Optimizer | Verified (804 days) | S2 | 8.0.28 | Any | Any | Unexpected aggregation result on lateral join |
106473 | 2022-02-16 8:55 | 2022-03-10 9:27 | MySQL Server: Optimizer | Verified (776 days) | S3 | 8.0.28 | Any | Any | Inner table of OUT-JOIN is nullable, after applying OUTER2INNER transformation |
106486 | 2022-02-17 9:27 | 2022-02-17 9:48 | MySQL Server: Optimizer | Verified (797 days) | S2 | 8.0.26, 8.0.28 | Any | Any | The union query returns an incorrect result |
106509 | 2022-02-18 13:15 | 2022-02-18 13:43 | MySQL Server: Optimizer | Verified (796 days) | S2 | 8.0.28 | Any | Any | Query by multi-valued index and order by desc by another index return one row |
106521 | 2022-02-20 13:00 | 2022-02-21 10:32 | MySQL Server: Optimizer | Verified (793 days) | S3 | 8.0.28 | Any | Any | Backward index scan is not shown for UPDATE/DELETE |
106542 | 2022-02-23 3:12 | 2022-02-28 1:06 | MySQL Server: Optimizer | Verified (791 days) | S5 | 8.0.27, 5.7.37, 8.0.28 | Any (rhel-7.4) | Any (x86-64) | in clause on range columns partitioned table is not partition-pruned well |
106580 | 2022-02-26 9:41 | 2022-03-02 14:56 | MySQL Server: Optimizer | Verified (784 days) | S3 | 8.0 | Any | Any | Multi-Valued Indexes only takes into account a portion of a whole data. |
106651 | 2022-03-07 4:34 | 2022-03-11 14:21 | MySQL Server: Optimizer | Verified (779 days) | S1 | 5.7.*, 5.7.37, 8.0.28 | Any | Any | Query wrong result when the condition is "where id ('decimal_a', 'decimal_b')" |
106654 | 2022-03-07 12:06 | 2022-03-10 14:01 | MySQL Server: Optimizer | Verified (776 days) | S5 | 8.0 | Any | Any | join on json key can not use index, but join on virtual column can use index |
106713 | 2022-03-12 6:02 | 2022-03-12 8:16 | MySQL Server: Optimizer | Verified (774 days) | S2 | 8.0.28 | Any | Any | Incorrect Semi-join Execution |
106715 | 2022-03-12 11:19 | 2022-03-14 10:29 | MySQL Server: Optimizer | Verified (772 days) | S2 | 8.0.27 | Any | Any | Incorrect left hash join with subquery in condition |
106716 | 2022-03-12 15:15 | 2022-03-14 10:33 | MySQL Server: Optimizer | Verified (772 days) | S2 | 8.0.28 | Any | Any | Incorrect Inner hash join when transforming materialization condition. |
106717 | 2022-03-13 3:54 | 2022-03-14 10:36 | MySQL Server: Optimizer | Verified (772 days) | S2 | 8.0.28, 8.0.27 | Any | Any | Incorrect nested loop antijoin when using materialization strategy |
106754 | 2022-03-17 7:06 | 2022-03-21 13:52 | MySQL Server: Optimizer | Verified (769 days) | S5 | 5.7, 8.0, 5.7.37, 8.0.28 | Any | Any | Index-loose scan doesn't work for signle table partition Query |
106850 | 2022-03-28 8:43 | 2022-03-28 14:45 | MySQL Server: Optimizer | Verified (758 days) | S3 | 8.0 | Any | Any | wrong result when two table join |
106938 | 2022-04-07 2:26 | 2022-04-08 1:35 | MySQL Server: Optimizer | Verified (747 days) | S1 | 8.0, 8.0.28 | Any | Any | lateral derived table with LIMIT produces wrong result |
107035 | 2022-04-15 9:12 | 2022-04-15 13:34 | MySQL Server: Optimizer | Verified (740 days) | S5 | 8.0 | Any | Any | MRR may cause performance downgrade when multi-range on partition key |
107220 | 2022-05-05 9:18 | 2022-05-11 14:09 | MySQL Server: Optimizer | Verified (720 days) | S3 | MySQL 8.0, 8.0.29 | Any | Any | Json query results are inconsistent with or without generated column indexes |
107261 | 2022-05-11 10:31 | 2022-05-11 11:18 | MySQL Server: Optimizer | Verified (714 days) | S3 | 8.0.29 | Any | Any | Wrong us of dbug_dump |
107286 | 2022-05-13 9:06 | 2022-05-13 9:30 | MySQL Server: Optimizer | Verified (712 days) | S3 | 8.0.29 | Any | Any | Recursive correlated derived table does not work correctly |
107292 | 2022-05-14 0:37 | 2022-05-17 9:46 | MySQL Server: Optimizer | Verified (711 days) | S5 | 8.0.21, 5.7, 8.0 | Any | Any | Index isn't used for order if some primary key columns specified in index |
Showing 1-30 of 745 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |