/ Changes On Branch execWithNormalize
Login

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

Changes In Branch execWithNormalize Excluding Merge-Ins

This is equivalent to a diff from df95455213 to 28643d837d

2018-12-05
13:39
Enhance the sqlite3_normalize_sql() interface so that it works even if the prepared statement was not initially compiled using SQLITE_PREPARE_NORMALIZED. Enhance the ".trace" command in the CLI so that it is able to access the full scope of functionality provided by sqlite3_trace_v2() and in particular so that it is able to show normalized SQL output using the newly enhanced sqlite3_normalize_sql() interface. (check-in: 7da617e97e user: drh tags: trunk)
2018-12-04
21:16
When compiled with SQLITE_ENABLE_NORMALIZE, always have sqlite3_exec() enable the SQLITE_PREPARE_NORMALIZE flag. (Leaf check-in: 28643d837d user: mistachkin tags: execWithNormalize)
16:51
Add the "index_usage" utility program. (check-in: df95455213 user: drh tags: trunk)
14:33
Performance improvement in sqlite3_step() by creating a new mTrace flag for the legacy xProfile pointer that is set by sqlite3_profile(). (check-in: e28584e8bc user: drh tags: trunk)

Changes to src/legacy.c.

    46     46     sqlite3_mutex_enter(db->mutex);
    47     47     sqlite3Error(db, SQLITE_OK);
    48     48     while( rc==SQLITE_OK && zSql[0] ){
    49     49       int nCol;
    50     50       char **azVals = 0;
    51     51   
    52     52       pStmt = 0;
           53  +#ifdef SQLITE_ENABLE_NORMALIZE
           54  +    rc = sqlite3_prepare_v3(
           55  +        db, zSql, -1, SQLITE_PREPARE_NORMALIZE, &pStmt, &zLeftover
           56  +    );
           57  +#else
    53     58       rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
           59  +#endif
    54     60       assert( rc==SQLITE_OK || pStmt==0 );
    55     61       if( rc!=SQLITE_OK ){
    56     62         continue;
    57     63       }
    58     64       if( !pStmt ){
    59     65         /* this happens for a comment or white-space */
    60     66         zSql = zLeftover;