diff -r 6cbc7bc8ea6d -r 5fe84a5f7035 server/sources/rql2sql.py --- a/server/sources/rql2sql.py Fri Apr 17 13:21:05 2009 +0200 +++ b/server/sources/rql2sql.py Fri Apr 17 16:55:37 2009 +0200 @@ -3,14 +3,14 @@ SQL queries optimization ~~~~~~~~~~~~~~~~~~~~~~~~ -1. EUser X WHERE X in_group G, G name 'users': +1. CWUser X WHERE X in_group G, G name 'users': - EUser is the only subject entity type for the in_group relation, + CWUser is the only subject entity type for the in_group relation, which allow us to do :: - SELECT eid_from FROM in_group, EGroup - WHERE in_group.eid_to = EGroup.eid_from - AND EGroup.name = 'users' + SELECT eid_from FROM in_group, CWGroup + WHERE in_group.eid_to = CWGroup.eid_from + AND CWGroup.name = 'users' 2. Any X WHERE X nonfinal1 Y, Y nonfinal2 Z