server/sources/rql2sql.py
changeset 9361 0542a85fe667
parent 9324 a5ce068143ad
child 9468 39b7a91a3f4c
child 9492 c7fc56eecd1a
--- a/server/sources/rql2sql.py	Thu Dec 12 14:25:24 2013 +0100
+++ b/server/sources/rql2sql.py	Thu Nov 14 17:17:02 2013 +0100
@@ -242,12 +242,6 @@
         rhsconst = None # ColumnAlias
     return lhs, lhsconst, rhs, rhsconst
 
-def switch_relation_field(sql, table=''):
-    switchedsql = sql.replace(table + '.eid_from', '__eid_from__')
-    switchedsql = switchedsql.replace(table + '.eid_to',
-                                      table + '.eid_from')
-    return switchedsql.replace('__eid_from__', table + '.eid_to')
-
 def sort_term_selection(sorts, rqlst, groups):
     # XXX beurk
     if isinstance(rqlst, list):
@@ -1132,8 +1126,6 @@
         sqls += self._process_relation_term(relation, rid, lhsvar, lhsconst, 'eid_from')
         sqls += self._process_relation_term(relation, rid, rhsvar, rhsconst, 'eid_to')
         sql = ' AND '.join(sqls)
-        if rschema.symmetric:
-            sql = '(%s OR %s)' % (sql, switch_relation_field(sql))
         return sql
 
     def _visit_outer_join_relation(self, relation, rschema):