Lines Matching refs:pEList
10612 ExprList *pEList; /* Optional list of named expressions */ member
10644 ExprList *pEList; /* The fields of the result */ member
69960 if( sqlite3WalkExprList(pWalker, p->pEList) ) return WRC_Abort;
70066 ExprList *pEList, /* A result set */
70075 assert( iCol>=0 && iCol<pEList->nExpr );
70076 pOrig = pEList->a[iCol].pExpr;
70084 if( pEList->a[iCol].iAlias==0 ){
70085 pEList->a[iCol].iAlias = (u16)(++pParse->nAlias);
70087 pDup->iTable = pEList->a[iCol].iAlias;
70173 ExprList *pEList;
70316 if( cnt==0 && (pEList = pNC->pEList)!=0 && zTab==0 ){
70317 for(j=0; j<pEList->nExpr; j++){
70318 char *zAs = pEList->a[j].zName;
70324 pOrig = pEList->a[j].pExpr;
70329 resolveAlias(pParse, pEList, j, pExpr, "");
70641 ExprList *pEList, /* List of expressions to scan */
70650 for(i=0; i<pEList->nExpr; i++){
70651 char *zAs = pEList->a[i].zName;
70684 ExprList *pEList; /* The columns of the result set */
70691 pEList = pSelect->pEList;
70698 nc.pEList = pEList;
70712 for(i=0; i<pEList->nExpr; i++){
70713 if( sqlite3ExprCompare(pEList->a[i].pExpr, pE)<2 ){
70757 ExprList *pEList;
70781 pEList = pSelect->pEList;
70782 assert( pEList!=0 );
70789 if( iCol<=0 || iCol>pEList->nExpr ){
70790 resolveOutOfRangeError(pParse, "ORDER", i+1, pEList->nExpr);
70794 iCol = resolveAsName(pParse, pEList, pE);
70849 ExprList *pEList;
70859 pEList = pSelect->pEList;
70860 assert( pEList!=0 ); /* sqlite3SelectNew() guarantees this */
70863 if( pItem->iCol>pEList->nExpr ){
70864 resolveOutOfRangeError(pParse, zType, i+1, pEList->nExpr);
70867 resolveAlias(pParse, pEList, pItem->iCol-1, pItem->pExpr, zType);
70904 nResult = pSelect->pEList->nExpr;
70908 iCol = resolveAsName(pParse, pSelect->pEList, pE);
70947 ExprList *pEList; /* Result set expression list */
71001 pEList = p->pEList;
71002 assert( pEList!=0 );
71003 for(i=0; i<pEList->nExpr; i++){
71004 Expr *pX = pEList->a[i].pExpr;
71049 sNC.pEList = p->pEList;
71259 return sqlite3ExprAffinity(pExpr->x.pSelect->pEList->a[0].pExpr);
71390 aff = sqlite3CompareAffinity(pExpr->x.pSelect->pEList->a[0].pExpr, aff);
71531 heightOfExprList(p->pEList, pnHeight);
72166 pNew->pEList = sqlite3ExprListDup(db, p->pEList, flags);
72295 ExprList *pEList,
72299 testcase( pEList && pEList->nExpr==mx );
72300 testcase( pEList && pEList->nExpr==mx+1 );
72301 if( pEList && pEList->nExpr>mx ){
72567 ExprList *pEList;
72588 pEList = p->pEList;
72589 if( pEList->nExpr!=1 ) return 0; /* One column in the result set */
72590 if( pEList->a[0].pExpr->op!=TK_COLUMN ) return 0; /* Result is a column */
72665 Expr *pExpr = p->pEList->a[0].pExpr; /* Expression <column> */
72871 ExprList *pEList;
72881 pEList = pExpr->x.pSelect->pEList;
72882 if( ALWAYS(pEList!=0 && pEList->nExpr>0) ){
72884 pEList->a[0].pExpr);
73988 ExprList *pEList; /* List of WHEN terms */
73999 pEList = pExpr->x.pList;
74000 aListelem = pEList->a;
74001 nExpr = pEList->nExpr;
77018 if( sqlite3FixExprList(pFix, pSelect->pEList) ){
81698 ExprList *pEList = NULL; /* Expression list contaning only pSelectRowid */
81730 pEList = sqlite3ExprListAppend(pParse, 0, pSelectRowid);
81731 if( pEList == 0 ) goto limit_where_cleanup_2;
81737 sqlite3ExprListDelete(pParse->db, pEList);
81742 pSelect = sqlite3SelectNew(pParse,pEList,pSelectSrc,pWhere,0,0,
85632 assert( pSelect->pEList );
85633 nColumn = pSelect->pEList->nExpr;
86630 ExprList *pEList; /* The result set of the SELECT */
86691 pEList = pSelect->pEList;
86692 assert( pEList!=0 );
86693 if( pEList->nExpr!=1 ){
86696 assert( pEList->a[0].pExpr );
86697 if( pEList->a[0].pExpr->op!=TK_ALL ){
90493 sqlite3ExprListDelete(db, p->pEList);
90522 ExprList *pEList, /* which columns to include in the result */
90541 if( pEList==0 ){
90542 pEList = sqlite3ExprListAppend(pParse, 0, sqlite3Expr(db,TK_ALL,0));
90544 pNew->pEList = pEList;
90999 ExprList *pEList, /* List of values being extracted */
91018 assert( pEList!=0 );
91029 nResultCol = pEList->nExpr;
91048 sqlite3ExprCodeExprList(pParse, pEList, regResult, eDest==SRT_Output);
91057 assert( pEList!=0 );
91058 assert( pEList->nExpr==nColumn );
91117 p->affinity = sqlite3CompareAffinity(pEList->a[0].pExpr, pDest->affinity);
91510 if( iCol>=0 && ALWAYS(iCol<pS->pEList->nExpr) ){
91516 Expr *p = pS->pEList->a[iCol].pExpr;
91550 Expr *p = pS->pEList->a[0].pExpr;
91577 ExprList *pEList /* Expressions defining the result set */
91585 for(i=0; i<pEList->nExpr; i++){
91586 Expr *p = pEList->a[i].pExpr;
91617 ExprList *pEList /* Expressions defining the result set */
91635 sqlite3VdbeSetNumCols(v, pEList->nExpr);
91636 for(i=0; i<pEList->nExpr; i++){
91638 p = pEList->a[i].pExpr;
91640 if( pEList->a[i].zName ){
91641 char *zName = pEList->a[i].zName;
91661 sqlite3DbStrDup(db, pEList->a[i].zSpan), SQLITE_DYNAMIC);
91671 sqlite3DbStrDup(db, pEList->a[i].zSpan), SQLITE_DYNAMIC);
91674 generateColumnTypes(pParse, pTabList, pEList);
91692 ExprList *pEList, /* Expr list from which to derive column names */
91705 *pnCol = nCol = pEList->nExpr;
91711 p = pEList->a[i].pExpr;
91714 if( (zName = pEList->a[i].zName)!=0 ){
91733 zName = sqlite3MPrintf(db, "%s", pEList->a[i].zSpan);
91797 assert( nCol==pSelect->pEList->nExpr || db->mallocFailed );
91801 a = pSelect->pEList->a;
91840 selectColumnsFromExprList(pParse, pSelect->pEList, &pTab->nCol, &pTab->aCol);
91954 if( pRet==0 && iCol<p->pEList->nExpr ){
91955 pRet = sqlite3ExprCollSeq(pParse, p->pEList->a[iCol].pExpr);
92045 assert( p->pEList );
92046 sqlite3VdbeAddOp2(v, OP_OpenEphemeral, dest.iParm, p->pEList->nExpr);
92054 assert( p->pEList && pPrior->pEList );
92055 if( p->pEList->nExpr!=pPrior->pEList->nExpr ){
92139 assert( p->pEList );
92188 assert( p->pEList );
92192 generateColumnNames(pParse, 0, pFirst->pEList);
92199 selectInnerLoop(pParse, p, p->pEList, unionTab, p->pEList->nExpr,
92228 assert( p->pEList );
92263 assert( p->pEList );
92267 generateColumnNames(pParse, 0, pFirst->pEList);
92277 selectInnerLoop(pParse, p, p->pEList, tab1, p->pEList->nExpr,
92307 nCol = p->pEList->nExpr;
92433 sqlite3CompareAffinity(p->pEList->a[0].pExpr, pDest->affinity);
92661 for(i=1; db->mallocFailed==0 && i<=p->pEList->nExpr; i++){
92689 assert( pItem->iCol>0 && pItem->iCol<=p->pEList->nExpr );
92728 int nExpr = p->pEList->nExpr;
92926 generateColumnNames(pParse, 0, pFirst->pEList);
92965 ExprList *pEList /* Substitute expressions */
92973 assert( pEList!=0 && pExpr->iColumn<pEList->nExpr );
92975 pNew = sqlite3ExprDup(db, pEList->a[pExpr->iColumn].pExpr, 0);
92983 pExpr->pLeft = substExpr(db, pExpr->pLeft, iTable, pEList);
92984 pExpr->pRight = substExpr(db, pExpr->pRight, iTable, pEList);
92986 substSelect(db, pExpr->x.pSelect, iTable, pEList);
92988 substExprList(db, pExpr->x.pList, iTable, pEList);
92997 ExprList *pEList /* Substitute values */
93002 pList->a[i].pExpr = substExpr(db, pList->a[i].pExpr, iTable, pEList);
93009 ExprList *pEList /* Substitute values */
93015 substExprList(db, p->pEList, iTable, pEList);
93016 substExprList(db, p->pGroupBy, iTable, pEList);
93017 substExprList(db, p->pOrderBy, iTable, pEList);
93018 p->pHaving = substExpr(db, p->pHaving, iTable, pEList);
93019 p->pWhere = substExpr(db, p->pWhere, iTable, pEList);
93020 substSelect(db, p->pPrior, iTable, pEList);
93025 substSelect(db, pItem->pSelect, iTable, pEList);
93448 pList = pParent->pEList;
93457 substExprList(db, pParent->pEList, iParent, pSub->pEList);
93459 substExprList(db, pParent->pGroupBy, iParent, pSub->pEList);
93460 pParent->pHaving = substExpr(db, pParent->pHaving, iParent, pSub->pEList);
93467 substExprList(db, pParent->pOrderBy, iParent, pSub->pEList);
93478 pParent->pHaving = substExpr(db, pParent->pHaving, iParent, pSub->pEList);
93484 pParent->pWhere = substExpr(db, pParent->pWhere, iParent, pSub->pEList);
93527 ExprList *pEList = p->pEList;
93529 if( pEList->nExpr!=1 ) return WHERE_ORDERBY_NORMAL;
93530 pExpr = pEList->a[0].pExpr;
93533 pEList = pExpr->x.pList;
93534 if( pEList==0 || pEList->nExpr!=1 ) return 0;
93535 if( pEList->a[0].pExpr->op!=TK_AGG_COLUMN ) return WHERE_ORDERBY_NORMAL;
93562 if( p->pWhere || p->pEList->nExpr!=1
93568 pExpr = p->pEList->a[0].pExpr;
93633 ExprList *pEList;
93645 pEList = p->pEList;
93676 selectColumnsFromExprList(pParse, pSel->pEList, &pTab->nCol, &pTab->aCol);
93721 for(k=0; k<pEList->nExpr; k++){
93722 Expr *pE = pEList->a[k].pExpr;
93728 if( k<pEList->nExpr ){
93734 struct ExprList_item *a = pEList->a;
93740 for(k=0; k<pEList->nExpr; k++){
93837 sqlite3ExprListDelete(db, pEList);
93838 p->pEList = pNew;
93841 if( p->pEList && p->pEList->nExpr>db->aLimit[SQLITE_LIMIT_COLUMN] ){
94184 ExprList *pEList; /* List of columns to extract. */
94222 pEList = p->pEList;
94227 assert( pEList!=0 );
94238 if( checkForMultiColumnSelectError(pParse, pDest, pEList->nExpr) ){
94288 pEList = p->pEList;
94325 p->pGroupBy = sqlite3ExprListDup(db, p->pEList, 0);
94364 sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pDest->iParm, pEList->nExpr);
94379 pKeyInfo = keyInfoFromExprList(pParse, p->pEList);
94408 selectInnerLoop(pParse, p, pEList, 0, 0, pOrderBy, -1, pDest,
94433 for(k=p->pEList->nExpr, pItem=p->pEList->a; k>0; k--, pItem++){
94458 sqlite3ExprAnalyzeAggList(&sNC, pEList);
94663 selectInnerLoop(pParse, p, p->pEList, 0, 0, pOrderBy,
94766 assert( !ExprHasProperty(p->pEList->a[0].pExpr, EP_xIsSelect) );
94767 pMinMax = sqlite3ExprListDup(db, p->pEList->a[0].pExpr->x.pList,0);
94797 selectInnerLoop(pParse, p, p->pEList, 0, 0, 0, -1,
94814 generateSortTail(pParse, p, v, pEList->nExpr, pDest);
94835 generateColumnNames(pParse, pTabList, pEList);
94885 sqlite3PrintExprList(p->pEList);
95521 ExprList *pEList, /* The VALUE clause: a list of values to be inserted */
95527 assert(pEList == 0 || pSelect == 0);
95528 assert(pEList != 0 || pSelect != 0 || db->mallocFailed);
95534 pTriggerStep->pExprList = sqlite3ExprListDup(db, pEList, EXPRDUP_REDUCE);
95539 sqlite3ExprListDelete(db, pEList);
95553 ExprList *pEList, /* The SET clause: list of column and new values */
95561 pTriggerStep->pExprList = sqlite3ExprListDup(db, pEList, EXPRDUP_REDUCE);
95565 sqlite3ExprListDelete(db, pEList);
95751 static int checkColumnOverlap(IdList *pIdList, ExprList *pEList){
95753 if( pIdList==0 || NEVER(pEList==0) ) return 1;
95754 for(e=0; e<pEList->nExpr; e++){
95755 if( sqlite3IdListIndex(pIdList, pEList->a[e].zName)>=0 ) return 1;
96853 ExprList *pEList = 0; /* The result set of the SELECT statement */
96867 pEList = sqlite3ExprListAppend(pParse, 0, sqlite3Expr(db, TK_ID, "_rowid_"));
96869 pEList = sqlite3ExprListAppend(pParse, pEList,
96879 pEList = sqlite3ExprListAppend(pParse, pEList, pExpr);
96881 pSelect = sqlite3SelectNew(pParse, pEList, pSrc, pWhere, 0, 0, 0, 0, 0, 0);
98801 mask |= exprListTableUsage(pMaskSet, pS->pEList);
