﻿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
24012	models.UUIDfield fails on Oracle backend	JorisBenschop	nobody	"Hi, my employers uses RAW(16) as a pk for all tables (using the SYS_GUID() function). This gives blocking issues in Django as Django keeps on trying to decode()  this field. However, using models.UUIDfield does not resovle the issue:

{{{
class Population(models.Model):
    population_id = models.UUIDField(primary_key=True)
    population_name = models.CharField(max_length=400)

x=Population.objects.all()[0]
Traceback (most recent call last):
File ""/home/gfjom/wingide4/lib/src/debug/tserver/_sandbox.py"", line 1, in <module>
    # Used internally for debug sandbox under external interpreter
  File ""/home/gfjom/django-virtualenv/lib/python2.7/site-packages/Django-1.8-py2.7.egg/django/db/models/query.py"", line 203, in __getitem__
    return list(qs)[0]
  File ""/home/gfjom/django-virtualenv/lib/python2.7/site-packages/Django-1.8-py2.7.egg/django/db/models/query.py"", line 164, in __iter__
    self._fetch_all()
  File ""/home/gfjom/django-virtualenv/lib/python2.7/site-packages/Django-1.8-py2.7.egg/django/db/models/query.py"", line 999, in _fetch_all
    self._result_cache = list(self.iterator())
  File ""/home/gfjom/django-virtualenv/lib/python2.7/site-packages/Django-1.8-py2.7.egg/django/db/models/query.py"", line 292, in iterator
    for row in compiler.results_iter():
  File ""/home/gfjom/django-virtualenv/lib/python2.7/site-packages/Django-1.8-py2.7.egg/django/db/models/sql/compiler.py"", line 753, in results_iter
    row = self.apply_converters(row, converters)
  File ""/home/gfjom/django-virtualenv/lib/python2.7/site-packages/Django-1.8-py2.7.egg/django/db/models/sql/compiler.py"", line 696, in apply_converters
    value = converter(value, field)
  File ""/home/gfjom/django-virtualenv/lib/python2.7/site-packages/Django-1.8-py2.7.egg/django/db/backends/oracle/base.py"", line 326, in convert_uuidfield_value
    value = uuid.UUID(value)
  File ""/tools/general/app/python-2.7.5-rhel6/lib/python2.7/uuid.py"", line 134, in __init__
    raise ValueError('badly formed hexadecimal UUID string')
ValueError: badly formed hexadecimal UUID string
}}}"	Uncategorized	closed	Database layer (models, ORM)	dev	Normal	wontfix	oracle, models.UUIDfield,1.8-alpha	Shai Berger	Accepted	0	0	0	0	0	0
