diff options
Diffstat (limited to 'test/sql/select.py')
| -rw-r--r-- | test/sql/select.py | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/test/sql/select.py b/test/sql/select.py index f0af7e238..6a8131046 100644 --- a/test/sql/select.py +++ b/test/sql/select.py @@ -945,6 +945,9 @@ EXISTS (select yay from foo where boo = lar)", self.assert_compile(select([table1], table1.c.myid.in_('a')), "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE mytable.myid = :mytable_myid") + self.assert_compile(select([table1], ~table1.c.myid.in_('a')), + "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE mytable.myid != :mytable_myid") + self.assert_compile(select([table1], table1.c.myid.in_('a', 'b')), "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE mytable.myid IN (:mytable_myid, :mytable_myid_1)") |