summaryrefslogtreecommitdiff
path: root/test/sql/select.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/select.py')
-rw-r--r--test/sql/select.py9
1 files changed, 9 insertions, 0 deletions
diff --git a/test/sql/select.py b/test/sql/select.py
index 0df575c7c..ae49659f7 100644
--- a/test/sql/select.py
+++ b/test/sql/select.py
@@ -888,6 +888,15 @@ WHERE mytable.name = :mytable_name_1 GROUP BY mytable.myid, mytable.name UNION S
FROM mytable WHERE mytable.name = :mytable_name_2"
)
+ self.assert_compile(
+ union(
+ select([literal(100).label('value')]),
+ select([literal(200).label('value')])
+ ),
+ "SELECT :param_1 AS value UNION SELECT :param_2 AS value"
+ )
+
+
def test_compound_select_grouping(self):
self.assert_compile(
union_all(