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
12814	Missing ORDER BY in subselect	EsOsO	nobody	"Python 2.6.4 (r264:75706, Dec  7 2009, 18:45:15)
{{{
>>> from django.db import connection
>>> from pokertour.models import Session, Entry
>>> s = Session.objects.all()[:4]
>>> s
[<Session: Session 033>, <Session: Session 032>, <Session: Session 031>, <Session: Session 030>]
>>> e = Entry.objects.filter(session__in=s)
>>> e
[<Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, '...(remaining elements truncated)...']
>>> connection.queries 
[{'time': '0.005', 'sql': 'SELECT ""pokertour_session"".""id"", ""pokertour_session"".""name"", ""pokertour_session"".""slug"", ""pokertour_session"".""date"", ""pokertour_session"".""location_id"" FROM ""pokertour_session"" ORDER BY ""pokertour_session"".""date"" DESC LIMIT 4'}, {'time': '0.004', 'sql': 'SELECT ""pokertour_entry"".""id"", ""pokertour_entry"".""player_id"", ""pokertour_entry"".""session_id"", ""pokertour_entry"".""cash_in"", ""pokertour_entry"".""cash_out"", ""pokertour_entry"".""bank_in"", ""pokertour_entry"".""stack"" FROM ""pokertour_entry"" WHERE ""pokertour_entry"".""session_id"" IN (SELECT U0.""id"" FROM ""pokertour_session"" U0 LIMIT 4) LIMIT 21'}]
>>>
}}}
 

The subquery should return the same records as the first, instead it loses the order by clause:[[BR]]
...FROM ""pokertour_session"" ORDER BY ""pokertour_session"".""date"" DESC LIMIT 4[[BR]]

...FROM ""pokertour_session"" U0 LIMIT 4"		closed	Database layer (models, ORM)	dev		duplicate			Unreviewed	0	0	0	0	0	0