#34840: Django 4.2 casts text fields when testing IS NULL, preventing use of
partial indexes
-------------------------------------+-------------------------------------
Reporter: Alex Vandiver | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 4.2
(models, ORM) |
Severity: Release blocker | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Simon Charette):
* cc: Florian Apolloner, Mariusz Felisiak (added)
Comment:
> This also means that there's a bit of a pickle -- you can't just strip
off the ::text in the query in some later 4.2 bugfix release, because that
will also make any 4.2-inserted indexes with ::text not work with the
newly ::text-less query.
Right, that's what I feared. I think we should favour reverting to the
previous behaviour if possible though as there are likely to be more
constraints created prior to 4.2 in the wild than after even at this
point. This is definitely something that should be mentioned in the
release notes though.
Any thoughts here Florian and Mariusz?
--
Ticket URL: <https://code.djangoproject.com/ticket/34840#comment:3>
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/0107018a945588ac-90149e7c-a856-41ab-892c-ef63edc72b4b-000000%40eu-central-1.amazonses.com.
