We noticed a regression in Python3.10.0a6 (it works properly in Python3.10.0a5) when running Django's test suite. Empty bytestrings are not longer returned properly on SQLite:

def test_return_empty_bytes(self):
    cur = self.con.cursor()
    cur.execute("select X''")
    val = cur.fetchone()[0]
    self.assertEqual(val, b'')

Regression in https://github.com/python/cpython/commit/47feb1feb28631b6647699b7633109aa85340966
See https://bugs.python.org/issue43249

I will submit PR in few minutes.

sqlite3_column_blob() should be handled like sqlite3_value_blob() in GH-24674:

In case of NULL, check sqlite3_errcode() and raise MemoryError if needed. Else it's a zero-sized blob.

I created bpo-43369 for out-of-memory error handling, since it also applies to sqlite3_column_text().

New changeset 3b4b2cf418707c79f96689e401e3c703c0fdd4d2 by Mariusz Felisiak in branch 'master':
bpo-43368: Fix fetching empty bytes in sqlite3 (GH-24706)
https://github.com/python/cpython/commit/3b4b2cf418707c79f96689e401e3c703c0fdd4d2