From 1fb60a37d31eacbac62ddafde51b829522925694 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Mon, 3 Apr 2023 09:31:50 +0200 Subject: Adding upstream version 11.4.5. Signed-off-by: Daniel Baumann --- tests/test_executor.py | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'tests/test_executor.py') diff --git a/tests/test_executor.py b/tests/test_executor.py index 013ff34..c455f3a 100644 --- a/tests/test_executor.py +++ b/tests/test_executor.py @@ -401,6 +401,16 @@ class TestExecutor(unittest.TestCase): ], ) + table1_view = exp.Select().select("id", "sub_type").from_("table1").subquery() + select_from_sub_query = exp.Select().select("id AS id_alias", "sub_type").from_(table1_view) + expression = exp.Select().select("*").from_("cte1").with_("cte1", as_=select_from_sub_query) + + schema = {"table1": {"id": "str", "sub_type": "str"}} + executed = execute(expression, tables={t: [] for t in schema}, schema=schema) + + self.assertEqual(executed.rows, []) + self.assertEqual(executed.columns, ("id_alias", "sub_type")) + def test_correlated_count(self): tables = { "parts": [{"pnum": 0, "qoh": 1}], -- cgit v1.2.3