Lines Matching refs:zDb
8200 const char *zDb,
10010 SQLITE_API int sqlite3_wal_checkpoint(sqlite3 *db, const char *zDb);
10106 const char *zDb, /* Name of attached database (or NULL) */
10500 char const *zDb, /* Database name */
10713 SQLITE_API SQLITE_EXPERIMENTAL int sqlite3_snapshot_recover(sqlite3 *db, const char *zDb);
11031 const char *zDb, /* Name of db (e.g. "main") */
18919 const char *zDb; /* Make sure all objects are contained in this database */ member
19658 SQLITE_PRIVATE void sqlite3CodeVerifyNamedSchema(Parse*, const char *zDb);
39339 char zDb[MAX_PATHNAME+1]; /* Database file path */
39363 memcpy(zDb, zPath, nDb);
39364 zDb[nDb] = '\0';
39366 rc = getFileMode(zDb, pMode, pUid, pGid);
74944 static Btree *findBtree(sqlite3 *pErrorDb, sqlite3 *pDb, const char *zDb){
74945 int i = sqlite3FindDbName(pDb, zDb);
74964 sqlite3ErrorWithMsg(pErrorDb, SQLITE_ERROR, "unknown database %s", zDb);
82720 const char *zDb, /* Database name */
82761 db->xPreUpdateCallback(db->pPreUpdateArg, db, op, zDb, zTbl, iKey1, iKey2);
89995 const char *zDb; /* database name - used by the update hook */
90020 zDb = db->aDb[pC->iDb].zDbSName;
90025 zDb = 0; /* Not needed. Silence a compiler warning. */
90032 sqlite3VdbePreUpdateHook(p, pC, SQLITE_INSERT, zDb, pTab, x.nKey,pOp->p2);
90067 zDb, pTab->zName, x.nKey);
90109 const char *zDb;
90144 zDb = db->aDb[pC->iDb].zDbSName;
90150 zDb = 0; /* Not needed. Silence a compiler warning. */
90163 zDb, pTab, pC->movetoTarget,
90198 db->xUpdateCallback(db->pUpdateArg, SQLITE_DELETE, zDb, pTab->zName,
93178 char *zDb; /* Database name */
93267 const char *zDb, /* The attached database containing the blob */
93306 pTab = sqlite3LocateTable(&sParse, 0, zTable, zDb);
93332 pBlob->zDb = db->aDb[sqlite3SchemaToIndex(db, pTab->pSchema)].zDbSName;
93569 v, v->apCsr[0], SQLITE_DELETE, p->zDb, p->pTab, iKey, -1
97669 const char *zDb
97676 if( zDb && (sqlite3StrNICmp(zSpan, zDb, n)!=0 || zDb[n]!=0) ){
97762 const char *zDb, /* Name of the database containing table, or NULL */
97793 if( zDb ){
97801 zDb = 0;
97805 if( sqlite3StrICmp(db->aDb[i].zDbSName,zDb)==0 ){
97810 if( i==db->nDb && sqlite3StrICmp("main", zDb)==0 ){
97814 zDb = db->aDb[0].zDbSName;
97835 if( sqlite3MatchEName(&pEList->a[j], zCol, zTab, zDb) ){
97845 if( zDb && pTab->pSchema!=pSchema ){
97897 if( zDb==0 && zTab!=0 && cntTab==0 ){
98044 assert( zTab==0 && zDb==0 );
98112 if( zDb ){
98113 sqlite3ErrorMsg(pParse, "%s: %s.%s.%s", zErr, zDb, zTab, zCol);
98314 const char *zDb;
98318 zDb = 0;
98329 zDb = 0;
98332 zDb = pLeft->u.zToken;
98343 return lookupName(pParse, zDb, zTable, zColumn, pNC, pExpr);
105539 static void renameTestSchema(Parse *pParse, const char *zDb, int bTemp){
105546 zDb, MASTER_NAME,
105547 zDb, bTemp
105557 MASTER_NAME, zDb
105585 char *zDb; /* Name of database iDb */
105603 zDb = db->aDb[iDb].zDbSName;
105613 if( sqlite3FindTable(db, zName, zDb)
105614 || sqlite3FindIndex(db, zName, zDb)
105641 if( sqlite3AuthCheck(pParse, SQLITE_ALTER_TABLE, zDb, pTab->zName, 0) ){
105679 , zDb, MASTER_NAME, zDb, zTabName, zName, (iDb==1), zTabName
105695 zDb, MASTER_NAME,
105704 if( sqlite3FindTable(db, "sqlite_sequence", zDb) ){
105707 zDb, zName, pTab->zName);
105723 , zDb, zTabName, zName, zTabName, zDb, zName);
105740 renameTestSchema(pParse, zDb, iDb==1);
105754 const char *zDb, /* Schema holding the table */
105760 zErr, zDb, zTab
105776 const char *zDb; /* Database name */
105792 zDb = db->aDb[iDb].zDbSName;
105796 pTab = sqlite3FindTable(db, zTab, zDb);
105801 if( sqlite3AuthCheck(pParse, SQLITE_ALTER_TABLE, zDb, pTab->zName, 0) ){
105830 sqlite3ErrorIfNotEmpty(pParse, zDb, zTab,
105834 sqlite3ErrorIfNotEmpty(pParse, zDb, zTab,
105852 sqlite3ErrorIfNotEmpty(pParse, zDb, zTab,
105858 sqlite3ErrorIfNotEmpty(pParse, zDb, zTab, "cannot add a STORED column");
105875 zDb, MASTER_NAME, pNew->addColOffset, zCol, pNew->addColOffset+1,
106039 const char *zDb; /* Name of schema containing the table */
106054 zDb = db->aDb[iSchema].zDbSName;
106058 if( sqlite3AuthCheck(pParse, SQLITE_ALTER_TABLE, zDb, pTab->zName, 0) ){
106090 zDb, MASTER_NAME,
106091 zDb, pTab->zName, iCol, zNew, bQuote, iSchema==1,
106100 zDb, pTab->zName, iCol, zNew, bQuote
106105 renameTestSchema(pParse, zDb, iSchema==1);
106516 const char *zDb, /* Name of schema SQL belongs to */
106524 db->init.iDb = bTemp ? 1 : sqlite3FindDbName(db, zDb);
106651 static int renameResolveTrigger(Parse *pParse, const char *zDb){
106682 Table *pTarget = sqlite3LocateTable(pParse, 0, pStep->zTarget, zDb);
106802 const char *zDb = (const char*)sqlite3_value_text(argv[3]);
106825 pTab = sqlite3FindTable(db, zTable, zDb);
106837 rc = renameParseSql(&sParse, zDb, db, zSql, bTemp);
106905 rc = renameResolveTrigger(&sParse, (bTemp ? 0 : zDb));
106910 Table *pTarget = sqlite3LocateTable(&sParse, 0, pStep->zTarget, zDb);
107012 const char *zDb = (const char*)sqlite3_value_text(argv[0]);
107034 sCtx.pTab = sqlite3FindTable(db, zOld, zDb);
107041 rc = renameParseSql(&sParse, zDb, db, zInput, bTemp);
107108 rc = renameResolveTrigger(&sParse, bTemp ? 0 : zDb);
107169 char const *zDb = (const char*)sqlite3_value_text(argv[0]);
107180 if( zDb && zInput ){
107183 rc = renameParseSql(&sParse, zDb, db, zInput, bTemp);
107195 rc = renameResolveTrigger(&sParse, bTemp ? 0 : zDb);
107199 int i2 = sqlite3FindDbName(db, zDb);
108622 char *z, *zDb;
108649 zDb = pName2->n ? db->aDb[iDb].zDbSName : 0;
108652 if( (pIdx = sqlite3FindIndex(db, z, zDb))!=0 ){
108654 }else if( (pTab = sqlite3LocateTable(pParse, 0, z, zDb))!=0 ){
108904 const char *zDb
108906 Index *pIdx = sqlite3FindIndex(db, zName, zDb);
108908 Table *pTab = sqlite3FindTable(db, zName, zDb);
108930 const char *zDb /* Database name (e.g. "main") */
108939 zSql = sqlite3MPrintf(db, zSql1, zDb);
108960 pIdx = findIndexOrPrimaryKey(db, zIndex, zDb);
108991 zSql = sqlite3MPrintf(db, zSql2, zDb);
109006 pIdx = findIndexOrPrimaryKey(db, zIndex, zDb);
109046 static int loadStat4(sqlite3 *db, const char *zDb){
109050 if( sqlite3FindTable(db, "sqlite_stat4", zDb) ){
109054 zDb
109601 pFix->zDb = db->aDb[iDb].zDbSName;
109629 int iDb = sqlite3FindDbName(db, pFix->zDb);
109883 char *zDb = db->aDb[iDb].zDbSName; /* Schema name of attached database */
109887 rc = db->xAuth(db->pAuthArg, SQLITE_READ, zTab,zCol,zDb,pParse->zAuthContext
109894 if( db->nDb>2 || iDb!=0 ) z = sqlite3_mprintf("%s.%z", zDb, z);
110473 const char *zDb;
110477 zDb = pParse->db->aDb[iDb].zDbSName;
110479 zDb = p->zDatabase;
110481 return sqlite3LocateTable(pParse, flags, p->zName, zDb);
110496 SQLITE_PRIVATE Index *sqlite3FindIndex(sqlite3 *db, const char *zName, const char *zDb){
110500 assert( zDb!=0 || sqlite3BtreeHoldsAllMutexes(db) );
110505 if( zDb && sqlite3DbIsNamed(db, j, zDb)==0 ) continue;
111107 char *zDb = db->aDb[iDb].zDbSName;
111108 if( sqlite3AuthCheck(pParse, SQLITE_INSERT, SCHEMA_TABLE(isTemp), 0, zDb) ){
111112 zName, 0, zDb) ){
111126 char *zDb = db->aDb[iDb].zDbSName;
111130 pTable = sqlite3FindTable(db, zName, zDb);
111140 if( sqlite3FindIndex(db, zName, zDb)!=0 ){
113100 const char *zDb = db->aDb[iDb].zDbSName;
113102 if( sqlite3AuthCheck(pParse, SQLITE_DELETE, zTab, 0, zDb)){
113123 if( sqlite3AuthCheck(pParse, code, pTab->zName, zArg2, zDb) ){
113126 if( sqlite3AuthCheck(pParse, SQLITE_DELETE, pTab->zName, 0, zDb) ){
113682 const char *zDb = pDb->zDbSName;
113683 if( sqlite3AuthCheck(pParse, SQLITE_INSERT, SCHEMA_TABLE(iDb), 0, zDb) ){
113688 if( sqlite3AuthCheck(pParse, i, zName, pTab->zName, zDb) ){
114163 const char *zDb = db->aDb[iDb].zDbSName;
114165 if( sqlite3AuthCheck(pParse, SQLITE_DELETE, zTab, 0, zDb) ){
114169 if( sqlite3AuthCheck(pParse, code, pIndex->zName, pTab->zName, zDb) ){
114748 SQLITE_PRIVATE void sqlite3CodeVerifyNamedSchema(Parse *pParse, const char *zDb){
114753 if( pDb->pBt && (!zDb || 0==sqlite3StrICmp(zDb, pDb->zDbSName)) ){
114972 const char *zDb; /* Name of the database */
115005 zDb = db->aDb[iDb].zDbSName;
115006 pTab = sqlite3FindTable(db, z, zDb);
115012 pIndex = sqlite3FindIndex(db, z, zDb);
119580 const char *zDb; /* Name of database containing pTab */
119590 zDb = db->aDb[iDb].zDbSName;
119615 pTo = sqlite3FindTable(db, pFKey->zTo, zDb);
119617 pTo = sqlite3LocateTable(pParse, 0, pFKey->zTo, zDb);
125728 const char *zDb = 0; /* The database name */
125764 zDb = pId2->n>0 ? pDb->zDbSName : 0;
125765 if( sqlite3AuthCheck(pParse, SQLITE_PRAGMA, zLeft, zRight, zDb) ){
125789 rc = sqlite3_file_control(db, zDb, SQLITE_FCNTL_PRAGMA, (void*)aFcntl);
126251 rc = sqlite3_file_control(db, zDb, SQLITE_FCNTL_MMAP_SIZE, &sz);
126482 pTab = sqlite3LocateTable(pParse, LOCATE_NOERR, zRight, zDb);
126558 pIdx = sqlite3FindIndex(db, zRight, zDb);
126563 pTab = sqlite3LocateTable(pParse, LOCATE_NOERR, zRight, zDb);
126604 pTab = sqlite3FindTable(db, zRight, zDb);
126693 pTab = sqlite3FindTable(db, zRight, zDb);
126749 pTab = sqlite3LocateTable(pParse, 0, zRight, zDb);
126763 pParent = sqlite3FindTable(db, pFK->zTo, zDb);
126785 pParent = sqlite3FindTable(db, pFK->zTo, zDb);
127401 for(iDbLast = zDb?iDb:db->nDb-1; iDb<=iDbLast; iDb++){
128515 const char *zDb = db->aDb[i].zDbSName;
128516 sqlite3ErrorWithMsg(db, rc, "database schema is locked: %s", zDb);
136067 const char *zDb = db->aDb[iTabDb].zDbSName;
136068 const char *zDbTrig = isTemp ? db->aDb[1].zDbSName : zDb;
136073 if( sqlite3AuthCheck(pParse, SQLITE_INSERT, SCHEMA_TABLE(iTabDb),0,zDb)){
136411 const char *zDb;
136421 zDb = pName->a[0].zDatabase;
136423 assert( zDb!=0 || sqlite3BtreeHoldsAllMutexes(db) );
136426 if( zDb && sqlite3DbIsNamed(db, j, zDb)==0 ) continue;
136435 sqlite3CodeVerifyNamedSchema(pParse, zDb);
136471 const char *zDb = db->aDb[iDb].zDbSName;
136474 if( sqlite3AuthCheck(pParse, code, pTrigger->zName, pTable->zName, zDb) ||
136475 sqlite3AuthCheck(pParse, SQLITE_DELETE, zTab, 0, zDb) ){
136595 const char *zDb;
136597 zDb = db->aDb[iDb].zDbSName;
136598 pSrc->a[pSrc->nSrc-1].zDatabase = sqlite3DbStrDup(db, zDb);
162431 const char *zDb, /* Database */
162436 sqlite3_wal_checkpoint(db, zDb);
162504 const char *zDb, /* Name of attached database (or NULL) */
162534 if( zDb && zDb[0] ){
162535 iDb = sqlite3FindDbName(db, zDb);
162539 sqlite3ErrorWithMsg(db, SQLITE_ERROR, "unknown database: %s", zDb);
162564 SQLITE_API int sqlite3_wal_checkpoint(sqlite3 *db, const char *zDb){
162567 return sqlite3_wal_checkpoint_v2(db,zDb,SQLITE_CHECKPOINT_PASSIVE,0,0);
164586 const char *zDb,
164600 int iDb = sqlite3FindDbName(db, zDb);
164622 const char *zDb,
164636 iDb = sqlite3FindDbName(db, zDb);
164676 SQLITE_API int sqlite3_snapshot_recover(sqlite3 *db, const char *zDb){
164688 iDb = sqlite3FindDbName(db, zDb);
165908 const char *zDb; /* logical database name */
166633 const char *zDb = p->zDb; /* Name of database (e.g. "main", "temp") */
166643 zDb, p->zName,
166644 zDb, p->zName,
166645 zDb, p->zName,
166646 zDb, p->zName,
166647 (p->zContentTbl ? "--" : ""), zDb,p->zName
166708 p->zDb, p->zName
166745 p->zDb, p->zName, zContentCols
166753 p->zDb, p->zName
166765 p->zDb, p->zName
166770 p->zDb, p->zName
166793 zSql = sqlite3_mprintf("PRAGMA %Q.page_size", p->zDb);
166951 p->zDb,
167133 const char *zDb, /* Name of db (i.e. "main", "temp" etc.) */
167144 zSql = sqlite3_mprintf("SELECT * FROM %Q.%Q", zDb, zTbl);
167488 p->zDb = zCsr;
169606 int res = sqlite3_table_column_metadata(p->db, p->zDb, zTbl, 0,0,0,0,0,0);
169916 p->zDb, p->zName, zName
169923 p->zDb, p->zName, zName
169929 p->zDb, p->zName, zName
169934 p->zDb, p->zName, zName
169938 p->zDb, p->zName, zName
172188 char const *zDb; /* Name of database (e.g. "main") */
172205 zDb = argv[1];
172206 nDb = (int)strlen(zDb);
172208 if( nDb==4 && 0==sqlite3_strnicmp("temp", zDb, 4) ){
172209 zDb = argv[3];
172210 nDb = (int)strlen(zDb);
172229 p->pFts3Tab->zDb = (char *)&p->pFts3Tab[1];
172230 p->pFts3Tab->zName = &p->pFts3Tab->zDb[nDb+1];
172234 memcpy((char *)p->pFts3Tab->zDb, zDb, nDb);
176639 zSql = sqlite3_mprintf(azSql[eStmt], p->zDb, p->zName, p->zWriteExprlist);
176644 zSql = sqlite3_mprintf(azSql[eStmt], p->zDb, p->zName);
177452 p->db, p->zDb, p->zSegmentsTbl, "block", iBlockid, 0, &p->pSegments
187329 char *zDb; /* Name of database containing r-tree table */
187895 rc = sqlite3_blob_open(pRtree->db, pRtree->zDb, zTab, "data", iNode, 0,
188215 pRtree->zDb, pRtree->zName,
188216 pRtree->zDb, pRtree->zName,
188217 pRtree->zDb, pRtree->zName
190322 zSql = sqlite3_mprintf("SELECT * FROM %Q.%Q", pRtree->zDb, pRtree->zName);
190530 , pRtree->zDb, pRtree->zName, zNewName
190531 , pRtree->zDb, pRtree->zName, zNewName
190532 , pRtree->zDb, pRtree->zName, zNewName
190579 db, pRtree->zDb, "sqlite_stat1",0,0,0,0,0,0
190585 zSql = sqlite3_mprintf(zFmt, pRtree->zDb, pRtree->zName);
190656 const char *zDb,
190690 zDb, zPrefix);
190696 zDb, zPrefix);
190699 zDb, zPrefix);
190702 zDb, zPrefix, pRtree->iNodeSize);
190735 zSql = sqlite3_mprintf(zFormat, zDb, zPrefix);
190746 zDb, zPrefix);
190753 sqlite3_str_appendf(p, "UPDATE \"%w\".\"%w_rowid\"SET ", zDb, zPrefix);
190823 zSql = sqlite3_mprintf("PRAGMA %Q.page_size", pRtree->zDb);
190836 pRtree->zDb, pRtree->zName
190914 pRtree->zDb = (char *)&pRtree[1];
190915 pRtree->zName = &pRtree->zDb[nDb+1];
190917 memcpy(pRtree->zDb, argv[1], nDb);
191077 const char *zDb; /* Database containing rtree table */
191178 pCheck->zDb, pCheck->zTab
191232 azSql[bLeaf], pCheck->zDb, pCheck->zTab
191381 pCheck->zDb, pCheck->zTab, zTbl
191403 const char *zDb, /* Name of db ("main", "temp" etc.) */
191415 check.zDb = zDb;
191428 pStmt = rtreeCheckPrepare(&check, "SELECT * FROM %Q.'%q_rowid'", zDb, zTab);
191437 pStmt = rtreeCheckPrepare(&check, "SELECT * FROM %Q.%Q", zDb, zTab);
191518 const char *zDb = (const char*)sqlite3_value_text(apArg[0]);
191521 zTab = zDb;
191522 zDb = "main";
191526 rc = rtreeCheckTable(sqlite3_context_db_handle(ctx), zDb, zTab, &zReport);
192784 pRtree->zDb = (char *)&pRtree[1];
192785 pRtree->zName = &pRtree->zDb[nDb+1];
192789 memcpy(pRtree->zDb, argv[1], nDb);
201586 char *zDb; /* Name of database session is attached to */
202505 const char *zDb, /* Name of attached database (e.g. "main") */
202527 rc = sqlite3_table_column_metadata(db, zDb, zThis, 0, 0, 0, 0, 0, 0);
202541 zPragma = sqlite3_mprintf("PRAGMA '%q'.table_info('%q')", zDb, zThis);
202623 pSession->rc = sessionTableInfo(pSession->db, pSession->zDb,
202875 char const *zDb, /* Database name */
202881 int nDb = sqlite3Strlen30(zDb);
202893 if( sqlite3_strnicmp(zDb, pSession->zDb, nDb+1) ) continue;
203088 pSession->zDb, zFrom, pTab->zName, pTab->azCol, pTab->abPK
203095 pSession->zDb, pTab->zName, zFrom, pTab->zName, zExpr, zExpr2
203125 const char *zDb = pSession->zDb;
203182 zDb, zFrom, pTo->zName, pTo->azCol, pTo->abPK
203188 rc = sessionDiffFindNew(SQLITE_INSERT, pSession, pTo, zDb, zFrom, zExpr);
203193 rc = sessionDiffFindNew(SQLITE_DELETE, pSession, pTo, zFrom, zDb, zExpr);
203216 const char *zDb, /* Name of db (e.g. "main") */
203221 int nDb = sqlite3Strlen30(zDb); /* Length of zDb in bytes */
203231 pNew->zDb = (char *)&pNew[1];
203233 memcpy(pNew->zDb, zDb, nDb+1);
203753 const char *zDb, /* Database name */
203767 "idx IS (CASE WHEN ?2=X'' THEN NULL ELSE ?2 END)", zDb
203776 sessionAppendIdent(&buf, zDb, &rc);
203943 rc = sessionTableInfo(db, pSession->zDb, zName, &nCol, 0, &azCol, &abPK);
203954 db, pSession->zDb, zName, nCol, azCol, abPK, &pSel);
207773 char *zDb; /* Database holding FTS index (e.g. "main") */
211383 pConfig->zContent = sqlite3Fts5Mprintf(&rc, "%Q.%Q", pConfig->zDb,zArg);
211579 pRet->zDb = sqlite3Fts5Strndup(&rc, azArg[1], -1);
211652 &rc, "%Q.'%q_%s'", pRet->zDb, pRet->zName, zTail
211682 sqlite3_free(pConfig->zDb);
211962 zSql = sqlite3Fts5Mprintf(&rc, zSelect, pConfig->zDb, pConfig->zName);
216108 pConfig->zDb, p->zDataTbl, "block", iRowid, 0, &p->pReader
216201 pConfig->zDb, pConfig->zName
216225 pConfig->zDb, pConfig->zName
216247 pConfig->zDb, pConfig->zName
216462 sqlite3_mprintf("PRAGMA %Q.data_version", p->pConfig->zDb)
217806 pConfig->zDb, pConfig->zName
219563 pConfig->zDb, pConfig->zName
221052 rc = sqlite3_blob_open(pConfig->db, pConfig->zDb, p->zDataTbl,
221384 pConfig->zDb, pConfig->zName, pSeg->iSegid
223066 pConfig->zDb, pConfig->zName, zRank, pConfig->zName,
225083 zSql = sqlite3_mprintf(azStmt[eStmt], pC->zDb, pC->zName, zBind);
225090 zSql = sqlite3_mprintf(azStmt[eStmt], pC->zDb, pC->zName);
225148 pConfig->zDb, pConfig->zName,
225149 pConfig->zDb, pConfig->zName,
225150 pConfig->zDb, pConfig->zName
225155 pConfig->zDb, pConfig->zName
225161 pConfig->zDb, pConfig->zName
225176 pConfig->zDb, pConfig->zName, zTail, zName, zTail
225212 pConfig->zDb, pConfig->zName, zPost, zDefn,
225527 pConfig->zDb, pConfig->zName,
225528 pConfig->zDb, pConfig->zName
225533 pConfig->zDb, pConfig->zName
225729 pConfig->zDb, pConfig->zName, zSuffix
228710 const char *zDb = bDb ? argv[3] : argv[1];
228713 int nDb = (int)strlen(zDb)+1;
228732 memcpy(pRet->zFts5Db, zDb, nDb);