import sqlite3

def coll(a, b):
    if a == "boom":
        raise KeyError("collation raised")
    return (a > b) - (a < b)

con = sqlite3.connect(":memory:")
con.create_collation("c", coll)
con.execute("create table t(x, y)")
con.executemany("insert into t values (?, ?)",
                [(1, "a"), (-9223372036854775808, "boom")])
cur = con.execute("select case when y = 'q' collate c then abs(x) else 0 end from t")
cur.fetchone()

KeyError: 'collation raised'

The above exception was the direct cause of the following exception:

SystemError: <class 'sqlite3.OperationalError'> returned a result with an exception set