Lines Matching refs:pSelect
17213 Select *pSelect; /* View definition */ member
17744 Select *pSelect; /* EP_xIsSelect and op = IN, EXISTS, SELECT */ member
17982 Select *pSelect; /* A SELECT statement used in place of a table name */ member
18729 Select *pSelect; /* SELECT statement or RHS of INSERT INTO SELECT ... */ member
18921 Select *pSelect; /* HAVING to WHERE clause ctx */ member
18983 Select *pSelect; /* The definition of this CTE */ member
19401 SQLITE_PRIVATE void sqlite3GenerateColumnNames(Parse *pParse, Select *pSelect);
29788 }else if( ALWAYS(pItem->pSelect) ){
29789 sqlite3_str_appendf(pAccum, "SUBQUERY %u", pItem->pSelect->selId);
30369 sqlite3TreeViewSelect(pView, pCte->pSelect, 0);
30405 if( pItem->pSelect ){
30406 sqlite3TreeViewSelect(pView, pItem->pSelect, 0);
30878 sqlite3TreeViewSelect(pView, pExpr->x.pSelect, 0);
30884 sqlite3TreeViewSelect(pView, pExpr->x.pSelect, 0);
30891 sqlite3TreeViewSelect(pView, pExpr->x.pSelect, 0);
30974 sqlite3TreeViewSelect(pView, pExpr->pLeft->x.pSelect, 0);
99407 if( sqlite3WalkSelect(pWalker, pExpr->x.pSelect) ) return WRC_Abort;
99499 if( pItem->pSelect && sqlite3WalkSelect(pWalker, pItem->pSelect) ){
99552 SQLITE_PRIVATE int sqlite3WalkerDepthIncrease(Walker *pWalker, Select *pSelect){
99553 UNUSED_PARAMETER(pSelect);
99557 SQLITE_PRIVATE void sqlite3WalkerDepthDecrease(Walker *pWalker, Select *pSelect){
99558 UNUSED_PARAMETER(pSelect);
99896 if( pItem->pSelect && (pItem->pSelect->selFlags & SF_NestedFrom)!=0 ){
99898 pEList = pItem->pSelect->pEList;
100114 assert( ExprUseXSelect(pExpr)==0 || pExpr->x.pSelect==0 );
100730 sqlite3WalkSelect(pWalker, pExpr->x.pSelect);
100861 Select *pSelect, /* The SELECT statement with the ORDER BY clause */
100872 pEList = pSelect->pEList;
100878 nc.pSrcList = pSelect->pSrc;
100934 Select *pSelect /* The SELECT statement containing the ORDER BY */
100942 pOrderBy = pSelect->pOrderBy;
100952 pSelect->pNext = 0;
100953 while( pSelect->pPrior ){
100954 pSelect->pPrior->pNext = pSelect;
100955 pSelect = pSelect->pPrior;
100957 while( pSelect && moreToDo ){
100960 pEList = pSelect->pEList;
100990 iCol = resolveOrderByTermToExprList(pParse, pSelect, pDup);
100992 resolveOrderByTermToExprList(pParse, pSelect, pE);
101023 pSelect = pSelect->pNext;
101047 Select *pSelect, /* The SELECT statement containing the clause */
101061 pEList = pSelect->pEList;
101092 static void windowRemoveExprFromSelect(Select *pSelect, Expr *pExpr){
101093 if( pSelect->pWin ){
101097 sWalker.u.pSelect = pSelect;
101125 Select *pSelect, /* The SELECT statement holding pOrderBy */
101136 nResult = pSelect->pEList->nExpr;
101143 iCol = resolveAsName(pParse, pSelect->pEList, pE2);
101170 for(j=0; j<pSelect->pEList->nExpr; j++){
101171 if( sqlite3ExprCompare(0, pE, pSelect->pEList->a[j].pExpr, -1)==0 ){
101175 windowRemoveExprFromSelect(pSelect, pE);
101180 return sqlite3ResolveOrderGroupBy(pParse, pSelect, pOrderBy, zType);
101246 Select *pSub = p->pSrc->a[0].pSelect;
101257 if( pItem->pSelect && (pItem->pSelect->selFlags & SF_Resolved)==0 ){
101262 sqlite3ResolveSelectNames(pParse, pItem->pSelect, pOuterNC);
101358 Select *pSub = p->pSrc->a[0].pSelect;
101702 assert( pExpr->x.pSelect!=0 );
101703 assert( pExpr->x.pSelect->pEList!=0 );
101704 assert( pExpr->x.pSelect->pEList->a[0].pExpr!=0 );
101705 return sqlite3ExprAffinity(pExpr->x.pSelect->pEList->a[0].pExpr);
101716 assert( pExpr->iTable==pExpr->pLeft->x.pSelect->pEList->nExpr );
101718 pExpr->pLeft->x.pSelect->pEList->a[pExpr->iColumn].pExpr
101934 aff = sqlite3CompareAffinity(pExpr->x.pSelect->pEList->a[0].pExpr, aff);
102077 return pExpr->x.pSelect->pEList->nExpr;
102104 return pVector->x.pSelect->pEList->a[i].pExpr;
102234 *ppExpr = pVector->x.pSelect->pEList->a[iField].pExpr;
102387 static void heightOfSelect(const Select *pSelect, int *pnHeight){
102389 for(p=pSelect; p; p=p->pPrior){
102414 heightOfSelect(p->x.pSelect, &nHeight);
102599 SQLITE_PRIVATE void sqlite3PExprAddSelect(Parse *pParse, Expr *pExpr, Select *pSelect){
102601 pExpr->x.pSelect = pSelect;
102606 sqlite3SelectDelete(pParse->db, pSelect);
102853 assert( !ExprUseXSelect(p) || p->x.pSelect==0 );
102866 sqlite3SelectDelete(db, p->x.pSelect);
103096 pNew->x.pSelect = sqlite3SelectDup(db, p->x.pSelect, dupFlags);
103151 pRet->a[i].pSelect = sqlite3SelectDup(db, p->a[i].pSelect, 0);
103172 Select *pSelect = pWalker->u.pSelect;
103177 sqlite3WindowLink(pSelect, pWin);
103182 return p==pWalker->u.pSelect ? WRC_Continue : WRC_Prune;
103190 w.u.pSelect = p;
103309 pNewItem->pSelect = sqlite3SelectDup(db, pOldItem->pSelect, flags);
104174 p = pX->x.pSelect;
104187 if( pSrc->a[0].pSelect ) return 0; /* FROM is not a subquery or view */
104345 ExprList *pEList = pX->x.pSelect->pEList;
104548 Select *pSelect = ExprUseXSelect(pExpr) ? pExpr->x.pSelect : 0;
104558 if( pSelect ){
104559 zRet[i] = sqlite3CompareAffinity(pSelect->pEList->a[i].pExpr, a);
104599 sqlite3SubselectError(pParse, pExpr->x.pSelect->pEList->nExpr, 1);
104664 pExpr->x.pSelect->selId));
104697 VdbeComment((v, "Result of SELECT %u", pExpr->x.pSelect->selId));
104710 Select *pSelect = pExpr->x.pSelect;
104711 ExprList *pEList = pSelect->pEList;
104714 addrOnce?"":"CORRELATED ", pSelect->selId
104725 pSelect->iLimit = 0;
104726 testcase( pSelect->selFlags & SF_Distinct );
104728 pCopy = sqlite3SelectDup(pParse->db, pSelect, 0);
104840 pSel = pExpr->x.pSelect;
104952 if( nVector!=pIn->x.pSelect->pEList->nExpr ){
104953 sqlite3SubselectError(pParse, pIn->x.pSelect->pEList->nExpr, nVector);
106112 && (nCol = pExpr->x.pSelect->pEList->nExpr)!=1
107541 static int selectRefEnter(Walker *pWalker, Select *pSelect){
107543 SrcList *pSrc = pSelect->pSrc;
107561 static void selectRefLeave(Walker *pWalker, Select *pSelect){
107563 SrcList *pSrc = pSelect->pSrc;
108810 static void renameWalkWith(Walker *pWalker, Select *pSelect){
108811 With *pWith = pSelect->pWith;
108817 if( (pWith->a[0].pSelect->selFlags & SF_Expanded)==0 ){
108827 Select *p = pWith->a[i].pSelect;
109301 if( pStep->pSelect ){
109302 sqlite3SelectPrep(pParse, pStep->pSelect, &sNC);
109312 if( p->pSelect ){
109313 sqlite3SelectPrep(pParse, p->pSelect, 0);
109316 assert( pStep->pFrom->a[i-1].pSelect );
109317 sqlite3SelectPrep(pParse, pStep->pFrom->a[i-1].pSelect, 0);
109379 sqlite3WalkSelect(pWalker, pStep->pSelect);
109392 sqlite3WalkSelect(pWalker, pStep->pFrom->a[i].pSelect);
109498 Select *pSelect = sParse.pNewTable->u.view.pSelect;
109499 pSelect->selFlags &= ~SF_View;
109501 sqlite3SelectPrep(&sParse, pSelect, 0);
109504 sqlite3WalkSelect(&sWalker, pSelect);
109621 static int renameTableSelectCb(Walker *pWalker, Select *pSelect){
109624 SrcList *pSrc = pSelect->pSrc;
109625 if( pSelect->selFlags & (SF_View|SF_CopyCte) ){
109626 testcase( pSelect->selFlags & SF_View );
109627 testcase( pSelect->selFlags & SF_CopyCte );
109640 renameWalkWith(pWalker, pSelect);
109709 Select *pSelect = pTab->u.view.pSelect;
109714 assert( pSelect->selFlags & SF_View );
109715 pSelect->selFlags &= ~SF_View;
109716 sqlite3SelectPrep(&sParse, pTab->u.view.pSelect, &sNC);
109720 sqlite3WalkSelect(&sWalker, pTab->u.view.pSelect);
109872 Select *pSelect = sParse.pNewTable->u.view.pSelect;
109873 pSelect->selFlags &= ~SF_View;
109875 sqlite3SelectPrep(&sParse, pSelect, 0);
109878 sqlite3WalkSelect(&sWalker, pSelect);
109974 sqlite3SelectPrep(&sParse, sParse.pNewTable->u.view.pSelect, &sNC);
112617 static int fixSelectCb(Walker *p, Select *pSelect){
112623 SrcList *pList = pSelect->pSrc;
112646 if( pSelect->pWith ){
112647 for(i=0; i<pSelect->pWith->nCte; i++){
112648 if( sqlite3WalkSelect(p, pSelect->pWith->a[i].pSelect) ){
112714 Select *pSelect /* The SELECT statement to be fixed to one database */
112716 return sqlite3WalkSelect(&pFix->w, pSelect);
112732 if( sqlite3WalkSelect(&pFix->w, pStep->pSelect)
113893 sqlite3SelectDelete(db, pTable->u.view.pSelect);
115652 Select *pSelect /* Select from a "CREATE ... AS SELECT" */
115659 if( pEnd==0 && pSelect==0 ){
115665 if( pSelect==0 && sqlite3ShadowTableName(db, p->zName) ){
115679 if( pSelect || (!IsOrdinaryTable(p) && db->init.newTnum) ){
115845 if( pSelect ){
115865 pSelTab = sqlite3ResultSetOfSelect(pParse, pSelect, SQLITE_AFF_BLOB);
115874 sqlite3Select(pParse, pSelect, &dest);
115890 if( pSelect ){
115970 if( !pSelect && IsOrdinaryTable(p) ){
115990 Select *pSelect, /* A SELECT statement that will become the new view */
116023 if( sqlite3FixSelect(&sFix, pSelect) ) goto create_view_fail;
116030 pSelect->selFlags |= SF_View;
116032 p->u.view.pSelect = pSelect;
116033 pSelect = 0;
116035 p->u.view.pSelect = sqlite3SelectDup(db, pSelect, EXPRDUP_REDUCE);
116061 sqlite3SelectDelete(db, pSelect);
116135 pSel = sqlite3SelectDup(db, pTable->u.view.pSelect, 0);
117911 if( pItem->pSelect ){
117912 sqlite3SrcListAssignCursors(pParse, pItem->pSelect->pSrc);
117932 if( pItem->pSelect ) sqlite3SelectDelete(db, pItem->pSelect);
117989 pItem->pSelect = pSubquery;
118570 pNew->pSelect = pQuery;
118585 sqlite3SelectDelete(db, pCte->pSelect);
119358 Select *pSelect = NULL; /* Complete SELECT tree */
119426 pSelect = sqlite3SelectNew(pParse, pEList, pSelectSrc, pWhere, 0 ,0,
119432 sqlite3PExprAddSelect(pParse, pInClause, pSelect);
123241 sqlite3SelectDelete(dbMem, pStep->pSelect);
123781 Select *pSelect = 0; /* If RESTRICT, "SELECT RAISE(...)" */
123876 pSelect = sqlite3SelectNew(pParse,
123900 pStep->pSelect = sqlite3SelectDup(db, pSelect, EXPRDUP_REDUCE);
123913 sqlite3SelectDelete(db, pSelect);
124589 Select *pSelect, /* A SELECT statement to use as the data source */
124694 Select *pSelect, /* A SELECT statement to use as the data source */
124747 if( pSelect && (pSelect->selFlags & SF_Values)!=0 && pSelect->pPrior==0 ){
124748 pList = pSelect->pEList;
124749 pSelect->pEList = 0;
124750 sqlite3SelectDelete(db, pSelect);
124751 pSelect = 0;
124804 sqlite3BeginWriteOperation(pParse, pSelect || pTrigger, iDb);
124816 if( pColumn==0 && xferOptimization(pParse, pTab, pSelect, onError, iDb) ){
124901 if( pSelect ){
124914 rc = sqlite3Select(pParse, pSelect, &dest);
124919 assert( pSelect->pEList );
124920 nColumn = pSelect->pEList->nExpr;
125098 }else if( pSelect ){
125188 }else if( pSelect ){
125218 assert( pSelect==0 ); /* Otherwise useTempTable is true */
125268 }else if( pSelect ){
125374 }else if( pSelect ){
125414 sqlite3SelectDelete(db, pSelect);
126767 Select *pSelect, /* A SELECT statement to use as the data source */
126787 if( pSelect==0 ){
126790 if( pParse->pWith || pSelect->pWith ){
126808 assert(pSelect->pSrc); /* allocated even if there is no FROM clause */
126809 if( pSelect->pSrc->nSrc!=1 ){
126812 if( pSelect->pSrc->a[0].pSelect ){
126815 if( pSelect->pWhere ){
126818 if( pSelect->pOrderBy ){
126823 if( pSelect->pGroupBy ){
126826 if( pSelect->pLimit ){
126829 if( pSelect->pPrior ){
126832 if( pSelect->selFlags & SF_Distinct ){
126835 pEList = pSelect->pEList;
126849 pItem = pSelect->pSrc->a;
133815 Select *pSelect, /* The query being coded */
133818 sqlite3ExprCodeExprList(pParse, pSelect->pEList, pInfo->regResult,
133837 Select *pSelect,
133845 innerLoopLoadRow(pParse, pSelect, pSort->pDeferredRowLoad);
133858 Select *pSelect, /* The whole SELECT statement */
133899 assert( pSelect->iOffset==0 || pSelect->iLimit!=0 );
133900 iLimit = pSelect->iOffset ? pSelect->iOffset+1 : pSelect->iLimit;
133918 regRecord = makeSorterRecord(pParse, pSort, pSelect, regBase, nBase);
133979 regRecord = makeSorterRecord(pParse, pSort, pSelect, regBase, nBase);
135049 pS = pTabList->a[j].pSelect;
135139 pS = pExpr->x.pSelect;
135234 Select *pSelect /* Generate column names for this SELECT statement */
135254 while( pSelect->pPrior ) pSelect = pSelect->pPrior;
135255 SELECTTRACE(1,pParse,pSelect,("generating column names\n"));
135256 pTabList = pSelect->pSrc;
135257 pEList = pSelect->pEList;
135435 Select *pSelect, /* SELECT used to determine types and collations */
135446 assert( pSelect!=0 );
135447 assert( (pSelect->selFlags & SF_Resolved)!=0 );
135448 assert( pTab->nCol==pSelect->pEList->nExpr || db->mallocFailed );
135451 sNC.pSrcList = pSelect->pSrc;
135452 a = pSelect->pEList->a;
135487 SQLITE_PRIVATE Table *sqlite3ResultSetOfSelect(Parse *pParse, Select *pSelect, char aff){
135495 sqlite3SelectPrep(pParse, pSelect, 0);
135498 while( pSelect->pPrior ) pSelect = pSelect->pPrior;
135506 sqlite3ColumnsFromExprList(pParse, pSelect->pEList, &pTab->nCol, &pTab->aCol);
135507 sqlite3SelectAddColumnTypeAndCollation(pParse, pTab, pSelect, aff);
136955 substSelect(pSubst, pExpr->x.pSelect, 1);
136998 substSelect(pSubst, pItem->pSelect, 1);
137025 Select *pSelect, /* The complete SELECT statement */
137035 sqlite3WalkSelect(&w, pSelect);
137069 for(p=pItem->pSelect; p; p=p->pPrior){
137322 pSub = pSubitem->pSelect;
137457 pSub1 = pSubitem->pSelect;
137464 pSubitem->pSelect = 0;
137529 assert( pSubitem->pSelect==0 );
137533 pSubitem->pSelect = pSub1;
138227 || p->pSrc->a[0].pSelect
138526 pFrom->pSelect = sqlite3SelectDup(db, pCte->pSelect, 0);
138528 pFrom->pSelect->selFlags |= SF_CopyCte;
138529 assert( pFrom->pSelect );
138542 pRecTerm = pSel = pFrom->pSelect;
138656 Select *pSel = pFrom->pSelect;
138759 Select *pSel = pFrom->pSelect;
138792 assert( pFrom->pSelect==0 );
138800 pFrom->pSelect = sqlite3SelectDup(db, pTab->u.view.pSelect, 0);
138816 sqlite3WalkSelect(pWalker, pFrom->pSelect);
138895 Select *pSub = pFrom->pSelect;
139033 static void sqlite3SelectExpand(Parse *pParse, Select *pSelect){
139040 sqlite3WalkSelect(&w, pSelect);
139045 sqlite3WalkSelect(&w, pSelect);
139079 Select *pSel = pFrom->pSelect;
139098 static void sqlite3SelectAddTypeInfo(Parse *pParse, Select *pSelect){
139105 sqlite3WalkSelect(&w, pSelect);
139345 Select *pS = pWalker->u.pSelect;
139392 sWalker.u.pSelect = p;
139412 assert( pThis->pSelect!=0 );
139413 if( pThis->pSelect->selFlags & SF_PushDown ) return 0;
139416 if( pItem->pSelect==0 ) continue;
139423 pS1 = pItem->pSelect;
139424 if( pItem->pTab->pSchema==0 && pThis->pSelect->selId!=pS1->selId ){
139429 if( pItem->pSelect->selFlags & SF_PushDown ){
139484 pSub = p->pSrc->a[0].pSelect;
139500 pSub = p->pSrc->a[0].pSelect;
139501 p->pSrc->a[0].pSelect = 0;
139679 Select *pSub = pItem->pSelect;
139877 pSub = pItem->pSelect;
139908 assert( pItem->pSelect && (pItem->pSelect->selFlags & SF_PushDown)!=0 );
139968 pSub->nSelectRow = pPrior->pSelect->nSelectRow;
141010 sqlite3SelectDelete(db, pTmp->pSelect);
141401 Select *pSelect, /* The SELECT statement */
141407 sqlite3SelectDelete(db, pSelect);
141411 pTriggerStep->pSelect = pSelect;
141459 Select *pSelect, /* A SELECT statement that supplies values */
141468 assert(pSelect != 0 || db->mallocFailed);
141473 pTriggerStep->pSelect = pSelect;
141474 pSelect = 0;
141476 pTriggerStep->pSelect = sqlite3SelectDup(db, pSelect, EXPRDUP_REDUCE);
141490 sqlite3SelectDelete(db, pSelect);
142012 sqlite3SelectDup(db, pStep->pSelect, 0),
142030 Select *pSelect = sqlite3SelectDup(db, pStep->pSelect, 0);
142032 sqlite3Select(pParse, pSelect, &sDest);
142033 sqlite3SelectDelete(db, pSelect);
142605 Select *pSelect = 0;
142671 pSelect = sqlite3SelectNew(pParse, pList,
142674 if( pSelect ) pSelect->selFlags |= SF_OrderByReqd;
142677 sqlite3Select(pParse, pSelect, &dest);
142678 sqlite3SelectDelete(db, pSelect);
146856 Select *pSelect; /* Pointer to the SELECT on the RHS */
146859 pOrigRhs = pNew->x.pSelect->pEList;
146879 pNew->x.pSelect->pEList = pRhs;
146889 pSelect = pNew->x.pSelect;
146890 if( pSelect->pOrderBy ){
146898 ExprList *pOrderBy = pSelect->pOrderBy;
146982 if( !ExprUseXSelect(pX) || pX->x.pSelect->pEList->nExpr==1 ){
148926 && (pAlt->pExpr->x.pSelect->pEList->nExpr>1)
149928 mask |= exprSelectUsage(pMaskSet, pSrc->a[i].pSelect);
150059 pTerm->prereqRight = exprSelectUsage(pMaskSet, pExpr->x.pSelect);
150378 && pExpr->x.pSelect->pPrior==0
150380 && pExpr->x.pSelect->pWin==0
150543 mask |= exprSelectUsage(pMaskSet, p->x.pSelect);
153078 pRhs = pRhs->x.pSelect->pEList->a[i].pExpr;
157187 static int selectWindowRewriteSelectCb(Walker *pWalker, Select *pSelect){
157190 if( pSave==pSelect ){
157193 p->pSubSelect = pSelect;
157194 sqlite3WalkSelect(pWalker, pSelect);
157434 p->pSrc->a[0].pSelect = pSub;
157746 SQLITE_PRIVATE void sqlite3WindowCodeInit(Parse *pParse, Select *pSelect){
157747 int nEphExpr = pSelect->pSrc->a[0].pSelect->pEList->nExpr;
157748 Window *pMWin = pSelect->pWin;
159608 static Select *attachWithToSelect(Parse *pParse, Select *pSelect, With *pWith){
159609 if( pSelect ){
159610 pSelect->pWith = pWith;
159611 parserDoubleLinkSelect(pParse, pSelect);
159615 return pSelect;
163495 pNew->pSelect = pOld->pSelect;
163503 pOld->pSelect = 0;
163980 Select *pSelect = sqlite3SelectNew(pParse, 0,pSrc,0,0,0,0,0,0);
163981 …if( yymsp[0].minor.yy562 ) sqlite3SrcListFuncArgs(pParse, pSelect ? pSrc : 0, yymsp[0].minor.yy56…
163983 sqlite3PExprAddSelect(pParse, yymsp[-4].minor.yy626, pSelect);
183922 static int langidFromSelect(Fts3Table *p, sqlite3_stmt *pSelect){
183924 if( p->zLanguageid ) iLangid = sqlite3_column_int(pSelect, p->nColumn+1);
183941 sqlite3_stmt *pSelect;
183945 rc = fts3SqlStmt(p, SQL_SELECT_CONTENT_BY_ROWID, &pSelect, &pRowid);
183947 if( SQLITE_ROW==sqlite3_step(pSelect) ){
183949 int iLangid = langidFromSelect(p, pSelect);
183950 i64 iDocid = sqlite3_column_int64(pSelect, 0);
183955 const char *zText = (const char *)sqlite3_column_text(pSelect, i);
183957 aSz[p->nColumn] += sqlite3_column_bytes(pSelect, i);
183961 sqlite3_reset(pSelect);
183967 rc = sqlite3_reset(pSelect);
183969 sqlite3_reset(pSelect);
187120 sqlite3_stmt *pSelect = 0; /* SELECT to read %_segdir entry */
187122 rc = fts3SqlStmt(p, SQL_SELECT_SEGDIR, &pSelect, 0);
187133 sqlite3_bind_int64(pSelect, 1, iAbsLevel+1);
187134 sqlite3_bind_int(pSelect, 2, iIdx);
187135 if( sqlite3_step(pSelect)==SQLITE_ROW ){
187136 iStart = sqlite3_column_int64(pSelect, 1);
187137 iLeafEnd = sqlite3_column_int64(pSelect, 2);
187138 fts3ReadEndBlockField(pSelect, 3, &iEnd, &pWriter->nLeafData);
187143 nRoot = sqlite3_column_bytes(pSelect, 4);
187144 aRoot = sqlite3_column_blob(pSelect, 4);
187146 sqlite3_reset(pSelect);
187150 return sqlite3_reset(pSelect);
187185 sqlite3_reset(pSelect);
187246 rc2 = sqlite3_reset(pSelect);
187405 sqlite3_stmt *pSelect = 0; /* Select statement to read idx values */
187408 rc = fts3SqlStmt(p, SQL_SELECT_INDEXES, &pSelect, 0);
187411 sqlite3_bind_int64(pSelect, 1, iAbsLevel);
187412 while( SQLITE_ROW==sqlite3_step(pSelect) ){
187423 aIdx[nIdx++] = sqlite3_column_int(pSelect, 0);
187425 rc2 = sqlite3_reset(pSelect);
187691 sqlite3_stmt *pSelect = 0;
187695 rc = fts3SqlStmt(p, SQL_SELECT_STAT, &pSelect, 0);
187698 sqlite3_bind_int(pSelect, 1, FTS_STAT_INCRMERGEHINT);
187699 if( SQLITE_ROW==sqlite3_step(pSelect) ){
187700 const char *aHint = sqlite3_column_blob(pSelect, 0);
187701 int nHint = sqlite3_column_bytes(pSelect, 0);
187710 rc2 = sqlite3_reset(pSelect);
189920 sqlite3_stmt *pSelect = 0;
189936 rc = fts3MatchinfoSelectDoctotal(pTab, &pSelect, &nDoc, 0, 0);
189947 rc = fts3MatchinfoSelectDoctotal(pTab, &pSelect, &nDoc, &a, &pEnd);
190009 rc = fts3MatchinfoSelectDoctotal(pTab, &pSelect, &pInfo->nDoc,0,0);
190024 sqlite3_reset(pSelect);
202069 sqlite3_stmt *pSelect; /* Source data */
202599 sqlite3_finalize(pIter->pSelect);
202613 pIter->pSelect = 0;
204104 if( pIter->pSelect==0 && rbuObjIterCacheTableInfo(p, pIter)==SQLITE_OK ){
204203 p->rc = prepareFreeAndCollectError(p->dbRbu,&pIter->pSelect,pz,zSql);
204328 p->rc = prepareFreeAndCollectError(p->dbRbu, &pIter->pSelect, pz,
205093 switch( sqlite3_column_type(p->objiter.pSelect, iCol) ){
205095 int iVal = sqlite3_column_int(p->objiter.pSelect, iCol);
205107 const unsigned char *z = sqlite3_column_text(p->objiter.pSelect, iCol);
205177 && sqlite3_column_type(pIter->pSelect, i)==SQLITE_NULL
205188 pVal = sqlite3_column_value(pIter->pSelect, i);
205204 assertColumnName(pIter->pSelect, pIter->nCol+1,
205207 pVal = sqlite3_column_value(pIter->pSelect, pIter->nCol+1);
205263 pVal = sqlite3_column_value(pIter->pSelect, i);
205272 assertColumnName(pIter->pSelect, pIter->nCol+1, "rbu_rowid");
205273 pVal = sqlite3_column_value(pIter->pSelect, pIter->nCol+1);
205487 int rc = sqlite3_step(pIter->pSelect);
205493 p->rc = sqlite3_reset(pIter->pSelect);
210900 sqlite3_stmt *pSelect, /* SELECT from sessionSelectStmt() */
210921 rc = sqlite3_bind_int64(pSelect, i+1, iVal);
210932 rc = sqlite3_bind_double(pSelect, i+1, rVal);
210942 rc = sqlite3_bind_text(pSelect, i+1, (char *)a, n, SQLITE_TRANSIENT);
210953 rc = sqlite3_bind_blob(pSelect, i+1, a, n, SQLITE_TRANSIENT);
212207 sqlite3_stmt *pSelect; /* SELECT statement */
212471 db, "main", zTab, p->nCol, p->azCol, p->abPK, &p->pSelect);
212632 sqlite3_stmt *pSelect /* SELECT statement from sessionSelectRow() */
212642 nCol, abPK, pSelect
212646 rc = sqlite3_step(pSelect);
212647 if( rc!=SQLITE_ROW ) rc = sqlite3_reset(pSelect);
212759 rc = sessionSeekToRow(p->db, pIter, p->abPK, p->pSelect);
212766 pIter->pConflict = p->pSelect;
212769 rc = sqlite3_reset(p->pSelect);
212848 assert( p->pDelete && p->pInsert && p->pSelect );
212933 rc = sessionSeekToRow(p->db, pIter, p->abPK, p->pSelect);
212936 sqlite3_reset(p->pSelect);
213136 sqlite3_finalize(sApply.pSelect);
213140 sApply.pSelect = 0;
213267 sqlite3_finalize(sApply.pSelect);