Bug #118195 | The opposite WHERE clause intersects and is always an empty set. | ||
---|---|---|---|
Submitted: | 14 May 13:34 | Modified: | 20 May 8:23 |
Reporter: | jinhui lai | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S2 (Serious) |
Version: | 9.3.0 | OS: | Ubuntu (22.04) |
Assigned to: | CPU Architecture: | Any |
[14 May 13:34]
jinhui lai
[19 May 21:15]
MySQL Verification Team
Thank you for the report and test case.
[19 May 21:16]
MySQL Verification Team
Bug #118196 marked as duplicate of this one
[19 May 21:17]
MySQL Verification Team
Bug #118197 is marked as duplicate of this one
[20 May 8:23]
Roy Lyseng
Posted by developer: Thank you for the bug report. However, we do not do any kind of optimization by combining the inner parts of two (or more) query blocks of a set operation, hence we do not consider this a bug. You are however welcome to file a feature request for the same, but I think it should be accompanied by a real-word use case.