#11145: problems with LIMIT on Oracle backend
------------------------------------------+---------------------------------
Reporter: kimus | Owner: nobody
Status: new | Milestone:
Component: Database layer (models, ORM) | Version: SVN
Keywords: | Stage: Unreviewed
Has_patch: 0 |
------------------------------------------+---------------------------------
shell commands:
{{{
>>> from some.app.models import *
>>> Patrimony.objects.all()
}}}
sql executed by the shell commands:
{{{
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'
NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF' NLS_TERRITORY =
'AMERICA'
SELECT "PATRIMONY"."CODE", "PATRIMONY"."NAME" FROM "PATRIMONY" LIMIT 21
}}}
error:
{{{
Traceback (most recent call last):
File "<console>", line 1, in <module>
File "/home/kimus/.../django/db/models/query.py", line 55, in __repr__
data = list(self[:REPR_OUTPUT_SIZE + 1])
File "/home/kimus/.../django/db/models/query.py", line 70, in __len__
self._result_cache.extend(list(self._iter))
File "/home/kimus/.../django/db/models/query.py", line 207, in iterator
for row in self.query.results_iter():
File "/home/kimus/.../django/db/models/sql/query.py", line 287, in
results_iter
for rows in self.execute_sql(MULTI):
File "/home/kimus/.../django/db/models/sql/query.py", line 2359, in
execute_sql
cursor.execute(sql, params)
File "/home/kimus/.../django/db/backends/util.py", line 19, in execute
return self.cursor.execute(sql, params)
File "/home/kimus/Develop/linux/python/django/django-
trunk/django/db/backends/oracle/base.py", line 434, in execute
raise e
DatabaseError: ORA-00933: SQL command not properly ended
}}}
--
Ticket URL: <http://code.djangoproject.com/ticket/11145>
Django <http://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 post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
