diff options
| -rw-r--r-- | lib/sqlalchemy/dialects/sqlite/pysqlite.py | 3 | ||||
| -rw-r--r-- | lib/sqlalchemy/testing/suite/test_select.py | 1 |
2 files changed, 3 insertions, 1 deletions
diff --git a/lib/sqlalchemy/dialects/sqlite/pysqlite.py b/lib/sqlalchemy/dialects/sqlite/pysqlite.py index eb855016e..377411520 100644 --- a/lib/sqlalchemy/dialects/sqlite/pysqlite.py +++ b/lib/sqlalchemy/dialects/sqlite/pysqlite.py @@ -506,6 +506,8 @@ class SQLiteDialect_pysqlite(SQLiteDialect): connect = super(SQLiteDialect_pysqlite, self).on_connect() def regexp(a, b): + if b is None: + return None return bool(re.match(a, b)) def set_regexp(connection): @@ -513,7 +515,6 @@ class SQLiteDialect_pysqlite(SQLiteDialect): dbapi_connection = connection.connection else: dbapi_connection = connection - dbapi_connection.create_function( "regexp", 2, diff --git a/lib/sqlalchemy/testing/suite/test_select.py b/lib/sqlalchemy/testing/suite/test_select.py index 224826c25..a2924bfde 100644 --- a/lib/sqlalchemy/testing/suite/test_select.py +++ b/lib/sqlalchemy/testing/suite/test_select.py @@ -894,6 +894,7 @@ class LikeFunctionsTest(fixtures.TablesTest): {"id": 8, "data": "ab9cdefg"}, {"id": 9, "data": "abcde#fg"}, {"id": 10, "data": "abcd9fg"}, + {"id": 11, "data": None}, ], ) |