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
27458	"Oracle backend giving ORA-00911 : Invalid Character, querying with a literal ""%s"""	Gabriel Canto de Souza	Andrew Nester	"This happened after trying to create a new object in the Django Admin interface which has a many to many field with another class, the full html debug page is attached to the ticket

The last query before the error was raised is this :

'SELECT ""GEO"".""DJANGO_PESSOA"".""OBJECTID"" FROM ""GEO"".""DJANGO_PESSOA"" INNER '
'JOIN ""GEO"".""DJANGO_DOCUMENTO""_PF951 ON (""GEO"".""DJANGO_PESSOA"".""OBJECTID"" = '
'""GEO"".""DJANGO_DOCUMENTO""_PF951.""DJANGOTESTPESSOA_ID"") WHERE '
'""GEO"".""DJANGO_DOCUMENTO""_PF951.""DJANGOTESTDOCUMENTO_ID"" = %s'

{{{
#!div style=""font-size: 80%""
models.py:
  {{{#!python
from __future__ import unicode_literals
from django.db import models

class DjangoTestPessoa(models.Model):
    objectid = models.BigIntegerField(primary_key=True,unique=True)
    nome = models.CharField(max_length=150, blank=True, null=True)

    class Meta:
        db_table = '""GEO"".""DJANGO_PESSOA""'


class DjangoTestDocumento(models.Model):
    objectid = models.BigIntegerField(primary_key=True,unique=True)
    numero = models.CharField(max_length=150, blank=True, null=True)
    pessoas = models.ManyToManyField(DjangoTestPessoa)
    
    class Meta:
        db_table = '""GEO"".""DJANGO_DOCUMENTO""'
  }}}
}}}"	Bug	closed	Database layer (models, ORM)	dev	Normal	fixed	Oracle	felisiak.mariusz@… Simon Charette	Ready for checkin	1	0	0	0	0	0