From cc4c0dd96253b35f63ef9b32e3f2fee436cb25c0 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 20 Sep 2023 13:43:21 -0400 Subject: [PATCH] adjust view definition reflection test for pg16 Change-Id: Idd45f8f9dab14bfb0e3f69e82e8c7898ab7d87ba --- test/dialect/postgresql/test_reflection.py | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) diff --git a/test/dialect/postgresql/test_reflection.py b/test/dialect/postgresql/test_reflection.py index f7f86a79c3..ab4fa2c038 100644 --- a/test/dialect/postgresql/test_reflection.py +++ b/test/dialect/postgresql/test_reflection.py @@ -321,15 +321,20 @@ class MaterializedViewReflectionTest( insp = inspect(connection) def normalize(definition): + # pg16 returns "SELECT" without qualifying tablename. + # older pgs include it + definition = re.sub( + r"testtable\.(\w+)", lambda m: m.group(1), definition + ) return re.sub(r"[\n\t ]+", " ", definition.strip()) eq_( normalize(insp.get_view_definition("test_mview")), - "SELECT testtable.id, testtable.data FROM testtable;", + "SELECT id, data FROM testtable;", ) eq_( normalize(insp.get_view_definition("test_regview")), - "SELECT testtable.data FROM testtable;", + "SELECT data FROM testtable;", ) def test_get_view_comment(self, connection): -- 2.47.3