sqlite> DROP INDEX i_revision;
sqlite> EXPLAIN INSERT INTO revprop VALUES (2, '( ) ');
|Trace|0|0|0||00|
|Goto|0|21|0||00|
|OpenWrite|0|3|0|2|00|
|OpenWrite|1|4|0|keyinfo(1,BINARY)|00|
|NewRowid|0|3|0||00|
|Integer|2|4|0||00|
|String8|0|5|0|( ) |00|
|HaltIfNull|19|2|4|revprop.revision may not be NULL|00|
|HaltIfNull|19|2|5|revprop.properties may not be NULL|00|
|SCopy|4|6|0||00|
|SCopy|3|7|0||00|
|MakeRecord|6|2|1|db|00|
|SCopy|3|8|0||00|
|IsUnique|1|15|8|6|00|
|Halt|19|2|0|column revision is not unique|00|
|IdxInsert|1|1|0||10|
|MakeRecord|4|2|8|db|00|
|Insert|0|8|3|revprop|1b|
|Close|0|0|0||00|
|Close|1|0|0||00|
|Halt|0|0|0||00|
|Transaction|0|1|0||00|
|VerifyCookie|0|3|0||00|
|TableLock|0|3|1|revprop|00|
|Goto|0|2|0||00|