Lines Matching refs:pTab
62 Table *pTab; /* Table definition */ member
313 int sqlite3ColumnIndex(Table *pTab, const char *zCol){ in sqlite3ColumnIndex() argument
317 for(pCol=pTab->aCol, i=0; i<pTab->nCol; pCol++, i++){ in sqlite3ColumnIndex()
366 iCol = sqlite3ColumnIndex(pSrc->a[i].pTab, zCol); in tableAndColumnIndex()
368 && (bIgnoreHidden==0 || IsHiddenColumn(&pSrc->a[i].pTab->aCol[iCol])==0) in tableAndColumnIndex()
496 Table *pRightTab = pRight->pTab; in sqlite3ProcessJoin()
499 if( NEVER(pLeft->pTab==0 || pRightTab==0) ) continue; in sqlite3ProcessJoin()
1032 Table *pTab; in selectExprDefer() local
1036 && (pTab = pExpr->y.pTab)!=0 in selectExprDefer()
1037 && IsOrdinaryTable(pTab) in selectExprDefer()
1038 && (pTab->aCol[pExpr->iColumn].colFlags & COLFLAG_SORTERREF)!=0 in selectExprDefer()
1051 if( !HasRowid(pTab) ){ in selectExprDefer()
1052 pPk = sqlite3PrimaryKeyIndex(pTab); in selectExprDefer()
1060 pNew->y.pTab = pExpr->y.pTab; in selectExprDefer()
1065 pSort->aDefer[nDefer].pTab = pExpr->y.pTab; in selectExprDefer()
1661 Table *pTab = pSort->aDefer[i].pTab; in generateSortTail() local
1662 int iDb = sqlite3SchemaToIndex(pParse->db, pTab->pSchema); in generateSortTail()
1663 sqlite3OpenTable(pParse, pSort->aDefer[i].iCsr, iDb, pTab, OP_OpenRead); in generateSortTail()
1721 Table *pTab = pSort->aDefer[i].pTab; in generateSortTail() local
1725 if( HasRowid(pTab) ){ in generateSortTail()
1732 assert( sqlite3PrimaryKeyIndex(pTab)->nKeyCol==nKey ); in generateSortTail()
1880 Table *pTab = 0; /* Table structure column is extracted from */ in columnTypeImpl() local
1883 while( pNC && !pTab ){ in columnTypeImpl()
1887 pTab = pTabList->a[j].pTab; in columnTypeImpl()
1894 if( pTab==0 ){ in columnTypeImpl()
1915 assert( pTab && ExprUseYTab(pExpr) && pExpr->y.pTab==pTab ); in columnTypeImpl()
1943 if( iCol<0 ) iCol = pTab->iPKey; in columnTypeImpl()
1944 assert( iCol==XN_ROWID || (iCol>=0 && iCol<pTab->nCol) ); in columnTypeImpl()
1949 zOrigCol = pTab->aCol[iCol].zCnName; in columnTypeImpl()
1950 zType = sqlite3ColumnType(&pTab->aCol[iCol],0); in columnTypeImpl()
1952 zOrigTab = pTab->zName; in columnTypeImpl()
1953 if( pNC->pParse && pTab->pSchema ){ in columnTypeImpl()
1954 int iDb = sqlite3SchemaToIndex(pNC->pParse->db, pTab->pSchema); in columnTypeImpl()
1958 assert( iCol==XN_ROWID || (iCol>=0 && iCol<pTab->nCol) ); in columnTypeImpl()
1962 zType = sqlite3ColumnType(&pTab->aCol[iCol],0); in columnTypeImpl()
2077 Table *pTab; in sqlite3GenerateColumnNames() local
2109 || (ExprUseYTab(p) && p->y.pTab!=0) ); /* Covering idx not yet coded */ in sqlite3GenerateColumnNames()
2117 pTab = p->y.pTab; in sqlite3GenerateColumnNames()
2118 assert( pTab!=0 ); in sqlite3GenerateColumnNames()
2119 if( iCol<0 ) iCol = pTab->iPKey; in sqlite3GenerateColumnNames()
2120 assert( iCol==-1 || (iCol>=0 && iCol<pTab->nCol) ); in sqlite3GenerateColumnNames()
2124 zCol = pTab->aCol[iCol].zCnName; in sqlite3GenerateColumnNames()
2128 zName = sqlite3MPrintf(db, "%s.%s", pTab->zName, zCol); in sqlite3GenerateColumnNames()
2178 Table *pTab; in sqlite3ColumnsFromExprList() local
2209 && ALWAYS( pColExpr->y.pTab!=0 ) in sqlite3ColumnsFromExprList()
2213 pTab = pColExpr->y.pTab; in sqlite3ColumnsFromExprList()
2214 if( iCol<0 ) iCol = pTab->iPKey; in sqlite3ColumnsFromExprList()
2215 zName = iCol>=0 ? pTab->aCol[iCol].zCnName : "rowid"; in sqlite3ColumnsFromExprList()
2282 Table *pTab, /* Add column type information to this table */ in sqlite3SelectAddColumnTypeAndCollation() argument
2296 assert( pTab->nCol==pSelect->pEList->nExpr || db->mallocFailed ); in sqlite3SelectAddColumnTypeAndCollation()
2301 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){ in sqlite3SelectAddColumnTypeAndCollation()
2304 pTab->tabFlags |= (pCol->colFlags & COLFLAG_NOINSERT); in sqlite3SelectAddColumnTypeAndCollation()
2324 assert( pTab->pIndex==0 ); in sqlite3SelectAddColumnTypeAndCollation()
2328 pTab->szTabRow = 1; /* Any non-zero value works */ in sqlite3SelectAddColumnTypeAndCollation()
2336 Table *pTab; in sqlite3ResultSetOfSelect() local
2347 pTab = sqlite3DbMallocZero(db, sizeof(Table) ); in sqlite3ResultSetOfSelect()
2348 if( pTab==0 ){ in sqlite3ResultSetOfSelect()
2351 pTab->nTabRef = 1; in sqlite3ResultSetOfSelect()
2352 pTab->zName = 0; in sqlite3ResultSetOfSelect()
2353 pTab->nRowLogEst = 200; assert( 200==sqlite3LogEst(1048576) ); in sqlite3ResultSetOfSelect()
2354 sqlite3ColumnsFromExprList(pParse, pSelect->pEList, &pTab->nCol, &pTab->aCol); in sqlite3ResultSetOfSelect()
2355 sqlite3SelectAddColumnTypeAndCollation(pParse, pTab, pSelect, aff); in sqlite3ResultSetOfSelect()
2356 pTab->iPKey = -1; in sqlite3ResultSetOfSelect()
2358 sqlite3DeleteTable(db, pTab); in sqlite3ResultSetOfSelect()
2361 return pTab; in sqlite3ResultSetOfSelect()
3934 if( NEVER(pSrcItem->pTab==0) ) return; in recomputeColumnsUsed()
4310 || IsVirtual(pSubSrc->a[0].pTab) /* (3b) */ in flattenSubquery()
4456 Table *pItemTab = pSubitem->pTab; in flattenSubquery()
4457 pSubitem->pTab = 0; in flattenSubquery()
4465 pSubitem->pTab = pItemTab; in flattenSubquery()
4495 if( ALWAYS(pSubitem->pTab!=0) ){ in flattenSubquery()
4496 Table *pTabToDel = pSubitem->pTab; in flattenSubquery()
4506 pSubitem->pTab = 0; in flattenSubquery()
5210 Table *pTab; in isSimpleCount() local
5224 pTab = p->pSrc->a[0].pTab; in isSimpleCount()
5225 assert( pTab!=0 ); in isSimpleCount()
5226 assert( !IsView(pTab) ); in isSimpleCount()
5227 if( !IsOrdinaryTable(pTab) ) return 0; in isSimpleCount()
5238 return pTab; in isSimpleCount()
5249 Table *pTab = pFrom->pTab; in sqlite3IndexedByLookup() local
5252 assert( pTab!=0 ); in sqlite3IndexedByLookup()
5255 for(pIdx=pTab->pIndex; in sqlite3IndexedByLookup()
5452 assert( pFrom->pTab==0 ); in resolveFromTermToCte()
5478 Table *pTab; in resolveFromTermToCte() local
5498 assert( pFrom->pTab==0 ); in resolveFromTermToCte()
5499 pTab = sqlite3DbMallocZero(db, sizeof(Table)); in resolveFromTermToCte()
5500 if( pTab==0 ) return 2; in resolveFromTermToCte()
5507 sqlite3DbFree(db, pTab); in resolveFromTermToCte()
5512 pFrom->pTab = pTab; in resolveFromTermToCte()
5513 pTab->nTabRef = 1; in resolveFromTermToCte()
5514 pTab->zName = sqlite3DbStrDup(db, pCte->zName); in resolveFromTermToCte()
5515 pTab->iPKey = -1; in resolveFromTermToCte()
5516 pTab->nRowLogEst = 200; assert( 200==sqlite3LogEst(1048576) ); in resolveFromTermToCte()
5517 pTab->tabFlags |= TF_Ephemeral | TF_NoVisibleRowid; in resolveFromTermToCte()
5546 pItem->pTab = pTab; in resolveFromTermToCte()
5547 pTab->nTabRef++; in resolveFromTermToCte()
5602 sqlite3ColumnsFromExprList(pParse, pEList, &pTab->nCol, &pTab->aCol); in resolveFromTermToCte()
5649 Table *pTab; in sqlite3ExpandSubquery() local
5652 pFrom->pTab = pTab = sqlite3DbMallocZero(pParse->db, sizeof(Table)); in sqlite3ExpandSubquery()
5653 if( pTab==0 ) return SQLITE_NOMEM; in sqlite3ExpandSubquery()
5654 pTab->nTabRef = 1; in sqlite3ExpandSubquery()
5656 pTab->zName = sqlite3DbStrDup(pParse->db, pFrom->zAlias); in sqlite3ExpandSubquery()
5658 pTab->zName = sqlite3MPrintf(pParse->db, "%!S", pFrom); in sqlite3ExpandSubquery()
5661 sqlite3ColumnsFromExprList(pParse, pSel->pEList,&pTab->nCol,&pTab->aCol); in sqlite3ExpandSubquery()
5662 pTab->iPKey = -1; in sqlite3ExpandSubquery()
5663 pTab->nRowLogEst = 200; assert( 200==sqlite3LogEst(1048576) ); in sqlite3ExpandSubquery()
5666 pTab->tabFlags |= TF_Ephemeral | TF_NoVisibleRowid; in sqlite3ExpandSubquery()
5668 pTab->tabFlags |= TF_Ephemeral; /* Legacy compatibility mode */ in sqlite3ExpandSubquery()
5769 Table *pTab; in selectExpander() local
5770 assert( pFrom->fg.isRecursive==0 || pFrom->pTab!=0 ); in selectExpander()
5771 if( pFrom->pTab ) continue; in selectExpander()
5778 assert( pFrom->pTab==0 ); in selectExpander()
5785 pTab = pFrom->pTab; in selectExpander()
5786 assert( pTab!=0 ); in selectExpander()
5790 assert( pFrom->pTab==0 ); in selectExpander()
5791 pFrom->pTab = pTab = sqlite3LocateTableItem(pParse, 0, pFrom); in selectExpander()
5792 if( pTab==0 ) return WRC_Abort; in selectExpander()
5793 if( pTab->nTabRef>=0xffff ){ in selectExpander()
5795 pTab->zName); in selectExpander()
5796 pFrom->pTab = 0; in selectExpander()
5799 pTab->nTabRef++; in selectExpander()
5800 if( !IsVirtual(pTab) && cannotBeFunction(pParse, pFrom) ){ in selectExpander()
5804 if( !IsOrdinaryTable(pTab) ){ in selectExpander()
5807 if( sqlite3ViewGetColumnNames(pParse, pTab) ) return WRC_Abort; in selectExpander()
5809 if( IsView(pTab) ){ in selectExpander()
5811 && pTab->pSchema!=db->aDb[1].pSchema in selectExpander()
5814 pTab->zName); in selectExpander()
5816 pFrom->pSelect = sqlite3SelectDup(db, pTab->u.view.pSelect, 0); in selectExpander()
5819 else if( ALWAYS(IsVirtual(pTab)) in selectExpander()
5821 && ALWAYS(pTab->u.vtab.p!=0) in selectExpander()
5822 && pTab->u.vtab.p->eVtabRisk > ((db->flags & SQLITE_TrustedSchema)!=0) in selectExpander()
5825 pTab->zName); in selectExpander()
5829 nCol = pTab->nCol; in selectExpander()
5830 pTab->nCol = -1; in selectExpander()
5834 pTab->nCol = nCol; in selectExpander()
5911 Table *pTab = pFrom->pTab; /* Table for this data source */ in selectExpander() local
5919 zTabName = pTab->zName; in selectExpander()
5927 assert( pNestedFrom->nExpr==pTab->nCol ); in selectExpander()
5933 iDb = sqlite3SchemaToIndex(db, pTab->pSchema); in selectExpander()
5957 for(j=0; j<pTab->nCol; j++){ in selectExpander()
5958 char *zName = pTab->aCol[j].zCnName; in selectExpander()
5974 && IsHiddenColumn(&pTab->aCol[j]) in selectExpander()
5978 if( (pTab->aCol[j].colFlags & COLFLAG_NOEXPAND)!=0 in selectExpander()
6036 || (pTab->aCol[j].colFlags & COLFLAG_NOEXPAND)!=0 in selectExpander()
6144 Table *pTab = pFrom->pTab; in selectAddSubqueryTypeInfo() local
6145 assert( pTab!=0 ); in selectAddSubqueryTypeInfo()
6146 if( (pTab->tabFlags & TF_Ephemeral)!=0 ){ in selectAddSubqueryTypeInfo()
6151 sqlite3SelectAddColumnTypeAndCollation(pParse, pTab, pSel, in selectAddSubqueryTypeInfo()
6388 Table *pTab, /* Table being queried */ in explainSimpleCount() argument
6392 int bCover = (pIdx!=0 && (HasRowid(pTab) || !IsPrimaryKeyIndex(pIdx))); in explainSimpleCount()
6394 pTab->zName, in explainSimpleCount()
6491 assert( pItem->pTab!=0 ); in isSelfJoinView()
6492 assert( pThis->pTab!=0 ); in isSelfJoinView()
6493 if( pItem->pTab->pSchema!=pThis->pTab->pSchema ) continue; in isSelfJoinView()
6496 if( pItem->pTab->pSchema==0 && pThis->pSelect->selId!=pS1->selId ){ in isSelfJoinView()
6619 if( p0->pTab==p1->pTab && 0==sqlite3_stricmp(p0->zAlias, p1->zAlias) ){ in sameSrcAlias()
6739 p0->zAlias ? p0->zAlias : p0->pTab->zName in sqlite3Select()
6779 Table *pTab = pItem->pTab; in sqlite3Select() local
6784 assert( pTab!=0 ); in sqlite3Select()
6806 if( pTab->nCol!=pSub->pEList->nExpr ){ in sqlite3Select()
6808 pTab->nCol, pTab->zName, pSub->pEList->nExpr); in sqlite3Select()
7046 pItem->pTab->nRowLogEst = pSub->nSelectRow; in sqlite3Select()
7094 dest.zAffSdst = sqlite3TableAffinityStr(db, pItem->pTab); in sqlite3Select()
7098 pItem->pTab->nRowLogEst = pSub->nSelectRow; in sqlite3Select()
7443 ii, pCol->pTab ? pCol->pTab->zName : "NULL", in sqlite3Select()
7712 Table *pTab; in sqlite3Select() local
7713 if( (pTab = isSimpleCount(p, pAggInfo))!=0 ){ in sqlite3Select()
7727 const int iDb = sqlite3SchemaToIndex(pParse->db, pTab->pSchema); in sqlite3Select()
7732 Pgno iRoot = pTab->tnum; /* Root page of scanned b-tree */ in sqlite3Select()
7735 sqlite3TableLock(pParse, iDb, pTab->tnum, 0, pTab->zName); in sqlite3Select()
7746 if( !HasRowid(pTab) ) pBest = sqlite3PrimaryKeyIndex(pTab); in sqlite3Select()
7748 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3Select()
7750 && pIdx->szIdxRow<pTab->szTabRow in sqlite3Select()
7770 explainSimpleCount(pParse, pTab, pBest); in sqlite3Select()