diff options
Diffstat (limited to 'test')
| -rw-r--r-- | test/aaa_profiling/test_memusage.py | 4 | ||||
| -rw-r--r-- | test/orm/test_deprecations.py | 1 | ||||
| -rw-r--r-- | test/sql/test_compiler.py | 8 |
3 files changed, 6 insertions, 7 deletions
diff --git a/test/aaa_profiling/test_memusage.py b/test/aaa_profiling/test_memusage.py index 10ec4d307..2b806baf7 100644 --- a/test/aaa_profiling/test_memusage.py +++ b/test/aaa_profiling/test_memusage.py @@ -458,7 +458,7 @@ class MemUsageWBackendTest(fixtures.MappedTest, EnsureZeroed): @testing.emits_warning("Compiled statement cache for lazy loader.*") @testing.crashes("sqlite", ":memory: connection not suitable here") def test_orm_many_engines(self): - metadata = MetaData(self.engine) + metadata = MetaData() table1 = Table( "mytable", @@ -485,7 +485,7 @@ class MemUsageWBackendTest(fixtures.MappedTest, EnsureZeroed): Column("col3", Integer, ForeignKey("mytable.col1")), ) - metadata.create_all() + metadata.create_all(self.engine) m1 = self.mapper_registry.map_imperatively( A, diff --git a/test/orm/test_deprecations.py b/test/orm/test_deprecations.py index e8d75ac48..97ee97bc0 100644 --- a/test/orm/test_deprecations.py +++ b/test/orm/test_deprecations.py @@ -1843,7 +1843,6 @@ class MixedEntitiesTest(QueryTest, AssertsCompiledSQL): q2 = q.values(func.count(User.name)) assert next(q2) == (4,) - @testing.fails_on("mssql", "FIXME: unknown") def test_values_specific_order_by(self): User = self.classes.User diff --git a/test/sql/test_compiler.py b/test/sql/test_compiler.py index c273dbbf8..d20037e92 100644 --- a/test/sql/test_compiler.py +++ b/test/sql/test_compiler.py @@ -2244,7 +2244,7 @@ class SelectTest(fixtures.TestBase, AssertsCompiledSQL): (value_tbl.c.val2 - value_tbl.c.val1) / value_tbl.c.val1, ), "SELECT values.id, (values.val2 - values.val1) " - "/ CAST(values.val1 AS NUMERIC) AS anon_1 FROM values", + "/ CAST(values.val1 AS FLOAT) AS anon_1 FROM values", ) self.assert_compile( @@ -2253,7 +2253,7 @@ class SelectTest(fixtures.TestBase, AssertsCompiledSQL): ), "SELECT values.id FROM values WHERE " "(values.val2 - values.val1) / " - "CAST(values.val1 AS NUMERIC) > :param_1", + "CAST(values.val1 AS FLOAT) > :param_1", ) self.assert_compile( @@ -2264,8 +2264,8 @@ class SelectTest(fixtures.TestBase, AssertsCompiledSQL): > 2.0, ), "SELECT values.id FROM values WHERE " - "(values.val1 / CAST((values.val2 - values.val1) AS NUMERIC)) " - "/ CAST(values.val1 AS NUMERIC) > :param_1", + "(values.val1 / CAST((values.val2 - values.val1) AS FLOAT)) " + "/ CAST(values.val1 AS FLOAT) > :param_1", ) def test_percent_chars(self): |