From 36db14f4c6c28209371d563d76697df0172e337f Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Mon, 24 Jul 2023 10:03:48 +0200 Subject: Merging upstream version 17.7.0. Signed-off-by: Daniel Baumann --- tests/test_build.py | 3 +++ 1 file changed, 3 insertions(+) (limited to 'tests/test_build.py') diff --git a/tests/test_build.py b/tests/test_build.py index f354640..826a59b 100644 --- a/tests/test_build.py +++ b/tests/test_build.py @@ -58,6 +58,9 @@ class TestBuild(unittest.TestCase): (lambda: x.as_("y"), "x AS y"), (lambda: x.isin(1, "2"), "x IN (1, '2')"), (lambda: x.isin(query="select 1"), "x IN (SELECT 1)"), + (lambda: x.isin(unnest="x"), "x IN (SELECT UNNEST(x))"), + (lambda: x.isin(unnest="x"), "x IN UNNEST(x)", "bigquery"), + (lambda: x.isin(unnest=["x", "y"]), "x IN (SELECT UNNEST(x, y))"), (lambda: x.between(1, 2), "x BETWEEN 1 AND 2"), (lambda: 1 + x + 2 + 3, "1 + x + 2 + 3"), (lambda: 1 + x * 2 + 3, "1 + (x * 2) + 3"), -- cgit v1.2.3