Lines Matching refs:pTabList
34186 const SrcList *pTabList, in sqlite3TreeViewDelete() argument
34197 if( pTabList ) n++; in sqlite3TreeViewDelete()
34207 if( pTabList ){ in sqlite3TreeViewDelete()
34210 sqlite3TreeViewSrcList(pView, pTabList); in sqlite3TreeViewDelete()
34242 const SrcList *pTabList, in sqlite3TreeViewInsert() argument
34263 if( pTabList ) n++; in sqlite3TreeViewInsert()
34274 if( pTabList ){ in sqlite3TreeViewInsert()
34277 sqlite3TreeViewSrcList(pView, pTabList); in sqlite3TreeViewInsert()
34312 const SrcList *pTabList, in sqlite3TreeViewUpdate() argument
34334 if( pTabList ) n++; in sqlite3TreeViewUpdate()
34346 if( pTabList ){ in sqlite3TreeViewUpdate()
34349 sqlite3TreeViewSrcList(pView, pTabList); in sqlite3TreeViewUpdate()
122880 SrcList *pTabList /* All table that pExpr might refer to */
122901 assert( pTabList );
122902 for(iSrc=0; iSrc<pTabList->nSrc; iSrc++){
122903 if( pExpr->iTable==pTabList->a[iSrc].iCursor ){
122904 pTab = pTabList->a[iSrc].pSTab;
129636 SrcList *pTabList, /* The table from which we should delete things */
129684 assert( pTabList->nSrc==1 );
129691 pTab = sqlite3SrcListLookup(pParse, pTabList);
129713 sqlite3TreeViewDelete(pParse->pWith, pTabList, pWhere,
129721 pParse, pTabList, pWhere, pOrderBy, pLimit, "DELETE"
129749 assert( pTabList->nSrc==1 );
129750 iTabCur = pTabList->a[0].iCursor = pParse->nTab++;
129788 sNC.pSrcList = pTabList;
129872 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, 0, 0,0,wcf,iTabCur+1);
130031 sqlite3SrcListDelete(db, pTabList);
135707 SrcList *pTabList, /* Name of table into which we are inserting */
135773 assert( pTabList->nSrc==1 );
135774 pTab = sqlite3SrcListLookup(pParse, pTabList);
135806 sqlite3TreeViewInsert(pParse->pWith, pTabList, pColumn, pSelect, pList,
135913 pTabList->a, pColumn->a[i].zName);
136063 pTabList->a, pTab->nCol-nHidden, nColumn);
136114 pTabList->a[0].iCursor = iDataCur;
136117 pNx->pUpsertSrc = pTabList;
136122 if( sqlite3UpsertAnalyzeTarget(pParse, pTabList, pNx, pUpsert) ){
136464 sqlite3SrcListDelete(db, pTabList);
146802 SrcList *pTabList = pNC->pSrcList;
146803 for(j=0;j<pTabList->nSrc && pTabList->a[j].iCursor!=pExpr->iTable;j++);
146804 if( j<pTabList->nSrc ){
146805 pTab = pTabList->a[j].pSTab;
146806 if( pTabList->a[j].fg.isSubquery ){
146807 pS = pTabList->a[j].u4.pSubq->pSelect;
146924 SrcList *pTabList, /* List of tables */
146931 sNC.pSrcList = pTabList;
146996 SrcList *pTabList;
147006 pTabList = pSelect->pSrc;
147009 assert( pTabList!=0 );
147050 generateColumnTypes(pParse, pTabList, pEList);
150891 SrcList *pTabList;
150911 pTabList = p->pSrc;
150927 sqlite3SrcListAssignCursors(pParse, pTabList);
150933 for(i=0, pFrom=pTabList->a; i<pTabList->nSrc; i++, pFrom++){
151086 for(i=0, pFrom=pTabList->a; i<pTabList->nSrc; i++, pFrom++){
151115 if( i+1<pTabList->nSrc
151192 if( (pTabList->nSrc>1
151195 || !inAnyUsingClause(zName,pFrom,pTabList->nSrc-i-1)
151333 SrcList *pTabList;
151340 pTabList = p->pSrc;
151341 for(i=0, pFrom=pTabList->a; i<pTabList->nSrc; i++, pFrom++){
151992 SrcList *pTabList, /* Search for self-joins in this FROM clause */
152004 pItem = &pTabList->a[iFirst++];
152189 SrcList *pTabList, /* FROM clause */
152193 SrcItem *pItem = &pTabList->a[i];
152199 if( pTabList->a[0].fg.jointype & JT_LTORJ ) return 0; /* (3) */
152201 if( isSelfJoinView(pTabList, pItem, i+1, pTabList->nSrc)!=0 ){
152205 if( pTabList->nSrc==1 ) return 1; /* (1a) */
152206 if( pTabList->a[1].fg.jointype & JT_CROSS ) return 1; /* (1b) */
152278 SrcList *pTabList; /* List of tables to select from */
152390 pTabList = p->pSrc;
152400 for(i=0; !p->pPrior && i<pTabList->nSrc; i++){
152401 SrcItem *pItem = &pTabList->a[i];
152440 for(j=i+1; j<pTabList->nSrc; j++){
152441 SrcItem *pI2 = &pTabList->a[j];
152455 for(j=pTabList->nSrc-1; j>=0; j--){
152456 pTabList->a[j].fg.jointype &= ~JT_LTORJ;
152457 if( pTabList->a[j].fg.jointype & JT_RIGHT ) break;
152518 && (p->pOrderBy!=0 || pTabList->nSrc>1) /* Condition (5) */
152552 && (pTabList->nSrc==1
152553 || (pTabList->a[1].fg.jointype&(JT_OUTER|JT_CROSS))!=0)
152564 pTabList = p->pSrc;
152614 pTabList = p->pSrc;
152624 for(i=0; i<pTabList->nSrc; i++){
152625 SrcItem *pItem = &pTabList->a[i];
152692 && pushDownWhereTerms(pParse, pSub, p->pWhere, pTabList, i)
152728 if( fromClauseTermCanBeCoroutine(pParse, pTabList, i, p->selFlags) ){
152760 }else if( (pPrior = isSelfJoinView(pTabList, pItem, 0, i))!=0 ){
152964 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, sSort.pOrderBy,
153110 sNC.pSrcList = pTabList;
153214 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pGroupBy, pDistinct,
153567 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pMinMaxOrderBy,
155627 SrcList *pTabList, /* List of tables to select from */
155640 Table *pTab = pTabList->a[0].pSTab;
155657 pSrc = sqlite3SrcListDup(db, pTabList, 0);
155660 assert( pTabList->nSrc>1 );
155722 SrcList *pTabList, /* The table in which we should change things */
155797 pTab = sqlite3SrcListLookup(pParse, pTabList);
155821 sqlite3TreeViewUpdate(pParse->pWith, pTabList, pChanges, pWhere,
155830 nChangeFrom = (pTabList->nSrc>1) ? pChanges->nExpr : 0;
155836 pParse, pTabList, pWhere, pOrderBy, pLimit, "UPDATE"
155871 pTabList->a[0].iCursor = iDataCur;
155887 sNC.pSrcList = pTabList;
155993 pTabList->a[0].colUsed = IsVirtual(pTab) ? ALLBITS : 0;
156084 updateVirtualTable(pParse, pTabList, pTab, pChanges, pRowidExpr, aXRef,
156130 pParse, iEph, pPk, pChanges, pTabList, pWhere, pOrderBy, pLimit
156177 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere,0,0,0,flags,iIdxCur);
156590 sqlite3SrcListDelete(db, pTabList);
156892 SrcList *pTabList, /* Table into which we are inserting */
156906 assert( pTabList->nSrc==1 );
156907 assert( pTabList->a[0].pSTab!=0 );
156917 sNC.pSrcList = pTabList;
156926 pTab = pTabList->a[0].pSTab;
156928 iCursor = pTabList->a[0].iCursor;
156949 sCol[1].iTable = pTabList->a[0].iCursor;
159425 SrcList *pTabList; /* List of tables in the join */
159493 SrcList *pTabList, /* Table list this loop refers to */
159505 SrcList *pTabList, /* Table list this loop refers to */
159721 SrcList *pTabList, /* Table list this loop refers to */
159731 SrcItem *pItem = &pTabList->a[pLevel->iFrom];
159846 SrcList *pTabList, /* Table list this loop refers to */
159863 sqlite3WhereAddExplainText(pParse, addr, pTabList, pLevel, wctrlFlags);
159885 SrcItem *pItem = &pWInfo->pTabList->a[pLevel->iFrom];
160765 assert( iCur==pWInfo->pTabList->a[pLevel->iFrom].iCursor );
161092 pTabItem = &pWInfo->pTabList->a[pLevel->iFrom];
161916 origSrc = pWInfo->pTabList->a;
161921 pOrTab = pWInfo->pTabList;
162351 pTab = pWInfo->pTabList->a[pLevel->iFrom].pSTab;
162453 SrcItem *pTabItem = &pWInfo->pTabList->a[pLevel->iFrom];
162466 pRight = &pWInfo->pTabList->a[pWInfo->a[k].iFrom];
163777 assert( pWInfo->pTabList!=0 );
163778 if( termIsEquivalence(pParse, pDup, pWInfo->pTabList) ){
164404 SrcList *pTabList, /* the FROM clause */
164409 exprAnalyze(pTabList, pWC, i);
165106 SrcList *pTabList, /* The FROM clause */
165118 if( pTabList->nSrc!=1 ) return 0;
165119 iBase = pTabList->a[0].iCursor;
165120 pTab = pTabList->a[0].pSTab;
165481 SrcList *pTabList; /* The complete FROM clause */
165498 pTabList = pWC->pWInfo->pTabList;
165499 pSrc = &pTabList->a[pLevel->iFrom];
165510 && sqlite3ExprIsSingleTableConstraint(pExpr, pTabList, pLevel->iFrom, 0)
165658 assert( pSrc == &pWC->pWInfo->pTabList->a[pLevel->iFrom] );
165766 const SrcList *pTabList;
165784 pTabList = pWInfo->pTabList;
165786 pItem = &pTabList->a[iSrc];
165803 && sqlite3ExprIsSingleTableConstraint(pExpr, pTabList, iSrc, 0)
165834 pTabItem = &pWInfo->pTabList->a[pLevel->iFrom];
166912 int nb = 1+(pWInfo->pTabList->nSrc+3)/4;
166913 SrcItem *pItem = pWInfo->pTabList->a + p->iTab;
167458 || (pWC->pWInfo->pTabList->a[pLoop->iTab].fg.jointype
168378 SrcList *pTabList; /* The FROM clause */
168390 pTabList = pWInfo->pTabList;
168391 pSrc = pTabList->a + pNew->iTab;
168734 SrcItem *pSrc = &pBuilder->pWInfo->pTabList->a[pNew->iTab];
169062 pSrc = &pWInfo->pTabList->a[pNew->iTab];
169188 pItem = pWInfo->pTabList->a + pNew->iTab;
169300 SrcList *pTabList = pWInfo->pTabList;
169302 SrcItem *pEnd = &pTabList->a[pWInfo->nLevel];
169320 for(iTab=0, pItem=pTabList->a; pItem<pEnd; iTab++, pItem++){
169571 iCur = pWInfo->pTabList->a[pLoop->iTab].iCursor;
170013 aFromTabs = pWInfo->pTabList->a;
170189 assert( nLoop<=pWInfo->pTabList->nSrc );
170489 pLevel->iTabCur = pWInfo->pTabList->a[pLevel->iFrom].iCursor;
170667 assert( pWInfo->pTabList->nSrc>=1 );
170668 pItem = pWInfo->pTabList->a;
170854 hasRightJoin = (pWInfo->pTabList->a[0].fg.jointype & JT_LTORJ)!=0;
170861 pItem = &pWInfo->pTabList->a[pLoop->iTab];
170935 SrcItem *pItem = &pWInfo->pTabList->a[pLoop->iTab];
171030 for(ii=0; ii<pWInfo->pTabList->nSrc; ii++){
171031 SrcItem *pItem = &pWInfo->pTabList->a[ii];
171132 SrcList *pTabList, /* FROM clause: A list of all tables to be scanned */
171179 testcase( pTabList->nSrc==BMS );
171180 if( pTabList->nSrc>BMS ){
171190 nTabList = (wctrlFlags & WHERE_OR_SUBCLAUSE) ? 1 : pTabList->nSrc;
171207 pWInfo->pTabList = pTabList;
171275 createMask(pMaskSet, pTabList->a[ii].iCursor);
171276 sqlite3WhereTabFuncArgs(pParse, &pTabList->a[ii], &pWInfo->sWC);
171277 }while( (++ii)<pTabList->nSrc );
171281 for(ii=0; ii<pTabList->nSrc; ii++){
171282 Bitmask m = sqlite3WhereGetMask(pMaskSet, pTabList->a[ii].iCursor);
171291 sqlite3WhereExprAnalyze(pTabList, &pWInfo->sWC);
171333 && (pTabList->a[0].fg.jointype & JT_LTORJ)!=0 )
171346 }else if( isDistinctRedundant(pParse, pTabList, &pWInfo->sWC, pResultSet) ){
171368 sSelect.pSrc = pTabList;
171426 assert( pWInfo->pTabList!=0 );
171524 assert( !(wsFlags&WHERE_VIRTUALTABLE) || IsVirtual(pTabList->a[0].pSTab) );
171527 && !IsVirtual(pTabList->a[0].pSTab)
171532 if( HasRowid(pTabList->a[0].pSTab) && (wsFlags & WHERE_IDX_ONLY) ){
171549 pTabItem = &pTabList->a[pLevel->iFrom];
171725 pSrc = &pTabList->a[pLevel->iFrom];
171740 assert( pTabList == pWInfo->pTabList );
171752 pParse, pTabList, pLevel, wctrlFlags
171758 sqlite3WhereAddScanStatus(v, pTabList, pLevel, addrExplain);
171812 SrcList *pTabList = pWInfo->pTabList;
171948 SrcItem *pSrc = &pTabList->a[pLevel->iFrom];
171979 pWInfo->pTabList->a[pLevel->iFrom].pSTab->zName));
171982 assert( pWInfo->nLevel<=pTabList->nSrc );
171987 SrcItem *pTabItem = &pTabList->a[pLevel->iFrom];
172116 pTabList,