Mercurial > p > roundup > code
diff roundup/backends/rdbms_common.py @ 3478:602bb26a9485
grouping/sorting on link to same class fixed [SF#1404930]
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Fri, 20 Jan 2006 02:42:35 +0000 |
| parents | 1142dafe0d7f |
| children | 87e512f87bae |
line wrap: on
line diff
--- a/roundup/backends/rdbms_common.py Fri Jan 20 02:41:28 2006 +0000 +++ b/roundup/backends/rdbms_common.py Fri Jan 20 02:42:35 2006 +0000 @@ -1,4 +1,4 @@ -# $Id: rdbms_common.py,v 1.161 2006-01-20 02:40:56 richard Exp $ +# $Id: rdbms_common.py,v 1.162 2006-01-20 02:42:35 richard Exp $ ''' Relational database (SQL) backend common code. Basics: @@ -2202,9 +2202,9 @@ op = link.orderprop() if op != 'id': tn = '_' + lcn - loj.append('LEFT OUTER JOIN %s on %s=%s.id'%(tn, - o, tn)) - o = tn + '._%s'%op + loj.append('LEFT OUTER JOIN %s as rhs_ on %s=rhs_.id' + %(tn, o)) + o = 'rhs_._%s'%op ordercols.append(o) elif prop == 'id': o = '_%s.id'%cn