diff options
Diffstat (limited to 'test')
| -rw-r--r-- | test/dialect/test_firebird.py | 16 | ||||
| -rw-r--r-- | test/sql/test_query.py | 1 |
2 files changed, 17 insertions, 0 deletions
diff --git a/test/dialect/test_firebird.py b/test/dialect/test_firebird.py index 9bdce8ff7..944d5bc2f 100644 --- a/test/dialect/test_firebird.py +++ b/test/dialect/test_firebird.py @@ -259,6 +259,22 @@ class CompileTest(TestBase, AssertsCompiledSQL): i = insert(table1, values=dict(name='foo')).returning(func.length(table1.c.name)) self.assert_compile(i, "INSERT INTO mytable (name) VALUES (:name) RETURNING char_length(mytable.name) AS length_1") + def test_charset(self): + """Exercise CHARACTER SET options on string types.""" + + columns = [ + (firebird.CHAR, [1], {}, + 'CHAR(1)'), + (firebird.CHAR, [1], {'charset' : 'OCTETS'}, + 'CHAR(1) CHARACTER SET OCTETS'), + (firebird.VARCHAR, [1], {}, + 'VARCHAR(1)'), + (firebird.VARCHAR, [1], {'charset' : 'OCTETS'}, + 'VARCHAR(1) CHARACTER SET OCTETS'), + ] + + for type_, args, kw, res in columns: + self.assert_compile(type_(*args, **kw), res) diff --git a/test/sql/test_query.py b/test/sql/test_query.py index 5a4f03311..2b51d68a2 100644 --- a/test/sql/test_query.py +++ b/test/sql/test_query.py @@ -809,6 +809,7 @@ class QueryTest(TestBase): assert len(r) == 0 @testing.emits_warning('.*empty sequence.*') + @testing.fails_on('firebird', 'uses sql-92 bind rules') def test_literal_in(self): """similar to test_bind_in but use a bind with a value.""" |