diff options
| author | Ants Aasma <ants.aasma@gmail.com> | 2008-10-20 20:41:09 +0000 |
|---|---|---|
| committer | Ants Aasma <ants.aasma@gmail.com> | 2008-10-20 20:41:09 +0000 |
| commit | 11619ad8eeb137efd84bda67d34414c3c3e00080 (patch) | |
| tree | b6f0265f2d81b2497e4fd2f4d3dc53bf23112ac3 /test/sql/select.py | |
| parent | 9dd05715de7e673b5ab4af8eb84b719f8d5e66ff (diff) | |
| download | sqlalchemy-11619ad8eeb137efd84bda67d34414c3c3e00080.tar.gz | |
Slightly changed behavior of IN operator for comparing to empty collections. Now results in inequality comparison against self. More portable, but breaks with stored procedures that aren't pure functions.
Diffstat (limited to 'test/sql/select.py')
| -rw-r--r-- | test/sql/select.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/test/sql/select.py b/test/sql/select.py index 52aa151d9..e959a7992 100644 --- a/test/sql/select.py +++ b/test/sql/select.py @@ -1185,7 +1185,7 @@ UNION SELECT mytable.myid FROM mytable WHERE mytable.myid = :myid_2)") # test empty in clause self.assert_compile(select([table1], table1.c.myid.in_([])), - "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE (CASE WHEN (mytable.myid IS NULL) THEN NULL ELSE 0 END = 1)") + "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE mytable.myid != mytable.myid") self.assert_compile( select([table1.c.myid.in_(select([table2.c.otherid]))]), |