SQLite

Check-in [28643d837d]
Login

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

Overview
Comment:When compiled with SQLITE_ENABLE_NORMALIZE, always have sqlite3_exec() enable the SQLITE_PREPARE_NORMALIZE flag.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | execWithNormalize
Files: files | file ages | folders
SHA3-256: 28643d837d057879b3067a18bb4c628d10ffc8c69b8f1870154566cb0b09cba5
User & Date: mistachkin 2018-12-04 21:16:34.044
Context
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)
Changes
Unified Diff Ignore Whitespace Patch
Changes to src/legacy.c.
︙︙
46
47
48
49
50
51
52





53

54
55
56
57
58
59
60

  sqlite3_mutex_enter(db->mutex);
  sqlite3Error(db, SQLITE_OK);
  while( rc==SQLITE_OK && zSql[0] ){
    int nCol;
    char **azVals = 0;

    pStmt = 0;





    rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);

    assert( rc==SQLITE_OK || pStmt==0 );
    if( rc!=SQLITE_OK ){
      continue;
    }
    if( !pStmt ){
      /* this happens for a comment or white-space */
      zSql = zLeftover;








>
>
>
>
>

>








46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66

  sqlite3_mutex_enter(db->mutex);
  sqlite3Error(db, SQLITE_OK);
  while( rc==SQLITE_OK && zSql[0] ){
    int nCol;
    char **azVals = 0;

    pStmt = 0;
#ifdef SQLITE_ENABLE_NORMALIZE
    rc = sqlite3_prepare_v3(
        db, zSql, -1, SQLITE_PREPARE_NORMALIZE, &pStmt, &zLeftover
    );
#else
    rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
#endif
    assert( rc==SQLITE_OK || pStmt==0 );
    if( rc!=SQLITE_OK ){
      continue;
    }
    if( !pStmt ){
      /* this happens for a comment or white-space */
      zSql = zLeftover;
︙︙