#30385: SearchVector's usage of CONCAT makes it impossible to index against.
-------------------------------------+-------------------------------------
Reporter: Simon | Owner: Simon Charette
Charette |
Type: Bug | Status: assigned
Component: | Version: 2.2
contrib.postgres |
Severity: Release | Keywords:
blocker |
Triage Stage: Accepted | Has patch: 1
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 1 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
`SearchVector` was changed in Django 2.2 to allow querying non-text fields
(#29582) by using `CONCAT` which automatically cast such fields to text
and deals with `NULL` value appropriately.
This had the unintended side effect of making the generated SQL loose it's
`IMMUTABLE` status as `CONCAT` can generate locale/TZ dependant output
which makes the generated SQL expression impossible to index against.
--
Ticket URL: <https://code.djangoproject.com/ticket/30385>
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 post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/052.e65a7204003ab508146f6f0ac668e4e0%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
