diff options
| author | drh <drh@noemail.net> | 2019-01-30 14:01:43 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2019-01-30 14:01:43 +0000 |
| commit | 5a9c6bcc158633596ea7c7d9778c4e7671fd183b (patch) | |
| tree | 774e8212502b2a5823130ae2ac08ebea3fe59eab /tool/index_usage.c | |
| parent | dd579233e80a3304eb64544e9fb1876aa5005bff (diff) | |
| download | sqlite-5a9c6bcc158633596ea7c7d9778c4e7671fd183b.tar.gz sqlite-5a9c6bcc158633596ea7c7d9778c4e7671fd183b.zip | |
Enhancements to the index_usage utility program.
FossilOrigin-Name: 19c739b4a8a43d894e37a99fa34838f3e3fa1fe0d019aefbc33f1d38d76af1a4
Diffstat (limited to 'tool/index_usage.c')
| -rw-r--r-- | tool/index_usage.c | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/tool/index_usage.c b/tool/index_usage.c index a86202425..9d97c7318 100644 --- a/tool/index_usage.c +++ b/tool/index_usage.c @@ -90,7 +90,9 @@ int main(int argc, char **argv){ argv[2], sqlite3_errmsg(db)); goto errorOut; } - rc = sqlite3_prepare_v2(db, "SELECT sql, rowid FROM log.sqllog", + rc = sqlite3_prepare_v2(db, + "SELECT sql, rowid FROM log.sqllog" + " WHERE upper(substr(sql,1,5)) NOT IN ('BEGIN','COMMI','ROLLB','PRAGM')", -1, &pStmt, 0); if( rc ){ printf("Cannot read the SQLLOG table in the LOG database \"%s\" - %s\n", |