Lines Matching refs:pSelect
17463 Select *pSelect; /* NULL for tables. Points to definition if a view. */ member
17989 Select *pSelect; /* EP_xIsSelect and op = IN, EXISTS, SELECT */ member
18229 Select *pSelect; /* A SELECT statement used in place of a table name */ member
18898 Select *pSelect; /* SELECT statement or RHS of INSERT INTO SELECT ... */ member
19067 Select *pSelect; /* HAVING to WHERE clause ctx */ member
19110 Select *pSelect; /* The definition of this CTE */ member
29516 sqlite3TreeViewSelect(pView, pCte->pSelect, 0);
29554 if( pItem->pSelect ){
29555 sqlite3TreeViewSelect(pView, pItem->pSelect, 0);
30014 sqlite3TreeViewSelect(pView, pExpr->x.pSelect, 0);
30019 sqlite3TreeViewSelect(pView, pExpr->x.pSelect, 0);
30026 sqlite3TreeViewSelect(pView, pExpr->x.pSelect, 0);
30100 sqlite3TreeViewSelect(pView, pExpr->pLeft->x.pSelect, 0);
93316 if( pTab && pTab->pSelect ){
97363 if( sqlite3WalkSelect(pWalker, pExpr->x.pSelect) ) return WRC_Abort;
97440 if( pItem->pSelect && sqlite3WalkSelect(pWalker, pItem->pSelect) ){
97493 SQLITE_PRIVATE int sqlite3WalkerDepthIncrease(Walker *pWalker, Select *pSelect){
97494 UNUSED_PARAMETER(pSelect);
97498 SQLITE_PRIVATE void sqlite3WalkerDepthDecrease(Walker *pWalker, Select *pSelect){
97499 UNUSED_PARAMETER(pSelect);
97831 if( pItem->pSelect && (pItem->pSelect->selFlags & SF_NestedFrom)!=0 ){
97833 pEList = pItem->pSelect->pEList;
98025 assert( pExpr->x.pSelect==0 );
98291 assert( HasRowid(pItem->pTab) && pItem->pTab->pSelect==0 );
98579 sqlite3WalkSelect(pWalker, pExpr->x.pSelect);
98706 Select *pSelect, /* The SELECT statement with the ORDER BY clause */
98717 pEList = pSelect->pEList;
98723 nc.pSrcList = pSelect->pSrc;
98779 Select *pSelect /* The SELECT statement containing the ORDER BY */
98787 pOrderBy = pSelect->pOrderBy;
98797 pSelect->pNext = 0;
98798 while( pSelect->pPrior ){
98799 pSelect->pPrior->pNext = pSelect;
98800 pSelect = pSelect->pPrior;
98802 while( pSelect && moreToDo ){
98805 pEList = pSelect->pEList;
98840 iCol = resolveOrderByTermToExprList(pParse, pSelect, pDup);
98872 pSelect = pSelect->pNext;
98896 Select *pSelect, /* The SELECT statement containing the clause */
98910 pEList = pSelect->pEList;
98942 static void windowRemoveExprFromSelect(Select *pSelect, Expr *pExpr){
98943 if( pSelect->pWin ){
98947 sWalker.u.pSelect = pSelect;
98975 Select *pSelect, /* The SELECT statement holding pOrderBy */
98986 nResult = pSelect->pEList->nExpr;
98992 iCol = resolveAsName(pParse, pSelect->pEList, pE2);
99019 for(j=0; j<pSelect->pEList->nExpr; j++){
99020 if( sqlite3ExprCompare(0, pE, pSelect->pEList->a[j].pExpr, -1)==0 ){
99024 windowRemoveExprFromSelect(pSelect, pE);
99029 return sqlite3ResolveOrderGroupBy(pParse, pSelect, pOrderBy, zType);
99093 Select *pSub = p->pSrc->a[0].pSelect;
99104 if( pItem->pSelect && (pItem->pSelect->selFlags & SF_Resolved)==0 ){
99117 sqlite3ResolveSelectNames(pParse, pItem->pSelect, pOuterNC);
99193 Select *pSub = p->pSrc->a[0].pSelect;
99539 return sqlite3ExprAffinity(pExpr->x.pSelect->pEList->a[0].pExpr);
99554 pExpr->pLeft->x.pSelect->pEList->a[pExpr->iColumn].pExpr
99764 aff = sqlite3CompareAffinity(pExpr->x.pSelect->pEList->a[0].pExpr, aff);
99905 return pExpr->x.pSelect->pEList->nExpr;
99931 return pVector->x.pSelect->pEList->a[i].pExpr;
100049 *ppExpr = pVector->x.pSelect->pEList->a[iField].pExpr;
100188 static void heightOfSelect(Select *pSelect, int *pnHeight){
100190 for(p=pSelect; p; p=p->pPrior){
100215 heightOfSelect(p->x.pSelect, &nHeight);
100399 SQLITE_PRIVATE void sqlite3PExprAddSelect(Parse *pParse, Expr *pExpr, Select *pSelect){
100401 pExpr->x.pSelect = pSelect;
100406 sqlite3SelectDelete(pParse->db, pSelect);
100595 assert( p->x.pSelect==0 );
100607 sqlite3SelectDelete(db, p->x.pSelect);
100817 pNew->x.pSelect = sqlite3SelectDup(db, p->x.pSelect, dupFlags);
100872 pRet->a[i].pSelect = sqlite3SelectDup(db, p->a[i].pSelect, 0);
100893 Select *pSelect = pWalker->u.pSelect;
100898 sqlite3WindowLink(pSelect, pWin);
100903 return p==pWalker->u.pSelect ? WRC_Continue : WRC_Prune;
100911 w.u.pSelect = p;
101023 pNewItem->pSelect = sqlite3SelectDup(db, pOldItem->pSelect, flags);
101853 p = pX->x.pSelect;
101866 if( pSrc->a[0].pSelect ) return 0; /* FROM is not a subquery or view */
101869 assert( pTab->pSelect==0 ); /* FROM clause is not a view */
102024 ExprList *pEList = pX->x.pSelect->pEList;
102225 Select *pSelect = (pExpr->flags & EP_xIsSelect) ? pExpr->x.pSelect : 0;
102235 if( pSelect ){
102236 zRet[i] = sqlite3CompareAffinity(pSelect->pEList->a[i].pExpr, a);
102276 sqlite3SubselectError(pParse, pExpr->x.pSelect->pEList->nExpr, 1);
102341 pExpr->x.pSelect->selId));
102372 VdbeComment((v, "Result of SELECT %u", pExpr->x.pSelect->selId));
102385 Select *pSelect = pExpr->x.pSelect;
102386 ExprList *pEList = pSelect->pEList;
102389 addrOnce?"":"CORRELATED ", pSelect->selId
102398 pSelect->iLimit = 0;
102399 testcase( pSelect->selFlags & SF_Distinct );
102401 if( sqlite3Select(pParse, pSelect, &dest) ){
102509 pSel = pExpr->x.pSelect;
102613 if( nVector!=pIn->x.pSelect->pEList->nExpr ){
102614 sqlite3SubselectError(pParse, pIn->x.pSelect->pEList->nExpr, nVector);
103752 if( op==TK_SELECT && (nCol = pExpr->x.pSelect->pEList->nExpr)!=1 ){
105633 if( pTab->pSelect ){
105940 if( pTab->pSelect ){
106002 if( pTab->pSelect ){
106248 static void renameWalkWith(Walker *pWalker, Select *pSelect){
106249 With *pWith = pSelect->pWith;
106253 Select *p = pWith->a[i].pSelect;
106677 if( pStep->pSelect ){
106678 sqlite3SelectPrep(pParse, pStep->pSelect, &sNC);
106737 sqlite3WalkSelect(pWalker, pStep->pSelect);
106849 Select *pSelect = sParse.pNewTable->pSelect;
106850 if( pSelect ){
106851 pSelect->selFlags &= ~SF_View;
106853 sqlite3SelectPrep(&sParse, pSelect, 0);
106856 sqlite3WalkSelect(&sWalker, pSelect);
106863 assert( sParse.pNewTable->pSelect==0 );
106966 static int renameTableSelectCb(Walker *pWalker, Select *pSelect){
106969 SrcList *pSrc = pSelect->pSrc;
106970 if( pSelect->selFlags & SF_View ) return WRC_Prune;
106981 renameWalkWith(pWalker, pSelect);
107048 if( pTab->pSelect ){
107050 Select *pSelect = pTab->pSelect;
107055 assert( pSelect->selFlags & SF_View );
107056 pSelect->selFlags &= ~SF_View;
107057 sqlite3SelectPrep(&sParse, pTab->pSelect, &sNC);
107061 sqlite3WalkSelect(&sWalker, pTab->pSelect);
107185 if( isLegacy==0 && sParse.pNewTable && sParse.pNewTable->pSelect ){
107189 sqlite3SelectPrep(&sParse, sParse.pNewTable->pSelect, &sNC);
109647 if( sqlite3FixSelect(pFix, pItem->pSelect) ) return 1;
109659 Select *pSelect /* The SELECT statement to be fixed to one database */
109661 while( pSelect ){
109662 if( sqlite3FixExprList(pFix, pSelect->pEList) ){
109665 if( sqlite3FixSrcList(pFix, pSelect->pSrc) ){
109668 if( sqlite3FixExpr(pFix, pSelect->pWhere) ){
109671 if( sqlite3FixExprList(pFix, pSelect->pGroupBy) ){
109674 if( sqlite3FixExpr(pFix, pSelect->pHaving) ){
109677 if( sqlite3FixExprList(pFix, pSelect->pOrderBy) ){
109680 if( sqlite3FixExpr(pFix, pSelect->pLimit) ){
109683 if( pSelect->pWith ){
109685 for(i=0; i<pSelect->pWith->nCte; i++){
109686 if( sqlite3FixSelect(pFix, pSelect->pWith->a[i].pSelect) ){
109691 pSelect = pSelect->pPrior;
109711 if( sqlite3FixSelect(pFix, pExpr->x.pSelect) ) return 1;
109744 if( sqlite3FixSelect(pFix, pStep->pSelect) ){
110723 sqlite3SelectDelete(db, pTable->pSelect);
112295 Select *pSelect /* Select from a "CREATE ... AS SELECT" */
112302 if( pEnd==0 && pSelect==0 ){
112309 if( pSelect==0 && sqlite3ShadowTableName(db, p->zName) ){
112323 if( pSelect ){
112426 if( p->pSelect==0 ){
112451 if( pSelect ){
112471 pSelTab = sqlite3ResultSetOfSelect(pParse, pSelect, SQLITE_AFF_BLOB);
112480 sqlite3Select(pParse, pSelect, &dest);
112496 if( pSelect ){
112563 if( !p->pSelect ){
112566 assert( !pSelect && pCons && pEnd );
112587 Select *pSelect, /* A SELECT statement that will become the new view */
112610 if( sqlite3FixSelect(&sFix, pSelect) ) goto create_view_fail;
112617 pSelect->selFlags |= SF_View;
112619 p->pSelect = pSelect;
112620 pSelect = 0;
112622 p->pSelect = sqlite3SelectDup(db, pSelect, EXPRDUP_REDUCE);
112647 sqlite3SelectDelete(db, pSelect);
112721 assert( pTable->pSelect );
112722 pSel = sqlite3SelectDup(db, pTable->pSelect, 0);
112802 if( pTab->pSelect ){
113140 if( isView && pTab->pSelect==0 ){
113144 if( !isView && pTab->pSelect ){
113612 if( pTab->pSelect ){
114465 if( pItem->pSelect ){
114466 sqlite3SrcListAssignCursors(pParse, pItem->pSelect->pSrc);
114486 sqlite3SelectDelete(db, pItem->pSelect);
114543 pItem->pSelect = pSubquery;
115111 pNew->a[pNew->nCte].pSelect = pQuery;
115130 sqlite3SelectDelete(db, pCte->pSelect);
115765 if( !viewOk && pTab->pSelect ){
115832 Select *pSelect = NULL; /* Complete SELECT tree */
115893 pSelect = sqlite3SelectNew(pParse, pEList, pSelectSrc, pWhere, 0 ,0,
115899 sqlite3PExprAddSelect(pParse, pInClause, pSelect);
115976 isView = pTab->pSelect!=0;
116225 assert( pPk!=0 || pTab->pSelect!=0 );
116459 if( pTab->pSelect==0 ){
116626 if( pIdx->pTable->pSelect ){
119394 sqlite3SelectDelete(dbMem, pStep->pSelect);
119424 assert( pTab->pSelect==0 ); /* Not a view */
119911 Select *pSelect = 0; /* If RESTRICT, "SELECT RAISE(...)" */
120006 pSelect = sqlite3SelectNew(pParse,
120030 pStep->pSelect = sqlite3SelectDup(db, pSelect, EXPRDUP_REDUCE);
120043 sqlite3SelectDelete(db, pSelect);
120667 Select *pSelect, /* A SELECT statement to use as the data source */
120772 Select *pSelect, /* A SELECT statement to use as the data source */
120825 if( pSelect && (pSelect->selFlags & SF_Values)!=0 && pSelect->pPrior==0 ){
120826 pList = pSelect->pEList;
120827 pSelect->pEList = 0;
120828 sqlite3SelectDelete(db, pSelect);
120829 pSelect = 0;
120852 isView = pTab->pSelect!=0;
120882 sqlite3BeginWriteOperation(pParse, pSelect || pTrigger, iDb);
120894 if( pColumn==0 && xferOptimization(pParse, pTab, pSelect, onError, iDb) ){
120979 if( pSelect ){
120992 rc = sqlite3Select(pParse, pSelect, &dest);
120997 assert( pSelect->pEList );
120998 nColumn = pSelect->pEList->nExpr;
121131 if( pTab->pSelect ){
121163 }else if( pSelect ){
121247 }else if( pSelect ){
121277 assert( pSelect==0 ); /* Otherwise useTempTable is true */
121332 }else if( pSelect ){
121431 }else if( pSelect ){
121469 sqlite3SelectDelete(db, pSelect);
121685 assert( pTab->pSelect==0 ); /* This table is not a VIEW */
122458 assert( pTab->pSelect==0 ); /* This table is not a VIEW */
122674 Select *pSelect, /* A SELECT statement to use as the data source */
122694 if( pSelect==0 ){
122697 if( pParse->pWith || pSelect->pWith ){
122715 assert(pSelect->pSrc); /* allocated even if there is no FROM clause */
122716 if( pSelect->pSrc->nSrc!=1 ){
122719 if( pSelect->pSrc->a[0].pSelect ){
122722 if( pSelect->pWhere ){
122725 if( pSelect->pOrderBy ){
122730 if( pSelect->pGroupBy ){
122733 if( pSelect->pLimit ){
122736 if( pSelect->pPrior ){
122739 if( pSelect->selFlags & SF_Distinct ){
122742 pEList = pSelect->pEList;
122756 pItem = pSelect->pSrc->a;
122773 if( pSrc->pSelect ){
129406 Select *pSelect, /* The query being coded */
129409 sqlite3ExprCodeExprList(pParse, pSelect->pEList, pInfo->regResult,
129428 Select *pSelect,
129436 innerLoopLoadRow(pParse, pSelect, pSort->pDeferredRowLoad);
129449 Select *pSelect, /* The whole SELECT statement */
129490 assert( pSelect->iOffset==0 || pSelect->iLimit!=0 );
129491 iLimit = pSelect->iOffset ? pSelect->iOffset+1 : pSelect->iLimit;
129509 regRecord = makeSorterRecord(pParse, pSort, pSelect, regBase, nBase);
129570 regRecord = makeSorterRecord(pParse, pSort, pSelect, regBase, nBase);
130520 pS = pTabList->a[j].pSelect;
130601 Select *pS = pExpr->x.pSelect;
130697 Select *pSelect /* Generate column names for this SELECT statement */
130717 while( pSelect->pPrior ) pSelect = pSelect->pPrior;
130718 SELECTTRACE(1,pParse,pSelect,("generating column names\n"));
130719 pTabList = pSelect->pSrc;
130720 pEList = pSelect->pEList;
130895 Select *pSelect, /* SELECT used to determine types and collations */
130906 assert( pSelect!=0 );
130907 assert( (pSelect->selFlags & SF_Resolved)!=0 );
130908 assert( pTab->nCol==pSelect->pEList->nExpr || db->mallocFailed );
130911 sNC.pSrcList = pSelect->pSrc;
130912 a = pSelect->pEList->a;
130942 SQLITE_PRIVATE Table *sqlite3ResultSetOfSelect(Parse *pParse, Select *pSelect, char aff){
130950 sqlite3SelectPrep(pParse, pSelect, 0);
130953 while( pSelect->pPrior ) pSelect = pSelect->pPrior;
130961 sqlite3ColumnsFromExprList(pParse, pSelect->pEList, &pTab->nCol, &pTab->aCol);
130962 sqlite3SelectAddColumnTypeAndCollation(pParse, pTab, pSelect, aff);
132372 substSelect(pSubst, pExpr->x.pSelect, 1);
132415 substSelect(pSubst, pItem->pSelect, 1);
132442 Select *pSelect, /* The complete SELECT statement */
132452 sqlite3WalkSelect(&w, pSelect);
132641 pSub = pSubitem->pSelect;
132836 pSub = pSub1 = pSubitem->pSelect;
132847 pSubitem->pSelect = 0;
133391 || p->pSrc->nSrc!=1 || p->pSrc->a[0].pSelect
133397 assert( pTab && !pTab->pSelect && pExpr );
133627 pFrom->pSelect = sqlite3SelectDup(db, pCte->pSelect, 0);
133629 assert( pFrom->pSelect );
133632 pSel = pFrom->pSelect;
133636 SrcList *pSrc = pFrom->pSelect->pSrc;
133736 Select *pSel = pFrom->pSelect;
133828 Select *pSel = pFrom->pSelect;
133851 if( IsVirtual(pTab) || pTab->pSelect ){
133855 assert( pFrom->pSelect==0 );
133856 if( pTab->pSelect && (db->flags & SQLITE_EnableView)==0 ){
133870 pFrom->pSelect = sqlite3SelectDup(db, pTab->pSelect, 0);
133874 sqlite3WalkSelect(pWalker, pFrom->pSelect);
133953 Select *pSub = pFrom->pSelect;
134091 static void sqlite3SelectExpand(Parse *pParse, Select *pSelect){
134098 sqlite3WalkSelect(&w, pSelect);
134103 sqlite3WalkSelect(&w, pSelect);
134137 Select *pSel = pFrom->pSelect;
134156 static void sqlite3SelectAddTypeInfo(Parse *pParse, Select *pSelect){
134163 sqlite3WalkSelect(&w, pSelect);
134391 Select *pS = pWalker->u.pSelect;
134428 sWalker.u.pSelect = p;
134450 if( pItem->pSelect==0 ) continue;
134457 pS1 = pItem->pSelect;
134458 if( pItem->pTab->pSchema==0 && pThis->pSelect->selId!=pS1->selId ){
134463 if( sqlite3ExprCompare(0, pThis->pSelect->pWhere, pS1->pWhere, -1)
134464 || sqlite3ExprCompare(0, pThis->pSelect->pHaving, pS1->pHaving, -1)
134509 pSub = p->pSrc->a[0].pSelect;
134525 pSub = p->pSrc->a[0].pSelect;
134526 p->pSrc->a[0].pSelect = 0;
134667 Select *pSub = pItem->pSelect;
134825 pSub = pItem->pSelect;
134930 assert( pPrior->pSelect!=0 );
134931 pSub->nSelectRow = pPrior->pSelect->nSelectRow;
135869 sqlite3SelectDelete(db, pTmp->pSelect);
136052 if( pTab->pSelect && tr_tm!=TK_INSTEAD ){
136057 if( !pTab->pSelect && tr_tm==TK_INSTEAD ){
136229 Select *pSelect, /* The SELECT statement */
136235 sqlite3SelectDelete(db, pSelect);
136239 pTriggerStep->pSelect = pSelect;
136287 Select *pSelect, /* A SELECT statement that supplies values */
136296 assert(pSelect != 0 || db->mallocFailed);
136301 pTriggerStep->pSelect = pSelect;
136302 pSelect = 0;
136304 pTriggerStep->pSelect = sqlite3SelectDup(db, pSelect, EXPRDUP_REDUCE);
136318 sqlite3SelectDelete(db, pSelect);
136658 sqlite3SelectDup(db, pStep->pSelect, 0),
136674 Select *pSelect = sqlite3SelectDup(db, pStep->pSelect, 0);
136676 sqlite3Select(pParse, pSelect, &sDest);
136677 sqlite3SelectDelete(db, pSelect);
137107 if( !pTab->pSelect ){
137267 isView = pTab->pSelect!=0;
139613 && !sParse.pNewTable->pSelect
140886 if( pItem->pSelect ){
140887 sqlite3_str_appendf(&str, " SUBQUERY %u", pItem->pSelect->selId);
141155 ExprList *pOrigRhs = pNew->x.pSelect->pEList; /* Original unmodified RHS */
141160 Select *pSelect; /* Pointer to the SELECT on the RHS */
141176 pNew->x.pSelect->pEList = pRhs;
141186 pSelect = pNew->x.pSelect;
141187 if( pSelect->pOrderBy ){
141195 ExprList *pOrderBy = pSelect->pOrderBy;
141279 if( (pX->flags & EP_xIsSelect)==0 || pX->x.pSelect->pEList->nExpr==1 ){
143159 && (pAlt->pExpr->x.pSelect->pEList->nExpr>1)
144142 mask |= exprSelectUsage(pMaskSet, pSrc->a[i].pSelect);
144270 pTerm->prereqRight = exprSelectUsage(pMaskSet, pExpr->x.pSelect);
144575 && pExpr->x.pSelect->pPrior==0
144577 && pExpr->x.pSelect->pWin==0
144731 mask |= exprSelectUsage(pMaskSet, p->x.pSelect);
147183 pRhs = pRhs->x.pSelect->pEList->a[i].pExpr;
147807 if( pTab->pSelect==0 && (pTab->tabFlags & TF_Ephemeral)==0 ){
149912 if( (pTab->tabFlags & TF_Ephemeral)!=0 || pTab->pSelect ){
150263 && pTab->pSelect==0
151190 static int selectWindowRewriteSelectCb(Walker *pWalker, Select *pSelect){
151193 if( pSave==pSelect ){
151196 p->pSubSelect = pSelect;
151197 sqlite3WalkSelect(pWalker, pSelect);
151409 p->pSrc->a[0].pSelect = pSub;
151709 SQLITE_PRIVATE void sqlite3WindowCodeInit(Parse *pParse, Select *pSelect){
151710 int nEphExpr = pSelect->pSrc->a[0].pSelect->pEList->nExpr;
151711 Window *pMWin = pSelect->pWin;
157172 pNew->pSelect = pOld->pSelect;
157180 pOld->pSelect = 0;
157631 Select *pSelect = sqlite3SelectNew(pParse, 0,pSrc,0,0,0,0,0,0);
157632 …if( yymsp[0].minor.yy242 ) sqlite3SrcListFuncArgs(pParse, pSelect ? pSrc : 0, yymsp[0].minor.yy24…
157634 sqlite3PExprAddSelect(pParse, yymsp[-4].minor.yy202, pSelect);
163846 if( !pTab || pTab->pSelect ){
177288 static int langidFromSelect(Fts3Table *p, sqlite3_stmt *pSelect){
177290 if( p->zLanguageid ) iLangid = sqlite3_column_int(pSelect, p->nColumn+1);
177307 sqlite3_stmt *pSelect;
177311 rc = fts3SqlStmt(p, SQL_SELECT_CONTENT_BY_ROWID, &pSelect, &pRowid);
177313 if( SQLITE_ROW==sqlite3_step(pSelect) ){
177315 int iLangid = langidFromSelect(p, pSelect);
177316 i64 iDocid = sqlite3_column_int64(pSelect, 0);
177321 const char *zText = (const char *)sqlite3_column_text(pSelect, i);
177323 aSz[p->nColumn] += sqlite3_column_bytes(pSelect, i);
177327 sqlite3_reset(pSelect);
177333 rc = sqlite3_reset(pSelect);
177335 sqlite3_reset(pSelect);
180464 sqlite3_stmt *pSelect = 0; /* SELECT to read %_segdir entry */
180466 rc = fts3SqlStmt(p, SQL_SELECT_SEGDIR, &pSelect, 0);
180477 sqlite3_bind_int64(pSelect, 1, iAbsLevel+1);
180478 sqlite3_bind_int(pSelect, 2, iIdx);
180479 if( sqlite3_step(pSelect)==SQLITE_ROW ){
180480 iStart = sqlite3_column_int64(pSelect, 1);
180481 iLeafEnd = sqlite3_column_int64(pSelect, 2);
180482 fts3ReadEndBlockField(pSelect, 3, &iEnd, &pWriter->nLeafData);
180487 nRoot = sqlite3_column_bytes(pSelect, 4);
180488 aRoot = sqlite3_column_blob(pSelect, 4);
180490 sqlite3_reset(pSelect);
180494 return sqlite3_reset(pSelect);
180529 sqlite3_reset(pSelect);
180587 rc2 = sqlite3_reset(pSelect);
180746 sqlite3_stmt *pSelect = 0; /* Select statement to read idx values */
180749 rc = fts3SqlStmt(p, SQL_SELECT_INDEXES, &pSelect, 0);
180752 sqlite3_bind_int64(pSelect, 1, iAbsLevel);
180753 while( SQLITE_ROW==sqlite3_step(pSelect) ){
180764 aIdx[nIdx++] = sqlite3_column_int(pSelect, 0);
180766 rc2 = sqlite3_reset(pSelect);
181032 sqlite3_stmt *pSelect = 0;
181036 rc = fts3SqlStmt(p, SQL_SELECT_STAT, &pSelect, 0);
181039 sqlite3_bind_int(pSelect, 1, FTS_STAT_INCRMERGEHINT);
181040 if( SQLITE_ROW==sqlite3_step(pSelect) ){
181041 const char *aHint = sqlite3_column_blob(pSelect, 0);
181042 int nHint = sqlite3_column_bytes(pSelect, 0);
181051 rc2 = sqlite3_reset(pSelect);
183258 sqlite3_stmt *pSelect = 0;
183274 rc = fts3MatchinfoSelectDoctotal(pTab, &pSelect, &nDoc, 0, 0);
183285 rc = fts3MatchinfoSelectDoctotal(pTab, &pSelect, &nDoc, &a, &pEnd);
183347 rc = fts3MatchinfoSelectDoctotal(pTab, &pSelect, &pInfo->nDoc,0,0);
183362 sqlite3_reset(pSelect);
195240 sqlite3_stmt *pSelect; /* Source data */
195770 sqlite3_finalize(pIter->pSelect);
195784 pIter->pSelect = 0;
197271 if( pIter->pSelect==0 && rbuObjIterCacheTableInfo(p, pIter)==SQLITE_OK ){
197370 p->rc = prepareFreeAndCollectError(p->dbRbu,&pIter->pSelect,pz,zSql);
197495 p->rc = prepareFreeAndCollectError(p->dbRbu, &pIter->pSelect, pz,
198224 switch( sqlite3_column_type(p->objiter.pSelect, iCol) ){
198226 int iVal = sqlite3_column_int(p->objiter.pSelect, iCol);
198238 const unsigned char *z = sqlite3_column_text(p->objiter.pSelect, iCol);
198308 && sqlite3_column_type(pIter->pSelect, i)==SQLITE_NULL
198319 pVal = sqlite3_column_value(pIter->pSelect, i);
198335 assertColumnName(pIter->pSelect, pIter->nCol+1,
198338 pVal = sqlite3_column_value(pIter->pSelect, pIter->nCol+1);
198394 pVal = sqlite3_column_value(pIter->pSelect, i);
198403 assertColumnName(pIter->pSelect, pIter->nCol+1, "rbu_rowid");
198404 pVal = sqlite3_column_value(pIter->pSelect, pIter->nCol+1);
198618 int rc = sqlite3_step(pIter->pSelect);
198624 p->rc = sqlite3_reset(pIter->pSelect);
203809 sqlite3_stmt *pSelect, /* SELECT from sessionSelectStmt() */
203830 rc = sqlite3_bind_int64(pSelect, i+1, iVal);
203841 rc = sqlite3_bind_double(pSelect, i+1, rVal);
203851 rc = sqlite3_bind_text(pSelect, i+1, (char *)a, n, SQLITE_TRANSIENT);
203862 rc = sqlite3_bind_blob(pSelect, i+1, a, n, SQLITE_TRANSIENT);
205018 sqlite3_stmt *pSelect; /* SELECT statement */
205215 db, "main", zTab, p->nCol, p->azCol, p->abPK, &p->pSelect);
205387 sqlite3_stmt *pSelect /* SELECT statement from sessionSelectRow() */
205397 nCol, abPK, pSelect
205401 rc = sqlite3_step(pSelect);
205402 if( rc!=SQLITE_ROW ) rc = sqlite3_reset(pSelect);
205514 rc = sessionSeekToRow(p->db, pIter, p->abPK, p->pSelect);
205521 pIter->pConflict = p->pSelect;
205524 rc = sqlite3_reset(p->pSelect);
205603 assert( p->pDelete && p->pUpdate && p->pInsert && p->pSelect );
205689 rc = sessionSeekToRow(p->db, pIter, p->abPK, p->pSelect);
205692 sqlite3_reset(p->pSelect);
205889 sqlite3_finalize(sApply.pSelect);
205894 sApply.pSelect = 0;
206022 sqlite3_finalize(sApply.pSelect);