#27227: Full text search by UUIDField returns DataError
-------------------------------------+-------------------------------------
Reporter: danclaudiupop | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 1.10
(models, ORM) |
Severity: Normal | Resolution:
Keywords: UUIDField fts | Triage Stage:
postgres | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by melvyn-sopacua):
So unfortunately, even when supporting the fallback value, this fails
because to_tsvector(uuid) fails for reasons pointed out by charettes: uuid
isn't searchable. However, having a way to provide the fallback is useful,
if one wants to have NULL returned. From the Coalesce docs:
The COALESCE function returns the first of its arguments that is not
null. Null is returned only if all arguments are null.
But, I don't have a real-world use case for this. If there's no interest
in supporting the fallback value, I'll throw away my local branch.
--
Ticket URL: <https://code.djangoproject.com/ticket/27227#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 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/071.db95f0f7f165bf3a7ec0ffc28c1fa538%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
