Hi -

Has anyone else observed differences between the behavior of order_by
between Python 2.3 and 2.4?  Under 2.3, the following code drops many
items in thread_list when using order_by():

    ...
    extra_last_updated = """
        SELECT date FROM forum_post
            WHERE forum_post.thread_id = forum_thread.id
            ORDER BY date DESC LIMIT 1
        """

    thread_list = thread_list.extra(
        select = {
            # ...
            #'last_updated': extra_last_updated,  # bug:
http://code.djangoproject.com/ticket/2210
            'date': extra_last_updated,
            'last_poster': extra_last_poster,
        #},)
        },).order_by('-csticky', '-date')

The above works as expected in a mod_python setup with Python 2.4 but
not Python 2.3 (Debian Sarge vs. Etch).  The pysqlite versions I'm
using are identical in both setups.  Of course, I haven't controlled
for a lot of other factors, but maybe someone has observed this before?


--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to