/ Check-in [cc8c3581]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix a formatting issue in the output of the sqlite3_expert program.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | schemalint
Files: files | file ages | folders
SHA3-256: cc8c3581060ffef02290b680183e6f6bc9837ba3550e74c8aaabdc7c45edc223
User & Date: dan 2017-04-11 18:29:14
Context
2017-04-11
19:00
Update this branch with latest trunk changes. check-in: 0f66a093 user: dan tags: schemalint
18:29
Fix a formatting issue in the output of the sqlite3_expert program. check-in: cc8c3581 user: dan tags: schemalint
17:43
Add header comments to the API functions in sqlite3expert.h. Include a list of all candidate indexes in the report output by the sqlite3_expert program. check-in: 0c45c5eb user: dan tags: schemalint
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to ext/expert/expert.c.

   124    124         fprintf(stdout, "-- Candidates -------------------------------\n");
   125    125         fprintf(stdout, "%s\n", zCand);
   126    126       }
   127    127       for(i=0; i<nQuery; i++){
   128    128         const char *zSql = sqlite3_expert_report(p, i, EXPERT_REPORT_SQL);
   129    129         const char *zIdx = sqlite3_expert_report(p, i, EXPERT_REPORT_INDEXES);
   130    130         const char *zEQP = sqlite3_expert_report(p, i, EXPERT_REPORT_PLAN);
   131         -      if( zIdx==0 ) zIdx = "(no new indexes)";
          131  +      if( zIdx==0 ) zIdx = "(no new indexes)\n";
   132    132         if( iVerbose>0 ){
   133    133           fprintf(stdout, "-- Query %d ----------------------------------\n",i+1);
   134    134           fprintf(stdout, "%s\n\n", zSql);
   135    135         }
   136    136         fprintf(stdout, "%s\n%s\n", zIdx, zEQP);
   137    137       }
   138    138     }else if( zErr ){