| Showing all 8 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 50389 | 2010-01-16 4:14 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5387 days) | S2 | 5.0.90, 5.1.34, 5.1.42, 5.1.43-bzr | Linux | Any | Using intersect does not return all rows |
| 60317 | 2011-03-03 16:20 | 2011-04-03 23:00 | MySQL Server: Optimizer | No Feedback (5216 days) | S3 | 5.1.30-community-log | Linux (centos) | Any | equivalent queries give different results |
| 70588 | 2013-10-10 12:09 | 2014-02-02 17:20 | MySQL Server: Partitions | Closed (4269 days) | S2 | 5.6.14,5.5 | Any | Any | Index merge used on partitionned table can return wrong result set |
| 69581 | 2013-06-26 10:04 | 2013-10-07 10:56 | MySQL Server: Optimizer | Closed (4298 days) | S2 | 5.6.12-log Source distribution | Any | Any | InnoDB index intersection returns less results than expected |
| 72745 | 2014-05-26 4:28 | 2014-05-26 5:48 | MySQL Server: Optimizer | Verified (4067 days) | S2 | 5.5.37, 5.5.38 | Any | Any | Wrong Results When Using Intersect |
| 80789 | 2016-03-18 10:22 | 2019-06-06 21:10 | MySQL Server: Optimizer | No Feedback (3358 days) | S1 | 5.6.27-29, 5.7.11 | CentOS (x86_64) | Any | "Select" query gives empty result depending on index or spacing in query |
| 117542 | 2025-02-21 18:23 | 2025-02-24 11:39 | MySQL Server: Parser | Not a Bug (140 days) | S3 | 8.0.40 | Windows | Any | INTERSECT is working in MySQL 8.0.40, but it's not in the official documentation! |
| 118243 | 2025-05-21 17:55 | 2025-05-22 16:33 | MySQL Workbench: SQL Editor | Duplicate (53 days) | S3 | 8.0.42 | Windows (Windows 11) | Any (Intel i9) | EXCEPT and INTERSECT not in autocomplete word list |
| Showing all 8 (Edit, Save, CSV, Feed) |
