jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lukas Kahwe Smith <...@pooteeweet.org>
Subject Re: IS NULL
Date Tue, 30 Aug 2011 08:05:46 GMT

On Aug 29, 2011, at 18:47 , Mark Herman wrote:

> First of all, by "document" you mean node, and "field" you mean property of a
> node right?

yes

> Here is the structure I'm testing with (@ indicates property):
> /nullproptest (nt:unstructured)
> /nullproptest/a (nt:unstructured)
> /nullproptest/a@important = "I'm here" (String)
> /nullproptest/b (nt:unstructured)
> /nullproptest/c (nt:unstructured)
> /nullproptest/c@important = "" (empty string)
> 
> (Note:  b does have the "important" property:)
> 
> Query: SELECT * FROM [nt:unstructured] WHERE [nt:unstructured].important IS
> NULL AND ISDESCENDANTNODE([/nullproptest]) ORDER BY SCORE() DESC
> Returns: /nullproptest/b
> 
> Query: SELECT * FROM [nt:unstructured] WHERE [nt:unstructured].important IS
> NOT NULL AND ISDESCENDANTNODE([/nullproptest]) ORDER BY SCORE() DESC
> Returns: /nullproptest/a, /nullproptest/c
> 
> Query: SELECT * FROM [nt:unstructured] WHERE [nt:unstructured].important <>
> "" AND ISDESCENDANTNODE([/nullproptest]) ORDER BY SCORE() DESC
> Returns: /nullproptest/a


ok thank you for the detailed reply. makes it all the more obvious that the issue must be
in the test case in our app and not with jackrabbit.

regards,
Lukas Kahwe Smith
mls@pooteeweet.org




Mime
View raw message