11613 #define WHERE_ONETABLE_ONLY    0x0040 /* Only code the 1st table in pTabList */
85987 ** is in pTabList or else it is the NEW or OLD table of a trigger.  
85998   SrcList *pTabList     /* All table that pExpr might refer to */
86003   int iSrc;             /* Index in pTabList->a[] of table being read */
86019     assert( pTabList );
86020     for(iSrc=0; ALWAYS(iSrc<pTabList->nSrc); iSrc++){
86021       if( pExpr->iTable==pTabList->a[iSrc].iCursor ){
86022         pTab = pTabList->a[iSrc].pTab;
91067 **                  pTabList              pWhere
91071   SrcList *pTabList,     /* The table from which we should delete things */
91115   assert( pTabList->nSrc==1 );
91122   pTab = sqlite3SrcListLookup(pParse, pTabList);
91161   assert( pTabList->nSrc==1 );
91162   iTabCur = pTabList->a[0].iCursor = pParse->nTab++;
91196   sNC.pSrcList = pTabList;
91252     pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, 0, 0, 
91404   sqlite3SrcListDelete(db, pTabList);
95243   SrcList *pTabList,    /* Name of table into which we are inserting */
95307   assert( pTabList->nSrc==1 );
95308   zTab = pTabList->a[0].zName;
95310   pTab = sqlite3SrcListLookup(pParse, pTabList);
95425               pTabList, 0, pColumn->a[i].zName);
95536        pTabList, 0, pTab->nCol-nHidden, nColumn);
95827   sqlite3SrcListDelete(db, pTabList);
102762         SrcList *pTabList = pNC->pSrcList;
102763         for(j=0;j<pTabList->nSrc && pTabList->a[j].iCursor!=pExpr->iTable;j++);
102764         if( j<pTabList->nSrc ){
102765           pTab = pTabList->a[j].pTab;
102766           pS = pTabList->a[j].pSelect;
102878   SrcList *pTabList,  /* List of tables */
102885   sNC.pSrcList = pTabList;
102918   SrcList *pTabList,  /* List of tables */
102945     }else if( (p->op==TK_COLUMN || p->op==TK_AGG_COLUMN) && pTabList ){
102949       for(j=0; ALWAYS(j<pTabList->nSrc); j++){
102950         if( pTabList->a[j].iCursor==p->iTable ) break;
102952       assert( j<pTabList->nSrc );
102953       pTab = pTabList->a[j].pTab;
102977   generateColumnTypes(pParse, pTabList, pEList);
105393 **    (2)  Fill in the pTabList->a[].pTab fields in the SrcList that 
105395 **         fill pTabList->a[].pSelect with a copy of the SELECT statement
105413   SrcList *pTabList;
105427   pTabList = p->pSrc;
105434   sqlite3SrcListAssignCursors(pParse, pTabList);
105440   for(i=0, pFrom=pTabList->a; i<pTabList->nSrc; i++, pFrom++){
105570         for(i=0, pFrom=pTabList->a; i<pTabList->nSrc; i++, pFrom++){
105613                 && tableAndColumnIndex(pTabList, i, zName, 0, 0)
105628             if( longNames || pTabList->nSrc>1 ){
105741   SrcList *pTabList;
105748     pTabList = p->pSrc;
105749     for(i=0, pFrom=pTabList->a; i<pTabList->nSrc; i++, pFrom++){
106004   SrcList *pTabList;     /* List of tables to select from */
106045   pTabList = p->pSrc;
106070   for(i=0; !p->pPrior && i<pTabList->nSrc; i++){
106071     struct SrcList_item *pItem = &pTabList->a[i];
106108     }else if( pTabList->nSrc==1
106164     pTabList = p->pSrc;
106268     pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, sSort.pOrderBy,
106356     sNC.pSrcList = pTabList;
106425       pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pGroupBy, 0,
106720         pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, pMinMax,0,flag,0);
106776     generateColumnNames(pParse, pTabList, pEList);
108291 *            onError   pTabList      pChanges             pWhere
108295   SrcList *pTabList,     /* The table in which we should change things */
108353   assert( pTabList->nSrc==1 );
108357   pTab = sqlite3SrcListLookup(pParse, pTabList);
108390   pTabList->a[0].iCursor = iBaseCur = iDataCur = pParse->nTab++;
108396       pTabList->a[0].iCursor = iDataCur;
108415   sNC.pSrcList = pTabList;
108473   pTabList->a[0].colUsed = 0;
108507     updateVirtualTable(pParse, pTabList, pTab, pChanges, pRowidExpr, aXRef,
108510     pTabList = 0;
108554         pParse, pTabList, pWhere, 0, 0, WHERE_ONEPASS_DESIRED, iIdxCur
108583     pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, 0, 0, 
108869   sqlite3SrcListDelete(db, pTabList);
110864   SrcList *pTabList;        /* List of tables in the join */
111532   SrcList *pTabList,       /* the FROM clause */
111537     exprAnalyze(pTabList, pWC, i);
112348   SrcList *pTabList,        /* The FROM clause */
112360   if( pTabList->nSrc!=1 ) return 0;
112361   iBase = pTabList->a[0].iCursor;
112362   pTab = pTabList->a[0].pTab;
113708   SrcList *pTabList,              /* Table list this loop refers to */
113718     struct SrcList_item *pItem = &pTabList->a[pLevel->iFrom];
113824   pTabItem = &pWInfo->pTabList->a[pLevel->iFrom];
114366       origSrc = pWInfo->pTabList->a;
114371       pOrTab = pWInfo->pTabList;
114690   int nb = 1+(pWInfo->pTabList->nSrc+7)/8;
114691   struct SrcList_item *pItem = pWInfo->pTabList->a + p->iTab;
115523   SrcList *pTabList;          /* The FROM clause */
115536   pTabList = pWInfo->pTabList;
115537   pSrc = pTabList->a + pNew->iTab;
115733   pSrc = &pWInfo->pTabList->a[pNew->iTab];
115890   pItem = pWInfo->pTabList->a + pNew->iTab;
115986   SrcList *pTabList = pWInfo->pTabList;
115997   for(iTab=0, pItem=pTabList->a; iTab<nTabList; iTab++, pItem++){
116108     iCur = pWInfo->pTabList->a[pLoop->iTab].iCursor;
116397   assert( nLoop<=pWInfo->pTabList->nSrc );
116654     pLevel->iTabCur = pWInfo->pTabList->a[pLevel->iFrom].iCursor;
116722   assert( pWInfo->pTabList->nSrc>=1 );
116723   pItem = pWInfo->pTabList->a;
116817 ** number pTabList->a[0].iCursor.  t2 uses the cursor pTabList->a[1].iCursor.
116822 ** in pTabList pointing at their appropriate entries.  The [...] code
116874   SrcList *pTabList,    /* FROM clause: A list of all tables to be scanned */
116882   int nTabList;              /* Number of elements in pTabList */
116913   testcase( pTabList->nSrc==BMS );
116914   if( pTabList->nSrc>BMS ){
116920   ** pTabList.  But if the WHERE_ONETABLE_ONLY flag is set, then we should
116921   ** only generate code for the first table in pTabList and assume that
116924   nTabList = (wctrlFlags & WHERE_ONETABLE_ONLY) ? 1 : pTabList->nSrc;
116943   pWInfo->pTabList = pTabList;
116997   ** Note that bitmasks are created for all pTabList->nSrc tables in
116998   ** pTabList, not just the first nTabList tables.  nTabList is normally
116999   ** equal to pTabList->nSrc but might be shortened to 1 if the
117002   for(ii=0; ii<pTabList->nSrc; ii++){
117003     createMask(pMaskSet, pTabList->a[ii].iCursor);
117008     for(ii=0; ii<pTabList->nSrc; ii++){
117009       Bitmask m = getMask(pMaskSet, pTabList->a[ii].iCursor);
117021   exprAnalyzeAll(pTabList, &pWInfo->sWC);
117027     if( isDistinctRedundant(pParse, pTabList, &pWInfo->sWC, pResultSet) ){
117124       if( (pWInfo->pTabList->a[pLoop->iTab].jointype & JT_LEFT)==0 ) break;
117157     if( HasRowid(pTabList->a[0].pTab) ){
117162   /* Open all tables in the pTabList and any indices selected for
117171     pTabItem = &pTabList->a[pLevel->iFrom];
117263                 &pTabList->a[pLevel->iFrom], notReady, pLevel);
117267     explainOneScan(pParse, pTabList, pLevel, ii, pLevel->iFrom, wctrlFlags);
117296   SrcList *pTabList = pWInfo->pTabList;
117342         sqlite3VdbeAddOp1(v, OP_NullRow, pTabList->a[i].iCursor);
117355                      pWInfo->pTabList->a[pLevel->iFrom].pTab->zName));
117363   assert( pWInfo->nLevel<=pTabList->nSrc );
117368     struct SrcList_item *pTabItem = &pTabList->a[pLevel->iFrom];

Indexes created Thu Nov 06 06:13:30 CET 2014