Showing 1-30 of 32 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
38550 | 2008-08-04 21:47 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5664 days) | S5 | 5.0.60, 5.1 | Any | Any | multiple optimizer bugs for queries with references from preceding table |
43052 | 2009-02-20 9:49 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5537 days) | S3 | 5.1.30-community, 4.1, 5.0, 5.1, 6.0 bzr | Any (MS Windows XP, Linux) | Any | not optimalised (sub)query, = versus IN |
44549 | 2009-04-29 17:47 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0.80, 5.1.34 | Any | Any | optimizer incorrectly chooses table scan and filesort over index |
45373 | 2009-06-08 13:14 | 2022-09-04 20:45 | MySQL Server: Optimizer | Verified (5418 days) | S3 | 5.1.35-community, 5.1.36-bzr | Any | Any | INDEX FOR GROUP BY is not used if there is a LIMIT clause in the query |
46288 | 2009-07-18 19:12 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5389 days) | S3 | 5.1.35-community, 5.1.36 | Windows | Any | Index is not used for equality condition on single-row, multiple column subquery |
46376 | 2009-07-24 17:05 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5378 days) | S5 | 5.0.85, 5.1.36, 5.1.38, 5.1.39 | Windows (XP) | Any | Optimizer choose wrong index even when where clause and order-by are covered |
46945 | 2009-08-26 20:10 | 2011-02-16 23:44 | MySQL Server | Verified (5338 days) | S2 | 4.1, 5.0, 5,1, next bzr | Any | Any | enable filesort index rebuild for SPATIAL index |
47884 | 2009-10-07 3:24 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5194 days) | S2 | 5.1.39, 5.1.44, 5.5.99 | Linux (Linux web2 2.6.18-92.1.18.el5.028stab060.8 #1 SMP Mon Feb 9 21:44:50 MSK 2009 x86_64) | Any | MySQL 5.1.39 failed to use index |
48875 | 2009-11-18 17:54 | 2022-12-04 20:45 | MySQL Server: DDL | Verified (5266 days) | S3 | 5.1.34, 5.1.42-bzr, 5.4.3, 8.0 | Any (Windows, Mac OS X) | Any | CREATE INDEX modifies the table name case |
49590 | 2009-12-10 16:03 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0+ | Any | Any | Server reporting different result sets for a query depending on use of indexes |
52620 | 2010-04-06 15:06 | 2023-02-12 20:45 | MySQL Server: Replication | Patch queued (4805 days) | S3 | 5.0.84 | Any | Any | Crash can leave null characters in binary log index file |
52762 | 2010-04-12 10:49 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5120 days) | S5 | 5.3 | Any | Any | like should be index optimised if starts with _ rather than % |
53588 | 2010-05-11 22:59 | 2021-04-16 7:39 | MySQL Server: DDL | Verified (2285 days) | S3 | 5.5/5.6/5.7/8.0 | Linux (Ubuntu, Synology OS) | Any | Blackhole : Specified key was too long; max key length is 1000 bytes |
57018 | 2010-09-25 15:32 | 2018-09-09 20:45 | MySQL Server: Data Types | Verified (4955 days) | S3 | 5.1.49, 5.1.52-bzr | Any | Any | Incorrect result when using BETWEEN comparison on an indexed DATETIME column. |
57849 | 2010-10-29 15:49 | 2014-10-08 9:42 | MySQL Workbench: SQL Editor | Verified (4863 days) | S3 | 5.2.29, 5.2.31 | Windows | Any | Ignoring "Index Comment" field |
61267 | 2011-05-23 18:18 | 2011-07-16 14:10 | MySQL Server: Information schema | Verified (4663 days) | S3 | 5.5.12 | Windows (64-bit) | Any | Index Prefix Length Completely Ignored |
65889 | 2012-07-13 0:21 | 2012-07-16 10:18 | MySQL Server: InnoDB storage engine | Verified (4298 days) | S3 | <=5.5 | Any | Any | Appended primary key stored inefficiently in unique surrogate keys |
66309 | 2012-08-10 15:50 | 2012-08-12 18:18 | MySQL Workbench: SQL Editor | Verified (4270 days) | S3 | 5.2.41 | Windows (W7 32/64) | Any | Alter table does not show order of fields in foreign key or index used |
68086 | 2013-01-15 8:41 | 2013-01-15 19:28 | MySQL Server: Memory storage engine | Verified (4112 days) | S3 | 5.5.29, 5.5.30, 5.7.1 | Any | Any | Heap tables don't use index for group by |
73603 | 2014-08-15 14:28 | 2015-05-04 13:17 | MySQL Server: Optimizer | Verified (3383 days) | S5 | 5.6.20, 5.6.24 | Windows (Server 2012 R2) | Any | MySQL 5.6.20 Not Using Index |
74449 | 2014-10-20 9:39 | 2014-10-20 10:44 | MySQL Server: Charsets | Verified (3469 days) | S3 | 5.5.40, 5.6.21, 5.7.5, 5.6.22 | Linux (CentOS 6.3) | Any | Incorrect datetime casting with charcter_set_connection=sjis |
76384 | 2015-03-19 8:41 | 2015-03-20 13:44 | MySQL Server: GIS | Verified (3318 days) | S2 | 5.6.19, 5.6.25, 5.7.8 | Any | Any | Spatial index not used when checking return values explicitly |
79953 | 2016-01-13 13:31 | 2016-01-14 6:52 | MySQL Server: FULLTEXT search | Verified (3018 days) | S3 | 5.7.10 | Windows (Win 2012R2) | Any | Fulltext-index not found in MySQL 5.7.10 when use GROUP_CONCAT |
89002 | 2017-12-21 9:41 | 2019-01-04 12:12 | MySQL Server: DDL | Verified (2311 days) | S3 | 5.7.20 | Linux | Any | Index on JSON virtual column with default sql_mode is evaluated badly |
89003 | 2017-12-21 9:45 | 2018-01-03 8:11 | MySQL Server: DDL | Verified (2311 days) | S3 | 5.7.20 | Linux | Any | Dropping Index on JSON virtual column with default sql_mode is not working |
90089 | 2018-03-15 12:57 | 2018-03-15 17:36 | MySQL Server: DML | Verified (2227 days) | S2 | 5.5/5.6/5.7/8.0 | Linux | Any | Year type column have index , between operate sql , the result is wrong . |
100436 | 2020-08-05 18:19 | 2020-08-05 20:56 | MySQL Workbench | Verified (1353 days) | S3 | 8.0.21 | MacOS (10.15.5) | x86 | Indexs that use expressions don't show up correctly in the alter table view |
104978 | 2021-09-17 19:57 | 2021-09-20 9:02 | MySQL Server: Optimizer | Verified (942 days) | S5 | 8.0.26, 5.7.35 | Windows | Any | Adding Join Index forces query optimizer to use inefficient execution plan |
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 . |
110556 | 2023-03-30 2:46 | 2023-03-30 6:19 | MySQL Server: JSON | Verified (386 days) | S2 | 8.0.28, 8.0.32 | Linux | Any | When we use json to build an index, we will get wrong results |
Showing 1-30 of 32 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |