#31445: Chain of unions leads to incorrect SQL query on MySQL.
-------------------------------------+-------------------------------------
Reporter: Thodoris | Owner: (none)
Sotiropoulos |
Type: Bug | Status: new
Component: Database layer | Version: 3.0
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Mariusz Felisiak):
This was fixed in MySQL 8.0.31, see
[https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-31.html#mysqld-8-0-31-optimizer
release notes]:
> ''"Bodies of parenthesized query expressions can now be nested to in
combination with `UNION`. For example, the query shown here, previously
rejected with error `ER_NOT_SUPPORTED_YET`, is now allowed"''
I'm going to add a regression test and skip it on MySQL < 8.0.31
--
Ticket URL: <https://code.djangoproject.com/ticket/31445#comment:7>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/010701866ef34b9e-7eb67cd6-dc80-46cd-b183-5a4df7536d77-000000%40eu-central-1.amazonses.com.
