1. Michael Manfre
  2. django-mssql
  3. Issues


Issue #18 resolved

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.

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