Fast Object Database for Java - with JPA/JDO support

Issue #2576: LIKE wildcard with single character "_" behaves like a "*"

Type: Bug reoprtVersion: 2.6.5Priority: NormalStatus: ActiveReplies: 1


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 ( LIKE "ke_") 

It matches both "key" and "keyboard"

Having the underscore anywhere else works fine, however. 



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