From 6eb9c11e7b0b99d7bc76633fbfebf6e280ae9994 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 8 Jan 2008 21:53:37 +0000 Subject: - fixed bug in union() so that select() statements which don't derive from FromClause objects can be unioned --- test/sql/select.py | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'test/sql') 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( -- cgit v1.2.1