diff options
| author | Ants Aasma <ants.aasma@gmail.com> | 2007-06-25 18:14:40 +0000 |
|---|---|---|
| committer | Ants Aasma <ants.aasma@gmail.com> | 2007-06-25 18:14:40 +0000 |
| commit | 987581e6d2c893f4fe1c6877bd4b096f00ff63c3 (patch) | |
| tree | 19a71c67c0fd50baa7019314dc6caa1c51eb550e /test/sql | |
| parent | bc58df9c1f1f443b67a3312463df2c9425531503 (diff) | |
| download | sqlalchemy-987581e6d2c893f4fe1c6877bd4b096f00ff63c3.tar.gz | |
fix precedence of between (ticket #621)
Diffstat (limited to 'test/sql')
| -rw-r--r-- | test/sql/select.py | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/test/sql/select.py b/test/sql/select.py index 7ae830e6a..10fa631f0 100644 --- a/test/sql/select.py +++ b/test/sql/select.py @@ -940,6 +940,10 @@ UNION SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE "SELECT op.field FROM op WHERE NOT op.field = :op_field") self.runtest(table.select(not_(table.c.field) == 5), "SELECT op.field FROM op WHERE (NOT op.field) = :literal") + self.runtest(table.select((table.c.field == table.c.field).between(False, True)), + "SELECT op.field FROM op WHERE (op.field = op.field) BETWEEN :literal AND :literal_1") + self.runtest(table.select(between((table.c.field == table.c.field), False, True)), + "SELECT op.field FROM op WHERE (op.field = op.field) BETWEEN :literal AND :literal_1") class CRUDTest(SQLTest): def testinsert(self): |