cubicweb #3261648 Simplify RQL rewriting on optional / inlined relations [open]
Considering the following RQL: Any A,N WHERE N is Note, N? rel A and the following read rql expression on Note entities: ERQLExpression('X todo TRUE') the generated RQL is: Any A,N WHERE N is Note WITH N,A BEING (Any N,A WHERE N? rel A, (N is NULL) OR (EXISTS(N todo TRUE)) The RQL below should probably be enough: Any N,A WHERE N is Note, N? rel A, (N is NULL) OR (EXISTS(N todo TRUE)  
priority  important 

type  bug 
done in  <not specified> 
load  0.500 
load left  0.500 
closed by  <not specified> 
Comments

2013/10/29 10:08, written by adimascio

2013/10/29 10:27, written by sthenault

2014/02/13 15:54, written by jcristau

2014/12/09 10:07, written by acampeas
add commentFurthermore, the generated SQL is bogus:
as 'todo' is an attribute, even Any N,A WHERE N is Note, N? rel A, N todo TRUE is enough. The hardest part may be to avoid the subquery though avoiding the OR is the must do.
moving to 3.19
now in 3.21