summaryrefslogtreecommitdiff
path: root/test/sql/test_selectable.py
diff options
context:
space:
mode:
authormike bayer <mike_mp@zzzcomputing.com>2021-07-13 15:15:33 +0000
committerGerrit Code Review <gerrit@ci3.zzzcomputing.com>2021-07-13 15:15:33 +0000
commit3f4ee382a71558d4dbc1d37a2bedcecdce3d5461 (patch)
treec6ca6a07e7b1a7c5b9682de66277c04b0880d28c /test/sql/test_selectable.py
parentb64ecb03a5411dd5f32e40ac564bec9a886d3672 (diff)
parenta0953bb7095dde805de8c13699b122767ed001b9 (diff)
downloadsqlalchemy-3f4ee382a71558d4dbc1d37a2bedcecdce3d5461.tar.gz
Merge "Adjust CTE recrusive col list to accommodate dupe col names"
Diffstat (limited to 'test/sql/test_selectable.py')
-rw-r--r--test/sql/test_selectable.py6
1 files changed, 4 insertions, 2 deletions
diff --git a/test/sql/test_selectable.py b/test/sql/test_selectable.py
index be894d239..cfdf4ad02 100644
--- a/test/sql/test_selectable.py
+++ b/test/sql/test_selectable.py
@@ -998,9 +998,11 @@ class SelectableTest(
self.assert_compile(
stmt,
"SELECT anon_1.col1, anon_1.col2, anon_1.col1_1 FROM "
- "((SELECT table1.col1, table1.col2, table2.col1 AS col1_1 "
+ "((SELECT table1.col1 AS col1, table1.col2 AS col2, table2.col1 "
+ "AS col1_1 "
"FROM table1, table2 LIMIT :param_1) UNION "
- "(SELECT table2.col1, table2.col2, table2.col3 FROM table2 "
+ "(SELECT table2.col1 AS col1, table2.col2 AS col2, "
+ "table2.col3 AS col3 FROM table2 "
"LIMIT :param_2)) AS anon_1",
)