I ran your SQL on a couple different versions of the SQLite shell, including a recent trunk tip.<sup>1</sup> It completed in the blink of an eye. This leads me to think that if the problem you report represents a library bug, it must have been fixed. Can you please state what "select sqlite_version();" returns? ---- 1. I ran the CREATE statements **before** the update statement.