Lines Matching refs:pTable
18089 Table *pTable; /* The SQL table being indexed */
68842 iTab = pIdx->pTable->tnum;
109557 sqlite3ExprCodeGetColumnOfTable(pParse->pVdbe, pIdx->pTable, iTabCur,
115565 VdbeComment((v,"%s.%s", pIdx->zName, pIdx->pTable->aCol[i].zCnName));
115828 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
116041 analyzeTable(pParse, pIdx->pTable, pIdx);
116122 pIndex->pTable->costMult = sqlite3LogEst(sqlite3Atoi(z+9));
116145 Table *pTable;
116154 pTable = sqlite3FindTable(pInfo->db, argv[0], pInfo->zDatabase);
116155 if( pTable==0 ){
116161 pIndex = sqlite3PrimaryKeyIndex(pTable);
116184 pTable->nRowLogEst = pIndex->aiRowLogEst[0];
116185 pTable->tabFlags |= TF_HasStat1;
116189 fakeIdx.szIdxRow = pTable->szTabRow;
116191 fakeIdx.pTable = pTable;
116193 decodeIntArray((char*)z, 1, 0, &pTable->nRowLogEst, &fakeIdx);
116194 pTable->szTabRow = fakeIdx.szIdxRow;
116195 pTable->tabFlags |= TF_HasStat1;
116351 assert( !HasRowid(pIdx->pTable) || pIdx->nColumn==pIdx->nKeyCol+1 );
116352 if( !HasRowid(pIdx->pTable) && IsPrimaryKeyIndex(pIdx) ){
116369 pIdx->pTable->tabFlags |= TF_HasStat4;
118045 if( pIndex->pTable->pIndex==pIndex ){
118046 pIndex->pTable->pIndex = pIndex->pNext;
118051 p = pIndex->pTable->pIndex;
118231 SQLITE_PRIVATE void sqlite3DeleteColumnNames(sqlite3 *db, Table *pTable){
118234 assert( pTable!=0 );
118236 if( (pCol = pTable->aCol)!=0 ){
118237 for(i=0; i<pTable->nCol; i++, pCol++){
118241 sqlite3DbNNFreeNN(db, pTable->aCol);
118242 if( IsOrdinaryTable(pTable) ){
118243 sqlite3ExprListDelete(db, pTable->u.tab.pDfltList);
118246 pTable->aCol = 0;
118247 pTable->nCol = 0;
118248 if( IsOrdinaryTable(pTable) ){
118249 pTable->u.tab.pDfltList = 0;
118270 static void SQLITE_NOINLINE deleteTable(sqlite3 *db, Table *pTable){
118283 if( !db->mallocFailed && (pTable->tabFlags & TF_Ephemeral)==0 ){
118289 for(pIndex = pTable->pIndex; pIndex; pIndex=pNext){
118291 assert( pIndex->pSchema==pTable->pSchema
118292 || (IsVirtual(pTable) && pIndex->idxType!=SQLITE_IDXTYPE_APPDEF) );
118293 if( db->pnBytesFreed==0 && !IsVirtual(pTable) ){
118304 if( IsOrdinaryTable(pTable) ){
118305 sqlite3FkDelete(db, pTable);
118308 else if( IsVirtual(pTable) ){
118309 sqlite3VtabClear(db, pTable);
118313 assert( IsView(pTable) );
118314 sqlite3SelectDelete(db, pTable->u.view.pSelect);
118319 sqlite3DeleteColumnNames(db, pTable);
118320 sqlite3DbFree(db, pTable->zName);
118321 sqlite3DbFree(db, pTable->zColAff);
118322 sqlite3ExprListDelete(db, pTable->pCheck);
118323 sqlite3DbFree(db, pTable);
118328 SQLITE_PRIVATE void sqlite3DeleteTable(sqlite3 *db, Table *pTable){
118331 if( !pTable ) return;
118332 if( db->pnBytesFreed==0 && (--pTable->nTabRef)>0 ) return;
118333 deleteTable(db, pTable);
118693 Table *pTable;
118760 pTable = sqlite3FindTable(db, zName, zDb);
118761 if( pTable ){
118764 (IsView(pTable)? "view" : "table"), pName);
118778 pTable = sqlite3DbMallocZero(db, sizeof(Table));
118779 if( pTable==0 ){
118785 pTable->zName = zName;
118786 pTable->iPKey = -1;
118787 pTable->pSchema = db->aDb[iDb].pSchema;
118788 pTable->nTabRef = 1;
118790 pTable->nRowLogEst = sqlite3LogEst(SQLITE_DEFAULT_ROWEST);
118792 pTable->nRowLogEst = 200; assert( 200==sqlite3LogEst(1048576) );
118795 pParse->pNewTable = pTable;
119693 const Column *aCol = pIdx->pTable->aCol;
119696 assert( x<pIdx->pTable->nCol );
119733 assert( pPk->pTable->tabFlags & TF_WithoutRowid );
119734 assert( pPk->pTable==pIdx->pTable );
119771 Table *pTab = pIdx->pTable;
120518 ** The Table structure pTable is really a VIEW. Fill in the names of
120519 ** the columns of the view in the pTable structure. Return the number
120522 static SQLITE_NOINLINE int viewGetColumnNames(Parse *pParse, Table *pTable){
120534 assert( pTable );
120537 if( IsVirtual(pTable) ){
120539 rc = sqlite3VtabCallConnect(pParse, pTable);
120550 assert( pTable->nCol<=0 );
120567 if( pTable->nCol<0 ){
120568 sqlite3ErrorMsg(pParse, "view %s is circularly defined", pTable->zName);
120571 assert( pTable->nCol>=0 );
120580 assert( IsView(pTable) );
120581 pSel = sqlite3SelectDup(db, pTable->u.view.pSelect, 0);
120588 pTable->nCol = -1;
120601 pTable->nCol = 0;
120603 }else if( pTable->pCheck ){
120606 ** arglist which is stored in pTable->pCheck. The pCheck field
120610 sqlite3ColumnsFromExprList(pParse, pTable->pCheck,
120611 &pTable->nCol, &pTable->aCol);
120613 && pTable->nCol==pSel->pEList->nExpr
120616 sqlite3SelectAddColumnTypeAndCollation(pParse, pTable, pSel,
120623 assert( pTable->aCol==0 );
120624 pTable->nCol = pSelTab->nCol;
120625 pTable->aCol = pSelTab->aCol;
120626 pTable->tabFlags |= (pSelTab->tabFlags & COLFLAG_NOINSERT);
120629 assert( sqlite3SchemaMutexHeld(db, 0, pTable->pSchema) );
120631 pTable->nNVCol = pTable->nCol;
120639 pTable->pSchema->schemaFlags |= DB_UnresetViews;
120641 sqlite3DeleteColumnNames(db, pTable);
120646 SQLITE_PRIVATE int sqlite3ViewGetColumnNames(Parse *pParse, Table *pTable){
120647 assert( pTable!=0 );
120648 if( !IsVirtual(pTable) && pTable->nCol>0 ) return 0;
120649 return viewGetColumnNames(pParse, pTable);
121207 Table *pTab = pIndex->pTable; /* The table that is indexed */
121365 ** UNIQUE constraint. If pTable and pIndex are NULL, use pParse->pNewTable
121391 DbFixer sFix; /* For assigning database names to pTable */
121612 pIndex->pTable = pTab;
122007 x = pIdx->pTable->nRowLogEst;
122010 pIdx->pTable->nRowLogEst = x = 99;
122064 Table *pTab = pIndex->pTable;
122281 ** need be. A new entry is created in the SrcList even if pTable is NULL.
122291 ** points to the table name and the pTable points to the database name.
122293 ** come from pTable (if pDatabase is NULL) or from pDatabase.
122294 ** SrcList.a[].zDatabase is filled with the database name from pTable,
122311 ** Both pTable and pDatabase are assumed to be quoted. They are dequoted
122317 Token *pTable, /* Table to append */
122322 assert( pDatabase==0 || pTable!=0 ); /* Cannot have C without B */
122348 pItem->zDatabase = sqlite3NameFromToken(db, pTable);
122350 pItem->zName = sqlite3NameFromToken(db, pTable);
122403 ** if this is the first term of the FROM clause. pTable and pDatabase
122408 ** SELECT statement that the subquery encodes. The pTable and
122418 Token *pTable, /* Name of the table to add to the FROM clause */
122419 Token *pDatabase, /* Name of the database containing pTable */
122432 p = sqlite3SrcListAppend(pParse, p, pTable, pDatabase);
122438 assert( (pTable==0)==(pDatabase==0) );
122441 Token *pToken = (ALWAYS(pDatabase) && pDatabase->z) ? pDatabase : pTable;
122817 Table *pTab = pIdx->pTable;
127542 iParent += sqlite3TableColumnToStorage(pIdx->pTable,
127689 assert( pIdx==0 || pIdx->pTable==pTab );
128686 Table *pTab = pIdx->pTable;
130823 sqlite3SetMakeRecordP5(v, pIdx->pTable);
131324 assert( pDest->pTable!=pSrc->pTable );
135602 pTab = pIdx->pTable;
137206 for(p=pIndex->pTable->pIndex; p; p=p->pNext){
147029 Table *pTable;
147036 pTable = tableOfTrigger(pTrigger);
147037 assert( (pTable && pTable->pSchema==pTrigger->pSchema) || iDb==1 );
147039 if( pTable ){
147044 if( sqlite3AuthCheck(pParse, code, pTrigger->zName, pTable->zName, zDb) ||
150291 ** Add a new module argument to pTable->u.vtab.azArg[].
150296 static void addModuleArgument(Parse *pParse, Table *pTable, char *zArg){
150301 assert( IsVirtual(pTable) );
150302 nBytes = sizeof(char *)*(2+pTable->u.vtab.nArg);
150303 if( pTable->u.vtab.nArg+3>=db->aLimit[SQLITE_LIMIT_COLUMN] ){
150304 sqlite3ErrorMsg(pParse, "too many columns on %s", pTable->zName);
150306 azModuleArg = sqlite3DbRealloc(db, pTable->u.vtab.azArg, nBytes);
150310 int i = pTable->u.vtab.nArg++;
150313 pTable->u.vtab.azArg = azModuleArg;
150329 Table *pTable; /* The new virtual table */
150333 pTable = pParse->pNewTable;
150334 if( pTable==0 ) return;
150335 assert( 0==pTable->pIndex );
150336 pTable->eTabType = TABTYP_VTAB;
150340 assert( pTable->u.vtab.nArg==0 );
150341 addModuleArgument(pParse, pTable, sqlite3NameFromToken(db, pModuleName));
150342 addModuleArgument(pParse, pTable, 0);
150343 addModuleArgument(pParse, pTable, sqlite3DbStrDup(db, pTable->zName));
150357 if( pTable->u.vtab.azArg ){
150358 int iDb = sqlite3SchemaToIndex(db, pTable->pSchema);
150360 sqlite3AuthCheck(pParse, SQLITE_CREATE_VTABLE, pTable->zName,
150361 pTable->u.vtab.azArg[0], pParse->db->aDb[iDb].zDbSName);
150369 ** virtual table currently under construction in pParse->pTable.
150805 pIdx->pTable = pTab;
151958 return pIdx->pTable->aCol[i].zCnName;
153092 Table *pTab = pIdx->pTable;
153701 if( (j>=0 && pIdx->pTable->aCol[j].notNull==0) || j==XN_EXPR ){
153959 }else if( HasRowid(pIdx->pTable) ){
153962 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
157007 if( iColumn==pIdx->pTable->iPKey ){
157010 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
157120 return pIdx->pTable->aCol[j].notNull;
157383 Table *pTable; /* The table being indexed */
157410 pTable = pSrc->pTab;
157435 "automatic index on %s(%s)", pTable->zName,
157436 pTable->aCol[iCol].zCnName);
157462 mxBitCol = MIN(BMS-1,pTable->nCol);
157463 testcase( pTable->nCol==BMS-1 );
157464 testcase( pTable->nCol==BMS-2 );
157469 nKeyCol += pTable->nCol - BMS + 1;
157477 pIdx->pTable = pTable;
157512 for(i=BMS-1; i<pTable->nCol; i++){
157527 VdbeComment((v, "for %s", pTable->zName));
157676 assert( pIdx->pTable==pItem->pTab );
157677 sqlite3ExprCodeGetColumnOfTable(v, pIdx->pTable, iCur, iCol,r1+jj);
159302 idxaff = sqlite3TableColumnAffinity(pIdx->pTable, pLhs->iColumn);
159363 pProbe->pTable->zName,pProbe->zName,
159650 ApplyCostMultiplier(pNew->rRun, pProbe->pTable->costMult);
159723 pProbe->pTable->zName, pProbe->zName, saved_nEq, rc));
159969 sPk.pTable = pTab;
161040 assert( nColumn==nKeyCol+1 || !HasRowid(pIndex->pTable) );
161042 || !HasRowid(pIndex->pTable));
161107 if( iColumn==pIndex->pTable->iPKey ) iColumn = XN_ROWID;
161119 && pIndex->pTable->aCol[iColumn].notNull==0
162047 pTab = pIdx->pTable;
163021 if( pWInfo->eOnePass==ONEPASS_OFF || !HasRowid(pIdx->pTable) ){
163059 assert( pIdx->pTable==pTab );
215571 SessionTable *pTable; /* List of attached tables */
215625 ** stored in a linked list starting at sqlite3_session.pTable.
216974 for(pRet=pSession->pTable; pRet; pRet=pRet->pNext){
216986 pRet = pSession->pTable;
217430 sessionDeleteTable(pSession, pSession->pTable);
217475 for(pTab=pSession->pTable; pTab; pTab=pTab->pNext){
217495 for(ppTab=&pSession->pTable; *ppTab; ppTab=&(*ppTab)->pNext);
218086 for(pTab=pSession->pTable; rc==SQLITE_OK && pTab; pTab=pTab->pNext){
218276 for(pTab=pSession->pTable; pTab && ret==0; pTab=pTab->pNext){
218300 if( pSession->pTable ){