/ Check-in [2f2ce416]
Login

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

Overview
Comment:Another virtual table fix in NGQP.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | nextgen-query-plan-exp
Files: files | file ages | folders
SHA1: 2f2ce4167728399cc30bef045aab500940af978c
User & Date: drh 2013-05-31 18:13:50
Context
2013-05-31
18:20
Fix a problem with code generation on LEFT JOIN of tables without an index. check-in: 0b1bee92 user: drh tags: nextgen-query-plan-exp
18:13
Another virtual table fix in NGQP. check-in: 2f2ce416 user: drh tags: nextgen-query-plan-exp
17:55
Fix problems in the virtual table logic for NGQP. check-in: 23af28e2 user: drh tags: nextgen-query-plan-exp
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/where.c.

  3020   3020       int addrNotFound;
  3021   3021       int nConstraint = pLoop->nTerm;
  3022   3022   
  3023   3023       sqlite3ExprCachePush(pParse);
  3024   3024       iReg = sqlite3GetTempRange(pParse, nConstraint+2);
  3025   3025       addrNotFound = pLevel->addrBrk;
  3026   3026       for(j=0; j<nConstraint; j++){
  3027         -      int iTarget = iReg+j+1;
         3027  +      int iTarget = iReg+j+2;
  3028   3028         pTerm = pLoop->aTerm[j];
  3029   3029         if( pTerm->eOperator & WO_IN ){
  3030   3030           codeEqualityTerm(pParse, pTerm, pLevel, j, bRev, iTarget);
  3031   3031           addrNotFound = pLevel->addrNxt;
  3032   3032         }else{
  3033   3033           sqlite3ExprCode(pParse, pTerm->pExpr->pRight, iTarget);
  3034   3034         }