Lines Matching refs:pTable
17753 Table *pTable; /* The SQL table being indexed */ member
64538 iTab = pIdx->pTable->tnum;
102977 sqlite3ExprCodeGetColumnOfTable(pParse->pVdbe, pIdx->pTable, iTabCur,
108440 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
108653 analyzeTable(pParse, pIdx->pTable, pIdx);
108734 pIndex->pTable->costMult = sqlite3LogEst(sqlite3Atoi(z+9));
108757 Table *pTable;
108766 pTable = sqlite3FindTable(pInfo->db, argv[0], pInfo->zDatabase);
108767 if( pTable==0 ){
108773 pIndex = sqlite3PrimaryKeyIndex(pTable);
108796 pTable->nRowLogEst = pIndex->aiRowLogEst[0];
108797 pTable->tabFlags |= TF_HasStat1;
108801 fakeIdx.szIdxRow = pTable->szTabRow;
108803 fakeIdx.pTable = pTable;
108805 decodeIntArray((char*)z, 1, 0, &pTable->nRowLogEst, &fakeIdx);
108806 pTable->szTabRow = fakeIdx.szIdxRow;
108807 pTable->tabFlags |= TF_HasStat1;
108963 assert( !HasRowid(pIdx->pTable) || pIdx->nColumn==pIdx->nKeyCol+1 );
108964 if( !HasRowid(pIdx->pTable) && IsPrimaryKeyIndex(pIdx) ){
110544 if( pIndex->pTable->pIndex==pIndex ){
110545 pIndex->pTable->pIndex = pIndex->pNext;
110550 p = pIndex->pTable->pIndex;
110652 SQLITE_PRIVATE void sqlite3DeleteColumnNames(sqlite3 *db, Table *pTable){
110655 assert( pTable!=0 );
110656 if( (pCol = pTable->aCol)!=0 ){
110657 for(i=0; i<pTable->nCol; i++, pCol++){
110663 sqlite3DbFree(db, pTable->aCol);
110682 static void SQLITE_NOINLINE deleteTable(sqlite3 *db, Table *pTable){
110694 if( db && !db->mallocFailed && (pTable->tabFlags & TF_Ephemeral)==0 ){
110700 for(pIndex = pTable->pIndex; pIndex; pIndex=pNext){
110702 assert( pIndex->pSchema==pTable->pSchema
110703 || (IsVirtual(pTable) && pIndex->idxType!=SQLITE_IDXTYPE_APPDEF) );
110704 if( (db==0 || db->pnBytesFreed==0) && !IsVirtual(pTable) ){
110716 sqlite3FkDelete(db, pTable);
110720 sqlite3DeleteColumnNames(db, pTable);
110721 sqlite3DbFree(db, pTable->zName);
110722 sqlite3DbFree(db, pTable->zColAff);
110723 sqlite3SelectDelete(db, pTable->pSelect);
110724 sqlite3ExprListDelete(db, pTable->pCheck);
110726 sqlite3VtabClear(db, pTable);
110728 sqlite3DbFree(db, pTable);
110733 SQLITE_PRIVATE void sqlite3DeleteTable(sqlite3 *db, Table *pTable){
110735 if( !pTable ) return;
110736 if( ((!db || db->pnBytesFreed==0) && (--pTable->nTabRef)>0) ) return;
110737 deleteTable(db, pTable);
111063 Table *pTable;
111130 pTable = sqlite3FindTable(db, zName, zDb);
111131 if( pTable ){
111146 pTable = sqlite3DbMallocZero(db, sizeof(Table));
111147 if( pTable==0 ){
111153 pTable->zName = zName;
111154 pTable->iPKey = -1;
111155 pTable->pSchema = db->aDb[iDb].pSchema;
111156 pTable->nTabRef = 1;
111158 pTable->nRowLogEst = sqlite3LogEst(SQLITE_DEFAULT_ROWEST);
111160 pTable->nRowLogEst = 200; assert( 200==sqlite3LogEst(1048576) );
111163 pParse->pNewTable = pTable;
111172 pTable->pSchema->pSeqTab = pTable;
111940 const Column *aCol = pIdx->pTable->aCol;
111943 assert( x<pIdx->pTable->nCol );
111981 assert( pPk->pTable->tabFlags & TF_WithoutRowid );
111982 assert( pPk->pTable==pIdx->pTable );
112018 Table *pTab = pIdx->pTable;
112662 SQLITE_PRIVATE int sqlite3ViewGetColumnNames(Parse *pParse, Table *pTable){
112675 assert( pTable );
112679 rc = sqlite3VtabCallConnect(pParse, pTable);
112684 if( IsVirtual(pTable) ) return 0;
112691 if( pTable->nCol>0 ) return 0;
112708 if( pTable->nCol<0 ){
112709 sqlite3ErrorMsg(pParse, "view %s is circularly defined", pTable->zName);
112712 assert( pTable->nCol>=0 );
112721 assert( pTable->pSelect );
112722 pSel = sqlite3SelectDup(db, pTable->pSelect, 0);
112730 pTable->nCol = -1;
112742 pTable->nCol = 0;
112744 }else if( pTable->pCheck ){
112751 sqlite3ColumnsFromExprList(pParse, pTable->pCheck,
112752 &pTable->nCol, &pTable->aCol);
112755 && pTable->nCol==pSel->pEList->nExpr
112757 sqlite3SelectAddColumnTypeAndCollation(pParse, pTable, pSel,
112764 assert( pTable->aCol==0 );
112765 pTable->nCol = pSelTab->nCol;
112766 pTable->aCol = pSelTab->aCol;
112769 assert( sqlite3SchemaMutexHeld(db, 0, pTable->pSchema) );
112771 pTable->nNVCol = pTable->nCol;
112781 pTable->pSchema->schemaFlags |= DB_UnresetViews;
112783 sqlite3DeleteColumnNames(db, pTable);
112784 pTable->aCol = 0;
112785 pTable->nCol = 0;
113335 Table *pTab = pIndex->pTable; /* The table that is indexed */
113740 pIndex->pTable = pTab;
114110 a[0] = pIdx->pTable->nRowLogEst;
114162 Table *pTab = pIndex->pTable;
114415 Token *pTable, /* Table to append */
114420 assert( pDatabase==0 || pTable!=0 ); /* Cannot have C without B */
114446 pItem->zDatabase = sqlite3NameFromToken(db, pTable);
114448 pItem->zName = sqlite3NameFromToken(db, pTable);
114512 Token *pTable, /* Name of the table to add to the FROM clause */
114527 p = sqlite3SrcListAppend(pParse, p, pTable, pDatabase);
114533 assert( (pTable==0)==(pDatabase==0) );
114536 Token *pToken = (ALWAYS(pDatabase) && pDatabase->z) ? pDatabase : pTable;
114845 Table *pTab = pIdx->pTable;
116626 if( pIdx->pTable->pSelect ){
119115 iParent += sqlite3TableColumnToStorage(pIdx->pTable,
119266 assert( pIdx==0 || pIdx->pTable==pTab );
120232 Table *pTab = pIdx->pTable;
122136 sqlite3SetMakeRecordP5(v, pIdx->pTable);
122613 assert( pDest->pTable!=pSrc->pTable );
126581 pTab = pIdx->pTable;
127959 for(p=pIndex->pTable->pIndex; p; p=p->pNext){
136459 Table *pTable;
136466 pTable = tableOfTrigger(pTrigger);
136467 assert( (pTable && pTable->pSchema==pTrigger->pSchema) || iDb==1 );
136469 if( pTable ){
136474 if( sqlite3AuthCheck(pParse, code, pTrigger->zName, pTable->zName, zDb) ||
139143 static void addModuleArgument(Parse *pParse, Table *pTable, char *zArg){
139144 sqlite3_int64 nBytes = sizeof(char *)*(2+pTable->nModuleArg);
139147 if( pTable->nModuleArg+3>=db->aLimit[SQLITE_LIMIT_COLUMN] ){
139148 sqlite3ErrorMsg(pParse, "too many columns on %s", pTable->zName);
139150 azModuleArg = sqlite3DbRealloc(db, pTable->azModuleArg, nBytes);
139154 int i = pTable->nModuleArg++;
139157 pTable->azModuleArg = azModuleArg;
139173 Table *pTable; /* The new virtual table */
139177 pTable = pParse->pNewTable;
139178 if( pTable==0 ) return;
139179 assert( 0==pTable->pIndex );
139183 assert( pTable->nModuleArg==0 );
139184 addModuleArgument(pParse, pTable, sqlite3NameFromToken(db, pModuleName));
139185 addModuleArgument(pParse, pTable, 0);
139186 addModuleArgument(pParse, pTable, sqlite3DbStrDup(db, pTable->zName));
139200 if( pTable->azModuleArg ){
139201 int iDb = sqlite3SchemaToIndex(db, pTable->pSchema);
139203 sqlite3AuthCheck(pParse, SQLITE_CREATE_VTABLE, pTable->zName,
139204 pTable->azModuleArg[0], pParse->db->aDb[iDb].zDbSName);
139639 pIdx->pTable = pTab;
140766 return pIdx->pTable->aCol[i].zName;
141788 Table *pTab = pIdx->pTable;
141937 pTab = pIdx->pTable;
142425 if( (j>=0 && pIdx->pTable->aCol[j].notNull==0) || j==XN_EXPR ){
142645 }else if( HasRowid(pIdx->pTable) ){
142658 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
145200 }else if( iColumn==pIdx->pTable->iPKey ){
145203 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
145307 return pIdx->pTable->aCol[j].notNull;
145529 Table *pTable; /* The table being indexed */
145556 pTable = pSrc->pTab;
145579 "automatic index on %s(%s)", pTable->zName,
145580 pTable->aCol[iCol].zName);
145606 mxBitCol = MIN(BMS-1,pTable->nCol);
145607 testcase( pTable->nCol==BMS-1 );
145608 testcase( pTable->nCol==BMS-2 );
145613 nKeyCol += pTable->nCol - BMS + 1;
145621 pIdx->pTable = pTable;
145653 for(i=BMS-1; i<pTable->nCol; i++){
145668 VdbeComment((v, "for %s", pTable->zName));
147202 idxaff = sqlite3TableColumnAffinity(pIdx->pTable, pLhs->iColumn);
147263 pProbe->pTable->zName,pProbe->zName,
147536 ApplyCostMultiplier(pNew->rRun, pProbe->pTable->costMult);
147607 pProbe->pTable->zName, pProbe->zName, saved_nEq, rc));
147760 sPk.pTable = pTab;
148627 assert( nColumn==nKeyCol+1 || !HasRowid(pIndex->pTable) );
148629 || !HasRowid(pIndex->pTable));
148690 if( iColumn==pIndex->pTable->iPKey ) iColumn = XN_ROWID;
148702 && pIndex->pTable->aCol[iColumn].notNull==0
150296 && (pWInfo->eOnePass==ONEPASS_OFF || !HasRowid(pIdx->pTable))
150315 assert( pIdx->pTable==pTab );
201595 SessionTable *pTable; /* List of attached tables */
202845 for(pRet=pSession->pTable; pRet; pRet=pRet->pNext){
202857 for(pRet=pSession->pTable; pRet->pNext; pRet=pRet->pNext);
203297 sessionDeleteTable(pSession->pTable);
203340 for(pTab=pSession->pTable; pTab; pTab=pTab->pNext){
203359 for(ppTab=&pSession->pTable; *ppTab; ppTab=&(*ppTab)->pNext);
203931 for(pTab=pSession->pTable; rc==SQLITE_OK && pTab; pTab=pTab->pNext){
204110 for(pTab=pSession->pTable; pTab && ret==0; pTab=pTab->pNext){