Lines Matching refs:pTable
17158 Table *pTable; /* The SQL table being indexed */ member
63400 iTab = pIdx->pTable->tnum;
100196 sqlite3ExprCodeGetColumnOfTable(pParse->pVdbe, pIdx->pTable, iTabCur,
105216 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
105419 analyzeTable(pParse, pIdx->pTable, pIdx);
105498 pIndex->pTable->costMult = sqlite3LogEst(sqlite3Atoi(z+9));
105521 Table *pTable;
105530 pTable = sqlite3FindTable(pInfo->db, argv[0], pInfo->zDatabase);
105531 if( pTable==0 ){
105537 pIndex = sqlite3PrimaryKeyIndex(pTable);
105560 pTable->nRowLogEst = pIndex->aiRowLogEst[0];
105561 pTable->tabFlags |= TF_HasStat1;
105565 fakeIdx.szIdxRow = pTable->szTabRow;
105567 fakeIdx.pTable = pTable;
105569 decodeIntArray((char*)z, 1, 0, &pTable->nRowLogEst, &fakeIdx);
105570 pTable->szTabRow = fakeIdx.szIdxRow;
105571 pTable->tabFlags |= TF_HasStat1;
105732 assert( !HasRowid(pIdx->pTable) || pIdx->nColumn==pIdx->nKeyCol+1 );
105733 if( !HasRowid(pIdx->pTable) && IsPrimaryKeyIndex(pIdx) ){
107320 if( pIndex->pTable->pIndex==pIndex ){
107321 pIndex->pTable->pIndex = pIndex->pNext;
107326 p = pIndex->pTable->pIndex;
107428 SQLITE_PRIVATE void sqlite3DeleteColumnNames(sqlite3 *db, Table *pTable){
107431 assert( pTable!=0 );
107432 if( (pCol = pTable->aCol)!=0 ){
107433 for(i=0; i<pTable->nCol; i++, pCol++){
107438 sqlite3DbFree(db, pTable->aCol);
107457 static void SQLITE_NOINLINE deleteTable(sqlite3 *db, Table *pTable){
107465 if( db && (pTable->tabFlags & TF_Ephemeral)==0 ){
107471 for(pIndex = pTable->pIndex; pIndex; pIndex=pNext){
107473 assert( pIndex->pSchema==pTable->pSchema
107474 || (IsVirtual(pTable) && pIndex->idxType!=SQLITE_IDXTYPE_APPDEF) );
107475 if( (db==0 || db->pnBytesFreed==0) && !IsVirtual(pTable) ){
107487 sqlite3FkDelete(db, pTable);
107491 sqlite3DeleteColumnNames(db, pTable);
107492 sqlite3DbFree(db, pTable->zName);
107493 sqlite3DbFree(db, pTable->zColAff);
107494 sqlite3SelectDelete(db, pTable->pSelect);
107495 sqlite3ExprListDelete(db, pTable->pCheck);
107497 sqlite3VtabClear(db, pTable);
107499 sqlite3DbFree(db, pTable);
107504 SQLITE_PRIVATE void sqlite3DeleteTable(sqlite3 *db, Table *pTable){
107506 if( !pTable ) return;
107507 if( ((!db || db->pnBytesFreed==0) && (--pTable->nTabRef)>0) ) return;
107508 deleteTable(db, pTable);
107726 Table *pTable;
107793 pTable = sqlite3FindTable(db, zName, zDb);
107794 if( pTable ){
107809 pTable = sqlite3DbMallocZero(db, sizeof(Table));
107810 if( pTable==0 ){
107816 pTable->zName = zName;
107817 pTable->iPKey = -1;
107818 pTable->pSchema = db->aDb[iDb].pSchema;
107819 pTable->nTabRef = 1;
107821 pTable->nRowLogEst = sqlite3LogEst(SQLITE_DEFAULT_ROWEST);
107823 pTable->nRowLogEst = 200; assert( 200==sqlite3LogEst(1048576) );
107826 pParse->pNewTable = pTable;
107835 pTable->pSchema->pSeqTab = pTable;
108561 const Column *aCol = pIdx->pTable->aCol;
108564 assert( x<pIdx->pTable->nCol );
109134 SQLITE_PRIVATE int sqlite3ViewGetColumnNames(Parse *pParse, Table *pTable){
109147 assert( pTable );
109151 rc = sqlite3VtabCallConnect(pParse, pTable);
109156 if( IsVirtual(pTable) ) return 0;
109163 if( pTable->nCol>0 ) return 0;
109180 if( pTable->nCol<0 ){
109181 sqlite3ErrorMsg(pParse, "view %s is circularly defined", pTable->zName);
109184 assert( pTable->nCol>=0 );
109193 assert( pTable->pSelect );
109194 pSel = sqlite3SelectDup(db, pTable->pSelect, 0);
109202 pTable->nCol = -1;
109213 if( pTable->pCheck ){
109220 sqlite3ColumnsFromExprList(pParse, pTable->pCheck,
109221 &pTable->nCol, &pTable->aCol);
109224 && pTable->nCol==pSel->pEList->nExpr
109226 sqlite3SelectAddColumnTypeAndCollation(pParse, pTable, pSel);
109232 assert( pTable->aCol==0 );
109233 pTable->nCol = pSelTab->nCol;
109234 pTable->aCol = pSelTab->aCol;
109237 assert( sqlite3SchemaMutexHeld(db, 0, pTable->pSchema) );
109239 pTable->nCol = 0;
109251 pTable->pSchema->schemaFlags |= DB_UnresetViews;
109253 sqlite3DeleteColumnNames(db, pTable);
109254 pTable->aCol = 0;
109255 pTable->nCol = 0;
109775 Table *pTab = pIndex->pTable; /* The table that is indexed */
110139 pIndex->pTable = pTab;
110504 a[0] = pIdx->pTable->nRowLogEst;
110556 Table *pTab = pIndex->pTable;
110809 Token *pTable, /* Table to append */
110814 assert( pDatabase==0 || pTable!=0 ); /* Cannot have C without B */
110840 pItem->zDatabase = sqlite3NameFromToken(db, pTable);
110842 pItem->zName = sqlite3NameFromToken(db, pTable);
110906 Token *pTable, /* Name of the table to add to the FROM clause */
110921 p = sqlite3SrcListAppend(pParse, p, pTable, pDatabase);
110927 assert( (pTable==0)==(pDatabase==0) );
110930 Token *pToken = (ALWAYS(pDatabase) && pDatabase->z) ? pDatabase : pTable;
111239 Table *pTab = pIdx->pTable;
112969 if( pIdx->pTable->pSelect ){
115581 assert( pIdx==0 || pIdx->pTable==pTab );
116536 Table *pTab = pIdx->pTable;
118126 sqlite3SetMakeRecordP5(v, pIdx->pTable);
118521 assert( pDest->pTable!=pSrc->pTable );
122359 pTab = pIdx->pTable;
123743 for(p=pIndex->pTable->pIndex; p; p=p->pNext){
132052 Table *pTable;
132059 pTable = tableOfTrigger(pTrigger);
132060 assert( pTable );
132061 assert( pTable->pSchema==pTrigger->pSchema || iDb==1 );
132068 if( sqlite3AuthCheck(pParse, code, pTrigger->zName, pTable->zName, zDb) ||
132077 assert( pTable!=0 );
134602 static void addModuleArgument(Parse *pParse, Table *pTable, char *zArg){
134603 sqlite3_int64 nBytes = sizeof(char *)*(2+pTable->nModuleArg);
134606 if( pTable->nModuleArg+3>=db->aLimit[SQLITE_LIMIT_COLUMN] ){
134607 sqlite3ErrorMsg(pParse, "too many columns on %s", pTable->zName);
134609 azModuleArg = sqlite3DbRealloc(db, pTable->azModuleArg, nBytes);
134613 int i = pTable->nModuleArg++;
134616 pTable->azModuleArg = azModuleArg;
134632 Table *pTable; /* The new virtual table */
134636 pTable = pParse->pNewTable;
134637 if( pTable==0 ) return;
134638 assert( 0==pTable->pIndex );
134642 assert( pTable->nModuleArg==0 );
134643 addModuleArgument(pParse, pTable, sqlite3NameFromToken(db, pModuleName));
134644 addModuleArgument(pParse, pTable, 0);
134645 addModuleArgument(pParse, pTable, sqlite3DbStrDup(db, pTable->zName));
134659 if( pTable->azModuleArg ){
134660 int iDb = sqlite3SchemaToIndex(db, pTable->pSchema);
134662 sqlite3AuthCheck(pParse, SQLITE_CREATE_VTABLE, pTable->zName,
134663 pTable->azModuleArg[0], pParse->db->aDb[iDb].zDbSName);
135094 pIdx->pTable = pTab;
136174 return pIdx->pTable->aCol[i].zName;
137193 Table *pTab = pIdx->pTable;
137752 if( (j>=0 && pIdx->pTable->aCol[j].notNull==0) || j==XN_EXPR ){
137899 }else if( HasRowid(pIdx->pTable) ){
137912 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
140404 }else if( iColumn==pIdx->pTable->iPKey ){
140407 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
140511 return pIdx->pTable->aCol[j].notNull;
140735 Table *pTable; /* The table being indexed */
140762 pTable = pSrc->pTab;
140785 "automatic index on %s(%s)", pTable->zName,
140786 pTable->aCol[iCol].zName);
140812 mxBitCol = MIN(BMS-1,pTable->nCol);
140813 testcase( pTable->nCol==BMS-1 );
140814 testcase( pTable->nCol==BMS-2 );
140819 nKeyCol += pTable->nCol - BMS + 1;
140827 pIdx->pTable = pTable;
140858 for(i=BMS-1; i<pTable->nCol; i++){
140873 VdbeComment((v, "for %s", pTable->zName));
142399 idxaff = sqlite3TableColumnAffinity(pIdx->pTable, pLhs->iColumn);
142460 pProbe->pTable->zName,pProbe->zName, pNew->u.btree.nEq));
142712 ApplyCostMultiplier(pNew->rRun, pProbe->pTable->costMult);
142781 pProbe->pTable->zName, pProbe->zName, saved_nEq, rc));
142927 sPk.pTable = pTab;
143779 assert( nColumn==nKeyCol+1 || !HasRowid(pIndex->pTable) );
143781 || !HasRowid(pIndex->pTable));
143835 if( iColumn==pIndex->pTable->iPKey ) iColumn = XN_ROWID;
143847 && pIndex->pTable->aCol[iColumn].notNull==0
145353 && (pWInfo->eOnePass==ONEPASS_OFF || !HasRowid(pIdx->pTable))
145372 assert( pIdx->pTable==pTab );
195085 SessionTable *pTable; /* List of attached tables */
196335 for(pRet=pSession->pTable; pRet; pRet=pRet->pNext){
196347 for(pRet=pSession->pTable; pRet->pNext; pRet=pRet->pNext);
196785 sessionDeleteTable(pSession->pTable);
196828 for(pTab=pSession->pTable; pTab; pTab=pTab->pNext){
196847 for(ppTab=&pSession->pTable; *ppTab; ppTab=&(*ppTab)->pNext);
197419 for(pTab=pSession->pTable; rc==SQLITE_OK && pTab; pTab=pTab->pNext){
197598 for(pTab=pSession->pTable; pTab && ret==0; pTab=pTab->pNext){
