Lines Matching refs:pEList
16542 ** a list of named expression (pEList). The named expression list may
16545 ** pEList corresponds to the result set of a SELECT and is NULL for
16563 ExprList *pEList; /* Optional list of result-set columns */
16610 ExprList *pEList; /* The fields of the result */
27135 sqlite3TreeViewExprList(pView, p->pEList, (n--)>0, "result-set");
91079 if( sqlite3WalkExprList(pWalker, p->pEList) ) return WRC_Abort;
91197 ** result set in pEList.
91216 ExprList *pEList, /* A result set */
91217 int iCol, /* A column in the result set. 0..pEList->nExpr-1 */
91226 assert( iCol>=0 && iCol<pEList->nExpr );
91227 pOrig = pEList->a[iCol].pExpr;
91387 ExprList *pEList;
91397 pEList = pItem->pSelect->pEList;
91398 for(j=0; j<pEList->nExpr; j++){
91399 if( sqlite3MatchSpanName(pEList->a[j].zSpan, zCol, zTab, zDb) ){
91539 if( (pEList = pNC->pEList)!=0
91543 for(j=0; j<pEList->nExpr; j++){
91544 char *zAs = pEList->a[j].zName;
91550 pOrig = pEList->a[j].pExpr;
91559 resolveAlias(pParse, pEList, j, pExpr, "", nSubquery);
91980 ** pEList is a list of expressions which are really the result set of the
91985 ** elements in pEList, corresponding to the matching entry. If there is
91989 ** pEList has been resolved. pE has not.
91993 ExprList *pEList, /* List of expressions to scan */
92002 for(i=0; i<pEList->nExpr; i++){
92003 char *zAs = pEList->a[i].zName;
92036 ExprList *pEList; /* The columns of the result set */
92043 pEList = pSelect->pEList;
92050 nc.pEList = pEList;
92064 for(i=0; i<pEList->nExpr; i++){
92065 if( sqlite3ExprCompare(0, pEList->a[i].pExpr, pE, -1)<2 ){
92109 ExprList *pEList;
92131 pEList = pSelect->pEList;
92132 assert( pEList!=0 );
92139 if( iCol<=0 || iCol>pEList->nExpr ){
92140 resolveOutOfRangeError(pParse, "ORDER", i+1, pEList->nExpr);
92144 iCol = resolveAsName(pParse, pEList, pE);
92207 ExprList *pEList;
92215 pEList = pSelect->pEList;
92216 assert( pEList!=0 ); /* sqlite3SelectNew() guarantees this */
92219 if( pItem->u.x.iOrderByCol>pEList->nExpr ){
92220 resolveOutOfRangeError(pParse, zType, i+1, pEList->nExpr);
92223 resolveAlias(pParse, pEList, pItem->u.x.iOrderByCol-1, pItem->pExpr,
92261 nResult = pSelect->pEList->nExpr;
92267 iCol = resolveAsName(pParse, pSelect->pEList, pE2);
92294 for(j=0; j<pSelect->pEList->nExpr; j++){
92295 if( sqlite3ExprCompare(0, pE, pSelect->pEList->a[j].pExpr, -1)==0 ){
92405 if( sqlite3ResolveExprListNames(&sNC, p->pEList) ) return WRC_Abort;
92434 sNC.pEList = p->pEList;
92504 if( p->pNext && p->pEList->nExpr!=p->pNext->pEList->nExpr ){
92739 return sqlite3ExprAffinity(pExpr->x.pSelect->pEList->a[0].pExpr);
92754 pExpr->pLeft->x.pSelect->pEList->a[pExpr->iColumn].pExpr
92951 aff = sqlite3CompareAffinity(pExpr->x.pSelect->pEList->a[0].pExpr, aff);
93067 return pExpr->x.pSelect->pEList->nExpr;
93093 return pVector->x.pSelect->pEList->a[i].pExpr;
93210 *ppExpr = pVector->x.pSelect->pEList->a[iField].pExpr;
93354 heightOfExprList(p->pEList, pnHeight);
94141 pNew->pEList = sqlite3ExprListDup(db, p->pEList, flags);
94358 ** If the expression list pEList contains more than iLimit elements,
94363 ExprList *pEList,
94367 testcase( pEList && pEList->nExpr==mx );
94368 testcase( pEList && pEList->nExpr==mx+1 );
94369 if( pEList && pEList->nExpr>mx ){
94772 ExprList *pEList;
94795 pEList = p->pEList;
94796 assert( pEList!=0 );
94798 for(i=0; i<pEList->nExpr; i++){
94799 Expr *pRes = pEList->a[i].pExpr;
94947 ExprList *pEList = pX->x.pSelect->pEList;
94948 for(i=0; i<pEList->nExpr; i++){
94949 if( sqlite3ExprCanBeNull(pEList->a[i].pExpr) ) break;
94951 if( i==pEList->nExpr ){
94963 ExprList *pEList = p->pEList;
94964 int nExpr = pEList->nExpr;
94966 assert( p->pEList!=0 ); /* Because of isCandidateForInOpt(p) */
94967 assert( p->pEList->a[0].pExpr!=0 ); /* Because of isCandidateForInOpt(p) */
94977 if( nExpr==1 && pEList->a[0].pExpr->iColumn<0 ){
94997 int iCol = pEList->a[i].pExpr->iColumn;
95039 Expr *pRhs = pEList->a[i].pExpr;
95160 zRet[i] = sqlite3CompareAffinity(pSelect->pEList->a[i].pExpr, a);
95198 sqlite3SubselectError(pParse, pExpr->x.pSelect->pEList->nExpr, 1);
95308 ExprList *pEList = pSelect->pEList;
95313 if( ALWAYS(pEList->nExpr==nVal) ){
95328 assert( pEList!=0 );
95329 assert( pEList->nExpr>0 );
95334 pParse, p, pEList->a[i].pExpr
95432 nReg = pExpr->op==TK_SELECT ? pSel->pEList->nExpr : 1;
95486 if( nVector!=pIn->x.pSelect->pEList->nExpr ){
95487 sqlite3SubselectError(pParse, pIn->x.pSelect->pEList->nExpr, nVector);
96585 if( op==TK_SELECT && (nCol = pExpr->x.pSelect->pEList->nExpr)!=1 ){
96739 ExprList *pEList; /* List of WHEN terms */
96748 pEList = pExpr->x.pList;
96749 aListelem = pEList->a;
96750 nExpr = pEList->nExpr;
96786 sqlite3ExprCode(pParse, pEList->a[nExpr-1].pExpr, target);
101255 if( sqlite3FixExprList(pFix, pSelect->pEList) ){
103859 && pTable->nCol==pSel->pEList->nExpr
106706 ExprList *pEList = NULL; /* Expression list contaning only pSelectRowid */
106739 pEList = sqlite3ExprListAppend(
106747 pEList = sqlite3ExprListAppend(pParse, 0, sqlite3Expr(db, TK_ID, zName));
106752 pEList = sqlite3ExprListAppend(pParse, pEList, p);
106756 pLhs->x.pList = sqlite3ExprListDup(db, pEList, 0);
106769 pSelect = sqlite3SelectNew(pParse, pEList, pSelectSrc, pWhere, 0 ,0,
111370 pList = pSelect->pEList;
111371 pSelect->pEList = 0;
111525 assert( pSelect->pEList );
111526 nColumn = pSelect->pEList->nExpr;
112792 ExprList *pEList; /* The result set of the SELECT */
112855 pEList = pSelect->pEList;
112856 assert( pEList!=0 );
112857 if( pEList->nExpr!=1 ){
112860 assert( pEList->a[0].pExpr );
112861 if( pEList->a[0].pExpr->op!=TK_ASTERISK ){
118756 sqlite3ExprListDelete(db, p->pEList);
118788 ExprList *pEList, /* which columns to include in the result */
118804 if( pEList==0 ){
118805 pEList = sqlite3ExprListAppend(pParse, 0,
118808 pNew->pEList = pEList;
119349 ** If srcTab is negative, then the p->pEList expressions
119351 ** zero or more, then data is pulled from srcTab and p->pEList is used only
119381 assert( p->pEList!=0 );
119391 nResultCol = p->pEList->nExpr;
119414 VdbeComment((v, "%s", p->pEList->a[i].zName));
119427 /* For each expression in p->pEList that is a copy of an expression in
119431 ** This allows the p->pEList field to be omitted from the sorted record,
119437 p->pEList->a[j-1].u.x.iOrderByCol = i+1-pSort->nOBSat;
119444 nResultCol = sqlite3ExprCodeExprList(pParse,p->pEList,regResult,
119477 CollSeq *pColl = sqlite3ExprCollSeq(pParse, p->pEList->a[i].pExpr);
119917 struct ExprList_item *aOutEx = p->pEList->a;
120119 if( iCol>=0 && iCol<pS->pEList->nExpr ){
120125 Expr *p = pS->pEList->a[iCol].pExpr;
120168 Expr *p = pS->pEList->a[0].pExpr;
120197 ExprList *pEList /* Expressions defining the result set */
120206 for(i=0; i<pEList->nExpr; i++){
120207 Expr *p = pEList->a[i].pExpr;
120269 ExprList *pEList;
120286 pEList = pSelect->pEList;
120292 sqlite3VdbeSetNumCols(v, pEList->nExpr);
120293 for(i=0; i<pEList->nExpr; i++){
120294 Expr *p = pEList->a[i].pExpr;
120299 if( pEList->a[i].zName ){
120301 char *zName = pEList->a[i].zName;
120323 const char *z = pEList->a[i].zSpan;
120328 generateColumnTypes(pParse, pTabList, pEList);
120355 ExprList *pEList, /* Expr list from which to derive column names */
120369 if( pEList ){
120370 nCol = pEList->nExpr;
120385 if( (zName = pEList->a[i].zName)!=0 ){
120388 Expr *pColExpr = sqlite3ExprSkipCollate(pEList->a[i].pExpr);
120406 zName = pEList->a[i].zSpan;
120473 assert( pTab->nCol==pSelect->pEList->nExpr || db->mallocFailed );
120477 a = pSelect->pEList->a;
120529 sqlite3ColumnsFromExprList(pParse, pSelect->pEList, &pTab->nCol, &pTab->aCol);
120645 /* iCol must be less than p->pEList->nExpr. Otherwise an error would
120648 if( pRet==0 && ALWAYS(iCol<p->pEList->nExpr) ){
120649 pRet = sqlite3ExprCollSeq(pParse, p->pEList->a[iCol].pExpr);
120735 int nCol = p->pEList->nExpr; /* Number of columns in the recursive table */
120895 assert( p->pNext==0 || p->pEList->nExpr==p->pNext->pEList->nExpr );
120981 assert( p->pEList );
120982 sqlite3VdbeAddOp2(v, OP_OpenEphemeral, dest.iSDParm, p->pEList->nExpr);
120996 assert( p->pEList && pPrior->pEList );
120997 assert( p->pEList->nExpr==pPrior->pEList->nExpr );
121083 assert( p->pEList );
121131 assert( p->pEList );
121166 assert( p->pEList );
121198 assert( p->pEList );
121237 nCol = p->pEList->nExpr;
121585 for(i=1; db->mallocFailed==0 && i<=p->pEList->nExpr; i++){
121615 assert( pItem->u.x.iOrderByCol<=p->pEList->nExpr );
121635 int nExpr = p->pEList->nExpr;
121825 ** expressions in pEList.
121832 ExprList *pEList; /* Replacement expressions */
121842 ** entry in pEList. (But leave references to the ROWID column
121846 ** whose result set is defined by pEList appears as entry in the
121867 Expr *pCopy = pSubst->pEList->a[pExpr->iColumn].pExpr;
121869 assert( pSubst->pEList!=0 && pExpr->iColumn<pSubst->pEList->nExpr );
121928 substExprList(pSubst, p->pEList);
122209 assert( pSub->pEList->nExpr==pSub1->pEList->nExpr );
122452 x.pEList = pSub->pEList;
122572 x.pEList = pSubq->pEList;
122604 ExprList *pEList = pFunc->x.pList; /* Arguments to agg function */
122611 if( pEList==0 || pEList->nExpr!=1 ) return eRet;
122622 *ppMinMax = pOrderBy = sqlite3ExprListDup(db, pEList, 0);
122645 if( p->pWhere || p->pEList->nExpr!=1
122651 pExpr = p->pEList->a[0].pExpr;
122740 p->pEList = sqlite3ExprListAppend(pParse, 0, sqlite3Expr(db, TK_ASTERISK, 0));
122852 ExprList *pEList;
122925 pEList = pLeft->pEList;
122927 if( pEList && pEList->nExpr!=pCte->pCols->nExpr ){
122929 pCte->zName, pEList->nExpr, pCte->pCols->nExpr
122934 pEList = pCte->pCols;
122937 sqlite3ColumnsFromExprList(pParse, pEList, &pTab->nCol, &pTab->aCol);
122995 ** (4) Scan the list of columns in the result set (pEList) looking
123005 ExprList *pEList;
123021 pEList = p->pEList;
123060 sqlite3ColumnsFromExprList(pParse, pSel->pEList,&pTab->nCol,&pTab->aCol);
123118 for(k=0; k<pEList->nExpr; k++){
123119 pE = pEList->a[k].pExpr;
123126 if( k<pEList->nExpr ){
123132 struct ExprList_item *a = pEList->a;
123138 for(k=0; k<pEList->nExpr; k++){
123192 && sqlite3MatchSpanName(pSub->pEList->a[j].zSpan, 0, zTName, 0)==0
123246 pX->zSpan = sqlite3DbStrDup(db, pSub->pEList->a[j].zSpan);
123267 sqlite3ExprListDelete(db, pEList);
123268 p->pEList = pNew;
123270 if( p->pEList ){
123271 if( p->pEList->nExpr>db->aLimit[SQLITE_LIMIT_COLUMN] ){
123722 if( p->pEList->nExpr!=1 ) return 0; /* Single result column */
123723 pExpr = p->pEList->a[0].pExpr;
123755 sqlite3ExprListDelete(db, pSub->pEList);
123757 pSub->pEList = sqlite3ExprListAppend(pParse, 0, pTerm);
123767 p->pEList->a[0].pExpr = pExpr;
123802 ExprList *pEList = 0; /* List of columns to extract. */
123857 assert( p->pEList!=0 );
123885 if( pTab->nCol!=pSub->pEList->nExpr ){
123887 pTab->nCol, pTab->zName, pSub->pEList->nExpr);
124117 pEList = p->pEList;
124135 pEList = p->pEList;
124156 && sqlite3ExprListCompare(sSort.pOrderBy, pEList, -1)==0
124159 pGroupBy = p->pGroupBy = sqlite3ExprListDup(db, pEList, 0);
124183 pKeyInfo = keyInfoFromExprList(pParse, sSort.pOrderBy, 0, pEList->nExpr);
124187 sSort.iECursor, sSort.pOrderBy->nExpr+1+pEList->nExpr, 0,
124197 sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pDest->iSDParm, pEList->nExpr);
124218 (char*)keyInfoFromExprList(pParse, p->pEList,0,0),
124234 p->pEList, wctrlFlags, p->nSelectRow);
124259 assert( p->pEList==pEList );
124290 for(k=p->pEList->nExpr, pItem=p->pEList->a; k>0; k--, pItem++){
124329 sqlite3ExprAnalyzeAggList(&sNC, pEList);
124710 generateSortTail(pParse, p, &sSort, pEList->nExpr, pDest);
125385 ExprList *pEList, /* The SET clause: list of column and new values */
125395 pTriggerStep->pExprList = sqlite3ExprListDup(db, pEList, EXPRDUP_REDUCE);
125399 sqlite3ExprListDelete(db, pEList);
125558 ** pEList is the SET clause of an UPDATE statement. Each entry
125559 ** in pEList is of the format <id>=<expr>. If any of the entries
125560 ** in pEList have an <id> which matches an identifier in pIdList,
125562 ** wildcard that matches anything. Likewise if pEList==NULL then
125566 static int checkColumnOverlap(IdList *pIdList, ExprList *pEList){
125568 if( pIdList==0 || NEVER(pEList==0) ) return 1;
125569 for(e=0; e<pEList->nExpr; e++){
125570 if( sqlite3IdListIndex(pIdList, pEList->a[e].zName)>=0 ) return 1;
129587 ExprList *pOrigRhs = pNew->x.pSelect->pEList; /* Original unmodified RHS */
129608 pNew->x.pSelect->pEList = pRhs;
129710 if( (pX->flags & EP_xIsSelect)==0 || pX->x.pSelect->pEList->nExpr==1 ){
132245 mask |= sqlite3WhereExprListUsage(pMaskSet, pS->pEList);
135205 pRhs = pRhs->x.pSelect->pEList->a[i].pExpr;
