diff options
Diffstat (limited to 'test/sql/test_update.py')
-rw-r--r-- | test/sql/test_update.py | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/test/sql/test_update.py b/test/sql/test_update.py index 829739bcc..a08d5f672 100644 --- a/test/sql/test_update.py +++ b/test/sql/test_update.py @@ -177,6 +177,17 @@ class UpdateTest(_UpdateFromTestBase, fixtures.TablesTest, AssertsCompiledSQL): 'mytable.myid = hoho(:hoho_1) AND ' 'mytable.name = :param_2 || mytable.name || :param_3') + def test_where_empty(self): + table1 = self.tables.mytable + self.assert_compile( + table1.update().where(and_()), + "UPDATE mytable SET myid=:myid, name=:name, description=:description" + ) + self.assert_compile( + table1.update().where(or_()), + "UPDATE mytable SET myid=:myid, name=:name, description=:description" + ) + def test_prefix_with(self): table1 = self.tables.mytable |