lib/thinking_sphinx/source/sql.rb in thinking-sphinx-allen-1.3.18.3 vs lib/thinking_sphinx/source/sql.rb in thinking-sphinx-allen-1.3.18.4
- old
+ new
@@ -21,10 +21,10 @@
#{ all_associations.collect { |assoc| assoc.to_sql }.join(' ') }
#{ sql_where_clause(options) }
GROUP BY #{ sql_group_clause }
SQL
- sql += " ORDER BY NULL" if adapter.sphinx_identifier == "mysql"
+ sql += " ORDER BY id desc" if adapter.sphinx_identifier == "mysql"
sql
end
# Simple helper method for the query range SQL - which is a statement that
# returns minimum and maximum id values. These can be filtered by delta -