From 379c6d1f52e1d311867c4f789dc389da1d9af898 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 6 Aug 2023 09:48:11 +0200 Subject: Merging upstream version 17.9.1. Signed-off-by: Daniel Baumann --- tests/test_transforms.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'tests/test_transforms.py') diff --git a/tests/test_transforms.py b/tests/test_transforms.py index 24d8c30..80d12ac 100644 --- a/tests/test_transforms.py +++ b/tests/test_transforms.py @@ -99,7 +99,7 @@ class TestTransforms(unittest.TestCase): self.validate( eliminate_qualify, "SELECT * FROM qt QUALIFY ROW_NUMBER() OVER (PARTITION BY p ORDER BY o) = 1", - "SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY p ORDER BY o) AS _w, p, o FROM qt) AS _t WHERE _w = 1", + "SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY p ORDER BY o) AS _w FROM qt) AS _t WHERE _w = 1", ) self.validate( eliminate_qualify, -- cgit v1.2.3