diff options
| author | Lele Gaifax <lele@metapensiero.it> | 2008-04-11 22:14:34 +0000 |
|---|---|---|
| committer | Lele Gaifax <lele@metapensiero.it> | 2008-04-11 22:14:34 +0000 |
| commit | c79342ef957fd901db41562ad13e68638a597fbe (patch) | |
| tree | 2eaddccbd78774a0d4cc4d73cf1c27d0859bfe50 /test/dialect/firebird.py | |
| parent | ce109f7adf081c3b42802d0de1a2c92bc56f9809 (diff) | |
| download | sqlalchemy-c79342ef957fd901db41562ad13e68638a597fbe.tar.gz | |
Firebird 2 has a SUBSTRING() builtin, expose it thru a function
Diffstat (limited to 'test/dialect/firebird.py')
| -rw-r--r-- | test/dialect/firebird.py | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/test/dialect/firebird.py b/test/dialect/firebird.py index fe4161a1b..f929443fd 100644 --- a/test/dialect/firebird.py +++ b/test/dialect/firebird.py @@ -85,6 +85,9 @@ class CompileTest(TestBase, AssertsCompiledSQL): t = Table('sometable', m, Column('col1', Integer), Column('col2', Integer)) self.assert_compile(select([func.max(t.c.col1)]), "SELECT max(sometable.col1) AS max_1 FROM sometable") + def test_substring(self): + self.assert_compile(func.substring('abc', 1, 2), "SUBSTRING(:substring_1 FROM :substring_2 FOR :substring_3)") + self.assert_compile(func.substring('abc', 1), "SUBSTRING(:substring_1 FROM :substring_2)") class MiscFBTests(TestBase): |