Lines Matching refs:pTable
17506 Table *pTable; /* The SQL table being indexed */ member
65798 iTab = pIdx->pTable->tnum;
105319 sqlite3ExprCodeGetColumnOfTable(pParse->pVdbe, pIdx->pTable, iTabCur,
111179 VdbeComment((v,"%s.%s", pIdx->zName, pIdx->pTable->aCol[i].zCnName));
111442 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
111655 analyzeTable(pParse, pIdx->pTable, pIdx);
111736 pIndex->pTable->costMult = sqlite3LogEst(sqlite3Atoi(z+9));
111759 Table *pTable;
111768 pTable = sqlite3FindTable(pInfo->db, argv[0], pInfo->zDatabase);
111769 if( pTable==0 ){
111775 pIndex = sqlite3PrimaryKeyIndex(pTable);
111798 pTable->nRowLogEst = pIndex->aiRowLogEst[0];
111799 pTable->tabFlags |= TF_HasStat1;
111803 fakeIdx.szIdxRow = pTable->szTabRow;
111805 fakeIdx.pTable = pTable;
111807 decodeIntArray((char*)z, 1, 0, &pTable->nRowLogEst, &fakeIdx);
111808 pTable->szTabRow = fakeIdx.szIdxRow;
111809 pTable->tabFlags |= TF_HasStat1;
111965 assert( !HasRowid(pIdx->pTable) || pIdx->nColumn==pIdx->nKeyCol+1 );
111966 if( !HasRowid(pIdx->pTable) && IsPrimaryKeyIndex(pIdx) ){
111983 pIdx->pTable->tabFlags |= TF_HasStat4;
113626 if( pIndex->pTable->pIndex==pIndex ){
113627 pIndex->pTable->pIndex = pIndex->pNext;
113632 p = pIndex->pTable->pIndex;
113812 SQLITE_PRIVATE void sqlite3DeleteColumnNames(sqlite3 *db, Table *pTable){
113815 assert( pTable!=0 );
113816 if( (pCol = pTable->aCol)!=0 ){
113817 for(i=0; i<pTable->nCol; i++, pCol++){
113821 sqlite3DbFree(db, pTable->aCol);
113822 if( IsOrdinaryTable(pTable) ){
113823 sqlite3ExprListDelete(db, pTable->u.tab.pDfltList);
113826 pTable->aCol = 0;
113827 pTable->nCol = 0;
113828 if( IsOrdinaryTable(pTable) ){
113829 pTable->u.tab.pDfltList = 0;
113850 static void SQLITE_NOINLINE deleteTable(sqlite3 *db, Table *pTable){
113862 if( db && !db->mallocFailed && (pTable->tabFlags & TF_Ephemeral)==0 ){
113868 for(pIndex = pTable->pIndex; pIndex; pIndex=pNext){
113870 assert( pIndex->pSchema==pTable->pSchema
113871 || (IsVirtual(pTable) && pIndex->idxType!=SQLITE_IDXTYPE_APPDEF) );
113872 if( (db==0 || db->pnBytesFreed==0) && !IsVirtual(pTable) ){
113883 if( IsOrdinaryTable(pTable) ){
113884 sqlite3FkDelete(db, pTable);
113887 else if( IsVirtual(pTable) ){
113888 sqlite3VtabClear(db, pTable);
113892 assert( IsView(pTable) );
113893 sqlite3SelectDelete(db, pTable->u.view.pSelect);
113898 sqlite3DeleteColumnNames(db, pTable);
113899 sqlite3DbFree(db, pTable->zName);
113900 sqlite3DbFree(db, pTable->zColAff);
113901 sqlite3ExprListDelete(db, pTable->pCheck);
113902 sqlite3DbFree(db, pTable);
113907 SQLITE_PRIVATE void sqlite3DeleteTable(sqlite3 *db, Table *pTable){
113909 if( !pTable ) return;
113910 if( ((!db || db->pnBytesFreed==0) && (--pTable->nTabRef)>0) ) return;
113911 deleteTable(db, pTable);
114255 Table *pTable;
114322 pTable = sqlite3FindTable(db, zName, zDb);
114323 if( pTable ){
114339 pTable = sqlite3DbMallocZero(db, sizeof(Table));
114340 if( pTable==0 ){
114346 pTable->zName = zName;
114347 pTable->iPKey = -1;
114348 pTable->pSchema = db->aDb[iDb].pSchema;
114349 pTable->nTabRef = 1;
114351 pTable->nRowLogEst = sqlite3LogEst(SQLITE_DEFAULT_ROWEST);
114353 pTable->nRowLogEst = 200; assert( 200==sqlite3LogEst(1048576) );
114356 pParse->pNewTable = pTable;
115254 const Column *aCol = pIdx->pTable->aCol;
115257 assert( x<pIdx->pTable->nCol );
115294 assert( pPk->pTable->tabFlags & TF_WithoutRowid );
115295 assert( pPk->pTable==pIdx->pTable );
115331 Table *pTab = pIdx->pTable;
116076 SQLITE_PRIVATE int sqlite3ViewGetColumnNames(Parse *pParse, Table *pTable){
116089 assert( pTable );
116092 if( IsVirtual(pTable) ){
116094 rc = sqlite3VtabCallConnect(pParse, pTable);
116104 if( pTable->nCol>0 ) return 0;
116121 if( pTable->nCol<0 ){
116122 sqlite3ErrorMsg(pParse, "view %s is circularly defined", pTable->zName);
116125 assert( pTable->nCol>=0 );
116134 assert( IsView(pTable) );
116135 pSel = sqlite3SelectDup(db, pTable->u.view.pSelect, 0);
116141 pTable->nCol = -1;
116153 pTable->nCol = 0;
116155 }else if( pTable->pCheck ){
116162 sqlite3ColumnsFromExprList(pParse, pTable->pCheck,
116163 &pTable->nCol, &pTable->aCol);
116166 && pTable->nCol==pSel->pEList->nExpr
116168 sqlite3SelectAddColumnTypeAndCollation(pParse, pTable, pSel,
116175 assert( pTable->aCol==0 );
116176 pTable->nCol = pSelTab->nCol;
116177 pTable->aCol = pSelTab->aCol;
116178 pTable->tabFlags |= (pSelTab->tabFlags & COLFLAG_NOINSERT);
116181 assert( sqlite3SchemaMutexHeld(db, 0, pTable->pSchema) );
116183 pTable->nNVCol = pTable->nCol;
116191 pTable->pSchema->schemaFlags |= DB_UnresetViews;
116193 sqlite3DeleteColumnNames(db, pTable);
116754 Table *pTab = pIndex->pTable; /* The table that is indexed */
117158 pIndex->pTable = pTab;
117551 x = pIdx->pTable->nRowLogEst;
117554 pIdx->pTable->nRowLogEst = x = 99;
117608 Table *pTab = pIndex->pTable;
117861 Token *pTable, /* Table to append */
117866 assert( pDatabase==0 || pTable!=0 ); /* Cannot have C without B */
117892 pItem->zDatabase = sqlite3NameFromToken(db, pTable);
117894 pItem->zName = sqlite3NameFromToken(db, pTable);
117958 Token *pTable, /* Name of the table to add to the FROM clause */
117973 p = sqlite3SrcListAppend(pParse, p, pTable, pDatabase);
117979 assert( (pTable==0)==(pDatabase==0) );
117982 Token *pToken = (ALWAYS(pDatabase) && pDatabase->z) ? pDatabase : pTable;
118325 Table *pTab = pIdx->pTable;
122961 iParent += sqlite3TableColumnToStorage(pIdx->pTable,
123113 assert( pIdx==0 || pIdx->pTable==pTab );
124104 Table *pTab = pIdx->pTable;
126205 sqlite3SetMakeRecordP5(v, pIdx->pTable);
126706 assert( pDest->pTable!=pSrc->pTable );
130847 pTab = pIdx->pTable;
132290 for(p=pIndex->pTable->pIndex; p; p=p->pNext){
141636 Table *pTable;
141643 pTable = tableOfTrigger(pTrigger);
141644 assert( (pTable && pTable->pSchema==pTrigger->pSchema) || iDb==1 );
141646 if( pTable ){
141651 if( sqlite3AuthCheck(pParse, code, pTrigger->zName, pTable->zName, zDb) ||
144833 static void addModuleArgument(Parse *pParse, Table *pTable, char *zArg){
144838 assert( IsVirtual(pTable) );
144839 nBytes = sizeof(char *)*(2+pTable->u.vtab.nArg);
144840 if( pTable->u.vtab.nArg+3>=db->aLimit[SQLITE_LIMIT_COLUMN] ){
144841 sqlite3ErrorMsg(pParse, "too many columns on %s", pTable->zName);
144843 azModuleArg = sqlite3DbRealloc(db, pTable->u.vtab.azArg, nBytes);
144847 int i = pTable->u.vtab.nArg++;
144850 pTable->u.vtab.azArg = azModuleArg;
144866 Table *pTable; /* The new virtual table */
144870 pTable = pParse->pNewTable;
144871 if( pTable==0 ) return;
144872 assert( 0==pTable->pIndex );
144873 pTable->eTabType = TABTYP_VTAB;
144877 assert( pTable->u.vtab.nArg==0 );
144878 addModuleArgument(pParse, pTable, sqlite3NameFromToken(db, pModuleName));
144879 addModuleArgument(pParse, pTable, 0);
144880 addModuleArgument(pParse, pTable, sqlite3DbStrDup(db, pTable->zName));
144894 if( pTable->u.vtab.azArg ){
144895 int iDb = sqlite3SchemaToIndex(db, pTable->pSchema);
144897 sqlite3AuthCheck(pParse, SQLITE_CREATE_VTABLE, pTable->zName,
144898 pTable->u.vtab.azArg[0], pParse->db->aDb[iDb].zDbSName);
145342 pIdx->pTable = pTab;
146464 return pIdx->pTable->aCol[i].zCnName;
147517 Table *pTab = pIdx->pTable;
147668 pTab = pIdx->pTable;
148163 if( (j>=0 && pIdx->pTable->aCol[j].notNull==0) || j==XN_EXPR ){
148410 }else if( HasRowid(pIdx->pTable) ){
148413 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
151064 }else if( iColumn==pIdx->pTable->iPKey ){
151067 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
151172 return pIdx->pTable->aCol[j].notNull;
151398 Table *pTable; /* The table being indexed */
151425 pTable = pSrc->pTab;
151451 "automatic index on %s(%s)", pTable->zName,
151452 pTable->aCol[iCol].zCnName);
151478 mxBitCol = MIN(BMS-1,pTable->nCol);
151479 testcase( pTable->nCol==BMS-1 );
151480 testcase( pTable->nCol==BMS-2 );
151485 nKeyCol += pTable->nCol - BMS + 1;
151493 pIdx->pTable = pTable;
151528 for(i=BMS-1; i<pTable->nCol; i++){
151543 VdbeComment((v, "for %s", pTable->zName));
153097 idxaff = sqlite3TableColumnAffinity(pIdx->pTable, pLhs->iColumn);
153158 pProbe->pTable->zName,pProbe->zName,
153444 ApplyCostMultiplier(pNew->rRun, pProbe->pTable->costMult);
153517 pProbe->pTable->zName, pProbe->zName, saved_nEq, rc));
153672 sPk.pTable = pTab;
154563 assert( nColumn==nKeyCol+1 || !HasRowid(pIndex->pTable) );
154565 || !HasRowid(pIndex->pTable));
154630 if( iColumn==pIndex->pTable->iPKey ) iColumn = XN_ROWID;
154642 && pIndex->pTable->aCol[iColumn].notNull==0
156285 if( pWInfo->eOnePass==ONEPASS_OFF || !HasRowid(pIdx->pTable) ){
156313 assert( pIdx->pTable==pTab );
208509 SessionTable *pTable; /* List of attached tables */
209912 for(pRet=pSession->pTable; pRet; pRet=pRet->pNext){
209924 pRet = pSession->pTable;
210368 sessionDeleteTable(pSession, pSession->pTable);
210413 for(pTab=pSession->pTable; pTab; pTab=pTab->pNext){
210433 for(ppTab=&pSession->pTable; *ppTab; ppTab=&(*ppTab)->pNext);
211024 for(pTab=pSession->pTable; rc==SQLITE_OK && pTab; pTab=pTab->pNext){
211214 for(pTab=pSession->pTable; pTab && ret==0; pTab=pTab->pNext){
211238 if( pSession->pTable ){