The sqlite3_deserialize() interface does not work for TEMP. That is not intentional. It should work. But TEMP is special and requires some special handling. And, as it turns out, I neglected to include any test cases that deserialize TEMP in any of the SQLite test suites. So it probably has never worked. I suspect that you are the first person to have tried to deserialized into TEMP.