The SQLite CLI is a handy tool for explaining query plans and virtual machine opcodes. Unfortunately it mostly doesn't do me any good because of user-defined functions in triggers:
sqlite> explain insert into changes default values; Error: no such function: debug It would be quite useful if there was a mode/pragma/feature to ignore these types of errors for explain [query plan]. -- Mark Lawrence _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users