Search with wildcards and index issue



I have a search using wildcards: SELECT $1 FROM CDI $1 WHERE $1.loginId LIKE '%*_last%2' ESCAPE '*'

This works perfectly when loginId has NO annotations.

Now if I add to loginId the following annotations:


the search no longer works.

I have attached the unit test. (this is using 2.3.7_10)




Your test demonstrates that ESCAPE in LIKE was ignored when using an index.

Build 2.3.7_11 fixes this bug. Thank you for your report.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)

Post Reply

To post a reply and/or subscribe to update notifications - please login