Lines Matching refs:pTable
19149 Table *pTable; /* The SQL table being indexed */ member
71816 iTab = pIdx->pTable->tnum;
114590 sqlite3ExprCodeGetColumnOfTable(pParse->pVdbe, pIdx->pTable, iTabCur,
121066 VdbeComment((v,"%s.%s", pIdx->zName, pIdx->pTable->aCol[i].zCnName));
121333 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
121592 analyzeTable(pParse, pIdx->pTable, pIdx);
121673 pIndex->pTable->costMult = sqlite3LogEst(sqlite3Atoi(z+9));
121696 Table *pTable;
121705 pTable = sqlite3FindTable(pInfo->db, argv[0], pInfo->zDatabase);
121706 if( pTable==0 ){
121712 pIndex = sqlite3PrimaryKeyIndex(pTable);
121735 pTable->nRowLogEst = pIndex->aiRowLogEst[0];
121736 pTable->tabFlags |= TF_HasStat1;
121740 fakeIdx.szIdxRow = pTable->szTabRow;
121742 fakeIdx.pTable = pTable;
121744 decodeIntArray((char*)z, 1, 0, &pTable->nRowLogEst, &fakeIdx);
121745 pTable->szTabRow = fakeIdx.szIdxRow;
121746 pTable->tabFlags |= TF_HasStat1;
121909 assert( !HasRowid(pIdx->pTable) || pIdx->nColumn==pIdx->nKeyCol+1 );
121910 if( !HasRowid(pIdx->pTable) && IsPrimaryKeyIndex(pIdx) ){
121931 pIdx->pTable->tabFlags |= TF_HasStat4;
123566 if( pIndex->pTable->pIndex==pIndex ){
123567 pIndex->pTable->pIndex = pIndex->pNext;
123572 p = pIndex->pTable->pIndex;
123752 SQLITE_PRIVATE void sqlite3DeleteColumnNames(sqlite3 *db, Table *pTable){
123755 assert( pTable!=0 );
123757 if( (pCol = pTable->aCol)!=0 ){
123758 for(i=0; i<pTable->nCol; i++, pCol++){
123762 sqlite3DbNNFreeNN(db, pTable->aCol);
123763 if( IsOrdinaryTable(pTable) ){
123764 sqlite3ExprListDelete(db, pTable->u.tab.pDfltList);
123767 pTable->aCol = 0;
123768 pTable->nCol = 0;
123769 if( IsOrdinaryTable(pTable) ){
123770 pTable->u.tab.pDfltList = 0;
123791 static void SQLITE_NOINLINE deleteTable(sqlite3 *db, Table *pTable){
123804 if( !db->mallocFailed && (pTable->tabFlags & TF_Ephemeral)==0 ){
123810 for(pIndex = pTable->pIndex; pIndex; pIndex=pNext){
123812 assert( pIndex->pSchema==pTable->pSchema
123813 || (IsVirtual(pTable) && pIndex->idxType!=SQLITE_IDXTYPE_APPDEF) );
123814 if( db->pnBytesFreed==0 && !IsVirtual(pTable) ){
123825 if( IsOrdinaryTable(pTable) ){
123826 sqlite3FkDelete(db, pTable);
123829 else if( IsVirtual(pTable) ){
123830 sqlite3VtabClear(db, pTable);
123834 assert( IsView(pTable) );
123835 sqlite3SelectDelete(db, pTable->u.view.pSelect);
123840 sqlite3DeleteColumnNames(db, pTable);
123841 sqlite3DbFree(db, pTable->zName);
123842 sqlite3DbFree(db, pTable->zColAff);
123843 sqlite3ExprListDelete(db, pTable->pCheck);
123844 sqlite3DbFree(db, pTable);
123849 SQLITE_PRIVATE void sqlite3DeleteTable(sqlite3 *db, Table *pTable){
123852 if( !pTable ) return;
123853 if( db->pnBytesFreed==0 && (--pTable->nTabRef)>0 ) return;
123854 deleteTable(db, pTable);
123856 SQLITE_PRIVATE void sqlite3DeleteTableGeneric(sqlite3 *db, void *pTable){
123857 sqlite3DeleteTable(db, (Table*)pTable);
124207 Table *pTable;
124274 pTable = sqlite3FindTable(db, zName, zDb);
124275 if( pTable ){
124278 (IsView(pTable)? "view" : "table"), pName);
124292 pTable = sqlite3DbMallocZero(db, sizeof(Table));
124293 if( pTable==0 ){
124299 pTable->zName = zName;
124300 pTable->iPKey = -1;
124301 pTable->pSchema = db->aDb[iDb].pSchema;
124302 pTable->nTabRef = 1;
124304 pTable->nRowLogEst = sqlite3LogEst(SQLITE_DEFAULT_ROWEST);
124306 pTable->nRowLogEst = 200; assert( 200==sqlite3LogEst(1048576) );
124309 pParse->pNewTable = pTable;
125228 const Column *aCol = pIdx->pTable->aCol;
125231 assert( x<pIdx->pTable->nCol );
125268 assert( pPk->pTable->tabFlags & TF_WithoutRowid );
125269 assert( pPk->pTable==pIdx->pTable );
125306 Table *pTab = pIdx->pTable;
126072 static SQLITE_NOINLINE int viewGetColumnNames(Parse *pParse, Table *pTable){
126084 assert( pTable );
126087 if( IsVirtual(pTable) ){
126089 rc = sqlite3VtabCallConnect(pParse, pTable);
126100 assert( pTable->nCol<=0 );
126117 if( pTable->nCol<0 ){
126118 sqlite3ErrorMsg(pParse, "view %s is circularly defined", pTable->zName);
126121 assert( pTable->nCol>=0 );
126130 assert( IsView(pTable) );
126131 pSel = sqlite3SelectDup(db, pTable->u.view.pSelect, 0);
126138 pTable->nCol = -1;
126151 pTable->nCol = 0;
126153 }else if( pTable->pCheck ){
126160 sqlite3ColumnsFromExprList(pParse, pTable->pCheck,
126161 &pTable->nCol, &pTable->aCol);
126163 && pTable->nCol==pSel->pEList->nExpr
126166 sqlite3SubqueryColumnTypes(pParse, pTable, pSel, SQLITE_AFF_NONE);
126172 assert( pTable->aCol==0 );
126173 pTable->nCol = pSelTab->nCol;
126174 pTable->aCol = pSelTab->aCol;
126175 pTable->tabFlags |= (pSelTab->tabFlags & COLFLAG_NOINSERT);
126178 assert( sqlite3SchemaMutexHeld(db, 0, pTable->pSchema) );
126180 pTable->nNVCol = pTable->nCol;
126188 pTable->pSchema->schemaFlags |= DB_UnresetViews;
126190 sqlite3DeleteColumnNames(db, pTable);
126195 SQLITE_PRIVATE int sqlite3ViewGetColumnNames(Parse *pParse, Table *pTable){
126196 assert( pTable!=0 );
126197 if( !IsVirtual(pTable) && pTable->nCol>0 ) return 0;
126198 return viewGetColumnNames(pParse, pTable);
126758 Table *pTab = pIndex->pTable; /* The table that is indexed */
127162 pIndex->pTable = pTab;
127557 x = pIdx->pTable->nRowLogEst;
127560 pIdx->pTable->nRowLogEst = x = 99;
127616 Table *pTab = pIndex->pTable;
127866 Token *pTable, /* Table to append */
127871 assert( pDatabase==0 || pTable!=0 ); /* Cannot have C without B */
127899 pItem->u4.zDatabase = sqlite3NameFromToken(db, pTable);
127901 pItem->zName = sqlite3NameFromToken(db, pTable);
128055 Token *pTable, /* Name of the table to add to the FROM clause */
128069 p = sqlite3SrcListAppend(pParse, p, pTable, pDatabase);
128075 assert( (pTable==0)==(pDatabase==0) );
128078 Token *pToken = (ALWAYS(pDatabase) && pDatabase->z) ? pDatabase : pTable;
128456 Table *pTab = pIdx->pTable;
128626 iDb = sqlite3SchemaToIndex(db, pIndex->pTable->pSchema);
133745 iParent += sqlite3TableColumnToStorage(pIdx->pTable,
133892 assert( pIdx==0 || pIdx->pTable==pTab );
134899 Table *pTab = pIdx->pTable;
137262 sqlite3SetMakeRecordP5(v, pIdx->pTable);
137765 assert( pDest->pTable!=pSrc->pTable );
142047 pTab = pIdx->pTable;
143809 for(p=pIndex->pTable->pIndex; p; p=p->pNext){
154539 Table *pTable;
154546 pTable = tableOfTrigger(pTrigger);
154547 assert( (pTable && pTable->pSchema==pTrigger->pSchema) || iDb==1 );
154549 if( pTable ){
154554 if( sqlite3AuthCheck(pParse, code, pTrigger->zName, pTable->zName, zDb) ||
157912 static void addModuleArgument(Parse *pParse, Table *pTable, char *zArg){
157917 assert( IsVirtual(pTable) );
157918 nBytes = sizeof(char *)*(2+pTable->u.vtab.nArg);
157919 if( pTable->u.vtab.nArg+3>=db->aLimit[SQLITE_LIMIT_COLUMN] ){
157920 sqlite3ErrorMsg(pParse, "too many columns on %s", pTable->zName);
157922 azModuleArg = sqlite3DbRealloc(db, pTable->u.vtab.azArg, nBytes);
157926 int i = pTable->u.vtab.nArg++;
157929 pTable->u.vtab.azArg = azModuleArg;
157945 Table *pTable; /* The new virtual table */
157949 pTable = pParse->pNewTable;
157950 if( pTable==0 ) return;
157951 assert( 0==pTable->pIndex );
157952 pTable->eTabType = TABTYP_VTAB;
157956 assert( pTable->u.vtab.nArg==0 );
157957 addModuleArgument(pParse, pTable, sqlite3NameFromToken(db, pModuleName));
157958 addModuleArgument(pParse, pTable, 0);
157959 addModuleArgument(pParse, pTable, sqlite3DbStrDup(db, pTable->zName));
157973 if( pTable->u.vtab.azArg ){
157974 int iDb = sqlite3SchemaToIndex(db, pTable->pSchema);
157976 sqlite3AuthCheck(pParse, SQLITE_CREATE_VTABLE, pTable->zName,
157977 pTable->u.vtab.azArg[0], pParse->db->aDb[iDb].zDbSName);
158447 pIdx->pTable = pTab;
159633 return pIdx->pTable->aCol[i].zCnName;
160893 Table *pTab = pIdx->pTable;
161533 if( (j>=0 && pIdx->pTable->aCol[j].notNull==0) || j==XN_EXPR ){
161782 }else if( HasRowid(pIdx->pTable) ){
161785 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
164974 if( iColumn==pIdx->pTable->iPKey ){
164977 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
165087 return pIdx->pTable->aCol[j].notNull;
165418 Table *pTab = pIdx->pTable;
165466 Table *pTable; /* The table being indexed */
165500 pTable = pSrc->pSTab;
165525 "automatic index on %s(%s)", pTable->zName,
165526 pTable->aCol[iCol].zCnName);
165551 if( IsView(pTable) ){
165556 if( !HasRowid(pTable) ){
165559 for(i=0; i<pTable->nCol; i++){
165560 if( (pTable->aCol[i].colFlags & COLFLAG_PRIMKEY)==0 ) continue;
165569 mxBitCol = MIN(BMS-1,pTable->nCol);
165570 testcase( pTable->nCol==BMS-1 );
165571 testcase( pTable->nCol==BMS-2 );
165576 nKeyCol += pTable->nCol - BMS + 1;
165580 assert( nKeyCol <= pTable->nCol + MAX(0, pTable->nCol - BMS + 1) );
165582 pIdx = sqlite3AllocateIndexObject(pParse->db, nKeyCol+HasRowid(pTable),
165587 pIdx->pTable = pTable;
165632 for(i=BMS-1; i<pTable->nCol; i++){
165639 if( HasRowid(pTable) ){
165650 VdbeComment((v, "for %s", pTable->zName));
165819 assert( pIdx->pTable==pItem->pSTab );
166247 if( !HasRowid(pIdx->pTable) && IsPrimaryKeyIndex(pIdx) ){
167555 idxaff = sqlite3TableColumnAffinity(pIdx->pTable, pLhs->iColumn);
167619 pProbe->pTable->zName,pProbe->zName,
167941 ApplyCostMultiplier(pNew->rRun, pProbe->pTable->costMult);
168017 pProbe->pTable->zName, pProbe->zName, saved_nEq, rc));
168305 aff = pIdx->pTable->aCol[pLeft->iColumn].affinity;
168414 sPk.pTable = pTab;
169628 assert( nColumn==nKeyCol+1 || !HasRowid(pIndex->pTable) );
169630 || !HasRowid(pIndex->pTable));
169695 if( iColumn==pIndex->pTable->iPKey ) iColumn = XN_ROWID;
169707 && pIndex->pTable->aCol[iColumn].notNull==0
170980 pTab = pIdx->pTable;
172033 if( pWInfo->eOnePass==ONEPASS_OFF || !HasRowid(pIdx->pTable) ){
172079 assert( pIdx->pTable==pTab );
228194 SessionTable *pTable; /* List of attached tables */
230021 for(pRet=pSession->pTable; pRet; pRet=pRet->pNext){
230033 pRet = pSession->pTable;
230546 sessionDeleteTable(pSession, pSession->pTable);
230589 for(pTab=pSession->pTable; pTab; pTab=pTab->pNext){
230609 for(ppTab=&pSession->pTable; *ppTab; ppTab=&(*ppTab)->pNext);
231202 for(pTab=pSession->pTable; rc==SQLITE_OK && pTab; pTab=pTab->pNext){
231390 for(pTab=pSession->pTable; pTab && ret==0; pTab=pTab->pNext){
231414 if( pSession->pTable ){
231427 if( pSession->pTable ){