[sqlite] Surprising result from changes() after constraint violation

Running Sqlite 3.19.3, an insert failed because of a constraint violation and the return value from changes() was not what I would have expected. Why did "select changes()" return "3" on the second call, even though nothing was inserted into the db? sqlite> pragma foreign_keys=1; sqlite>

[sqlite] feature enhancement request for explain query plan

Having been bitten by my misunderstanding of how sqlite uses indices, I would like to make a request for a feature enhancment. Currently, explain query plan lists the index being used with each table. It would be very convenient if it would also list the columns of that index being used. Thus,