This content has been marked as final. Show 4 replies
This seems to be a BUG.
This one is pretty much similar.
[url https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PATCH&id=9149540.8]Bug 9149540 - Wrong results for LIKE operator with NLS_SORT=binary_ci and NLS_COMP=linguistic ID 9149540.8
Did you create a SR?
Yes, this looks like a nasty bug but it is not bug #9149540. I can reproduce it in code later than 18.104.22.168, where bug #9149540 is fixed. The symptoms do not match either.1 person found this helpful
I am investigating this issue. It has to do with incorrectly preformed transformation of the LIKE predicate into a combination of >=, <, and INSTR()=1 predicates. The goal of the transformation is to make it possible to use a linguistic index to select the values.
Thank you both for the replies. I have opened an SR...
Did you ever get an ans from them? seems like if I do wild card % infront of the '%__%' like searches its fine. But without it, '__%' it returns a weird result.
Oracle version is 22.214.171.124.0 Oracle version.