#34840: Django 4.2 casts text fields when testing IS NULL, preventing use of partial indexes -------------------------------------+------------------------------------- Reporter: Alex Vandiver | Owner: murtatah Type: Bug | Status: assigned 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 -------------------------------------+-------------------------------------
Comment (by Florian Apolloner): Regarding my comment https://code.djangoproject.com/ticket/34840#comment:11 -- The validation error is wrong there, it is actually a database area that is masked (https://github.com/django/django/pull/15659#pullrequestreview-1629960210). I wonder if we could teach the ORM to only add casts when using bind params, there is no reason to add those for column refs. That is unless our testsuite doesn't miss some further important edge cases :) At the very least we will need instructions (release notes, maybe a blog post) for people on how to check whether they are affected and how to fix it. -- Ticket URL: <https://code.djangoproject.com/ticket/34840#comment:15> 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 django-updates+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/0107018aa2d0bfc0-2ac55d39-c90d-49fd-9b9c-e04f4c7537a3-000000%40eu-central-1.amazonses.com.