Bug #97967 | Empty resultset for subquery with union and text column with constant expression | ||
---|---|---|---|
Submitted: | 12 Dec 2019 12:11 | Modified: | 18 Dec 2019 17:39 |
Reporter: | Jörg Bender | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S2 (Serious) |
Version: | 8.0.18 | OS: | Windows |
Assigned to: | CPU Architecture: | x86 | |
Tags: | constant expression, empty resultset, text, UNION |
[12 Dec 2019 12:11]
Jörg Bender
[12 Dec 2019 12:38]
MySQL Verification Team
Thank you for the bug report.
[18 Dec 2019 17:39]
Paul DuBois
Posted by developer: Fixed in 8.0.20. In unions of a const table and zero or more known-zero expressions, derived tables of exactly one row could be read incorrectly as having zero rows.