Lines Matching defs:pSel
19754 SQLITE_PRIVATE void sqlite3WindowLink(Select *pSel, Window *pWin);
30827 Select *pSel = pItem->pSelect;
30828 assert( pSel!=0 );
30829 if( pSel->selFlags & SF_NestedFrom ){
30830 sqlite3_str_appendf(pAccum, "(join-%u)", pSel->selId);
30832 sqlite3_str_appendf(pAccum, "(subquery-%u)", pSel->selId);
104838 Select *pSel = pNC->pWinSelect;
104841 sqlite3WindowUpdate(pParse, pSel ? pSel->pWinDefn : 0, pWin, pDef);
104847 sqlite3WindowLink(pSel, pWin);
106817 Select *pSel;
106833 pSel = sqlite3SelectNew(pParse, pExpr->x.pList, 0, 0, 0, 0, 0, SF_Values,0);
106835 if( pSel ){
106837 pSel->op = TK_ALL;
106838 pSel->pPrior = pRet;
106840 pRet = pSel;
109067 Select *pSel; /* SELECT statement to encode */
109079 pSel = pExpr->x.pSelect;
109084 ExplainQueryPlan((pParse, 0, "REUSE SUBQUERY %d", pSel->selId));
109124 addrOnce?"":"CORRELATED ", pSel->selId));
109125 nReg = pExpr->op==TK_SELECT ? pSel->pEList->nExpr : 1;
109139 if( pSel->pLimit ){
109147 sqlite3ExprDup(db, pSel->pLimit->pLeft, 0), pLimit);
109149 sqlite3ExprDeferredDelete(pParse, pSel->pLimit->pLeft);
109150 pSel->pLimit->pLeft = pLimit;
109154 pSel->pLimit = sqlite3PExpr(pParse, TK_LIMIT, pLimit, 0);
109156 pSel->iLimit = 0;
109157 if( sqlite3Select(pParse, pSel, &dest) ){
113646 Select *pSel = sqlite3SelectNew(
113649 if( pSel==0 ){
113654 sqlite3SelectPrep(pParse, pSel, 0);
113656 assert( pStep->pExprList==0 || pStep->pExprList==pSel->pEList );
113657 assert( pSrc==pSel->pSrc );
113658 if( pStep->pExprList ) pSel->pEList = 0;
113659 pSel->pSrc = 0;
113660 sqlite3SelectDelete(db, pSel);
120524 Select *pSel; /* Copy of the SELECT that implements the view */
120581 pSel = sqlite3SelectDup(db, pTable->u.view.pSelect, 0);
120582 if( pSel ){
120587 sqlite3SrcListAssignCursors(pParse, pSel->pSrc);
120593 pSelTab = sqlite3ResultSetOfSelect(pParse, pSel, SQLITE_AFF_NONE);
120596 pSelTab = sqlite3ResultSetOfSelect(pParse, pSel, SQLITE_AFF_NONE);
120613 && pTable->nCol==pSel->pEList->nExpr
120616 sqlite3SelectAddColumnTypeAndCollation(pParse, pTable, pSel,
120633 sqlite3SelectDelete(db, pSel);
123844 Select *pSel;
123857 pSel = sqlite3SelectNew(pParse, 0, pFrom, pWhere, 0, 0, pOrderBy,
123860 sqlite3Select(pParse, pSel, &dest);
123861 sqlite3SelectDelete(db, pSel);
142292 ** If pSel is not part of a compound SELECT, return a pointer to its
142296 static ExprList *findLeftmostExprlist(Select *pSel){
142297 while( pSel->pPrior ){
142298 pSel = pSel->pPrior;
142300 return pSel->pEList;
143306 Select *pSel;
143307 for(pSel=pSubq; pSel; pSel=pSel->pPrior){
143308 u8 op = pSel->op;
143312 if( pSel->pWin ) return 0; /* restriction (6b) */
143730 Select *pSel;
143784 pRecTerm = pSel = pFrom->pSelect;
143785 bMayRecursive = ( pSel->op==TK_ALL || pSel->op==TK_UNION );
143786 while( bMayRecursive && pRecTerm->op==pSel->op ){
143817 if( pSel->selFlags & SF_Recursive ){
143824 pRecTerm->pWith = pSel->pWith;
143832 if( sqlite3WalkSelect(pWalker, pSel) ){
143839 for(pLeft=pSel; pLeft->pPrior; pLeft=pLeft->pPrior);
143854 if( pSel->selFlags & SF_Recursive ){
143859 sqlite3WalkSelect(pWalker, pSel);
143898 Select *pSel = pFrom->pSelect;
143901 assert( pSel );
143910 while( pSel->pPrior ){ pSel = pSel->pPrior; }
143911 sqlite3ColumnsFromExprList(pParse, pSel->pEList,&pTab->nCol,&pTab->aCol);
144025 Select *pSel = pFrom->pSelect;
144027 assert( pSel!=0 );
144029 if( sqlite3WalkSelect(pWalker, pSel) ) return WRC_Abort;
144398 Select *pSel = pFrom->pSelect;
144399 if( pSel ){
144400 while( pSel->pPrior ) pSel = pSel->pPrior;
144401 sqlite3SelectAddColumnTypeAndCollation(pParse, pTab, pSel,
164453 ** Possibly link window pWin into the list at pSel->pWin (window functions
164454 ** to be processed as part of SELECT statement pSel). The window is linked
164458 SQLITE_PRIVATE void sqlite3WindowLink(Select *pSel, Window *pWin){
164459 if( pSel ){
164460 if( 0==pSel->pWin || 0==sqlite3WindowCompare(0, pSel->pWin, pWin, 0) ){
164461 pWin->pNextWin = pSel->pWin;
164462 if( pSel->pWin ){
164463 pSel->pWin->ppThis = &pWin->pNextWin;
164465 pSel->pWin = pWin;
164466 pWin->ppThis = &pSel->pWin;
164468 if( sqlite3ExprListCompare(pWin->pPartition, pSel->pWin->pPartition,-1) ){
164469 pSel->selFlags |= SF_MultiPart;
210432 sqlite3_stmt *pSel = 0;
210434 p->rc = prepareFreeAndCollectError(p->dbMain, &pSel, &p->zErrmsg,
210439 if( p->rc==SQLITE_OK && SQLITE_ROW==sqlite3_step(pSel) ){
210442 const char *zQuoted = (const char*)sqlite3_column_text(pSel, iCol);
210457 rbuFinalize(p, pSel);
218093 sqlite3_stmt *pSel = 0; /* SELECT statement to query table pTab */
218109 db, pSession->zDb, zName, nCol, azCol, abPK, &pSel);
218117 rc = sessionSelectBind(pSel, nCol, abPK, p);
218119 if( sqlite3_step(pSel)==SQLITE_ROW ){
218125 sessionAppendCol(&buf, pSel, iCol, &rc);
218129 rc = sessionAppendUpdate(&buf, bPatchset, pSel, p, abPK);
218135 rc = sqlite3_reset(pSel);
218153 sqlite3_finalize(pSel);