| branch | stable |
| changeset 1950 | ab7a41b2cd26 |
| parent 1949 | 9064102b4deb |
| child 1951 | f28e7f300d3f |
| 1949:9064102b4deb | 1950:ab7a41b2cd26 |
|---|---|
475 'HAVING COUNT(X) > 10', {'x': self.ueid}) |
475 'HAVING COUNT(X) > 10', {'x': self.ueid}) |
476 self.assertEquals(len(rset.rows), 1) |
476 self.assertEquals(len(rset.rows), 1) |
477 self.assertEquals(rset.rows[0][0], self.ueid) |
477 self.assertEquals(rset.rows[0][0], self.ueid) |
478 |
478 |
479 def test_select_complex_sort(self): |
479 def test_select_complex_sort(self): |
480 self.skip('retry me once http://www.sqlite.org/cvstrac/tktview?tn=3773 is fixed') |
480 """need sqlite including http://www.sqlite.org/cvstrac/tktview?tn=3773 fix""" |
481 rset = self.execute('Any X ORDERBY X,D LIMIT 5 WHERE X creation_date D') |
481 rset = self.execute('Any X ORDERBY X,D LIMIT 5 WHERE X creation_date D') |
482 result = rset.rows |
482 result = rset.rows |
483 result.sort() |
483 result.sort() |
484 self.assertEquals(tuplify(result), [(1,), (2,), (3,), (4,), (5,)]) |
484 self.assertEquals(tuplify(result), [(1,), (2,), (3,), (4,), (5,)]) |
485 |
485 |
1217 def test_nonregr_sortterm_management(self): |
1217 def test_nonregr_sortterm_management(self): |
1218 """Error: Variable has no attribute 'sql' in rql2sql.py (visit_variable) |
1218 """Error: Variable has no attribute 'sql' in rql2sql.py (visit_variable) |
1219 |
1219 |
1220 cause: old variable ref inserted into a fresh rqlst copy |
1220 cause: old variable ref inserted into a fresh rqlst copy |
1221 (in RQLSpliter._complex_select_plan) |
1221 (in RQLSpliter._complex_select_plan) |
1222 |
|
1223 need sqlite including http://www.sqlite.org/cvstrac/tktview?tn=3773 fix |
|
1222 """ |
1224 """ |
1223 self.skip('retry me once http://www.sqlite.org/cvstrac/tktview?tn=3773 is fixed') |
|
1224 self.execute('Any X ORDERBY D DESC WHERE X creation_date D') |
1225 self.execute('Any X ORDERBY D DESC WHERE X creation_date D') |
1225 |
1226 |
1226 def test_nonregr_extra_joins(self): |
1227 def test_nonregr_extra_joins(self): |
1227 ueid = self.session.user.eid |
1228 ueid = self.session.user.eid |
1228 teid1 = self.execute("INSERT Folder X: X name 'folder1'")[0][0] |
1229 teid1 = self.execute("INSERT Folder X: X name 'folder1'")[0][0] |