- add coverage for result map rewriting

- fix the result map rewriter for col mismatches, since the rewritten
select at the moment typically has more columns than the original

1 files changed, 6 insertions, 0 deletions

diff --git a/test/sql/test_join_rewriting.py b/test/sql/test_join_rewriting.py
index 701d25887..5a9bdd1d3 100644
--- a/test/sql/test_join_rewriting.py
+++ b/test/sql/test_join_rewriting.py
@@ -37,6 +37,12 @@ class _JoinRewriteTestBase(AssertsCompiledSQL):
             assert_
         )
 
+        compiled = s.compile(dialect=self.__dialect__)
+        for key, col in zip([c.key for c in s.c], s.inner_columns):
+            key = key % compiled.anon_map
+            assert col in compiled.result_map[key][1]
+
+
     def test_a_bc(self):
         j1 = b.join(c)
         j2 = a.join(j1)