--> https://issues.apache.org/jira/browse/JCR-2815
Regards Clemens > -----Ursprüngliche Nachricht----- > Von: Clemens Wyss [mailto:[email protected]] > Gesendet: Sonntag, 21. November 2010 14:29 > An: [email protected] > Betreff: Bug? SQL query on Name property which starts with a number... > > 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?
