Lines Matching defs:pTabList
33619 const SrcList *pTabList,
33630 if( pTabList ) n++;
33640 if( pTabList ){
33643 sqlite3TreeViewSrcList(pView, pTabList);
33675 const SrcList *pTabList,
33696 if( pTabList ) n++;
33707 if( pTabList ){
33710 sqlite3TreeViewSrcList(pView, pTabList);
33745 const SrcList *pTabList,
33767 if( pTabList ) n++;
33779 if( pTabList ){
33782 sqlite3TreeViewSrcList(pView, pTabList);
121229 ** is in pTabList or else it is the NEW or OLD table of a trigger.
121240 SrcList *pTabList /* All table that pExpr might refer to */
121244 int iSrc; /* Index in pTabList->a[] of table being read */
121261 assert( pTabList );
121262 for(iSrc=0; iSrc<pTabList->nSrc; iSrc++){
121263 if( pExpr->iTable==pTabList->a[iSrc].iCursor ){
121264 pTab = pTabList->a[iSrc].pTab;
127901 ** pTabList pWhere
127905 SrcList *pTabList, /* The table from which we should delete things */
127953 assert( pTabList->nSrc==1 );
127960 pTab = sqlite3SrcListLookup(pParse, pTabList);
127982 sqlite3TreeViewDelete(pParse->pWith, pTabList, pWhere,
127990 pParse, pTabList, pWhere, pOrderBy, pLimit, "DELETE"
128018 assert( pTabList->nSrc==1 );
128019 iTabCur = pTabList->a[0].iCursor = pParse->nTab++;
128057 sNC.pSrcList = pTabList;
128141 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, 0, 0,0,wcf,iTabCur+1);
128300 sqlite3SrcListDelete(db, pTabList);
133772 SrcList *pTabList, /* Name of table into which we are inserting */
133837 assert( pTabList->nSrc==1 );
133838 pTab = sqlite3SrcListLookup(pParse, pTabList);
133870 sqlite3TreeViewInsert(pParse->pWith, pTabList, pColumn, pSelect, pList,
133983 pTabList->a, pColumn->a[i].zName);
134128 pTabList->a, pTab->nCol-nHidden, nColumn);
134179 pTabList->a[0].iCursor = iDataCur;
134182 pNx->pUpsertSrc = pTabList;
134187 if( sqlite3UpsertAnalyzeTarget(pParse, pTabList, pNx, pUpsert) ){
134529 sqlite3SrcListDelete(db, pTabList);
144815 SrcList *pTabList = pNC->pSrcList;
144816 for(j=0;j<pTabList->nSrc && pTabList->a[j].iCursor!=pExpr->iTable;j++);
144817 if( j<pTabList->nSrc ){
144818 pTab = pTabList->a[j].pTab;
144819 pS = pTabList->a[j].pSelect;
144933 SrcList *pTabList, /* List of tables */
144940 sNC.pSrcList = pTabList;
145005 SrcList *pTabList;
145015 pTabList = pSelect->pSrc;
145018 assert( pTabList!=0 );
145059 generateColumnTypes(pParse, pTabList, pEList);
148842 ** (2) Fill in the pTabList->a[].pTab fields in the SrcList that
148844 ** fill pTabList->a[].pSelect with a copy of the SELECT statement
148862 SrcList *pTabList;
148882 pTabList = p->pSrc;
148898 sqlite3SrcListAssignCursors(pParse, pTabList);
148904 for(i=0, pFrom=pTabList->a; i<pTabList->nSrc; i++, pFrom++){
149053 for(i=0, pFrom=pTabList->a; i<pTabList->nSrc; i++, pFrom++){
149081 if( i+1<pTabList->nSrc
149158 if( (pTabList->nSrc>1
149161 || !inAnyUsingClause(zName,pFrom,pTabList->nSrc-i-1)
149299 SrcList *pTabList;
149306 pTabList = p->pSrc;
149307 for(i=0, pFrom=pTabList->a; i<pTabList->nSrc; i++, pFrom++){
149949 ** Check to see if the pThis entry of pTabList is a self-join of another view.
149957 SrcList *pTabList, /* Search for self-joins in this FROM clause */
149966 pItem = &pTabList->a[iFirst++];
150116 ** Return TRUE (non-zero) if the i-th entry in the pTabList SrcList can
150145 SrcList *pTabList, /* FROM clause */
150149 SrcItem *pItem = &pTabList->a[i];
150155 if( pTabList->a[0].fg.jointype & JT_LTORJ ) return 0; /* (3) */
150157 if( isSelfJoinView(pTabList, pItem, i+1, pTabList->nSrc)!=0 ){
150161 if( pTabList->nSrc==1 ) return 1; /* (1a) */
150162 if( pTabList->a[1].fg.jointype & JT_CROSS ) return 1; /* (1b) */
150200 SrcList *pTabList; /* List of tables to select from */
150311 pTabList = p->pSrc;
150320 for(i=0; !p->pPrior && i<pTabList->nSrc; i++){
150321 SrcItem *pItem = &pTabList->a[i];
150359 for(j=i+1; j<pTabList->nSrc; j++){
150360 SrcItem *pI2 = &pTabList->a[j];
150374 for(j=pTabList->nSrc-1; j>=0; j--){
150375 pTabList->a[j].fg.jointype &= ~JT_LTORJ;
150376 if( pTabList->a[j].fg.jointype & JT_RIGHT ) break;
150433 && (p->pOrderBy!=0 || pTabList->nSrc>1) /* Condition (5) */
150467 && (pTabList->nSrc==1
150468 || (pTabList->a[1].fg.jointype&(JT_OUTER|JT_CROSS))!=0)
150478 pTabList = p->pSrc;
150527 pTabList = p->pSrc;
150534 for(i=0; i<pTabList->nSrc; i++){
150535 SrcItem *pItem = &pTabList->a[i];
150587 && pushDownWhereTerms(pParse, pSub, p->pWhere, pTabList, i)
150622 if( fromClauseTermCanBeCoroutine(pParse, pTabList, i, p->selFlags) ){
150653 }else if( (pPrior = isSelfJoinView(pTabList, pItem, 0, i))!=0 ){
150843 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, sSort.pOrderBy,
150983 sNC.pSrcList = pTabList;
151086 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pGroupBy, pDistinct,
151417 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pMinMaxOrderBy,
153426 ** SELECT <other-columns>, pChanges FROM pTabList WHERE pWhere
153429 ** iEph. None of pChanges, pTabList or pWhere are modified or consumed by
153434 ** SELECT <other-columns>, pChanges FROM pTabList
153443 ** of table pTabList->a[0].pTab.
153465 SrcList *pTabList, /* List of tables to select from */
153478 Table *pTab = pTabList->a[0].pTab;
153495 pSrc = sqlite3SrcListDup(db, pTabList, 0);
153498 assert( pTabList->nSrc>1 );
153556 ** pTabList
153560 SrcList *pTabList, /* The table in which we should change things */
153635 pTab = sqlite3SrcListLookup(pParse, pTabList);
153659 sqlite3TreeViewUpdate(pParse->pWith, pTabList, pChanges, pWhere,
153668 nChangeFrom = (pTabList->nSrc>1) ? pChanges->nExpr : 0;
153674 pParse, pTabList, pWhere, pOrderBy, pLimit, "UPDATE"
153709 pTabList->a[0].iCursor = iDataCur;
153725 sNC.pSrcList = pTabList;
153837 pTabList->a[0].colUsed = IsVirtual(pTab) ? ALLBITS : 0;
153928 updateVirtualTable(pParse, pTabList, pTab, pChanges, pRowidExpr, aXRef,
153974 pParse, iEph, pPk, pChanges, pTabList, pWhere, pOrderBy, pLimit
154021 pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere,0,0,0,flags,iIdxCur);
154434 sqlite3SrcListDelete(db, pTabList);
154736 SrcList *pTabList, /* Table into which we are inserting */
154750 assert( pTabList->nSrc==1 );
154751 assert( pTabList->a[0].pTab!=0 );
154761 sNC.pSrcList = pTabList;
154770 pTab = pTabList->a[0].pTab;
154772 iCursor = pTabList->a[0].iCursor;
154793 sCol[1].iTable = pTabList->a[0].iCursor;
157254 SrcList *pTabList; /* List of tables in the join */
157312 SrcList *pTabList, /* Table list this loop refers to */
157534 SrcList *pTabList, /* Table list this loop refers to */
157543 SrcItem *pItem = &pTabList->a[pLevel->iFrom];
157653 SrcItem *pItem = &pWInfo->pTabList->a[pLevel->iFrom];
158477 assert( iCur==pWInfo->pTabList->a[pLevel->iFrom].iCursor );
158804 pTabItem = &pWInfo->pTabList->a[pLevel->iFrom];
159620 origSrc = pWInfo->pTabList->a;
159625 pOrTab = pWInfo->pTabList;
160055 pTab = pWInfo->pTabList->a[pLevel->iFrom].pTab;
160157 SrcItem *pTabItem = &pWInfo->pTabList->a[pLevel->iFrom];
160169 pRight = &pWInfo->pTabList->a[pWInfo->a[k].iFrom];
162053 SrcList *pTabList, /* the FROM clause */
162058 exprAnalyze(pTabList, pWC, i);
162750 SrcList *pTabList, /* The FROM clause */
162762 if( pTabList->nSrc!=1 ) return 0;
162763 iBase = pTabList->a[0].iCursor;
162764 pTab = pTabList->a[0].pTab;
163077 SrcList *pTabList; /* The complete FROM clause */
163094 pTabList = pWC->pWInfo->pTabList;
163095 pSrc = &pTabList->a[pLevel->iFrom];
163106 && sqlite3ExprIsSingleTableConstraint(pExpr, pTabList, pLevel->iFrom, 0)
163236 assert( pSrc == &pWC->pWInfo->pTabList->a[pLevel->iFrom] );
163338 const SrcList *pTabList;
163356 pTabList = pWInfo->pTabList;
163358 pItem = &pTabList->a[iSrc];
163375 && sqlite3ExprIsSingleTableConstraint(pExpr, pTabList, iSrc, 0)
163406 pTabItem = &pWInfo->pTabList->a[pLevel->iFrom];
164433 int nb = 1+(pWInfo->pTabList->nSrc+3)/4;
164434 SrcItem *pItem = pWInfo->pTabList->a + p->iTab;
164973 || (pWC->pWInfo->pTabList->a[pLoop->iTab].fg.jointype
165882 SrcList *pTabList; /* The FROM clause */
165894 pTabList = pWInfo->pTabList;
165895 pSrc = pTabList->a + pNew->iTab;
166233 SrcItem *pSrc = &pBuilder->pWInfo->pTabList->a[pNew->iTab];
166563 pSrc = &pWInfo->pTabList->a[pNew->iTab];
166691 pItem = pWInfo->pTabList->a + pNew->iTab;
166803 SrcList *pTabList = pWInfo->pTabList;
166805 SrcItem *pEnd = &pTabList->a[pWInfo->nLevel];
166823 for(iTab=0, pItem=pTabList->a; pItem<pEnd; iTab++, pItem++){
166985 iCur = pWInfo->pTabList->a[pLoop->iTab].iCursor;
167368 assert( nLoop<=pWInfo->pTabList->nSrc );
167652 pLevel->iTabCur = pWInfo->pTabList->a[pLevel->iFrom].iCursor;
167827 assert( pWInfo->pTabList->nSrc>=1 );
167828 pItem = pWInfo->pTabList->a;
168014 hasRightJoin = (pWInfo->pTabList->a[0].fg.jointype & JT_LTORJ)!=0;
168020 pItem = &pWInfo->pTabList->a[pLoop->iTab];
168091 SrcItem *pItem = &pWInfo->pTabList->a[pLoop->iTab];
168244 for(ii=0; ii<pWInfo->pTabList->nSrc; ii++){
168245 SrcItem *pItem = &pWInfo->pTabList->a[ii];
168289 ** number pTabList->a[0].iCursor. t2 uses the cursor pTabList->a[1].iCursor.
168294 ** in pTabList pointing at their appropriate entries. The [...] code
168346 SrcList *pTabList, /* FROM clause: A list of all tables to be scanned */
168356 int nTabList; /* Number of elements in pTabList */
168393 testcase( pTabList->nSrc==BMS );
168394 if( pTabList->nSrc>BMS ){
168400 ** pTabList. But if the WHERE_OR_SUBCLAUSE flag is set, then we should
168401 ** only generate code for the first table in pTabList and assume that
168404 nTabList = (wctrlFlags & WHERE_OR_SUBCLAUSE) ? 1 : pTabList->nSrc;
168424 pWInfo->pTabList = pTabList;
168485 ** Note that bitmasks are created for all pTabList->nSrc tables in
168486 ** pTabList, not just the first nTabList tables. nTabList is normally
168487 ** equal to pTabList->nSrc but might be shortened to 1 if the
168492 createMask(pMaskSet, pTabList->a[ii].iCursor);
168493 sqlite3WhereTabFuncArgs(pParse, &pTabList->a[ii], &pWInfo->sWC);
168494 }while( (++ii)<pTabList->nSrc );
168498 for(ii=0; ii<pTabList->nSrc; ii++){
168499 Bitmask m = sqlite3WhereGetMask(pMaskSet, pTabList->a[ii].iCursor);
168508 sqlite3WhereExprAnalyze(pTabList, &pWInfo->sWC);
168525 ** no RIGHT or FULL OUTER joins in pTabList.
168550 && (pTabList->a[0].fg.jointype & JT_LTORJ)!=0 )
168563 }else if( isDistinctRedundant(pParse, pTabList, &pWInfo->sWC, pResultSet) ){
168585 sSelect.pSrc = pTabList;
168642 assert( pWInfo->pTabList!=0 );
168739 assert( !(wsFlags & WHERE_VIRTUALTABLE) || IsVirtual(pTabList->a[0].pTab) );
168742 && !IsVirtual(pTabList->a[0].pTab)
168747 if( HasRowid(pTabList->a[0].pTab) && (wsFlags & WHERE_IDX_ONLY) ){
168756 /* Open all tables in the pTabList and any indices selected for
168764 pTabItem = &pTabList->a[pLevel->iFrom];
168940 pSrc = &pTabList->a[pLevel->iFrom];
168950 assert( pTabList == pWInfo->pTabList );
168962 pParse, pTabList, pLevel, wctrlFlags
168968 sqlite3WhereAddScanStatus(v, pTabList, pLevel, addrExplain);
169021 SrcList *pTabList = pWInfo->pTabList;
169157 SrcItem *pSrc = &pTabList->a[pLevel->iFrom];
169187 pWInfo->pTabList->a[pLevel->iFrom].pTab->zName));
169190 assert( pWInfo->nLevel<=pTabList->nSrc );
169195 SrcItem *pTabItem = &pTabList->a[pLevel->iFrom];