Lines Matching refs:pItem
17018 struct SrcList_item *pItem = &pSrc->a[k];
17020 if( pItem->zDatabase ){
17021 sqlite3StrAccumAppend(pAccum, pItem->zDatabase, -1);
17024 sqlite3StrAccumAppend(pAccum, pItem->zName, -1);
59227 struct ExprList_item *pItem;
59229 for(i=p->nExpr, pItem=p->a; i>0; i--, pItem++){
59230 if( sqlite3WalkExpr(pWalker, pItem->pExpr) ) return WRC_Abort;
59263 struct SrcList_item *pItem;
59267 for(i=pSrc->nSrc, pItem=pSrc->a; i>0; i--, pItem++){
59268 if( sqlite3WalkSelect(pWalker, pItem->pSelect) ){
59439 struct SrcList_item *pItem; /* Use for looping over pSrcList items */
59460 for(i=0, pItem=pSrcList->a; i<pSrcList->nSrc; i++, pItem++){
59465 pTab = pItem->pTab;
59470 if( pItem->zAlias ){
59471 char *zTabName = pItem->zAlias;
59484 pExpr->iTable = pItem->iCursor;
59487 pMatch = pItem;
59493 pExpr->iTable = pItem->iCursor;
59495 pMatch = pItem;
59500 if( pItem[1].jointype & JT_NATURAL ){
59503 pItem++;
59505 }else if( (pUsing = pItem[1].pUsing)!=0 ){
59512 pItem++;
59710 struct SrcList_item *pItem = &pSrc->a[iSrc];
59711 p->pTab = pItem->pTab;
59712 p->iTable = pItem->iCursor;
59717 pItem->colUsed |= ((Bitmask)1)<<(iCol>=BMS ? BMS-1 : iCol);
59764 struct SrcList_item *pItem;
59766 pItem = pSrcList->a;
59768 pExpr->pTab = pItem->pTab;
59769 pExpr->iTable = pItem->iCursor;
60059 struct ExprList_item *pItem;
60063 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
60066 if( pItem->done ) continue;
60067 pE = pItem->pExpr;
60088 pItem->pExpr = pE = sqlite3Expr(db, TK_INTEGER, 0);
60093 pItem->iCol = (u16)iCol;
60094 pItem->done = 1;
60130 struct ExprList_item *pItem;
60141 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
60142 if( pItem->iCol ){
60143 if( pItem->iCol>pEList->nExpr ){
60147 resolveAlias(pParse, pEList, pItem->iCol-1, pItem->pExpr, zType);
60179 struct ExprList_item *pItem; /* A term of the ORDER BY clause */
60186 for(i=0, pItem=pOrderBy->a; i<pOrderBy->nExpr; i++, pItem++){
60187 Expr *pE = pItem->pExpr;
60194 pItem->iCol = (u16)iCol;
60205 pItem->iCol = (u16)iCol;
60210 pItem->iCol = 0;
60293 struct SrcList_item *pItem = &p->pSrc->a[i];
60294 if( pItem->pSelect ){
60296 if( pItem->zName ) pParse->zAuthContext = pItem->zName;
60297 sqlite3ResolveSelectNames(pParse, pItem->pSelect, pOuterNC);
60358 struct ExprList_item *pItem;
60363 for(i=0, pItem=pGroupBy->a; i<pGroupBy->nExpr; i++, pItem++){
60364 if( ExprHasProperty(pItem->pExpr, EP_Agg) ){
61344 struct ExprList_item *pItem, *pOldItem;
61351 pNew->a = pItem = sqlite3DbMallocRaw(db, p->nExpr*sizeof(p->a[0]) );
61352 if( pItem==0 ){
61357 for(i=0; i<p->nExpr; i++, pItem++, pOldItem++){
61359 pItem->pExpr = sqlite3ExprDup(db, pOldExpr, flags);
61360 pItem->zName = sqlite3DbStrDup(db, pOldItem->zName);
61361 pItem->zSpan = sqlite3DbStrDup(db, pOldItem->zSpan);
61362 pItem->sortOrder = pOldItem->sortOrder;
61363 pItem->done = 0;
61364 pItem->iCol = pOldItem->iCol;
61365 pItem->iAlias = pOldItem->iAlias;
61496 struct ExprList_item *pItem = &pList->a[pList->nExpr++];
61497 memset(pItem, 0, sizeof(*pItem));
61498 pItem->pExpr = pExpr;
61525 struct ExprList_item *pItem;
61527 pItem = &pList->a[pList->nExpr-1];
61528 assert( pItem->zName==0 );
61529 pItem->zName = sqlite3DbStrNDup(pParse->db, pName->z, pName->n);
61530 if( dequote && pItem->zName ) sqlite3Dequote(pItem->zName);
61550 struct ExprList_item *pItem = &pList->a[pList->nExpr-1];
61552 assert( db->mallocFailed || pItem->pExpr==pSpan->pExpr );
61553 sqlite3DbFree(db, pItem->zSpan);
61554 pItem->zSpan = sqlite3DbStrNDup(db, (char*)pSpan->zStart,
61581 struct ExprList_item *pItem;
61585 for(pItem=pList->a, i=0; i<pList->nExpr; i++, pItem++){
61586 sqlite3ExprDelete(db, pItem->pExpr);
61587 sqlite3DbFree(db, pItem->zName);
61588 sqlite3DbFree(db, pItem->zSpan);
62154 struct ExprList_item *pItem;
62166 for(i=pList->nExpr, pItem=pList->a; i>0; i--, pItem++){
62167 Expr *pE2 = pItem->pExpr;
63528 struct ExprList_item *pItem = pList->a;
63529 for(; i>0; i--, pItem++){
63530 if( ALWAYS(pItem->pExpr) ) pItem->pExpr->flags |= EP_FixedDest;
63575 struct ExprList_item *pItem;
63580 for(pItem=pList->a, i=0; i<n; i++, pItem++){
63581 if( pItem->iAlias ){
63582 int iReg = codeAlias(pParse, pItem->iAlias, pItem->pExpr, target+i);
63588 sqlite3ExprCode(pParse, pItem->pExpr, target+i);
64030 struct SrcList_item *pItem = pSrcList->a;
64031 for(i=0; i<pSrcList->nSrc; i++, pItem++){
64034 if( pExpr->iTable==pItem->iCursor ){
64087 } /* endif pExpr->iTable==pItem->iCursor */
64099 struct AggInfo_func *pItem = pAggInfo->aFunc;
64100 for(i=0; i<pAggInfo->nFunc; i++, pItem++){
64101 if( sqlite3ExprCompare(pItem->pExpr, pExpr) ){
64112 pItem = &pAggInfo->aFunc[i];
64113 pItem->pExpr = pExpr;
64114 pItem->iMem = ++pParse->nMem;
64116 pItem->pFunc = sqlite3FindFunction(pParse->db,
64120 pItem->iDistinct = pParse->nTab++;
64122 pItem->iDistinct = -1;
64174 struct ExprList_item *pItem;
64177 for(pItem=pList->a, i=0; i<pList->nExpr; i++, pItem++){
64178 sqlite3ExprAnalyzeAggregates(pNC, pItem->pExpr);
66124 struct SrcList_item *pItem;
66128 for(i=0, pItem=pList->a; i<pList->nSrc; i++, pItem++){
66129 if( pItem->zDatabase==0 ){
66130 pItem->zDatabase = sqlite3DbStrDup(pFix->pParse->db, zDb);
66131 }else if( sqlite3StrICmp(pItem->zDatabase,zDb)!=0 ){
66134 pFix->zType, pFix->pName, pItem->zDatabase);
66138 if( sqlite3FixSelect(pFix, pItem->pSelect) ) return 1;
66139 if( sqlite3FixExpr(pFix, pItem->pOn) ) return 1;
66189 struct ExprList_item *pItem;
66191 for(i=0, pItem=pList->a; i<pList->nExpr; i++, pItem++){
66192 if( sqlite3FixExpr(pFix, pItem->pExpr) ){
69618 struct SrcList_item *pItem;
69630 pItem = &pList->a[pList->nSrc-1];
69639 pItem->zName = sqlite3NameFromToken(db, pTable);
69640 pItem->zDatabase = sqlite3NameFromToken(db, pDatabase);
69649 struct SrcList_item *pItem;
69652 for(i=0, pItem=pList->a; i<pList->nSrc; i++, pItem++){
69653 if( pItem->iCursor>=0 ) break;
69654 pItem->iCursor = pParse->nTab++;
69655 if( pItem->pSelect ){
69656 sqlite3SrcListAssignCursors(pParse, pItem->pSelect->pSrc);
69667 struct SrcList_item *pItem;
69669 for(pItem=pList->a, i=0; i<pList->nSrc; i++, pItem++){
69670 sqlite3DbFree(db, pItem->zDatabase);
69671 sqlite3DbFree(db, pItem->zName);
69672 sqlite3DbFree(db, pItem->zAlias);
69673 sqlite3DbFree(db, pItem->zIndex);
69674 sqlite3DeleteTable(pItem->pTab);
69675 sqlite3SelectDelete(db, pItem->pSelect);
69676 sqlite3ExprDelete(db, pItem->pOn);
69677 sqlite3IdListDelete(db, pItem->pUsing);
69708 struct SrcList_item *pItem;
69720 pItem = &p->a[p->nSrc-1];
69723 pItem->zAlias = sqlite3NameFromToken(db, pAlias);
69725 pItem->pSelect = pSubquery;
69726 pItem->pOn = pOn;
69727 pItem->pUsing = pUsing;
69745 struct SrcList_item *pItem = &p->a[p->nSrc-1];
69746 assert( pItem->notIndexed==0 && pItem->zIndex==0 );
69750 pItem->notIndexed = 1;
69752 pItem->zIndex = sqlite3NameFromToken(pParse->db, pIndexedBy);
70652 struct SrcList_item *pItem = pSrc->a;
70654 assert( pItem && pSrc->nSrc==1 );
70655 pTab = sqlite3LocateTable(pParse, 0, pItem->zName, pItem->zDatabase);
70656 sqlite3DeleteTable(pItem->pTab);
70657 pItem->pTab = pTab;
70661 if( sqlite3IndexedByLookup(pParse, pItem) ){
73591 struct SrcList_item *pItem = pSrc->a;
73592 pItem->pTab = pFKey->pFrom;
73593 pItem->zName = pFKey->pFrom->zName;
73594 pItem->pTab->nRef++;
73595 pItem->iCursor = pParse->nTab++;
73609 pItem->zName = 0;
75586 struct SrcList_item *pItem; /* An element of pSelect->pSrc */
75658 pItem = pSelect->pSrc->a;
75659 pSrc = sqlite3LocateTable(pParse, 0, pItem->zName, pItem->zDatabase);
79982 struct ExprList_item *pItem;
79992 for(i=0, pItem=pList->a; i<nExpr; i++, pItem++){
79994 pColl = sqlite3ExprCollSeq(pParse, pItem->pExpr);
79999 pInfo->aSortOrder[i] = pItem->sortOrder;
81328 struct ExprList_item *pItem;
81329 for(j=0, pItem=pOrderBy->a; j<nOrderBy; j++, pItem++){
81330 assert( pItem->iCol>0 );
81331 if( pItem->iCol==i ) break;
81353 struct ExprList_item *pItem;
81354 for(i=0, pItem=pOrderBy->a; i<nOrderBy; i++, pItem++){
81355 assert( pItem->iCol>0 && pItem->iCol<=p->pEList->nExpr );
81356 aPermute[i] = pItem->iCol - 1;
81674 struct SrcList_item *pItem;
81686 for(i=pSrc->nSrc, pItem=pSrc->a; i>0; i--, pItem++){
81687 substSelect(db, pItem->pSelect, iTable, pEList);
82708 struct ExprList_item *pItem;
82711 for(j=0, pItem=pList->a; !pColl && j<nArg; j++, pItem++){
82712 pColl = sqlite3ExprCollSeq(pParse, pItem->pExpr);
82848 struct SrcList_item *pItem = &pTabList->a[i];
82850 Select *pSub = pItem->pSelect;
82853 if( pSub==0 || pItem->isPopulated ) continue;
82873 sqlite3SelectDestInit(&dest, SRT_EphemTab, pItem->iCursor);
82874 assert( pItem->isPopulated==0 );
82876 pItem->isPopulated = 1;
83023 struct ExprList_item *pItem; /* For looping over expression in a list */
83025 for(k=p->pEList->nExpr, pItem=p->pEList->a; k>0; k--, pItem++){
83026 pItem->iAlias = 0;
83028 for(k=pGroupBy->nExpr, pItem=pGroupBy->a; k>0; k--, pItem++){
83029 pItem->iAlias = 0;
83469 struct SrcList_item *pItem = &p->pSrc->a[i];
83472 if( pItem->pSelect ){
83474 sqlite3PrintSelect(pItem->pSelect, indent+10);
83476 }else if( pItem->zName ){
83477 sqlite3DebugPrintf("%s", pItem->zName);
83479 if( pItem->pTab ){
83480 sqlite3DebugPrintf("(table: %s)", pItem->pTab->zName);
83482 if( pItem->zAlias ){
83483 sqlite3DebugPrintf(" AS %s", pItem->zAlias);
90595 struct SrcList_item *pItem = &pTabList->a[pLevel->iFrom];
90596 zMsg = sqlite3MPrintf(db, "TABLE %s", pItem->zName);
90597 if( pItem->zAlias ){
90598 zMsg = sqlite3MAppendf(db, zMsg, "%s AS %s", zMsg, pItem->zAlias);