babelfish-for-postgresql / babelfish_extensions / 21311050105

77%

BABEL_6_X_DEV: 78%

Build Type

push

github

Committed by web-flow

Commit Message

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>

Coverage Stats

3 of 0 new or added lines in 0 files covered. (NaN%)

1 existing line in 1 file now uncovered.

52479 of 68469 relevant lines covered (76.65%)

388043.29 hits per line