jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clemens Wyss <clemens...@mysign.ch>
Subject Bug? SQL query on Name property which starts with a number...
Date Sun, 21 Nov 2010 13:28:55 GMT
1) Create a (nt:unstrutured) node in the repo
2) Add a Name property (e.g.) nameProperty

If the Name-property contains a text which doesn't start with a numer, e.g. "hello" then
>select * from nt:unstructured where nameProperty = 'hello'
returns the given node.

BUT if the the text of the Name-property starts with a number, e.g. "2hello" 
>select * from nt:unstructured where nameProperty = '2hello'
Or
>select * from nt:unstructured where nameProperty like '%hello'
NO MATCHING NODE IS RETURNED

BUG?

Mime
View raw message