1 files changed, 17 insertions, 0 deletions
diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py
index b5ce291eb..ed0f11907 100644
--- a/test/dialect/test_sqlite.py
+++ b/test/dialect/test_sqlite.py
@@ -54,6 +54,7 @@ from sqlalchemy.testing import expect_warnings
 from sqlalchemy.testing import fixtures
 from sqlalchemy.testing import is_
 from sqlalchemy.testing import mock
+from sqlalchemy.testing.assertions import expect_raises_message
 from sqlalchemy.types import Boolean
 from sqlalchemy.types import Date
 from sqlalchemy.types import DateTime
@@ -596,6 +597,22 @@ class DialectTest(
                 )
             )
 
+    @testing.requires.insert_order_dicts
+    @testing.only_on("sqlite+pysqlite")
+    def test_isolation_level_message(self):
+        # needs to test that all three words are present and we also
+        # dont want to default all isolation level messages to use
+        # sorted(), so rely on python 3.7 for ordering of keywords
+        # in the message
+        with expect_raises_message(
+            exc.ArgumentError,
+            "Invalid value 'invalid' for "
+            "isolation_level. Valid isolation levels for "
+            "sqlite are READ UNCOMMITTED, SERIALIZABLE, AUTOCOMMIT",
+        ):
+            with testing.db.connect() as conn:
+                conn.execution_options(isolation_level="invalid")
+
     @testing.only_on("sqlite+pysqlcipher")
     def test_pysqlcipher_connects(self):
         """test #6586"""