Lines Matching refs:pTable
18737 Table *pTable; /* The SQL table being indexed */ member
70806 iTab = pIdx->pTable->tnum;
113129 sqlite3ExprCodeGetColumnOfTable(pParse->pVdbe, pIdx->pTable, iTabCur,
119421 VdbeComment((v,"%s.%s", pIdx->zName, pIdx->pTable->aCol[i].zCnName));
119688 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
119947 analyzeTable(pParse, pIdx->pTable, pIdx);
120028 pIndex->pTable->costMult = sqlite3LogEst(sqlite3Atoi(z+9));
120061 Table *pTable;
120070 pTable = sqlite3FindTable(pInfo->db, argv[0], pInfo->zDatabase);
120071 if( pTable==0 ){
120077 pIndex = sqlite3PrimaryKeyIndex(pTable);
120100 pTable->nRowLogEst = pIndex->aiRowLogEst[0];
120101 pTable->tabFlags |= TF_HasStat1;
120105 fakeIdx.szIdxRow = pTable->szTabRow;
120107 fakeIdx.pTable = pTable;
120109 decodeIntArray((char*)z, 1, 0, &pTable->nRowLogEst, &fakeIdx);
120110 pTable->szTabRow = fakeIdx.szIdxRow;
120111 pTable->tabFlags |= TF_HasStat1;
120273 assert( !HasRowid(pIdx->pTable) || pIdx->nColumn==pIdx->nKeyCol+1 );
120274 if( !HasRowid(pIdx->pTable) && IsPrimaryKeyIndex(pIdx) ){
120292 pIdx->pTable->tabFlags |= TF_HasStat4;
121953 if( pIndex->pTable->pIndex==pIndex ){
121954 pIndex->pTable->pIndex = pIndex->pNext;
121959 p = pIndex->pTable->pIndex;
122139 SQLITE_PRIVATE void sqlite3DeleteColumnNames(sqlite3 *db, Table *pTable){
122142 assert( pTable!=0 );
122144 if( (pCol = pTable->aCol)!=0 ){
122145 for(i=0; i<pTable->nCol; i++, pCol++){
122149 sqlite3DbNNFreeNN(db, pTable->aCol);
122150 if( IsOrdinaryTable(pTable) ){
122151 sqlite3ExprListDelete(db, pTable->u.tab.pDfltList);
122154 pTable->aCol = 0;
122155 pTable->nCol = 0;
122156 if( IsOrdinaryTable(pTable) ){
122157 pTable->u.tab.pDfltList = 0;
122178 static void SQLITE_NOINLINE deleteTable(sqlite3 *db, Table *pTable){
122191 if( !db->mallocFailed && (pTable->tabFlags & TF_Ephemeral)==0 ){
122197 for(pIndex = pTable->pIndex; pIndex; pIndex=pNext){
122199 assert( pIndex->pSchema==pTable->pSchema
122200 || (IsVirtual(pTable) && pIndex->idxType!=SQLITE_IDXTYPE_APPDEF) );
122201 if( db->pnBytesFreed==0 && !IsVirtual(pTable) ){
122212 if( IsOrdinaryTable(pTable) ){
122213 sqlite3FkDelete(db, pTable);
122216 else if( IsVirtual(pTable) ){
122217 sqlite3VtabClear(db, pTable);
122221 assert( IsView(pTable) );
122222 sqlite3SelectDelete(db, pTable->u.view.pSelect);
122227 sqlite3DeleteColumnNames(db, pTable);
122228 sqlite3DbFree(db, pTable->zName);
122229 sqlite3DbFree(db, pTable->zColAff);
122230 sqlite3ExprListDelete(db, pTable->pCheck);
122231 sqlite3DbFree(db, pTable);
122236 SQLITE_PRIVATE void sqlite3DeleteTable(sqlite3 *db, Table *pTable){
122239 if( !pTable ) return;
122240 if( db->pnBytesFreed==0 && (--pTable->nTabRef)>0 ) return;
122241 deleteTable(db, pTable);
122243 SQLITE_PRIVATE void sqlite3DeleteTableGeneric(sqlite3 *db, void *pTable){
122244 sqlite3DeleteTable(db, (Table*)pTable);
122588 Table *pTable;
122655 pTable = sqlite3FindTable(db, zName, zDb);
122656 if( pTable ){
122659 (IsView(pTable)? "view" : "table"), pName);
122673 pTable = sqlite3DbMallocZero(db, sizeof(Table));
122674 if( pTable==0 ){
122680 pTable->zName = zName;
122681 pTable->iPKey = -1;
122682 pTable->pSchema = db->aDb[iDb].pSchema;
122683 pTable->nTabRef = 1;
122685 pTable->nRowLogEst = sqlite3LogEst(SQLITE_DEFAULT_ROWEST);
122687 pTable->nRowLogEst = 200; assert( 200==sqlite3LogEst(1048576) );
122690 pParse->pNewTable = pTable;
123596 const Column *aCol = pIdx->pTable->aCol;
123599 assert( x<pIdx->pTable->nCol );
123636 assert( pPk->pTable->tabFlags & TF_WithoutRowid );
123637 assert( pPk->pTable==pIdx->pTable );
123674 Table *pTab = pIdx->pTable;
124438 static SQLITE_NOINLINE int viewGetColumnNames(Parse *pParse, Table *pTable){
124450 assert( pTable );
124453 if( IsVirtual(pTable) ){
124455 rc = sqlite3VtabCallConnect(pParse, pTable);
124466 assert( pTable->nCol<=0 );
124483 if( pTable->nCol<0 ){
124484 sqlite3ErrorMsg(pParse, "view %s is circularly defined", pTable->zName);
124487 assert( pTable->nCol>=0 );
124496 assert( IsView(pTable) );
124497 pSel = sqlite3SelectDup(db, pTable->u.view.pSelect, 0);
124504 pTable->nCol = -1;
124517 pTable->nCol = 0;
124519 }else if( pTable->pCheck ){
124526 sqlite3ColumnsFromExprList(pParse, pTable->pCheck,
124527 &pTable->nCol, &pTable->aCol);
124529 && pTable->nCol==pSel->pEList->nExpr
124532 sqlite3SubqueryColumnTypes(pParse, pTable, pSel, SQLITE_AFF_NONE);
124538 assert( pTable->aCol==0 );
124539 pTable->nCol = pSelTab->nCol;
124540 pTable->aCol = pSelTab->aCol;
124541 pTable->tabFlags |= (pSelTab->tabFlags & COLFLAG_NOINSERT);
124544 assert( sqlite3SchemaMutexHeld(db, 0, pTable->pSchema) );
124546 pTable->nNVCol = pTable->nCol;
124554 pTable->pSchema->schemaFlags |= DB_UnresetViews;
124556 sqlite3DeleteColumnNames(db, pTable);
124561 SQLITE_PRIVATE int sqlite3ViewGetColumnNames(Parse *pParse, Table *pTable){
124562 assert( pTable!=0 );
124563 if( !IsVirtual(pTable) && pTable->nCol>0 ) return 0;
124564 return viewGetColumnNames(pParse, pTable);
125122 Table *pTab = pIndex->pTable; /* The table that is indexed */
125527 pIndex->pTable = pTab;
125922 x = pIdx->pTable->nRowLogEst;
125925 pIdx->pTable->nRowLogEst = x = 99;
125979 Table *pTab = pIndex->pTable;
126232 Token *pTable, /* Table to append */
126237 assert( pDatabase==0 || pTable!=0 ); /* Cannot have C without B */
126263 pItem->zDatabase = sqlite3NameFromToken(db, pTable);
126265 pItem->zName = sqlite3NameFromToken(db, pTable);
126333 Token *pTable, /* Name of the table to add to the FROM clause */
126347 p = sqlite3SrcListAppend(pParse, p, pTable, pDatabase);
126353 assert( (pTable==0)==(pDatabase==0) );
126356 Token *pToken = (ALWAYS(pDatabase) && pDatabase->z) ? pDatabase : pTable;
126732 Table *pTab = pIdx->pTable;
126902 iDb = sqlite3SchemaToIndex(db, pIndex->pTable->pSchema);
131826 iParent += sqlite3TableColumnToStorage(pIdx->pTable,
131973 assert( pIdx==0 || pIdx->pTable==pTab );
132978 Table *pTab = pIdx->pTable;
135324 sqlite3SetMakeRecordP5(v, pIdx->pTable);
135827 assert( pDest->pTable!=pSrc->pTable );
140105 pTab = pIdx->pTable;
141866 for(p=pIndex->pTable->pIndex; p; p=p->pNext){
152384 Table *pTable;
152391 pTable = tableOfTrigger(pTrigger);
152392 assert( (pTable && pTable->pSchema==pTrigger->pSchema) || iDb==1 );
152394 if( pTable ){
152399 if( sqlite3AuthCheck(pParse, code, pTrigger->zName, pTable->zName, zDb) ||
155751 static void addModuleArgument(Parse *pParse, Table *pTable, char *zArg){
155756 assert( IsVirtual(pTable) );
155757 nBytes = sizeof(char *)*(2+pTable->u.vtab.nArg);
155758 if( pTable->u.vtab.nArg+3>=db->aLimit[SQLITE_LIMIT_COLUMN] ){
155759 sqlite3ErrorMsg(pParse, "too many columns on %s", pTable->zName);
155761 azModuleArg = sqlite3DbRealloc(db, pTable->u.vtab.azArg, nBytes);
155765 int i = pTable->u.vtab.nArg++;
155768 pTable->u.vtab.azArg = azModuleArg;
155784 Table *pTable; /* The new virtual table */
155788 pTable = pParse->pNewTable;
155789 if( pTable==0 ) return;
155790 assert( 0==pTable->pIndex );
155791 pTable->eTabType = TABTYP_VTAB;
155795 assert( pTable->u.vtab.nArg==0 );
155796 addModuleArgument(pParse, pTable, sqlite3NameFromToken(db, pModuleName));
155797 addModuleArgument(pParse, pTable, 0);
155798 addModuleArgument(pParse, pTable, sqlite3DbStrDup(db, pTable->zName));
155812 if( pTable->u.vtab.azArg ){
155813 int iDb = sqlite3SchemaToIndex(db, pTable->pSchema);
155815 sqlite3AuthCheck(pParse, SQLITE_CREATE_VTABLE, pTable->zName,
155816 pTable->u.vtab.azArg[0], pParse->db->aDb[iDb].zDbSName);
156282 pIdx->pTable = pTab;
157443 return pIdx->pTable->aCol[i].zCnName;
158605 Table *pTab = pIdx->pTable;
159237 if( (j>=0 && pIdx->pTable->aCol[j].notNull==0) || j==XN_EXPR ){
159486 }else if( HasRowid(pIdx->pTable) ){
159489 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
162618 if( iColumn==pIdx->pTable->iPKey ){
162621 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
162731 return pIdx->pTable->aCol[j].notNull;
163014 Table *pTab = pIdx->pTable;
163062 Table *pTable; /* The table being indexed */
163096 pTable = pSrc->pTab;
163121 "automatic index on %s(%s)", pTable->zName,
163122 pTable->aCol[iCol].zCnName);
163147 if( IsView(pTable) ){
163152 mxBitCol = MIN(BMS-1,pTable->nCol);
163153 testcase( pTable->nCol==BMS-1 );
163154 testcase( pTable->nCol==BMS-2 );
163159 nKeyCol += pTable->nCol - BMS + 1;
163167 pIdx->pTable = pTable;
163212 for(i=BMS-1; i<pTable->nCol; i++){
163228 VdbeComment((v, "for %s", pTable->zName));
163391 assert( pIdx->pTable==pItem->pTab );
163772 if( !HasRowid(pIdx->pTable) && IsPrimaryKeyIndex(pIdx) ){
165070 idxaff = sqlite3TableColumnAffinity(pIdx->pTable, pLhs->iColumn);
165134 pProbe->pTable->zName,pProbe->zName,
165445 ApplyCostMultiplier(pNew->rRun, pProbe->pTable->costMult);
165521 pProbe->pTable->zName, pProbe->zName, saved_nEq, rc));
165809 aff = pIdx->pTable->aCol[pLeft->iColumn].affinity;
165918 sPk.pTable = pTab;
167033 assert( nColumn==nKeyCol+1 || !HasRowid(pIndex->pTable) );
167035 || !HasRowid(pIndex->pTable));
167100 if( iColumn==pIndex->pTable->iPKey ) iColumn = XN_ROWID;
167112 && pIndex->pTable->aCol[iColumn].notNull==0
168188 pTab = pIdx->pTable;
169240 if( pWInfo->eOnePass==ONEPASS_OFF || !HasRowid(pIdx->pTable) ){
169286 assert( pIdx->pTable==pTab );
224944 SessionTable *pTable; /* List of attached tables */
226738 for(pRet=pSession->pTable; pRet; pRet=pRet->pNext){
226750 pRet = pSession->pTable;
227234 sessionDeleteTable(pSession, pSession->pTable);
227277 for(pTab=pSession->pTable; pTab; pTab=pTab->pNext){
227297 for(ppTab=&pSession->pTable; *ppTab; ppTab=&(*ppTab)->pNext);
227880 for(pTab=pSession->pTable; rc==SQLITE_OK && pTab; pTab=pTab->pNext){
228068 for(pTab=pSession->pTable; pTab && ret==0; pTab=pTab->pNext){
228092 if( pSession->pTable ){
228105 if( pSession->pTable ){