The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.

Issue #18 resolved
Michael Manfre
repo owner created an issue

ERROR: test_aggrate_annotation (regressiontests.aggregation_regress.tests.AggregationTests)

Comments (1)

  1. Michael Manfre reporter

    Fixed #18 - Ordering subqueries is prevented due to MSSQL limitation.

    This change assumes that the 'with_col_aliases' SQLCompiler.as_sql is always used to mean that the query is a sub-query. This is currently true for the core as of Django 1.5 trunk.

    → <<cset 608b132f4420>>

  2. Log in to comment