| « Show Previous 30 Entries | Showing 31-60 of 235 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 78651 | 2015-09-30 18:44 | 2016-10-20 12:35 | MySQL Server: Optimizer | Verified (3127 days) | S3 | 5.5.45, 5.6.26, 5.7.8, 5.5.47, 5.6.28, 5.7.10 | Any | Any | Optimizer chooses wrong index for ORDER BY |
| 79480 | 2015-12-01 10:59 | 2015-12-03 10:42 | MySQL Server: Optimizer | Verified (3064 days) | S3 | 5.7.9 | Any | Any | Suboptimal query plan in simple join compared to MariaDB 10.1 |
| 79681 | 2015-12-16 21:53 | 2016-01-13 10:41 | MySQL Server: Optimizer | Verified (3050 days) | S5 | 5.7, 5.7.10 | Red Hat (Redhat 6 update 5) | Any | Queries running much slower in version 5.7 versus 5.6 |
| 80067 | 2016-01-20 10:50 | 2020-06-17 23:13 | MySQL Server: Optimizer | Verified (3016 days) | S3 | 5.6.28, 5.7.10 | Any | Any | Index on BIT column is NOT used when column name only is used in WHERE clause |
| 80206 | 2016-01-30 6:13 | 2016-01-30 6:13 | MySQL Server: Optimizer | Verified | S3 | 5.7.10 | Any | Any | EQ_REF extension should be skipped for the last joined table |
| 80224 | 2016-02-01 19:13 | 2016-02-15 9:00 | MySQL Server: Optimizer | Verified (2990 days) | S3 | 5.5.46, 5.6.28, 5.7.11 | Any | Any | CONCAT_WS duplication of arguments when used in conjunction with HAVING |
| 81469 | 2016-05-17 21:51 | 2016-05-18 6:54 | MySQL Server: Optimizer | Verified (2897 days) | S3 | 5.6.30, 5.7.12 | Any | Any | Slow performance for IN subquery and UNION |
| 82021 | 2016-06-27 17:46 | 2016-06-28 6:11 | MySQL Server: Optimizer | Verified (2856 days) | S3 | 5.6.31, 5.7.13 | Any | Any | Difference in range behaviour between range analyzer and query execution engine |
| 82074 | 2016-06-30 21:50 | 2016-07-01 5:04 | MySQL Server: Optimizer | Verified (2853 days) | S3 | 5.5.49, 5.6.30, 5.7.13 | Any | Any | Select_scan set even if table scan was not used |
| 82334 | 2016-07-25 10:58 | 2016-12-16 14:00 | MySQL Server: Optimizer | Verified (2685 days) | S2 | 5.7.13 | CentOS | Any | unexpected order for grouped query |
| 82338 | 2016-07-25 21:05 | 2021-12-29 17:53 | MySQL Server: Optimizer | Verified (846 days) | S3 | any, 5.6.31, 5.7.13 | Any | Any | Please support ASC/DESC index traversal on ASC/ASC indexing. |
| 82363 | 2016-07-27 19:28 | 2016-07-28 8:11 | MySQL Server: Optimizer | Verified (2826 days) | S3 | 5.7 and every other | Any | Any | impossible const condition still followed in a JOIN |
| 82725 | 2016-08-25 15:55 | 2016-09-14 6:28 | MySQL Server: Optimizer | Verified (2778 days) | S5 | 5.7.14, 5.7.15 | CentOS (Linux rda-db-rep.ucar.edu 3.10.0-327.28.2.el7.x86_64 #1 SMP Wed Aug 3 11:11:39 UTC 2016 x86_64 x86_6) | Any | Extremely slow query when optimizer_switch='derived_merge=ON' |
| 82805 | 2016-08-31 2:20 | 2016-08-31 9:47 | MySQL Server: Optimizer | Verified (2792 days) | S2 | 5.7.10, 5.7.14 | Any | Any | Having clause condition fails on join table with TEXT field |
| 83062 | 2016-09-20 13:18 | 2018-04-24 20:15 | MySQL Server: Optimizer | Verified (2771 days) | S3 | 5.6.32, 5.7.14, 5.6.33, 5.7.15 | Any | Any | it's no longer possible to determine used key parts by looking at key_length |
| 83071 | 2016-09-21 8:02 | 2016-09-21 8:34 | MySQL Server: Optimizer | Verified (2771 days) | S3 | 5.7.14, 5.6.*, 5.7.15 | Any | Any | MySQL prefers first declared index over more useful other indexes |
| 83248 | 2016-10-03 15:57 | 2023-02-22 1:40 | MySQL Server: Optimizer | Verified (2759 days) | S3 | 8.0.0, 5.7.15 | Any | Any | Partition pruning is not working with LEFT JOIN |
| 83323 | 2016-10-10 18:02 | 2018-04-13 12:41 | MySQL Server: Optimizer | Verified (2556 days) | S3 | 5.7, 5.6, 8.0.1 | Any | Any | Optimizer chooses wrong plan when joining 2 tables |
| 83627 | 2016-11-01 8:16 | 2016-11-01 9:36 | MySQL Server: Optimizer | Verified (2730 days) | S3 | 5.7/8.0 | Linux | Any | inconsistent results with generated column when meets char and padding |
| 83722 | 2016-11-07 13:28 | 2020-06-24 9:10 | MySQL Server: Optimizer | Verified (2724 days) | S3 | 5.7/8.0 | Ubuntu (16.04) | Any | UNION with outer LIMIT can return wrong number of rows |
| 83856 | 2016-11-17 4:19 | 2019-11-15 17:31 | MySQL Server: Optimizer | Verified (2683 days) | S3 | 5.7.13,5.7.16 | CentOS | Any | Index ref not used for multi-column IN - type or collation conversion warning |
| 84024 | 2016-12-01 2:40 | 2016-12-02 9:07 | MySQL Server: Optimizer | Verified (2699 days) | S3 | 5.7.16, 5.6.34 | Any | Any | Optimizer thinks clustered primary key is not covering |
| 84416 | 2017-01-04 23:11 | 2017-01-05 11:26 | MySQL Server: Optimizer | Verified (2665 days) | S3 | 5.6 and 5.7 | Any | Any | MySQL updates 0000-00-00 00:00:00 for datetime type |
| 84638 | 2017-01-24 12:40 | 2017-01-30 6:47 | MySQL Server: Optimizer | Verified (2644 days) | S3 | 5.6, 5.7 | Any | Any | Missing FROM clause returns error when using INTO at the end of the statement |
| 84720 | 2017-01-30 12:09 | 2017-01-30 13:19 | MySQL Server: Optimizer | Verified (2640 days) | S3 | 5.6.27,5.7, 5.7.17 | Any | Any | WITH ROLLUP not providing expected NULL values |
| 84858 | 2017-02-07 13:09 | 2017-02-09 6:34 | MySQL Server: Optimizer | Verified (2630 days) | S3 | 5.6, 5.7, 5.6.35 | Any | Any | Time is spent at "statistics" stage for primary key lookups |
| 85188 | 2017-02-27 2:33 | 2017-02-27 7:30 | MySQL Server: Optimizer | Verified (2612 days) | S3 | 5.6.34,5.6.35, 5.7.17 | Any | Any | warnings of explain extended does not convert charset |
| 85945 | 2017-04-14 8:01 | 2017-04-17 8:08 | MySQL Server: Optimizer | Verified (2563 days) | S3 | 5.7.13, 5.7.18 | Any | Any | SQL optimizer fail to check IS NULL condition |
| 86220 | 2017-05-08 16:35 | 2018-11-06 12:50 | MySQL Server: Optimizer | Verified (1996 days) | S3 | 5.7.18 | Any | Any | Query returns wrong results when using UDF in view |
| 86610 | 2017-06-07 14:36 | 2017-06-16 6:47 | MySQL Server: Optimizer | Verified (2505 days) | S3 | 5.7 | Linux (centos7) | Any | Mysql 5.6 and 5.7.17 enterprise "semi join" results are different |
| « Show Previous 30 Entries | Showing 31-60 of 235 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
