[JCR-2815] SQL query on Name property which starts with a number, does not match

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.1.1
• Component/s: query
• Assignee: Unassigned
• Reporter: Clemens Wyss
• Created: 22/Nov/10 08:03
• Updated: 23/Nov/10 17:27

Description

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