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.