The first startsWith, endsWith or contains in a lambda's JSON given a
pattern that isn't a string literal, such as a column or texts joined with
+: the engine writes the pattern's own SQL as the text to match on all but
Snowflake, or fails, so the rows would be wrong (PLAN ยง11.14); undefined
when there is none
The first
startsWith,endsWithorcontainsin a lambda's JSON given a pattern that isn't a string literal, such as a column or texts joined with+: the engine writes the pattern's own SQL as the text to match on all but Snowflake, or fails, so the rows would be wrong (PLAN ยง11.14);undefinedwhen there is none