googleapis · steffnay · Nov 16, 2020 · Nov 16, 2020 · Nov 16, 2020
diff --git a/tests/system.py b/tests/system.py
@@ -249,7 +249,7 @@ def test_close_releases_open_sockets(self):
        client.close()

        conn_count_end = len(current_process.connections())
-        self.assertEqual(conn_count_end, conn_count_start)
+        self.assertLessEqual(conn_count_end, conn_count_start)

    def test_create_dataset(self):
        DATASET_ID = _make_dataset_id("create_dataset")
@@ -1972,7 +1972,9 @@ def test_query_w_dml(self):
    def test_dbapi_w_dml(self):
        dataset_name = _make_dataset_id("dml_dbapi")
        table_name = "test_table"
-        self._load_table_for_dml([("Hello World",)], dataset_name, table_name)
+        self._load_table_for_dml(
+            [("こんにちは",), ("Hello World",), ("Howdy!",)], dataset_name, table_name
+        )
        query_template = """UPDATE {}.{}
            SET greeting = 'Guten Tag'
            WHERE greeting = 'Hello World'
@@ -1983,7 +1985,6 @@ def test_dbapi_w_dml(self):
            job_id="test_dbapi_w_dml_{}".format(str(uuid.uuid4())),
        )
        self.assertEqual(Config.CURSOR.rowcount, 1)
-        self.assertIsNone(Config.CURSOR.fetchone())

    def test_query_w_query_params(self):
        from google.cloud.bigquery.job import QueryJobConfig