diff options
Diffstat (limited to 'test/query.py')
| -rw-r--r-- | test/query.py | 19 |
1 files changed, 14 insertions, 5 deletions
diff --git a/test/query.py b/test/query.py index 75088da57..e3d1767b5 100644 --- a/test/query.py +++ b/test/query.py @@ -63,16 +63,25 @@ class QueryTest(PersistTest): x['x'] += 1 return x['x'] + # select "count(1)" from the DB which returns different results + # on different DBs + f = select([func.count(1)], engine=db).execute().fetchone()[0] + t = Table('default_test1', db, Column('col1', Integer, primary_key=True, default=mydefault), Column('col2', String(20), default="imthedefault"), - Column('col3', String(20), default=func.count(1)), + Column('col3', Integer, default=func.count(1)), ) t.create() - t.insert().execute() - t.insert().execute() - t.insert().execute() - t.drop() + try: + t.insert().execute() + t.insert().execute() + t.insert().execute() + + l = t.select().execute() + self.assert_(l.fetchall() == [(1, 'imthedefault', f), (2, 'imthedefault', f), (3, 'imthedefault', f)]) + finally: + t.drop() def testdelete(self): c = db.connection() |