Native replace() returns wrong result for empty-string search

[andygrove]

Description

Comet's native replace() function returns incorrect results when the search string is empty.

Spark behavior: replace('hello', '', 'x') returns xhxexlxlxox (inserts replacement between every character and at boundaries).

Comet behavior: returns hello (no replacement).

How to Reproduce

SELECT replace('hello', '', 'x');

Expected: xhxexlxlxox
Actual (Comet): hello

Expected Behavior

Comet should match Spark's semantics for empty-string search in replace().

[wattt3]

take

[andygrove]

@wattt3 apologies - this issue seems to be invalid. It is based on the behavior of Java's string replace method and not the Spark implementation