Lines Matching refs:pSel
20491 SQLITE_PRIVATE void sqlite3WindowLink(Select *pSel, Window *pWin);
31997 Select *pSel = pItem->pSelect; in sqlite3_str_vappendf() local
31998 assert( pSel!=0 ); /* Because of tag-20240424-1 */ in sqlite3_str_vappendf()
31999 if( pSel->selFlags & SF_NestedFrom ){ in sqlite3_str_vappendf()
32000 sqlite3_str_appendf(pAccum, "(join-%u)", pSel->selId); in sqlite3_str_vappendf()
32001 }else if( pSel->selFlags & SF_MultiValue ){ in sqlite3_str_vappendf()
32006 sqlite3_str_appendf(pAccum, "(subquery-%u)", pSel->selId); in sqlite3_str_vappendf()
108024 Select *pSel = pNC->pWinSelect;
108027 sqlite3WindowUpdate(pParse, pSel ? pSel->pWinDefn : 0, pWin, pDef);
108033 sqlite3WindowLink(pSel, pWin);
110102 Select *pSel;
110118 pSel = sqlite3SelectNew(pParse, pExpr->x.pList, 0, 0, 0, 0, 0, SF_Values,0);
110120 if( pSel ){
110122 pSel->op = TK_ALL;
110123 pSel->pPrior = pRet;
110125 pRet = pSel;
112634 Select *pSel; /* SELECT statement to encode */
112649 pSel = pExpr->x.pSelect;
112654 ExplainQueryPlan((pParse, 0, "REUSE SUBQUERY %d", pSel->selId));
112694 addrOnce?"":"CORRELATED ", pSel->selId));
112696 nReg = pExpr->op==TK_SELECT ? pSel->pEList->nExpr : 1;
112710 if( pSel->pLimit ){
112718 sqlite3ExprDup(db, pSel->pLimit->pLeft, 0), pLimit);
112720 sqlite3ExprDeferredDelete(pParse, pSel->pLimit->pLeft);
112721 pSel->pLimit->pLeft = pLimit;
112725 pSel->pLimit = sqlite3PExpr(pParse, TK_LIMIT, pLimit, 0);
112727 pSel->iLimit = 0;
112728 if( sqlite3Select(pParse, pSel, &dest) ){
117481 Select *pSel = sqlite3SelectNew(
117484 if( pSel==0 ){
117498 sqlite3SelectPrep(pParse, pSel, 0);
117501 assert( pStep->pExprList==0 || pStep->pExprList==pSel->pEList );
117502 assert( pSrc==pSel->pSrc );
117503 if( pStep->pExprList ) pSel->pEList = 0;
117504 pSel->pSrc = 0;
117505 sqlite3SelectDelete(db, pSel);
124440 Select *pSel; /* Copy of the SELECT that implements the view */
124497 pSel = sqlite3SelectDup(db, pTable->u.view.pSelect, 0);
124498 if( pSel ){
124503 sqlite3SrcListAssignCursors(pParse, pSel->pSrc);
124509 pSelTab = sqlite3ResultSetOfSelect(pParse, pSel, SQLITE_AFF_NONE);
124512 pSelTab = sqlite3ResultSetOfSelect(pParse, pSel, SQLITE_AFF_NONE);
124529 && pTable->nCol==pSel->pEList->nExpr
124532 sqlite3SubqueryColumnTypes(pParse, pTable, pSel, SQLITE_AFF_NONE);
124548 sqlite3SelectDelete(db, pSel);
127767 Select *pSel;
127780 pSel = sqlite3SelectNew(pParse, 0, pFrom, pWhere, 0, 0, pOrderBy,
127783 sqlite3Select(pParse, pSel, &dest);
127784 sqlite3SelectDelete(db, pSel);
147009 static ExprList *findLeftmostExprlist(Select *pSel){
147010 while( pSel->pPrior ){
147011 pSel = pSel->pPrior;
147013 return pSel->pEList;
148071 Select *pSel;
148073 for(pSel=pSubq; pSel; pSel=pSel->pPrior){
148074 u8 op = pSel->op;
148081 if( pSel->pWin ) return 0; /* restriction (6b) */
148088 for(pSel=pSubq; pSel; pSel=pSel->pPrior){
148090 const ExprList *pList = pSel->pEList;
148617 Select *pSel;
148668 pRecTerm = pSel = pFrom->pSelect;
148669 bMayRecursive = ( pSel->op==TK_ALL || pSel->op==TK_UNION );
148670 while( bMayRecursive && pRecTerm->op==pSel->op ){
148701 if( pSel->selFlags & SF_Recursive ){
148708 pRecTerm->pWith = pSel->pWith;
148716 if( sqlite3WalkSelect(pWalker, pSel) ){
148723 for(pLeft=pSel; pLeft->pPrior; pLeft=pLeft->pPrior);
148738 if( pSel->selFlags & SF_Recursive ){
148743 sqlite3WalkSelect(pWalker, pSel);
148782 Select *pSel = pFrom->pSelect;
148785 assert( pSel );
148794 while( pSel->pPrior ){ pSel = pSel->pPrior; }
148795 sqlite3ColumnsFromExprList(pParse, pSel->pEList,&pTab->nCol,&pTab->aCol);
148911 Select *pSel = pFrom->pSelect;
148913 assert( pSel!=0 );
148915 if( sqlite3WalkSelect(pWalker, pSel) ) return WRC_Abort;
149312 Select *pSel = pFrom->pSelect;
149313 if( pSel ){
149314 sqlite3SubqueryColumnTypes(pParse, pTab, pSel, SQLITE_AFF_NONE);
170682 SQLITE_PRIVATE void sqlite3WindowLink(Select *pSel, Window *pWin){
170683 if( pSel ){
170684 if( 0==pSel->pWin || 0==sqlite3WindowCompare(0, pSel->pWin, pWin, 0) ){
170685 pWin->pNextWin = pSel->pWin;
170686 if( pSel->pWin ){
170687 pSel->pWin->ppThis = &pWin->pNextWin;
170689 pSel->pWin = pWin;
170690 pWin->ppThis = &pSel->pWin;
170692 if( sqlite3ExprListCompare(pWin->pPartition, pSel->pWin->pPartition,-1) ){
170693 pSel->selFlags |= SF_MultiPart;
219743 sqlite3_stmt *pSel = 0;
219745 p->rc = prepareFreeAndCollectError(p->dbMain, &pSel, &p->zErrmsg,
219750 if( p->rc==SQLITE_OK && SQLITE_ROW==sqlite3_step(pSel) ){
219753 const char *zQuoted = (const char*)sqlite3_column_text(pSel, iCol);
219768 rbuFinalize(p, pSel);
227884 sqlite3_stmt *pSel = 0; /* SELECT statement to query table pTab */
227901 zName, pTab->bRowid, pTab->nCol, pTab->azCol, pTab->abPK, &pSel
227910 rc = sessionSelectBind(pSel, pTab->nCol, pTab->abPK, p);
227912 if( sqlite3_step(pSel)==SQLITE_ROW ){
227918 sessionAppendCol(&buf, pSel, iCol, &rc);
227922 rc = sessionAppendUpdate(&buf, bPatchset, pSel, p, pTab->abPK);
227928 rc = sqlite3_reset(pSel);
227946 sqlite3_finalize(pSel);
243266 sqlite3_stmt *pSel = 0; /* SELECT to find iPg */
243268 pSel = fts5IdxNextStmt(p);
243269 if( pSel ){
243271 sqlite3_bind_int(pSel, 1, pSeg->iSegid);
243272 sqlite3_bind_blob(pSel, 2, pTerm, nTerm, SQLITE_STATIC);
243274 if( sqlite3_step(pSel)==SQLITE_ROW ){
243275 i64 val = sqlite3_column_int64(pSel, 0);
243279 p->rc = sqlite3_reset(pSel);
243280 sqlite3_bind_null(pSel, 2);