From be4e6d4cd515dd91370a5944fa4dab70a8de206b Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 12 Jan 2011 11:31:13 -0500 Subject: [PATCH] - add a note about query.order_by(None) with union etc. clarifies [ticket:2022] --- lib/sqlalchemy/orm/query.py | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/lib/sqlalchemy/orm/query.py b/lib/sqlalchemy/orm/query.py index d5f0ef0ca5..5964459182 100644 --- a/lib/sqlalchemy/orm/query.py +++ b/lib/sqlalchemy/orm/query.py @@ -1073,7 +1073,14 @@ class Query(object): SELECT * FROM (SELECT * FROM X UNION SELECT * FROM y UNION SELECT * FROM Z) - + + Note that many database backends do not allow ORDER BY to + be rendered on a query called within UNION, EXCEPT, etc. + To disable all ORDER BY clauses including those configured + on mappers, issue ``query.order_by(None)`` - the resulting + :class:`.Query` object will not render ORDER BY within + its SELECT statement. + """ -- 2.47.2