Mercurial > p > roundup > code
diff roundup/backends/back_mysql.py @ 3525:7be25d75c3d5
Fixed SQL generation for sort/group by separate Link properties [SF#1417565]
Metakit fails the new test. I have no idea why.
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Mon, 30 Jan 2006 00:36:26 +0000 |
| parents | 602bb26a9485 |
| children | 438adf66eb1a |
line wrap: on
line diff
--- a/roundup/backends/back_mysql.py Sun Jan 29 23:40:41 2006 +0000 +++ b/roundup/backends/back_mysql.py Mon Jan 30 00:36:26 2006 +0000 @@ -1,4 +1,4 @@ -#$Id: back_mysql.py,v 1.65 2006-01-20 02:42:35 richard Exp $ +#$Id: back_mysql.py,v 1.66 2006-01-30 00:36:26 richard Exp $ # # Copyright (c) 2003 Martynas Sklyzmantas, Andrey Lebedev <andrey@micro.lt> # @@ -723,6 +723,7 @@ orderby = [] ordercols = [] mlsort = [] + rhsnum = 0 for sortby in group, sort: sdir, prop = sortby if sdir and prop: @@ -741,9 +742,11 @@ op = link.orderprop () if op != 'id': tn = '_' + lcn - loj.append('LEFT OUTER JOIN %s as rhs_ on %s=rhs_.id' - %(tn, o)) - o = 'rhs_._%s'%op + rhs = 'rhs%s_'%rhsnum + rhsnum += 1 + loj.append('LEFT OUTER JOIN %s as %s on %s=%s.id'%( + tn, rhs, o, rhs)) + o = '%s._%s'%(rhs, op) ordercols.append(o) elif prop == 'id': o = '_%s.id'%cn