From 1a9618afdd6413fd04ee44b797a15735eaa1a230 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Fri, 2 Oct 2020 08:15:41 -0400
Subject: accommodate for null in sqlite regex handler

Fixes: #5624
Change-Id: Ic20dcde0a1e96b9981c63cac3cd34c7fdc7bd395
---
 lib/sqlalchemy/dialects/sqlite/pysqlite.py | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'lib/sqlalchemy/dialects/sqlite')

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,
-- 
cgit v1.2.1