babelfish-for-postgresql / babelfish_extensions / 21292135776

76%

BABEL_5_X_DEV: 77%

push

github

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

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

50463 of 66440 relevant lines covered (75.95%)

394358.09 hits per line