#2520: Invalid SQL generated when searching, using Foreign Keys in ordering but
not in searching
----------------------------------+-----------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: adrian
Type: defect | Status: new
Priority: normal | Milestone:
Component: Database wrapper | Version:
Severity: normal | Keywords:
----------------------------------+-----------------------------------------
A ProgrammingError, missing FROM-clause entry is generated in the
following specific conditions:
1. A Foreign Key is used in model.Meta.ordering
2. The Foreign Key is NOT in the model.Admin.search_fields
3. You perform a search.
The JOIN is not made with the Foreign Key, but it is listed in the ORDER
BY clause.
--
Ticket URL: <http://code.djangoproject.com/ticket/2520>
Django <http://code.djangoproject.org/>
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
-~----------~----~----~----~------~----~------~--~---