Lines Matching refs:pTable
18675 Table *pTable; /* The SQL table being indexed */ member
70407 iTab = pIdx->pTable->tnum;
112392 sqlite3ExprCodeGetColumnOfTable(pParse->pVdbe, pIdx->pTable, iTabCur,
118684 VdbeComment((v,"%s.%s", pIdx->zName, pIdx->pTable->aCol[i].zCnName));
118951 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
119197 analyzeTable(pParse, pIdx->pTable, pIdx);
119278 pIndex->pTable->costMult = sqlite3LogEst(sqlite3Atoi(z+9));
119311 Table *pTable;
119320 pTable = sqlite3FindTable(pInfo->db, argv[0], pInfo->zDatabase);
119321 if( pTable==0 ){
119327 pIndex = sqlite3PrimaryKeyIndex(pTable);
119350 pTable->nRowLogEst = pIndex->aiRowLogEst[0];
119351 pTable->tabFlags |= TF_HasStat1;
119355 fakeIdx.szIdxRow = pTable->szTabRow;
119357 fakeIdx.pTable = pTable;
119359 decodeIntArray((char*)z, 1, 0, &pTable->nRowLogEst, &fakeIdx);
119360 pTable->szTabRow = fakeIdx.szIdxRow;
119361 pTable->tabFlags |= TF_HasStat1;
119523 assert( !HasRowid(pIdx->pTable) || pIdx->nColumn==pIdx->nKeyCol+1 );
119524 if( !HasRowid(pIdx->pTable) && IsPrimaryKeyIndex(pIdx) ){
119542 pIdx->pTable->tabFlags |= TF_HasStat4;
121203 if( pIndex->pTable->pIndex==pIndex ){
121204 pIndex->pTable->pIndex = pIndex->pNext;
121209 p = pIndex->pTable->pIndex;
121389 SQLITE_PRIVATE void sqlite3DeleteColumnNames(sqlite3 *db, Table *pTable){
121392 assert( pTable!=0 );
121394 if( (pCol = pTable->aCol)!=0 ){
121395 for(i=0; i<pTable->nCol; i++, pCol++){
121399 sqlite3DbNNFreeNN(db, pTable->aCol);
121400 if( IsOrdinaryTable(pTable) ){
121401 sqlite3ExprListDelete(db, pTable->u.tab.pDfltList);
121404 pTable->aCol = 0;
121405 pTable->nCol = 0;
121406 if( IsOrdinaryTable(pTable) ){
121407 pTable->u.tab.pDfltList = 0;
121428 static void SQLITE_NOINLINE deleteTable(sqlite3 *db, Table *pTable){
121441 if( !db->mallocFailed && (pTable->tabFlags & TF_Ephemeral)==0 ){
121447 for(pIndex = pTable->pIndex; pIndex; pIndex=pNext){
121449 assert( pIndex->pSchema==pTable->pSchema
121450 || (IsVirtual(pTable) && pIndex->idxType!=SQLITE_IDXTYPE_APPDEF) );
121451 if( db->pnBytesFreed==0 && !IsVirtual(pTable) ){
121462 if( IsOrdinaryTable(pTable) ){
121463 sqlite3FkDelete(db, pTable);
121466 else if( IsVirtual(pTable) ){
121467 sqlite3VtabClear(db, pTable);
121471 assert( IsView(pTable) );
121472 sqlite3SelectDelete(db, pTable->u.view.pSelect);
121477 sqlite3DeleteColumnNames(db, pTable);
121478 sqlite3DbFree(db, pTable->zName);
121479 sqlite3DbFree(db, pTable->zColAff);
121480 sqlite3ExprListDelete(db, pTable->pCheck);
121481 sqlite3DbFree(db, pTable);
121486 SQLITE_PRIVATE void sqlite3DeleteTable(sqlite3 *db, Table *pTable){
121489 if( !pTable ) return;
121490 if( db->pnBytesFreed==0 && (--pTable->nTabRef)>0 ) return;
121491 deleteTable(db, pTable);
121493 SQLITE_PRIVATE void sqlite3DeleteTableGeneric(sqlite3 *db, void *pTable){
121494 sqlite3DeleteTable(db, (Table*)pTable);
121838 Table *pTable;
121905 pTable = sqlite3FindTable(db, zName, zDb);
121906 if( pTable ){
121909 (IsView(pTable)? "view" : "table"), pName);
121923 pTable = sqlite3DbMallocZero(db, sizeof(Table));
121924 if( pTable==0 ){
121930 pTable->zName = zName;
121931 pTable->iPKey = -1;
121932 pTable->pSchema = db->aDb[iDb].pSchema;
121933 pTable->nTabRef = 1;
121935 pTable->nRowLogEst = sqlite3LogEst(SQLITE_DEFAULT_ROWEST);
121937 pTable->nRowLogEst = 200; assert( 200==sqlite3LogEst(1048576) );
121940 pParse->pNewTable = pTable;
122846 const Column *aCol = pIdx->pTable->aCol;
122849 assert( x<pIdx->pTable->nCol );
122886 assert( pPk->pTable->tabFlags & TF_WithoutRowid );
122887 assert( pPk->pTable==pIdx->pTable );
122924 Table *pTab = pIdx->pTable;
123687 static SQLITE_NOINLINE int viewGetColumnNames(Parse *pParse, Table *pTable){
123699 assert( pTable );
123702 if( IsVirtual(pTable) ){
123704 rc = sqlite3VtabCallConnect(pParse, pTable);
123715 assert( pTable->nCol<=0 );
123732 if( pTable->nCol<0 ){
123733 sqlite3ErrorMsg(pParse, "view %s is circularly defined", pTable->zName);
123736 assert( pTable->nCol>=0 );
123745 assert( IsView(pTable) );
123746 pSel = sqlite3SelectDup(db, pTable->u.view.pSelect, 0);
123753 pTable->nCol = -1;
123766 pTable->nCol = 0;
123768 }else if( pTable->pCheck ){
123775 sqlite3ColumnsFromExprList(pParse, pTable->pCheck,
123776 &pTable->nCol, &pTable->aCol);
123778 && pTable->nCol==pSel->pEList->nExpr
123781 sqlite3SubqueryColumnTypes(pParse, pTable, pSel, SQLITE_AFF_NONE);
123787 assert( pTable->aCol==0 );
123788 pTable->nCol = pSelTab->nCol;
123789 pTable->aCol = pSelTab->aCol;
123790 pTable->tabFlags |= (pSelTab->tabFlags & COLFLAG_NOINSERT);
123793 assert( sqlite3SchemaMutexHeld(db, 0, pTable->pSchema) );
123795 pTable->nNVCol = pTable->nCol;
123803 pTable->pSchema->schemaFlags |= DB_UnresetViews;
123805 sqlite3DeleteColumnNames(db, pTable);
123810 SQLITE_PRIVATE int sqlite3ViewGetColumnNames(Parse *pParse, Table *pTable){
123811 assert( pTable!=0 );
123812 if( !IsVirtual(pTable) && pTable->nCol>0 ) return 0;
123813 return viewGetColumnNames(pParse, pTable);
124371 Table *pTab = pIndex->pTable; /* The table that is indexed */
124776 pIndex->pTable = pTab;
125171 x = pIdx->pTable->nRowLogEst;
125174 pIdx->pTable->nRowLogEst = x = 99;
125228 Table *pTab = pIndex->pTable;
125481 Token *pTable, /* Table to append */
125486 assert( pDatabase==0 || pTable!=0 ); /* Cannot have C without B */
125512 pItem->zDatabase = sqlite3NameFromToken(db, pTable);
125514 pItem->zName = sqlite3NameFromToken(db, pTable);
125582 Token *pTable, /* Name of the table to add to the FROM clause */
125596 p = sqlite3SrcListAppend(pParse, p, pTable, pDatabase);
125602 assert( (pTable==0)==(pDatabase==0) );
125605 Token *pToken = (ALWAYS(pDatabase) && pDatabase->z) ? pDatabase : pTable;
125981 Table *pTab = pIdx->pTable;
126151 iDb = sqlite3SchemaToIndex(db, pIndex->pTable->pSchema);
131073 iParent += sqlite3TableColumnToStorage(pIdx->pTable,
131220 assert( pIdx==0 || pIdx->pTable==pTab );
132225 Table *pTab = pIdx->pTable;
134366 sqlite3SetMakeRecordP5(v, pIdx->pTable);
134869 assert( pDest->pTable!=pSrc->pTable );
139116 pTab = pIdx->pTable;
140765 for(p=pIndex->pTable->pIndex; p; p=p->pNext){
151232 Table *pTable;
151239 pTable = tableOfTrigger(pTrigger);
151240 assert( (pTable && pTable->pSchema==pTrigger->pSchema) || iDb==1 );
151242 if( pTable ){
151247 if( sqlite3AuthCheck(pParse, code, pTrigger->zName, pTable->zName, zDb) ||
154515 static void addModuleArgument(Parse *pParse, Table *pTable, char *zArg){
154520 assert( IsVirtual(pTable) );
154521 nBytes = sizeof(char *)*(2+pTable->u.vtab.nArg);
154522 if( pTable->u.vtab.nArg+3>=db->aLimit[SQLITE_LIMIT_COLUMN] ){
154523 sqlite3ErrorMsg(pParse, "too many columns on %s", pTable->zName);
154525 azModuleArg = sqlite3DbRealloc(db, pTable->u.vtab.azArg, nBytes);
154529 int i = pTable->u.vtab.nArg++;
154532 pTable->u.vtab.azArg = azModuleArg;
154548 Table *pTable; /* The new virtual table */
154552 pTable = pParse->pNewTable;
154553 if( pTable==0 ) return;
154554 assert( 0==pTable->pIndex );
154555 pTable->eTabType = TABTYP_VTAB;
154559 assert( pTable->u.vtab.nArg==0 );
154560 addModuleArgument(pParse, pTable, sqlite3NameFromToken(db, pModuleName));
154561 addModuleArgument(pParse, pTable, 0);
154562 addModuleArgument(pParse, pTable, sqlite3DbStrDup(db, pTable->zName));
154576 if( pTable->u.vtab.azArg ){
154577 int iDb = sqlite3SchemaToIndex(db, pTable->pSchema);
154579 sqlite3AuthCheck(pParse, SQLITE_CREATE_VTABLE, pTable->zName,
154580 pTable->u.vtab.azArg[0], pParse->db->aDb[iDb].zDbSName);
155026 pIdx->pTable = pTab;
156187 return pIdx->pTable->aCol[i].zCnName;
157349 Table *pTab = pIdx->pTable;
157960 if( (j>=0 && pIdx->pTable->aCol[j].notNull==0) || j==XN_EXPR ){
158209 }else if( HasRowid(pIdx->pTable) ){
158212 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
161277 if( iColumn==pIdx->pTable->iPKey ){
161280 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
161390 return pIdx->pTable->aCol[j].notNull;
161665 Table *pTab = pIdx->pTable;
161713 Table *pTable; /* The table being indexed */
161747 pTable = pSrc->pTab;
161772 "automatic index on %s(%s)", pTable->zName,
161773 pTable->aCol[iCol].zCnName);
161798 if( IsView(pTable) ){
161803 mxBitCol = MIN(BMS-1,pTable->nCol);
161804 testcase( pTable->nCol==BMS-1 );
161805 testcase( pTable->nCol==BMS-2 );
161810 nKeyCol += pTable->nCol - BMS + 1;
161818 pIdx->pTable = pTable;
161863 for(i=BMS-1; i<pTable->nCol; i++){
161879 VdbeComment((v, "for %s", pTable->zName));
162042 assert( pIdx->pTable==pItem->pTab );
162423 if( !HasRowid(pIdx->pTable) && IsPrimaryKeyIndex(pIdx) ){
163721 idxaff = sqlite3TableColumnAffinity(pIdx->pTable, pLhs->iColumn);
163785 pProbe->pTable->zName,pProbe->zName,
164083 ApplyCostMultiplier(pNew->rRun, pProbe->pTable->costMult);
164159 pProbe->pTable->zName, pProbe->zName, saved_nEq, rc));
164445 aff = pIdx->pTable->aCol[pLeft->iColumn].affinity;
164554 sPk.pTable = pTab;
165645 assert( nColumn==nKeyCol+1 || !HasRowid(pIndex->pTable) );
165647 || !HasRowid(pIndex->pTable));
165712 if( iColumn==pIndex->pTable->iPKey ) iColumn = XN_ROWID;
165724 && pIndex->pTable->aCol[iColumn].notNull==0
166669 pTab = pIdx->pTable;
167740 if( pWInfo->eOnePass==ONEPASS_OFF || !HasRowid(pIdx->pTable) ){
167786 assert( pIdx->pTable==pTab );
223101 SessionTable *pTable; /* List of attached tables */
224895 for(pRet=pSession->pTable; pRet; pRet=pRet->pNext){
224907 pRet = pSession->pTable;
225391 sessionDeleteTable(pSession, pSession->pTable);
225434 for(pTab=pSession->pTable; pTab; pTab=pTab->pNext){
225454 for(ppTab=&pSession->pTable; *ppTab; ppTab=&(*ppTab)->pNext);
226037 for(pTab=pSession->pTable; rc==SQLITE_OK && pTab; pTab=pTab->pNext){
226225 for(pTab=pSession->pTable; pTab && ret==0; pTab=pTab->pNext){
226249 if( pSession->pTable ){
226262 if( pSession->pTable ){