[Date Prev][Date Next] [Chronological] [Thread] [Top]

[back-sql] Problem with NOT search requests (ITS#2652)

Full_Name: Emmanuel Duru
Version: 2.2.0 alpha
OS: solaris 8
Submission from: (NULL) (

A search request like (!<some attribute>=<some value>) should select
the entries which do not have <some attribute>; with back-sql only
entries which have at least one value for <some attribute> are selected.
The problem is that the request to select candidate entries perform a
join on the attribute in the filter (excluding entries without the
attribute). Consequently, the search request (!<some attribute>=*) does
not select any entry.
[Pierangelo Masarati] This is a known limitation caused by the design of the
some filters may not generate complete queries.  We might need
to think about a different design, if feasible.