diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2006-05-05 00:42:42 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2006-05-05 00:42:42 +0000 |
| commit | dec6e3b80f40c249207642d4fa6e9feca7a5a8c9 (patch) | |
| tree | c84a810d842874a0ab746e907775891b21e48c73 /lib/sqlalchemy/ansisql.py | |
| parent | f7d896af75460ca03a3ec08a1de6b621d23cb340 (diff) | |
| download | sqlalchemy-dec6e3b80f40c249207642d4fa6e9feca7a5a8c9.tar.gz | |
fixed HAVING/ORDER BY order, 0.1.7 prep
Diffstat (limited to 'lib/sqlalchemy/ansisql.py')
| -rw-r--r-- | lib/sqlalchemy/ansisql.py | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/lib/sqlalchemy/ansisql.py b/lib/sqlalchemy/ansisql.py index a344e017c..602da58ee 100644 --- a/lib/sqlalchemy/ansisql.py +++ b/lib/sqlalchemy/ansisql.py @@ -371,14 +371,14 @@ class ANSICompiler(sql.Compiled): if group_by: text += " GROUP BY " + group_by - order_by = self.get_str(select.order_by_clause) - if order_by: - text += " ORDER BY " + order_by - if select.having is not None: t = self.get_str(select.having) if t: text += " \nHAVING " + t + + order_by = self.get_str(select.order_by_clause) + if order_by: + text += " ORDER BY " + order_by text += self.visit_select_postclauses(select) |