diff options
Diffstat (limited to 'test/sql/select.py')
-rw-r--r-- | test/sql/select.py | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/test/sql/select.py b/test/sql/select.py index 2e099b01a..0edaab071 100644 --- a/test/sql/select.py +++ b/test/sql/select.py @@ -314,6 +314,14 @@ sq.myothertable_othername AS sq_myothertable_othername FROM (" + sqstring + ") A self.runtest( select([table1.c.myid]).distinct(), "SELECT DISTINCT mytable.myid FROM mytable" ) + + self.runtest( + select([func.count(table1.c.myid.distinct())]), "SELECT count(DISTINCT mytable.myid) FROM mytable" + ) + + self.runtest( + select([func.count(distinct(table1.c.myid))]), "SELECT count(DISTINCT mytable.myid) FROM mytable" + ) def testoperators(self): |