correct for "autocommit" deprecation warning

Ensure no autocommit warnings occur internally or
within tests.

Also includes fixes for SQL Server full text tests
which apparently have not been working at all for a long
time, as it used long removed APIs.  CI has not had
fulltext running for some years and is now installed.

Change-Id: Id806e1856c9da9f0a9eac88cebc7a94ecc95eb96

1 files changed, 2 insertions, 12 deletions

diff --git a/test/sql/test_defaults.py b/test/sql/test_defaults.py
index 4a6ebd0c8..2a2e70bc3 100644
--- a/test/sql/test_defaults.py
+++ b/test/sql/test_defaults.py
@@ -1012,9 +1012,7 @@ class PKIncrementTest(fixtures.TablesTest):
             Column("str1", String(20)),
         )
 
-    # TODO: add coverage for increment on a secondary column in a key
-    @testing.fails_on("firebird", "Data type unknown")
-    def _test_autoincrement(self, connection):
+    def test_autoincrement(self, connection):
         aitable = self.tables.aitable
 
         ids = set()
@@ -1064,14 +1062,6 @@ class PKIncrementTest(fixtures.TablesTest):
             ],
         )
 
-    def test_autoincrement_autocommit(self):
-        with testing.db.connect() as conn:
-            self._test_autoincrement(conn)
-
-    def test_autoincrement_transaction(self):
-        with testing.db.begin() as conn:
-            self._test_autoincrement(conn)
-
 
 class EmptyInsertTest(fixtures.TestBase):
     __backend__ = True
@@ -1267,7 +1257,7 @@ class SpecialTypePKTest(fixtures.TestBase):
             implicit_returning=implicit_returning,
         )
 
-        with testing.db.connect() as conn:
+        with testing.db.begin() as conn:
             t.create(conn)
             r = conn.execute(t.insert().values(data=5))