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