summaryrefslogtreecommitdiff
path: root/test/sql/test_update.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/test_update.py')
-rw-r--r--test/sql/test_update.py11
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