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
11145	problems with LIMIT on Oracle backend	kimus	nobody	"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
}}}"		closed	Database layer (models, ORM)	dev		invalid			Unreviewed	0	0	0	0	0	0