3 Replies Latest reply on Aug 21, 2014 7:05 PM by rhauch

JCR Query in Modeshape returns no result when empty string used in comparison

valeriy.shtanko Mar 17, 2014 1:21 PM

I found the problem with JCR Query in Modeshape when empty string used in comparison.

Query

SELECT * FROM [car:Car] AS cars WHERE [car:engine] = ''

returns no nodes instead of expected 1 node.

To reproduce suituation, files

<modeshape-sources-dir>/modeshape-jcr/src/test/resources/io/cars-system-view.xml

<modeshape-sources-dir>/modeshape-jcr/src/test/java/org/modeshape/jcr/JcrQueryManagerTest.java

should be replaced with attachments.

Test function is 'shouldBeAbleToFindResultSearchingByEmptyProperty'.

1. Re: JCR Query in Modeshape returns no result when empty string used in comparison

rhauch Mar 17, 2014 4:19 PM (in response to valeriy.shtanko)

Please open an issue in our JIRA. We should be able to use criteria that checks for an empty string, and for a 0-length string as well. (Did you try that?)
Actions
2. Re: JCR Query in Modeshape returns no result when empty string used in comparison

valeriy.shtanko Mar 18, 2014 5:08 AM (in response to rhauch)

I created issue
MODE-2174
Actions
3. Re: Re: JCR Query in Modeshape returns no result when empty string used in comparison

rhauch Aug 21, 2014 7:05 PM (in response to valeriy.shtanko)

I finally got around to testing this, and the existing code works correctly. The following criteria:

... WHERE [car:engine] = ''

applied only to non-null property values. Also, at least as of 4.0.0.Beta1, even when a property value is an empty string the above criteria works correctly.

Note that the correct way to find nodes where the property value is null or empty is to use:

... WHERE [car:engine] IS NULL OR [car:engine] = ''

But the following also works, even when the property value is null:

... WHERE LENGTH([car:engine]) == 0
Actions