babelfish-for-postgresql / babelfish_extensions / 21311050105

77%

BABEL_5_X_DEV: 77%

push

github

Fix exact pattern matching for LIKE operator (#4489)

* Fix exact pattern matching for LIKE operator (#4473) (#4487)

Currently, when LIKE operator is transformed for exact match cases, it is completely converted to an = operator without retaining the LIKE filter. This causes incorrect behavior with sys.sysname (domain on sys.varchar(128)) and varchar datatypes where trailing spaces are ignored during comparison.

Solution:
Modify LIKE transformation logic: When transforming LIKE to = operator for exact match, retain the LIKE filter as well. This will ensure both operands are cast to TEXT and return expected results.

Issues Resolved
[BABEL-6223]

Authored by: Mohit Raj mrxmohit@amazon.com

* update schedule files

---------

Co-authored-by: Mohit Raj <mrxmohit@amazon.com>

3 of 3 new or added lines in 1 file covered. (100.0%)

52479 of 68469 relevant lines covered (76.65%)

388043.29 hits per line