Mercurial > p > roundup > code
diff roundup/backends/back_mysql.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 | 7be25d75c3d5 |
line wrap: on
line diff
--- a/roundup/backends/back_mysql.py Fri Jan 20 02:41:28 2006 +0000 +++ b/roundup/backends/back_mysql.py Fri Jan 20 02:42:35 2006 +0000 @@ -1,4 +1,4 @@ -#$Id: back_mysql.py,v 1.64 2006-01-20 02:40:56 richard Exp $ +#$Id: back_mysql.py,v 1.65 2006-01-20 02:42:35 richard Exp $ # # Copyright (c) 2003 Martynas Sklyzmantas, Andrey Lebedev <andrey@micro.lt> # @@ -741,9 +741,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