| Showing 1-30 of 466 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 102850 | 2021-03-07 18:55 | 2021-03-08 6:01 | MySQL Server: Optimizer | Verified | S5 | 8.0.23 | Any | Any | MySQL does not use functional index on the function LOG10 |
| 102686 | 2021-02-22 12:50 | 2021-02-24 16:01 | MySQL Server: Optimizer | Verified (12 days) | S5 | 8.0 | Any | Any | The query plan changed cause query too long |
| 102681 | 2021-02-22 5:29 | 2021-02-22 6:05 | MySQL Server: Optimizer | Verified (14 days) | S3 | 8.0,5.7.33, 8.0.23 | Any | Any | result of "datetime_val not between NULL and NULL" is unexpected |
| 102656 | 2021-02-19 3:52 | 2021-02-19 6:59 | MySQL Server: Optimizer | Verified (17 days) | S3 | 8.0.22, 8.0.23 | Any | Any | SELECT results containing the special character " ︠e " is different |
| 102655 | 2021-02-19 3:07 | 2021-02-19 6:34 | MySQL Server: Optimizer | Verified (17 days) | S3 | 8.0, 8.0.23 | Any | Any | results from SELECT are different when use WHERE or not |
| 102634 | 2021-02-18 3:26 | 2021-02-18 7:36 | MySQL Server: Optimizer | Verified (18 days) | S3 | 8.0.17+ | Any | Any | Optimizer loses part of range when OR multiple identical ranges in range plan |
| 102481 | 2021-02-04 15:37 | 2021-02-05 14:40 | MySQL Server: Optimizer | Verified (31 days) | S3 | 8.0.23 | Any | Any | EXPLAIN FOR CONNECTION not good |
| 102468 | 2021-02-03 10:06 | 2021-02-03 10:21 | MySQL Server: Optimizer | Verified (33 days) | S3 | 8.0.22, 8.0.23 | Any | Any | Temptable storage engine returns error: doesn't support update of indexes |
| 102444 | 2021-02-02 1:10 | 2021-02-02 5:20 | MySQL Server: Optimizer | Verified (34 days) | S2 | 5.7.22 - 5.7.32; 8.0.12, 5.7.33 | Any | x86 | Dependent subquery with ORDER BY return NULL value |
| 102429 | 2021-01-30 8:52 | 2021-01-31 3:00 | MySQL Server: Optimizer | Verified (37 days) | S2 | 8.0.23 | Any | Any | Table #sql13c8_4a4_d' uses an extension that doesn't exist in this MySQL version |
| 102359 | 2021-01-24 8:57 | 2021-01-27 18:48 | MySQL Server: Optimizer | Verified (40 days) | S2 | 8.0.23 | Any | Any | Functional Index ignored by Select query from within a Stored Function |
| 102292 | 2021-01-19 9:54 | 2021-03-03 8:04 | MySQL Server: Optimizer | Verified (47 days) | S3 | 8.0.22, 8.0.23 | Any (CentOS Linux release 8.0.1905 (Core)) | Any (4.18.0-80.el8.x86_64 ) | ANALYZE TABLE capitalized table name, statistics results are not updated. |
| 102291 | 2021-01-19 9:17 | 2021-01-19 9:58 | MySQL Server: Optimizer | Verified (48 days) | S1 | 8.0, 8.0.22, 8.0.23 | Any | Any | Subquery produces wrong result when set big_tables = 1 |
| 102252 | 2021-01-15 5:57 | 2021-01-15 8:31 | MySQL Server: Optimizer | Verified (52 days) | S3 | 8.0.22 | Ubuntu (20.04.1) | x86 | INSERT,SELECT from same table with aggregate and NOW() columns produces error |
| 102251 | 2021-01-15 4:42 | 2021-01-15 11:29 | MySQL Server: Optimizer | Verified (52 days) | S2 | 8.0, 8.0.22 | Any | Any | CTE produces wrong result |
| 102181 | 2021-01-07 14:23 | 2021-01-12 11:12 | MySQL Server: Optimizer | Verified (55 days) | S3 | 5.7.30, 5.7.32 | Any | Any | max_execution_time is not applicable in all query stages |
| 102160 | 2021-01-06 8:31 | 2021-01-06 9:01 | MySQL Server: Optimizer | Verified (61 days) | S3 | 8.0.22, 5.7.32 | CentOS | Any | Simple SELECT query returns different results when an index exists or not |
| 102037 | 2020-12-20 22:23 | 2021-01-13 15:01 | MySQL Server: Optimizer | Verified (54 days) | S5 | 8.0 | Any | Any | CPU overhead from inlists much larger in 8.0.22 |
| 102025 | 2020-12-18 7:33 | 2021-01-21 14:49 | MySQL Server: Optimizer | Verified (80 days) | S2 | 8.0.22, 5.7.32 | Any | Any | Wrong result when use "select all" |
| 101838 | 2020-12-02 19:17 | 2020-12-11 14:39 | MySQL Server: Optimizer | Verified (87 days) | S2 | 8.0 | Any | Any | Adding GROUP BY slows down a query. |
| 101796 | 2020-11-30 8:52 | 2020-11-30 8:59 | MySQL Server: Optimizer | Verified (98 days) | S2 | 5.6.34, 5.6.50, 5.7.32 | Any | Any | Incorrect query result for index_subquery type IN subquery |
| 101794 | 2020-11-30 3:46 | 2020-12-02 4:15 | MySQL Server: Optimizer | Verified (97 days) | S3 | 5.7, 5.7.32, 8.0.22 | Linux | Any | Query failing with "ERROR 1030 (HY000): Got error 1 from storage engine" |
| 101705 | 2020-11-21 8:01 | 2020-11-24 4:45 | MySQL Server: Optimizer | Verified (105 days) | S2 | 5.7.32 | Any | Any | Optimizer spends several seconds to produce query plan |
| 101691 | 2020-11-20 7:25 | 2020-11-20 7:50 | MySQL Server: Optimizer | Verified (108 days) | S3 | 8.0.22, 8.0.17, 8.0.18 | Any | Any | Use substring_index and rank() in a sql cause wrong result |
| 101665 | 2020-11-18 17:58 | 2020-11-19 14:02 | MySQL Server: Optimizer | Verified (109 days) | S3 | 8.0.22 | Linux | x86 | mysql use incorrect index during executing "select" query |
| 101517 | 2020-11-09 6:32 | 2020-11-09 7:41 | MySQL Server: Optimizer | Verified (119 days) | S3 | 8.0.20, 8.0.22 | CentOS | Any | EXPLAIN in tree format is inconsistent with classical format when LIMIT 1 used |
| 101459 | 2020-11-04 13:05 | 2020-11-05 12:00 | MySQL Server: Optimizer | Verified (123 days) | S5 | 5.6.50,5.7.32 | Any | Any | With more than one value in IN() clause, query skip index use. |
| 101278 | 2020-10-22 17:51 | 2020-10-23 10:26 | MySQL Server: Optimizer | Verified (136 days) | S5 | 8.0 | Any | Any | Field_string::cmp suboptimal string comparison |
| 101269 | 2020-10-22 3:26 | 2020-10-22 5:00 | MySQL Server: Optimizer | Verified (137 days) | S1 | 5.7, 8.0, 8.0.22, 5.7.32 | Any | Any | using different index may produce different results |
| 101059 | 2020-10-06 2:47 | 2020-10-06 5:26 | MySQL Server: Optimizer | Verified (153 days) | S3 | 8.0.19, 8.0.21, 5.7.31, 5.6.49 | Any | x86 | Query result inconsistent for the year type in NOT IN expression |
| Showing 1-30 of 466 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
