LIKE wildcard with single character "_" behaves like a "*"

#1

Hi, 

I've been using pattern matching with wildcards, and encountered an issue when dealing with the underscore character. The issue is that if it is placed at the end of the string, the "_" behaves like a "*".

For example, if I have a query

SELECT * FROM table1 WHERE (col1.name LIKE "ke_") 

It matches both "key" and "keyboard"

Having the underscore anywhere else works fine, however. 

Thanks

#2

Thank you this report.

Please try build 2.8.3_01 that should fix the issue.

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

Post Reply

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