/ Check-in [a17712bf]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
Comment:Fix a problem causing the OR/covering-index optimization to be disabled if compile time parameter SQLITE_MAX_ATTACHED were set to greater than 30.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: a17712bf8d98dd485560f434a5350e6381cf1411
User & Date: dan 2016-02-01 13:58:56
Context
2016-02-01
16:36
Update walcrash.test to ensure that, during a particular test, enough data is written to cause SQLite to sync the wal file 14 times. check-in: 5d7c0928 user: dan tags: trunk
13:58
Fix a problem causing the OR/covering-index optimization to be disabled if compile time parameter SQLITE_MAX_ATTACHED were set to greater than 30. check-in: a17712bf user: dan tags: trunk
13:21
Minor simplification to the OP_AutoCommit opcode. Fix some code comments related to transaction control. check-in: a9b6a067 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/wherecode.c.

   774    774     Vdbe *v = pParse->pVdbe;        /* Vdbe to generate code within */
   775    775   
   776    776     assert( iIdxCur>0 );
   777    777     assert( pIdx->aiColumn[pIdx->nColumn-1]==-1 );
   778    778     
   779    779     sqlite3VdbeAddOp3(v, OP_Seek, iIdxCur, 0, iCur);
   780    780     if( (pWInfo->wctrlFlags & WHERE_FORCE_TABLE)
   781         -   && sqlite3ParseToplevel(pParse)->writeMask==0 
          781  +   && DbMaskAllZero(sqlite3ParseToplevel(pParse)->writeMask)
   782    782     ){
   783    783       int i;
   784    784       Table *pTab = pIdx->pTable;
   785    785       int *ai = (int*)sqlite3DbMallocZero(pParse->db, sizeof(int)*(pTab->nCol+1));
   786    786       if( ai ){
   787    787         ai[0] = pTab->nCol;
   788    788         for(i=0; i<pIdx->nColumn-1; i++){