babelfish-for-postgresql / babelfish_extensions / 21283089948

Build # 21283089948

Build Type

push

github

Committed by web-flow

Commit Message

Fix exact pattern matching for LIKE operator (#4473)

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

Coverage Stats

50691 of 66455 relevant lines covered (76.28%)

396014.68 hits per line

Source File

Press 'n' to go to next uncovered line, 'b' for previous

Source Not Available