id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
27227	Full text search by UUIDField returns DataError	Dan Claudiu Pop	nobody	"Consider the following model:

{{{
class Show(models.Model):
    cid = models.UUIDField(
        default=uuid.uuid4,
        editable=False,
        verbose_name=""Content ID"",
        help_text=""Unique Identifier""
    )
    title_short = models.CharField(
        max_length=60,
        blank=True,
        verbose_name=""Short Title"",
        help_text=""Short title (60 chars)""
    )
}}}

The following snippet returns DataError, see below traceback:

{{{
>>> from django.contrib.postgres.search import SearchVector
>>> Show.objects.annotate(search=SearchVector('cid')).filter(search='foo')

Traceback (most recent call last):
  File ""<console>"", line 1, in <module>
  File ""/home/vagrant/ve/lib/python3.4/site-packages/django/db/models/query.py"", line 232, in __repr__
    data = list(self[:REPR_OUTPUT_SIZE + 1])
  File ""/home/vagrant/ve/lib/python3.4/site-packages/django/db/models/query.py"", line 256, in __iter__
    self._fetch_all()
  File ""/home/vagrant/ve/lib/python3.4/site-packages/django/db/models/query.py"", line 1087, in _fetch_all
    self._result_cache = list(self.iterator())
  File ""/home/vagrant/ve/lib/python3.4/site-packages/django/db/models/query.py"", line 54, in __iter__
    results = compiler.execute_sql()
  File ""/home/vagrant/ve/lib/python3.4/site-packages/django/db/models/sql/compiler.py"", line 835, in execute_sql
    cursor.execute(sql, params)
  File ""/home/vagrant/ve/lib/python3.4/site-packages/django/db/backends/utils.py"", line 79, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)
  File ""/home/vagrant/ve/lib/python3.4/site-packages/django/db/backends/utils.py"", line 64, in execute
    return self.cursor.execute(sql, params)
  File ""/home/vagrant/ve/lib/python3.4/site-packages/django/db/utils.py"", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File ""/home/vagrant/ve/lib/python3.4/site-packages/django/utils/six.py"", line 685, in reraise
    raise value.with_traceback(tb)
  File ""/home/vagrant/ve/lib/python3.4/site-packages/django/db/backends/utils.py"", line 64, in execute
    return self.cursor.execute(sql, params)
django.db.utils.DataError: invalid input syntax for uuid: """"
LINE 1: ...tag"", to_tsvector(COALESCE(""entities_show"".""cid"", '')) AS ""s...
}}}

Tried with PostgreSQL 9.3.14 and PostgreSQL 9.5.3

"	Bug	closed	Database layer (models, ORM)	1.10	Normal	needsinfo	UUIDField fts postgres	danclaudiupop@…	Unreviewed	0	0	0	0	0	0