Lines Matching refs:iDb
33 int iDb; /* The database containing the table to be locked */ member
51 int iDb, /* Index of the database containing the table to lock */ in lockTable() argument
60 assert( iDb>=0 ); in lockTable()
65 if( p->iDb==iDb && p->iTab==iTab ){ in lockTable()
76 p->iDb = iDb; in lockTable()
87 int iDb, /* Index of the database containing the table to lock */ in sqlite3TableLock() argument
92 if( iDb==1 ) return; in sqlite3TableLock()
93 if( !sqlite3BtreeSharable(pParse->db->aDb[iDb].pBt) ) return; in sqlite3TableLock()
94 lockTable(pParse, iDb, iTab, isWriteLock, zName); in sqlite3TableLock()
108 int p1 = p->iDb; in codeTableLocks()
143 int iDb, i; in sqlite3FinishCoding() local
212 iDb = 0; in sqlite3FinishCoding()
215 if( DbMaskTest(pParse->cookieMask, iDb)==0 ) continue; in sqlite3FinishCoding()
216 sqlite3VdbeUsesBtree(v, iDb); in sqlite3FinishCoding()
217 pSchema = db->aDb[iDb].pSchema; in sqlite3FinishCoding()
220 iDb, /* P1 */ in sqlite3FinishCoding()
221 DbMaskTest(pParse->writeMask,iDb), /* P2 */ in sqlite3FinishCoding()
228 }while( ++iDb<db->nDb ); in sqlite3FinishCoding()
504 int iDb = sqlite3SchemaToIndex(pParse->db, p->pSchema); in sqlite3LocateTableItem() local
505 zDb = pParse->db->aDb[iDb].zDbSName; in sqlite3LocateTableItem()
580 void sqlite3UnlinkAndDeleteIndex(sqlite3 *db, int iDb, const char *zIdxName){ in sqlite3UnlinkAndDeleteIndex() argument
584 assert( sqlite3SchemaMutexHeld(db, iDb, 0) ); in sqlite3UnlinkAndDeleteIndex()
585 pHash = &db->aDb[iDb].pSchema->idxHash; in sqlite3UnlinkAndDeleteIndex()
640 void sqlite3ResetOneSchema(sqlite3 *db, int iDb){ in sqlite3ResetOneSchema() argument
642 assert( iDb<db->nDb ); in sqlite3ResetOneSchema()
644 if( iDb>=0 ){ in sqlite3ResetOneSchema()
645 assert( sqlite3SchemaMutexHeld(db, iDb, 0) ); in sqlite3ResetOneSchema()
646 DbSetProperty(db, iDb, DB_ResetWanted); in sqlite3ResetOneSchema()
884 void sqlite3UnlinkAndDeleteTable(sqlite3 *db, int iDb, const char *zTabName){ in sqlite3UnlinkAndDeleteTable() argument
889 assert( iDb>=0 && iDb<db->nDb ); in sqlite3UnlinkAndDeleteTable()
891 assert( sqlite3SchemaMutexHeld(db, iDb, 0) ); in sqlite3UnlinkAndDeleteTable()
893 pDb = &db->aDb[iDb]; in sqlite3UnlinkAndDeleteTable()
927 void sqlite3OpenSchemaTable(Parse *p, int iDb){ in sqlite3OpenSchemaTable() argument
929 sqlite3TableLock(p, iDb, SCHEMA_ROOT, 1, LEGACY_SCHEMA_TABLE); in sqlite3OpenSchemaTable()
930 sqlite3VdbeAddOp4Int(v, OP_OpenWrite, 0, SCHEMA_ROOT, iDb, 5); in sqlite3OpenSchemaTable()
993 int iDb; /* Database holding the object */ in sqlite3TwoPartName() local
1003 iDb = sqlite3FindDb(db, pName1); in sqlite3TwoPartName()
1004 if( iDb<0 ){ in sqlite3TwoPartName()
1009 assert( db->init.iDb==0 || db->init.busy || IN_SPECIAL_PARSE in sqlite3TwoPartName()
1011 iDb = db->init.iDb; in sqlite3TwoPartName()
1014 return iDb; in sqlite3TwoPartName()
1224 int iDb; /* Database number to create the table in */ in sqlite3StartTable() local
1229 iDb = db->init.iDb; in sqlite3StartTable()
1230 zName = sqlite3DbStrDup(db, SCHEMA_TABLE(iDb)); in sqlite3StartTable()
1234 iDb = sqlite3TwoPartName(pParse, pName1, pName2, &pName); in sqlite3StartTable()
1235 if( iDb<0 ) return; in sqlite3StartTable()
1236 if( !OMIT_TEMPDB && isTemp && pName2->n>0 && iDb!=1 ){ in sqlite3StartTable()
1242 if( !OMIT_TEMPDB && isTemp ) iDb = 1; in sqlite3StartTable()
1253 if( db->init.iDb==1 ) isTemp = 1; in sqlite3StartTable()
1264 char *zDb = db->aDb[iDb].zDbSName; in sqlite3StartTable()
1283 char *zDb = db->aDb[iDb].zDbSName; in sqlite3StartTable()
1294 sqlite3CodeVerifySchema(pParse, iDb); in sqlite3StartTable()
1314 pTable->pSchema = db->aDb[iDb].pSchema; in sqlite3StartTable()
1338 sqlite3BeginWriteOperation(pParse, 1, iDb); in sqlite3StartTable()
1352 sqlite3VdbeAddOp3(v, OP_ReadCookie, iDb, reg3, BTREE_FILE_FORMAT); in sqlite3StartTable()
1353 sqlite3VdbeUsesBtree(v, iDb); in sqlite3StartTable()
1357 sqlite3VdbeAddOp3(v, OP_SetCookie, iDb, BTREE_FILE_FORMAT, fileFormat); in sqlite3StartTable()
1358 sqlite3VdbeAddOp3(v, OP_SetCookie, iDb, BTREE_TEXT_ENCODING, ENC(db)); in sqlite3StartTable()
1378 sqlite3VdbeAddOp3(v, OP_CreateBtree, iDb, reg2, BTREE_INTKEY); in sqlite3StartTable()
1380 sqlite3OpenSchemaTable(pParse, iDb); in sqlite3StartTable()
1742 int isInit = db->init.busy && db->init.iDb!=1; in sqlite3AddDefaultValue()
1918 && !sqlite3BtreeIsReadonly(db->aDb[db->init.iDb].pBt) in sqlite3AddCheckConstraint()
2043 void sqlite3ChangeCookie(Parse *pParse, int iDb){ in sqlite3ChangeCookie() argument
2046 assert( sqlite3SchemaMutexHeld(db, iDb, 0) ); in sqlite3ChangeCookie()
2047 sqlite3VdbeAddOp3(v, OP_SetCookie, iDb, BTREE_SCHEMA_VERSION, in sqlite3ChangeCookie()
2048 (int)(1+(unsigned)db->aDb[iDb].pSchema->schema_cookie)); in sqlite3ChangeCookie()
2624 int iDb; /* Database in which the table lives */ in sqlite3EndTable() local
2712 iDb = sqlite3SchemaToIndex(db, p->pSchema); in sqlite3EndTable()
2832 sqlite3VdbeAddOp3(v, OP_OpenWrite, 1, pParse->regRoot, iDb); in sqlite3EndTable()
2882 db->aDb[iDb].zDbSName, in sqlite3EndTable()
2891 sqlite3ChangeCookie(pParse, iDb); in sqlite3EndTable()
2898 Db *pDb = &db->aDb[iDb]; in sqlite3EndTable()
2899 assert( sqlite3SchemaMutexHeld(db, iDb, 0) ); in sqlite3EndTable()
2910 sqlite3VdbeAddParseSchemaOp(v, iDb, in sqlite3EndTable()
2919 assert( sqlite3SchemaMutexHeld(db, iDb, 0) ); in sqlite3EndTable()
2936 assert( sqlite3SchemaMutexHeld(db, iDb, 0) ); in sqlite3EndTable()
2973 int iDb; in sqlite3CreateView() local
2994 iDb = sqlite3SchemaToIndex(db, p->pSchema); in sqlite3CreateView()
2995 sqlite3FixInit(&sFix, pParse, iDb, "view", pName); in sqlite3CreateView()
3218 void sqlite3RootPageMoved(sqlite3 *db, int iDb, Pgno iFrom, Pgno iTo){ in sqlite3RootPageMoved() argument
3223 assert( sqlite3SchemaMutexHeld(db, iDb, 0) ); in sqlite3RootPageMoved()
3224 pDb = &db->aDb[iDb]; in sqlite3RootPageMoved()
3248 static void destroyRootPage(Parse *pParse, int iTable, int iDb){ in destroyRootPage() argument
3252 sqlite3VdbeAddOp3(v, OP_Destroy, iTable, r1, iDb); in destroyRootPage()
3267 pParse->db->aDb[iDb].zDbSName, iTable, r1, r1); in destroyRootPage()
3315 int iDb = sqlite3SchemaToIndex(pParse->db, pTab->pSchema); in destroyTable() local
3316 assert( iDb>=0 && iDb<pParse->db->nDb ); in destroyTable()
3317 destroyRootPage(pParse, iLargest, iDb); in destroyTable()
3329 int iDb, /* The database number */ in sqlite3ClearStatTables() argument
3334 const char *zDbName = pParse->db->aDb[iDb].zDbSName; in sqlite3ClearStatTables()
3350 void sqlite3CodeDropTable(Parse *pParse, Table *pTab, int iDb, int isView){ in sqlite3CodeDropTable() argument
3354 Db *pDb = &db->aDb[iDb]; in sqlite3CodeDropTable()
3358 sqlite3BeginWriteOperation(pParse, 1, iDb); in sqlite3CodeDropTable()
3411 sqlite3VdbeAddOp4(v, OP_VDestroy, iDb, 0, 0, pTab->zName, 0); in sqlite3CodeDropTable()
3414 sqlite3VdbeAddOp4(v, OP_DropTable, iDb, 0, 0, pTab->zName, 0); in sqlite3CodeDropTable()
3415 sqlite3ChangeCookie(pParse, iDb); in sqlite3CodeDropTable()
3416 sqliteViewResetAll(db, iDb); in sqlite3CodeDropTable()
3462 int iDb; in sqlite3DropTable() local
3482 iDb = sqlite3SchemaToIndex(db, pTab->pSchema); in sqlite3DropTable()
3483 assert( iDb>=0 && iDb<db->nDb ); in sqlite3DropTable()
3494 const char *zTab = SCHEMA_TABLE(iDb); in sqlite3DropTable()
3495 const char *zDb = db->aDb[iDb].zDbSName; in sqlite3DropTable()
3501 if( !OMIT_TEMPDB && iDb==1 ){ in sqlite3DropTable()
3512 if( !OMIT_TEMPDB && iDb==1 ){ in sqlite3DropTable()
3550 sqlite3BeginWriteOperation(pParse, 1, iDb); in sqlite3DropTable()
3552 sqlite3ClearStatTables(pParse, iDb, "tbl", pTab->zName); in sqlite3DropTable()
3555 sqlite3CodeDropTable(pParse, pTab, iDb, isView); in sqlite3DropTable()
3746 int iDb = sqlite3SchemaToIndex(db, pIndex->pSchema); in sqlite3RefillIndex() local
3750 db->aDb[iDb].zDbSName ) ){ in sqlite3RefillIndex()
3756 sqlite3TableLock(pParse, iDb, pTab->tnum, 1, pTab->zName); in sqlite3RefillIndex()
3775 sqlite3OpenTable(pParse, iTab, iDb, pTab, OP_OpenRead); in sqlite3RefillIndex()
3785 if( memRootPage<0 ) sqlite3VdbeAddOp2(v, OP_Clear, tnum, iDb); in sqlite3RefillIndex()
3786 sqlite3VdbeAddOp4(v, OP_OpenWrite, iIdx, (int)tnum, iDb, in sqlite3RefillIndex()
3922 int iDb; /* Index of the database that is being written */ in sqlite3CreateIndex() local
3955 iDb = sqlite3TwoPartName(pParse, pName1, pName2, &pName); in sqlite3CreateIndex()
3956 if( iDb<0 ) goto exit_create_index; in sqlite3CreateIndex()
3967 iDb = 1; in sqlite3CreateIndex()
3972 sqlite3FixInit(&sFix, pParse, iDb, "index", pName); in sqlite3CreateIndex()
3981 if( iDb==1 && db->aDb[iDb].pSchema!=pTab->pSchema ){ in sqlite3CreateIndex()
3993 iDb = sqlite3SchemaToIndex(db, pTab->pSchema); in sqlite3CreateIndex()
3995 pDb = &db->aDb[iDb]; in sqlite3CreateIndex()
4053 sqlite3CodeVerifySchema(pParse, iDb); in sqlite3CreateIndex()
4081 if( sqlite3AuthCheck(pParse, SQLITE_INSERT, SCHEMA_TABLE(iDb), 0, zDb) ){ in sqlite3CreateIndex()
4085 if( !OMIT_TEMPDB && iDb==1 ) i = SQLITE_CREATE_TEMP_INDEX; in sqlite3CreateIndex()
4143 pIndex->pSchema = db->aDb[iDb].pSchema; in sqlite3CreateIndex()
4150 assert( sqlite3SchemaMutexHeld(db, iDb, 0) ); in sqlite3CreateIndex()
4393 sqlite3BeginWriteOperation(pParse, 1, iDb); in sqlite3CreateIndex()
4402 sqlite3VdbeAddOp3(v, OP_CreateBtree, iDb, iMem, BTREE_BLOBKEY); in sqlite3CreateIndex()
4424 db->aDb[iDb].zDbSName, in sqlite3CreateIndex()
4437 sqlite3ChangeCookie(pParse, iDb); in sqlite3CreateIndex()
4438 sqlite3VdbeAddParseSchemaOp(v, iDb, in sqlite3CreateIndex()
4561 int iDb; in sqlite3DropIndex() local
4587 iDb = sqlite3SchemaToIndex(db, pIndex->pSchema); in sqlite3DropIndex()
4592 const char *zDb = db->aDb[iDb].zDbSName; in sqlite3DropIndex()
4593 const char *zTab = SCHEMA_TABLE(iDb); in sqlite3DropIndex()
4597 if( !OMIT_TEMPDB && iDb==1 ) code = SQLITE_DROP_TEMP_INDEX; in sqlite3DropIndex()
4607 sqlite3BeginWriteOperation(pParse, 1, iDb); in sqlite3DropIndex()
4610 db->aDb[iDb].zDbSName, pIndex->zName in sqlite3DropIndex()
4612 sqlite3ClearStatTables(pParse, iDb, "idx", pIndex->zName); in sqlite3DropIndex()
4613 sqlite3ChangeCookie(pParse, iDb); in sqlite3DropIndex()
4614 destroyRootPage(pParse, pIndex->tnum, iDb); in sqlite3DropIndex()
4615 sqlite3VdbeAddOp4(v, OP_DropIndex, iDb, 0, 0, pIndex->zName, 0); in sqlite3DropIndex()
5224 static void sqlite3CodeVerifySchemaAtToplevel(Parse *pToplevel, int iDb){ in sqlite3CodeVerifySchemaAtToplevel() argument
5225 assert( iDb>=0 && iDb<pToplevel->db->nDb ); in sqlite3CodeVerifySchemaAtToplevel()
5226 assert( pToplevel->db->aDb[iDb].pBt!=0 || iDb==1 ); in sqlite3CodeVerifySchemaAtToplevel()
5227 assert( iDb<SQLITE_MAX_DB ); in sqlite3CodeVerifySchemaAtToplevel()
5228 assert( sqlite3SchemaMutexHeld(pToplevel->db, iDb, 0) ); in sqlite3CodeVerifySchemaAtToplevel()
5229 if( DbMaskTest(pToplevel->cookieMask, iDb)==0 ){ in sqlite3CodeVerifySchemaAtToplevel()
5230 DbMaskSet(pToplevel->cookieMask, iDb); in sqlite3CodeVerifySchemaAtToplevel()
5231 if( !OMIT_TEMPDB && iDb==1 ){ in sqlite3CodeVerifySchemaAtToplevel()
5236 void sqlite3CodeVerifySchema(Parse *pParse, int iDb){ in sqlite3CodeVerifySchema() argument
5237 sqlite3CodeVerifySchemaAtToplevel(sqlite3ParseToplevel(pParse), iDb); in sqlite3CodeVerifySchema()
5269 void sqlite3BeginWriteOperation(Parse *pParse, int setStatement, int iDb){ in sqlite3BeginWriteOperation() argument
5271 sqlite3CodeVerifySchemaAtToplevel(pToplevel, iDb); in sqlite3BeginWriteOperation()
5272 DbMaskSet(pToplevel->writeMask, iDb); in sqlite3BeginWriteOperation()
5421 int iDb = sqlite3SchemaToIndex(pParse->db, pTab->pSchema); in reindexTable() local
5422 sqlite3BeginWriteOperation(pParse, 0, iDb); in reindexTable()
5438 int iDb; /* The database index number */ in reindexDatabases() local
5444 for(iDb=0, pDb=db->aDb; iDb<db->nDb; iDb++, pDb++){ in reindexDatabases()
5474 int iDb; /* The database index number */ in sqlite3Reindex() local
5500 iDb = sqlite3TwoPartName(pParse, pName1, pName2, &pObjName); in sqlite3Reindex()
5501 if( iDb<0 ) return; in sqlite3Reindex()
5504 zDb = db->aDb[iDb].zDbSName; in sqlite3Reindex()
5514 sqlite3BeginWriteOperation(pParse, 0, iDb); in sqlite3Reindex()