Open
Description
SQLLike has different implementations for inPs and in memory evaluation.
inPs simply delegates the evaluation to Database.
InMemory tries to use RegEx to achieve same result, however operator % is not handled correctly, making it impossible to specify the position of search string.
Implement SQLLikeToRegEx to correctly handle the use of %operator.
Both TBOS_SQLLike
and TBOS_SQLLikeCaseInSensitive
are affected.
Test by comparing results of expression using SQLLike containing % with ObjectInspector InPs checked and unchecked (before and after this change)
Metadata
Metadata
Assignees
Labels
No labels