Search with wildcards and index issue

#1

Hi,

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:

@Index(unique="true")
@Column(nullable=false,unique=true)

the search no longer works.

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

Thanks

Paul.

#2

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

Reply