Repair tests for older SQLite, timing, pypy

Change-Id: I9e425d2415d18a893342244755c7748b546fb20d

1 files changed, 3 insertions, 5 deletions

diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py
index 23ceb88b3..ad169eebf 100644
--- a/test/dialect/test_sqlite.py
+++ b/test/dialect/test_sqlite.py
@@ -536,17 +536,15 @@ class DefaultsTest(fixtures.TestBase, AssertsCompiledSQL):
             "t",
             self.metadata,
             Column("id", Integer, primary_key=True),
-            Column("x", DateTime(), server_default=func.now()),
+            Column("x", String(), server_default=func.lower("UPPERCASE")),
         )
         t.create(testing.db)
         with testing.db.begin() as conn:
-            now = conn.scalar(func.now())
-            today = datetime.datetime.today()
             conn.execute(t.insert())
-            conn.execute(t.insert().values(x=today))
+            conn.execute(t.insert().values(x="foobar"))
             eq_(
                 conn.execute(select(t.c.x).order_by(t.c.id)).fetchall(),
-                [(now,), (today,)],
+                [("uppercase",), ("foobar",)],
             )
 
     @testing.provide_metadata