Test added for list intersection with a SQL lambda function
@@ -25,6 +25,11 @@ def test_move_l_r_table_prefix_to_column_suffix():
expected = "name_l['first'] = name_r['first'] and levenshtein(dob_l, dob_r) < 2"
assert res.lower() == expected.lower()
+ br = "len(list_filter(l.list_of_names, x -> list_contains(r.list_of_names, x))) >= 1"
+ res = move_l_r_table_prefix_to_column_suffix(br)
+ expected = "len(list_filter(list_of_names_l, x -> list_contains(list_of_names_r, x))) >= 1"
+ assert res.lower() == expected.lower()
+
def test_cast_concat_as_varchar():
