It's interesting this seems to work with 10g XE. I am not sure if this is relevant, but I am using the Full Oracle Client with Administrative Tools (as oppose to the Oracle Instant Client) and cx_Oracle for Python access to the database. The error I felt was most problematic is that the SQL statement has 4 opening parenthesis, and only 3 closing parenthesis. This kind of statement work in Oracle 10g XE?
On Wed, Jan 30, 2013 at 7:30 PM, Ian Kelly <ian.g.ke...@gmail.com> wrote: > On Wed, Jan 30, 2013 at 4:30 PM, Dylan Klomparens > <dylan.klompar...@gmail.com> wrote: > > Hello, > > > > I've encountered what may be a Django ORM bug and am writing to see what > the > > dev community thinks. I have a model that uses generic relations. An > error > > is returned when I attempt to delete multiple rows of said model in the > > database table. The error is repeatable, and I have found it is only > > applicable to models that contain generic relations. The error occurs > after > > the deletion is confirmed in the admin interface and the SQL statement > > begins execution. > > > > I've attached the use case that creates the bug, the generated SQL > statement > > (read from the debug output), and the model in question. > > > > Could someone please confirm that this is indeed a bug? If so, I can > create > > a ticket and begin researching how to remedy this problem. > > I can confirm that the attached SQL is problematic for Oracle. It has > an ORDER BY clause inside an IN subquery, which is meaningless in > general and not permitted by Oracle. However, I was not able to > confirm the bug using Django 1.5rc1 and Oracle 10g XE. I tried > replicating the case with the model provided, and the multiple > deletion was successful. > > -- > You received this message because you are subscribed to the Google Groups > "Django developers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-developers+unsubscr...@googlegroups.com. > To post to this group, send email to django-developers@googlegroups.com. > Visit this group at http://groups.google.com/group/django-developers?hl=en > . > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "Django developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-developers+unsubscr...@googlegroups.com. To post to this group, send email to django-developers@googlegroups.com. Visit this group at http://groups.google.com/group/django-developers?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
