diff options
| author | drh <drh@noemail.net> | 2020-06-19 15:24:12 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2020-06-19 15:24:12 +0000 |
| commit | 067b92ba00887811d9c54c84621b4cfd6f55e27a (patch) | |
| tree | e047b726264aad8f2aee65472deafd0b5bda39df /tool/index_usage.c | |
| parent | 1e32bed3c1ce78263598d860d531d3e7e6171929 (diff) | |
| download | sqlite-067b92ba00887811d9c54c84621b4cfd6f55e27a.tar.gz sqlite-067b92ba00887811d9c54c84621b4cfd6f55e27a.zip | |
Extend the refactoring into extensions. Clean up stray newlines.
FossilOrigin-Name: 7a876209a678a34c198b54ceef9e3c041f128a14dc73357f6a57cadadaa6cf7b
Diffstat (limited to 'tool/index_usage.c')
| -rw-r--r-- | tool/index_usage.c | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/tool/index_usage.c b/tool/index_usage.c index 451fa65c3..9bd3c9fdc 100644 --- a/tool/index_usage.c +++ b/tool/index_usage.c @@ -104,7 +104,7 @@ int main(int argc, char **argv){ printf("Cannot open \"%s\" for reading: %s\n", argv[1], sqlite3_errmsg(db)); goto errorOut; } - rc = sqlite3_prepare_v2(db, "SELECT * FROM sqlite_master", -1, &pStmt, 0); + rc = sqlite3_prepare_v2(db, "SELECT * FROM sqlite_schema", -1, &pStmt, 0); if( rc ){ printf("Cannot read the schema from \"%s\" - %s\n", argv[1], sqlite3_errmsg(db)); @@ -126,7 +126,7 @@ int main(int argc, char **argv){ } rc = sqlite3_exec(db, "INSERT INTO temp.idxu(tbl,idx,cnt)" - " SELECT tbl_name, name, 0 FROM sqlite_master" + " SELECT tbl_name, name, 0 FROM sqlite_schema" " WHERE type='index' AND sql IS NOT NULL", 0, 0, 0); /* Open the LOG database */ @@ -205,9 +205,9 @@ int main(int argc, char **argv){ rc = sqlite3_prepare_v2(db, "SELECT tbl, idx, cnt, " " (SELECT group_concat(name,',') FROM pragma_index_info(idx))" - " FROM temp.idxu, main.sqlite_master" - " WHERE temp.idxu.tbl=main.sqlite_master.tbl_name" - " AND temp.idxu.idx=main.sqlite_master.name" + " FROM temp.idxu, main.sqlite_schema" + " WHERE temp.idxu.tbl=main.sqlite_schema.tbl_name" + " AND temp.idxu.idx=main.sqlite_schema.name" " ORDER BY cnt DESC, tbl, idx", -1, &pStmt, 0); if( rc ){ |