Lines Matching refs:v
188 Vdbe *v = sqlite3GetVdbe(pParse); in openStatTable() local
197 if( v==0 ) return; in openStatTable()
199 assert( sqlite3VdbeDb(v)==db ); in openStatTable()
238 sqlite3VdbeAddOp2(v, OP_Clear, (int)aRoot[i], iDb); in openStatTable()
246 sqlite3VdbeAddOp4Int(v, OP_OpenWrite, iStatCur+i, (int)aRoot[i], iDb, 3); in openStatTable()
247 sqlite3VdbeChangeP5(v, aCreateTbl[i]); in openStatTable()
248 VdbeComment((v, aTable[i].zName)); in openStatTable()
946 Vdbe *v, /* Prepared statement under construction */ in analyzeVdbeCommentIndexWithColumnName() argument
954 VdbeComment((v,"%s.rowid",pIdx->zName)); in analyzeVdbeCommentIndexWithColumnName()
957 VdbeComment((v,"%s.expr(%d)",pIdx->zName, k)); in analyzeVdbeCommentIndexWithColumnName()
959 VdbeComment((v,"%s.%s", pIdx->zName, pIdx->pTable->aCol[i].zCnName)); in analyzeVdbeCommentIndexWithColumnName()
982 Vdbe *v; /* The virtual machine being built up */ in analyzeOneTable() local
1002 v = sqlite3GetVdbe(pParse); in analyzeOneTable()
1003 if( v==0 || NEVER(pTab==0) ){ in analyzeOneTable()
1046 sqlite3VdbeLoadString(v, regTabname, pTab->zName); in analyzeOneTable()
1068 sqlite3VdbeLoadString(v, regIdxname, zIdxName); in analyzeOneTable()
1069 VdbeComment((v, "Analysis for %s.%s", pTab->zName, zIdxName)); in analyzeOneTable()
1111 sqlite3VdbeAddOp3(v, OP_OpenRead, iIdxCur, pIdx->tnum, iDb); in analyzeOneTable()
1113 VdbeComment((v, "%s", pIdx->zName)); in analyzeOneTable()
1122 sqlite3VdbeAddOp2(v, OP_Integer, nCol, regStat+1); in analyzeOneTable()
1124 sqlite3VdbeAddOp2(v, OP_Integer, pIdx->nKeyCol, regRowid); in analyzeOneTable()
1127 sqlite3VdbeAddOp2(v, OP_Count, iIdxCur, regTemp); in analyzeOneTable()
1128 addrRewind = sqlite3VdbeAddOp1(v, OP_Rewind, iIdxCur); in analyzeOneTable()
1129 VdbeCoverage(v); in analyzeOneTable()
1133 addrRewind = sqlite3VdbeAddOp1(v, OP_Rewind, iIdxCur); in analyzeOneTable()
1134 VdbeCoverage(v); in analyzeOneTable()
1135 sqlite3VdbeAddOp3(v, OP_Count, iIdxCur, regTemp, 1); in analyzeOneTable()
1138 sqlite3VdbeAddOp2(v, OP_Integer, db->nAnalysisLimit, regTemp2); in analyzeOneTable()
1150 sqlite3VdbeAddOp2(v, OP_Integer, 0, regChng); in analyzeOneTable()
1151 addrNextRow = sqlite3VdbeCurrentAddr(v); in analyzeOneTable()
1169 sqlite3VdbeAddOp0(v, OP_Goto); in analyzeOneTable()
1170 addrNextRow = sqlite3VdbeCurrentAddr(v); in analyzeOneTable()
1175 sqlite3VdbeAddOp2(v, OP_NotNull, regPrev, endDistinctTest); in analyzeOneTable()
1176 VdbeCoverage(v); in analyzeOneTable()
1180 sqlite3VdbeAddOp2(v, OP_Integer, i, regChng); in analyzeOneTable()
1181 sqlite3VdbeAddOp3(v, OP_Column, iIdxCur, i, regTemp); in analyzeOneTable()
1182 analyzeVdbeCommentIndexWithColumnName(v,pIdx,i); in analyzeOneTable()
1184 sqlite3VdbeAddOp4(v, OP_Ne, regTemp, 0, regPrev+i, pColl, P4_COLLSEQ); in analyzeOneTable()
1185 sqlite3VdbeChangeP5(v, SQLITE_NULLEQ); in analyzeOneTable()
1186 VdbeCoverage(v); in analyzeOneTable()
1188 sqlite3VdbeAddOp2(v, OP_Integer, nColTest, regChng); in analyzeOneTable()
1189 sqlite3VdbeGoto(v, endDistinctTest); in analyzeOneTable()
1199 sqlite3VdbeJumpHere(v, addrNextRow-1); in analyzeOneTable()
1201 sqlite3VdbeJumpHere(v, aGotoChng[i]); in analyzeOneTable()
1202 sqlite3VdbeAddOp3(v, OP_Column, iIdxCur, i, regPrev+i); in analyzeOneTable()
1203 analyzeVdbeCommentIndexWithColumnName(v,pIdx,i); in analyzeOneTable()
1205 sqlite3VdbeResolveLabel(v, endDistinctTest); in analyzeOneTable()
1220 sqlite3VdbeAddOp2(v, OP_IdxRowid, iIdxCur, regRowid); in analyzeOneTable()
1228 sqlite3VdbeAddOp3(v, OP_Column, iIdxCur, k, regKey+j); in analyzeOneTable()
1229 analyzeVdbeCommentIndexWithColumnName(v,pIdx,k); in analyzeOneTable()
1231 sqlite3VdbeAddOp3(v, OP_MakeRecord, regKey, pPk->nKeyCol, regRowid); in analyzeOneTable()
1242 j1 = sqlite3VdbeAddOp1(v, OP_IsNull, regTemp); VdbeCoverage(v); in analyzeOneTable()
1243 j2 = sqlite3VdbeAddOp1(v, OP_If, regTemp); VdbeCoverage(v); in analyzeOneTable()
1244 j3 = sqlite3VdbeAddOp4Int(v, OP_SeekGT, iIdxCur, 0, regPrev, 1); in analyzeOneTable()
1245 VdbeCoverage(v); in analyzeOneTable()
1246 sqlite3VdbeJumpHere(v, j1); in analyzeOneTable()
1247 sqlite3VdbeAddOp2(v, OP_Next, iIdxCur, addrNextRow); VdbeCoverage(v); in analyzeOneTable()
1248 sqlite3VdbeJumpHere(v, j2); in analyzeOneTable()
1249 sqlite3VdbeJumpHere(v, j3); in analyzeOneTable()
1251 sqlite3VdbeAddOp2(v, OP_Next, iIdxCur, addrNextRow); VdbeCoverage(v); in analyzeOneTable()
1258 sqlite3VdbeAddOp4(v, OP_MakeRecord, regTabname, 3, regTemp, "BBB", 0); in analyzeOneTable()
1259 sqlite3VdbeAddOp2(v, OP_NewRowid, iStatCur, regNewRowid); in analyzeOneTable()
1260 sqlite3VdbeAddOp3(v, OP_Insert, iStatCur, regTemp, regNewRowid); in analyzeOneTable()
1262 sqlite3VdbeChangeP4(v, -1, (char*)pStat1, P4_TABLE); in analyzeOneTable()
1264 sqlite3VdbeChangeP5(v, OPFLAG_APPEND); in analyzeOneTable()
1281 addrNext = sqlite3VdbeCurrentAddr(v); in analyzeOneTable()
1283 addrIsNull = sqlite3VdbeAddOp1(v, OP_IsNull, regSampleRowid); in analyzeOneTable()
1284 VdbeCoverage(v); in analyzeOneTable()
1288 sqlite3VdbeAddOp4Int(v, seekOp, iTabCur, addrNext, regSampleRowid, 0); in analyzeOneTable()
1289 VdbeCoverage(v); in analyzeOneTable()
1293 sqlite3VdbeAddOp3(v, OP_MakeRecord, regCol, nCol, regSample); in analyzeOneTable()
1294 sqlite3VdbeAddOp3(v, OP_MakeRecord, regTabname, 6, regTemp); in analyzeOneTable()
1295 sqlite3VdbeAddOp2(v, OP_NewRowid, iStatCur+1, regNewRowid); in analyzeOneTable()
1296 sqlite3VdbeAddOp3(v, OP_Insert, iStatCur+1, regTemp, regNewRowid); in analyzeOneTable()
1297 sqlite3VdbeAddOp2(v, OP_Goto, 1, addrNext); /* P1==1 for end-of-loop */ in analyzeOneTable()
1298 sqlite3VdbeJumpHere(v, addrIsNull); in analyzeOneTable()
1303 sqlite3VdbeJumpHere(v, addrRewind); in analyzeOneTable()
1311 VdbeComment((v, "%s", pTab->zName)); in analyzeOneTable()
1312 sqlite3VdbeAddOp2(v, OP_Count, iTabCur, regStat1); in analyzeOneTable()
1313 jZeroRows = sqlite3VdbeAddOp1(v, OP_IfNot, regStat1); VdbeCoverage(v); in analyzeOneTable()
1314 sqlite3VdbeAddOp2(v, OP_Null, 0, regIdxname); in analyzeOneTable()
1316 sqlite3VdbeAddOp4(v, OP_MakeRecord, regTabname, 3, regTemp, "BBB", 0); in analyzeOneTable()
1317 sqlite3VdbeAddOp2(v, OP_NewRowid, iStatCur, regNewRowid); in analyzeOneTable()
1318 sqlite3VdbeAddOp3(v, OP_Insert, iStatCur, regTemp, regNewRowid); in analyzeOneTable()
1319 sqlite3VdbeChangeP5(v, OPFLAG_APPEND); in analyzeOneTable()
1321 sqlite3VdbeChangeP4(v, -1, (char*)pStat1, P4_TABLE); in analyzeOneTable()
1323 sqlite3VdbeJumpHere(v, jZeroRows); in analyzeOneTable()
1333 Vdbe *v = sqlite3GetVdbe(pParse); in loadAnalysis() local
1334 if( v ){ in loadAnalysis()
1335 sqlite3VdbeAddOp1(v, OP_LoadAnalysis, iDb); in loadAnalysis()
1408 Vdbe *v; in sqlite3Analyze() local
1443 if( db->nSqlExec==0 && (v = sqlite3GetVdbe(pParse))!=0 ){ in sqlite3Analyze()
1444 sqlite3VdbeAddOp0(v, OP_Expire); in sqlite3Analyze()
1473 tRowcnt v; local
1481 v = 0;
1483 v = v*10 + c - '0';
1487 if( aOut ) aOut[i] = v;
1488 if( aLog ) aLog[i] = sqlite3LogEst(v);
1493 aLog[i] = sqlite3LogEst(v);