babelfish-for-postgresql / babelfish_extensions / 21318274092

77%

push

github

Fix exact pattern matching for LIKE operator (#4473) (#4497)

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%)

52709 of 68486 relevant lines covered (76.96%)

391408.0 hits per line