Lines Matching refs:pEList
12235 ExprList *pEList; /* Optional list of result-set columns */ member
12278 ExprList *pEList; /* The fields of the result */ member
81220 if( sqlite3WalkExprList(pWalker, p->pEList) ) return WRC_Abort;
81385 ExprList *pEList, /* A result set */
81395 assert( iCol>=0 && iCol<pEList->nExpr );
81396 pOrig = pEList->a[iCol].pExpr;
81406 if( pEList->a[iCol].u.x.iAlias==0 ){
81407 pEList->a[iCol].u.x.iAlias = (u16)(++pParse->nAlias);
81409 pDup->iTable = pEList->a[iCol].u.x.iAlias;
81563 ExprList *pEList;
81573 pEList = pItem->pSelect->pEList;
81574 for(j=0; j<pEList->nExpr; j++){
81575 if( sqlite3MatchSpanName(pEList->a[j].zSpan, zCol, zTab, zDb) ){
81711 if( (pEList = pNC->pEList)!=0
81715 for(j=0; j<pEList->nExpr; j++){
81716 char *zAs = pEList->a[j].zName;
81722 pOrig = pEList->a[j].pExpr;
81727 resolveAlias(pParse, pEList, j, pExpr, "", nSubquery);
82118 ExprList *pEList, /* List of expressions to scan */
82127 for(i=0; i<pEList->nExpr; i++){
82128 char *zAs = pEList->a[i].zName;
82161 ExprList *pEList; /* The columns of the result set */
82168 pEList = pSelect->pEList;
82175 nc.pEList = pEList;
82189 for(i=0; i<pEList->nExpr; i++){
82190 if( sqlite3ExprCompare(pEList->a[i].pExpr, pE, -1)<2 ){
82234 ExprList *pEList;
82258 pEList = pSelect->pEList;
82259 assert( pEList!=0 );
82266 if( iCol<=0 || iCol>pEList->nExpr ){
82267 resolveOutOfRangeError(pParse, "ORDER", i+1, pEList->nExpr);
82271 iCol = resolveAsName(pParse, pEList, pE);
82334 ExprList *pEList;
82344 pEList = pSelect->pEList;
82345 assert( pEList!=0 ); /* sqlite3SelectNew() guarantees this */
82348 if( pItem->u.x.iOrderByCol>pEList->nExpr ){
82349 resolveOutOfRangeError(pParse, zType, i+1, pEList->nExpr);
82352 resolveAlias(pParse, pEList, pItem->u.x.iOrderByCol-1, pItem->pExpr,
82390 nResult = pSelect->pEList->nExpr;
82396 iCol = resolveAsName(pParse, pSelect->pEList, pE2);
82423 for(j=0; j<pSelect->pEList->nExpr; j++){
82424 if( sqlite3ExprCompare(pE, pSelect->pEList->a[j].pExpr, -1)==0 ){
82441 ExprList *pEList; /* Result set expression list */
82536 pEList = p->pEList;
82537 assert( pEList!=0 );
82538 for(i=0; i<pEList->nExpr; i++){
82539 Expr *pX = pEList->a[i].pExpr;
82572 sNC.pEList = p->pEList;
82843 return sqlite3ExprAffinity(pExpr->x.pSelect->pEList->a[0].pExpr);
83025 aff = sqlite3CompareAffinity(pExpr->x.pSelect->pEList->a[0].pExpr, aff);
83164 heightOfExprList(p->pEList, pnHeight);
83889 pNew->pEList = sqlite3ExprListDup(db, p->pEList, flags);
84020 ExprList *pEList,
84024 testcase( pEList && pEList->nExpr==mx );
84025 testcase( pEList && pEList->nExpr==mx+1 );
84026 if( pEList && pEList->nExpr>mx ){
84341 ExprList *pEList;
84362 pEList = p->pEList;
84363 if( pEList->nExpr!=1 ) return 0; /* One column in the result set */
84364 if( pEList->a[0].pExpr->op!=TK_COLUMN ) return 0; /* Result is a column */
84506 assert( p->pEList!=0 ); /* Because of isCandidateForInOpt(p) */
84507 assert( p->pEList->a[0].pExpr!=0 ); /* Because of isCandidateForInOpt(p) */
84510 pExpr = p->pEList->a[0].pExpr;
84705 ExprList *pEList;
84718 pEList = pSelect->pEList;
84720 assert( pEList!=0 );
84721 assert( pEList->nExpr>0 );
84724 pEList->a[0].pExpr);
85901 ExprList *pEList; /* List of WHEN terms */
85910 pEList = pExpr->x.pList;
85911 aListelem = pEList->a;
85912 nExpr = pEList->nExpr;
85947 sqlite3ExprCode(pParse, pEList->a[nExpr-1].pExpr, target);
90450 if( sqlite3FixExprList(pFix, pSelect->pEList) ){
95721 ExprList *pEList = NULL; /* Expression list contaning only pSelectRowid */
95752 pEList = sqlite3ExprListAppend(pParse, 0, pSelectRowid);
95753 if( pEList == 0 ) goto limit_where_cleanup_2;
95759 sqlite3ExprListDelete(pParse->db, pEList);
95764 pSelect = sqlite3SelectNew(pParse,pEList,pSelectSrc,pWhere,0,0,
100127 pList = pSelect->pEList;
100128 pSelect->pEList = 0;
100285 assert( pSelect->pEList );
100286 nColumn = pSelect->pEList->nExpr;
101403 ExprList *pEList; /* The result set of the SELECT */
101467 pEList = pSelect->pEList;
101468 assert( pEList!=0 );
101469 if( pEList->nExpr!=1 ){
101472 assert( pEList->a[0].pExpr );
101473 if( pEList->a[0].pExpr->op!=TK_ALL ){
106534 sqlite3ExprListDelete(db, p->pEList);
106567 ExprList *pEList, /* which columns to include in the result */
106586 if( pEList==0 ){
106587 pEList = sqlite3ExprListAppend(pParse, 0, sqlite3Expr(db,TK_ALL,0));
106589 pNew->pEList = pEList;
107126 ExprList *pEList, /* List of values being extracted */
107144 assert( pEList!=0 );
107154 nResultCol = pEList->nExpr;
107177 VdbeComment((v, "%s", pEList->a[i].zName));
107183 sqlite3ExprCodeExprList(pParse, pEList, regResult,
107216 CollSeq *pColl = sqlite3ExprCollSeq(pParse, pEList->a[i].pExpr);
107316 sqlite3CompareAffinity(pEList->a[0].pExpr, pDest->affSdst);
107653 struct ExprList_item *aOutEx = p->pEList->a;
107850 if( iCol>=0 && iCol<pS->pEList->nExpr ){
107856 Expr *p = pS->pEList->a[iCol].pExpr;
107900 Expr *p = pS->pEList->a[0].pExpr;
107930 ExprList *pEList /* Expressions defining the result set */
107938 for(i=0; i<pEList->nExpr; i++){
107939 Expr *p = pEList->a[i].pExpr;
107970 ExprList *pEList /* Expressions defining the result set */
107988 sqlite3VdbeSetNumCols(v, pEList->nExpr);
107989 for(i=0; i<pEList->nExpr; i++){
107991 p = pEList->a[i].pExpr;
107993 if( pEList->a[i].zName ){
107994 char *zName = pEList->a[i].zName;
108014 sqlite3DbStrDup(db, pEList->a[i].zSpan), SQLITE_DYNAMIC);
108023 const char *z = pEList->a[i].zSpan;
108028 generateColumnTypes(pParse, pTabList, pEList);
108046 ExprList *pEList, /* Expr list from which to derive column names */
108059 if( pEList ){
108060 nCol = pEList->nExpr;
108073 p = sqlite3ExprSkipCollate(pEList->a[i].pExpr);
108074 if( (zName = pEList->a[i].zName)!=0 ){
108096 zName = sqlite3MPrintf(db, "%s", pEList->a[i].zSpan);
108163 assert( pTab->nCol==pSelect->pEList->nExpr || db->mallocFailed );
108167 a = pSelect->pEList->a;
108210 selectColumnsFromExprList(pParse, pSelect->pEList, &pTab->nCol, &pTab->aCol);
108331 if( pRet==0 && iCol<p->pEList->nExpr ){
108332 pRet = sqlite3ExprCollSeq(pParse, p->pEList->a[iCol].pExpr);
108418 int nCol = p->pEList->nExpr; /* Number of columns in the recursive table */
108510 selectInnerLoop(pParse, p, p->pEList, iCurrent,
108576 int nExpr = p->pEList->nExpr;
108585 if( p->pEList->nExpr!=nExpr ){
108680 assert( p->pEList );
108681 sqlite3VdbeAddOp2(v, OP_OpenEphemeral, dest.iSDParm, p->pEList->nExpr);
108696 assert( p->pEList && pPrior->pEList );
108697 if( p->pEList->nExpr!=pPrior->pEList->nExpr ){
108786 assert( p->pEList );
108835 assert( p->pEList );
108839 generateColumnNames(pParse, 0, pFirst->pEList);
108846 selectInnerLoop(pParse, p, p->pEList, unionTab,
108875 assert( p->pEList );
108910 assert( p->pEList );
108914 generateColumnNames(pParse, 0, pFirst->pEList);
108924 selectInnerLoop(pParse, p, p->pEList, tab1,
108954 nCol = p->pEList->nExpr;
109075 sqlite3CompareAffinity(p->pEList->a[0].pExpr, pDest->affSdst);
109302 for(i=1; db->mallocFailed==0 && i<=p->pEList->nExpr; i++){
109333 testcase( pItem->u.x.iOrderByCol > p->pEList->nExpr );
109353 int nExpr = p->pEList->nExpr;
109529 generateColumnNames(pParse, 0, pFirst->pEList);
109569 ExprList *pEList /* Substitute expressions */
109577 assert( pEList!=0 && pExpr->iColumn<pEList->nExpr );
109579 pNew = sqlite3ExprDup(db, pEList->a[pExpr->iColumn].pExpr, 0);
109584 pExpr->pLeft = substExpr(db, pExpr->pLeft, iTable, pEList);
109585 pExpr->pRight = substExpr(db, pExpr->pRight, iTable, pEList);
109587 substSelect(db, pExpr->x.pSelect, iTable, pEList);
109589 substExprList(db, pExpr->x.pList, iTable, pEList);
109598 ExprList *pEList /* Substitute values */
109603 pList->a[i].pExpr = substExpr(db, pList->a[i].pExpr, iTable, pEList);
109610 ExprList *pEList /* Substitute values */
109616 substExprList(db, p->pEList, iTable, pEList);
109617 substExprList(db, p->pGroupBy, iTable, pEList);
109618 substExprList(db, p->pOrderBy, iTable, pEList);
109619 p->pHaving = substExpr(db, p->pHaving, iTable, pEList);
109620 p->pWhere = substExpr(db, p->pWhere, iTable, pEList);
109621 substSelect(db, p->pPrior, iTable, pEList);
109626 substSelect(db, pItem->pSelect, iTable, pEList);
109807 || (sqlite3ExprListFlags(p->pEList) & EP_Subquery)!=0
109906 || pSub->pEList->nExpr!=pSub1->pEList->nExpr
110108 pList = pParent->pEList;
110116 substExprList(db, pParent->pEList, iParent, pSub->pEList);
110118 substExprList(db, pParent->pGroupBy, iParent, pSub->pEList);
110119 pParent->pHaving = substExpr(db, pParent->pHaving, iParent, pSub->pEList);
110141 substExprList(db, pParent->pOrderBy, iParent, pSub->pEList);
110152 pParent->pHaving = substExpr(db, pParent->pHaving, iParent, pSub->pEList);
110158 pParent->pWhere = substExpr(db, pParent->pWhere, iParent, pSub->pEList);
110216 ExprList *pEList = pExpr->x.pList; /* Arguments to agg function */
110219 if( pEList && pEList->nExpr==1 && pEList->a[0].pExpr->op==TK_AGG_COLUMN ){
110223 *ppMinMax = pEList;
110226 *ppMinMax = pEList;
110252 if( p->pWhere || p->pEList->nExpr!=1
110258 pExpr = p->pEList->a[0].pExpr;
110347 p->pEList = sqlite3ExprListAppend(pParse, 0, sqlite3Expr(db, TK_ALL, 0));
110446 ExprList *pEList;
110508 pEList = pLeft->pEList;
110510 if( pEList && pEList->nExpr!=pCte->pCols->nExpr ){
110512 pCte->zName, pEList->nExpr, pCte->pCols->nExpr
110517 pEList = pCte->pCols;
110520 selectColumnsFromExprList(pParse, pEList, &pTab->nCol, &pTab->aCol);
110586 ExprList *pEList;
110600 pEList = p->pEList;
110643 selectColumnsFromExprList(pParse, pSel->pEList, &pTab->nCol, &pTab->aCol);
110694 for(k=0; k<pEList->nExpr; k++){
110695 pE = pEList->a[k].pExpr;
110701 if( k<pEList->nExpr ){
110707 struct ExprList_item *a = pEList->a;
110720 for(k=0; k<pEList->nExpr; k++){
110771 && sqlite3MatchSpanName(pSub->pEList->a[j].zSpan, 0, zTName, 0)==0
110825 pX->zSpan = sqlite3DbStrDup(db, pSub->pEList->a[j].zSpan);
110846 sqlite3ExprListDelete(db, pEList);
110847 p->pEList = pNew;
110850 if( p->pEList && p->pEList->nExpr>db->aLimit[SQLITE_LIMIT_COLUMN] ){
111181 ExprList *pEList; /* List of columns to extract. */
111231 pEList = p->pEList;
111236 assert( pEList!=0 );
111254 if( checkForMultiColumnSelectError(pParse, pDest, pEList->nExpr) ){
111361 pEList = p->pEList;
111398 && sqlite3ExprListCompare(sSort.pOrderBy, p->pEList, -1)==0
111401 p->pGroupBy = sqlite3ExprListDup(db, p->pEList, 0);
111418 pKeyInfo = keyInfoFromExprList(pParse, sSort.pOrderBy, 0, pEList->nExpr);
111422 sSort.iECursor, sSort.pOrderBy->nExpr+1+pEList->nExpr, 0,
111432 sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pDest->iSDParm, pEList->nExpr);
111451 (char*)keyInfoFromExprList(pParse, p->pEList,0,0),
111465 p->pEList, wctrlFlags, 0);
111489 selectInnerLoop(pParse, p, pEList, -1, &sSort, &sDistinct, pDest,
111519 for(k=p->pEList->nExpr, pItem=p->pEList->a; k>0; k--, pItem++){
111557 sqlite3ExprAnalyzeAggList(&sNC, pEList);
111789 selectInnerLoop(pParse, p, p->pEList, -1, &sSort,
111932 selectInnerLoop(pParse, p, p->pEList, -1, 0, 0,
111949 generateSortTail(pParse, p, &sSort, pEList->nExpr, pDest);
111969 generateColumnNames(pParse, pTabList, pEList);
112000 sqlite3TreeViewExprList(pView, p->pEList, (n--)>0, "result-set");
112702 ExprList *pEList, /* The SET clause: list of column and new values */
112710 pTriggerStep->pExprList = sqlite3ExprListDup(db, pEList, EXPRDUP_REDUCE);
112714 sqlite3ExprListDelete(db, pEList);
112898 static int checkColumnOverlap(IdList *pIdList, ExprList *pEList){
112900 if( pIdList==0 || NEVER(pEList==0) ) return 1;
112901 for(e=0; e<pEList->nExpr; e++){
112902 if( sqlite3IdListIndex(pIdList, pEList->a[e].zName)>=0 ) return 1;
114109 ExprList *pEList = 0; /* The result set of the SELECT statement */
114123 pEList = sqlite3ExprListAppend(pParse, 0, sqlite3Expr(db, TK_ID, "_rowid_"));
114125 pEList = sqlite3ExprListAppend(pParse, pEList,
114135 pEList = sqlite3ExprListAppend(pParse, pEList, pExpr);
114137 pSelect = sqlite3SelectNew(pParse, pEList, pSrc, pWhere, 0, 0, 0, 0, 0, 0);
116513 mask |= exprListTableUsage(pMaskSet, pS->pEList);
