Bug #109723 | Exists query assertion error | ||
---|---|---|---|
Submitted: | 20 Jan 2023 12:16 | Modified: | 25 Jan 2023 9:30 |
Reporter: | Pedro Ferreira | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S6 (Debug Builds) |
Version: | 8.0.32 | OS: | Ubuntu (22.04) |
Assigned to: | CPU Architecture: | x86 (x86_64) | |
Tags: | exists, subquery |
[20 Jan 2023 12:16]
Pedro Ferreira
[25 Jan 2023 9:30]
MySQL Verification Team
Hello Pedro Ferreira, Thank you for the report and feedback. Observed that 8.0.32 debug build is affected. regards, Umesh
[1 Feb 2023 21:06]
Dag Wanvik
Posted by developer: This is a variant of Bug#34746261 Bug#34746261 Forced secondary engine execution assertion error
[6 Feb 2023 16:27]
Jon Stephens
Documented fix as follows in the MySQL 8.0.33 changelog: A query of the form SELECT 1 FROM t1 WHERE NOT EXISTS (VALUES ROW(1), ROW(2)) caused an assert in debug builds when the subquery_to_derived optimizer switch was enabled. Closed.