Lines Matching refs:zDb
7698 const char *zDb,
9516 SQLITE_API int sqlite3_wal_checkpoint(sqlite3 *db, const char *zDb);
9612 const char *zDb, /* Name of attached database (or NULL) */
10024 char const *zDb, /* Database name */
10239 SQLITE_API SQLITE_EXPERIMENTAL int sqlite3_snapshot_recover(sqlite3 *db, const char *zDb);
10561 const char *zDb, /* Name of db (e.g. "main") */
18941 const char *zDb; /* Make sure all objects are contained in this database */ member
19582 SQLITE_PRIVATE void sqlite3CodeVerifyNamedSchema(Parse*, const char *zDb);
40236 char zDb[MAX_PATHNAME+1]; /* Database file path */
40260 memcpy(zDb, zPath, nDb);
40261 zDb[nDb] = '\0';
40263 rc = getFileMode(zDb, pMode, pUid, pGid);
76535 static Btree *findBtree(sqlite3 *pErrorDb, sqlite3 *pDb, const char *zDb){
76536 int i = sqlite3FindDbName(pDb, zDb);
76555 sqlite3ErrorWithMsg(pErrorDb, SQLITE_ERROR, "unknown database %s", zDb);
84377 const char *zDb, /* Database name */
84422 db->xPreUpdateCallback(db->pPreUpdateArg, db, op, zDb, zTbl, iKey1, iKey2);
91954 const char *zDb; /* database name - used by the update hook */
91979 zDb = db->aDb[pC->iDb].zDbSName;
91984 zDb = 0;
91991 sqlite3VdbePreUpdateHook(p,pC,SQLITE_INSERT,zDb,pTab,x.nKey,pOp->p2,-1);
92027 zDb, pTab->zName, x.nKey);
92096 const char *zDb;
92131 zDb = db->aDb[pC->iDb].zDbSName;
92137 zDb = 0;
92151 zDb, pTab, pC->movetoTarget,
92186 db->xUpdateCallback(db->pUpdateArg, SQLITE_DELETE, zDb, pTab->zName,
95207 char *zDb; /* Database name */
95299 const char *zDb, /* The attached database containing the blob */
95338 pTab = sqlite3LocateTable(&sParse, 0, zTable, zDb);
95364 pBlob->zDb = db->aDb[sqlite3SchemaToIndex(db, pTab->pSchema)].zDbSName;
95604 v, v->apCsr[0], SQLITE_DELETE, p->zDb, p->pTab, iKey, -1, p->iCol
99733 const char *zDb
99740 if( zDb && (sqlite3StrNICmp(zSpan, zDb, n)!=0 || zDb[n]!=0) ){
99827 const char *zDb, /* Name of the database containing table, or NULL */
99858 if( zDb ){
99866 zDb = 0;
99870 if( sqlite3StrICmp(db->aDb[i].zDbSName,zDb)==0 ){
99875 if( i==db->nDb && sqlite3StrICmp("main", zDb)==0 ){
99879 zDb = db->aDb[0].zDbSName;
99900 if( sqlite3MatchEName(&pEList->a[j], zCol, zTab, zDb) ){
99910 if( zDb && pTab->pSchema!=pSchema ){
99968 if( cnt==0 && zDb==0 ){
100133 assert( zTab==0 && zDb==0 );
100201 if( zDb ){
100202 sqlite3ErrorMsg(pParse, "%s: %s.%s.%s", zErr, zDb, zTab, zCol);
100453 const char *zDb;
100457 zDb = 0;
100469 zDb = 0;
100473 zDb = pLeft->u.zToken;
100486 return lookupName(pParse, zDb, zTable, zColumn, pNC, pExpr);
108047 const char *zDb, /* Name of db to verify schema of */
108059 zDb,
108060 zDb, bTemp, zWhen, bNoDQS
108070 zDb, zWhen, bNoDQS
108082 static void renameFixQuotes(Parse *pParse, const char *zDb, int bTemp){
108087 " AND sql NOT LIKE 'create virtual%%'" , zDb, zDb
108122 char *zDb; /* Name of database iDb */
108138 zDb = db->aDb[iDb].zDbSName;
108147 if( sqlite3FindTable(db, zName, zDb)
108148 || sqlite3FindIndex(db, zName, zDb)
108175 if( sqlite3AuthCheck(pParse, SQLITE_ALTER_TABLE, zDb, pTab->zName, 0) ){
108213 , zDb, zDb, zTabName, zName, (iDb==1), zTabName
108229 zDb,
108238 if( sqlite3FindTable(db, "sqlite_sequence", zDb) ){
108241 zDb, zName, pTab->zName);
108257 , zDb, zTabName, zName, zTabName, zDb, zName);
108274 renameTestSchema(pParse, zDb, iDb==1, "after rename", 0);
108287 const char *zDb, /* Schema holding the table */
108293 zErr, zDb, zTab
108309 const char *zDb; /* Database name */
108325 zDb = db->aDb[iDb].zDbSName;
108329 pTab = sqlite3FindTable(db, zTab, zDb);
108334 if( sqlite3AuthCheck(pParse, SQLITE_ALTER_TABLE, zDb, pTab->zName, 0) ){
108364 sqlite3ErrorIfNotEmpty(pParse, zDb, zTab,
108368 sqlite3ErrorIfNotEmpty(pParse, zDb, zTab,
108386 sqlite3ErrorIfNotEmpty(pParse, zDb, zTab,
108392 sqlite3ErrorIfNotEmpty(pParse, zDb, zTab, "cannot add a STORED column");
108412 zDb, pNew->u.tab.addColOffset, zCol, pNew->u.tab.addColOffset,
108447 zTab, zDb
108592 const char *zDb; /* Name of schema containing the table */
108607 zDb = db->aDb[iSchema].zDbSName;
108611 if( sqlite3AuthCheck(pParse, SQLITE_ALTER_TABLE, zDb, pTab->zName, 0) ){
108629 renameTestSchema(pParse, zDb, iSchema==1, "", 0);
108630 renameFixQuotes(pParse, zDb, iSchema==1);
108646 zDb,
108647 zDb, pTab->zName, iCol, zNew, bQuote, iSchema==1,
108655 zDb, pTab->zName, iCol, zNew, bQuote
108660 renameTestSchema(pParse, zDb, iSchema==1, "after rename", 1);
109115 const char *zDb, /* Name of schema SQL belongs to */
109123 db->init.iDb = bTemp ? 1 : sqlite3FindDbName(db, zDb);
109450 const char *zDb = (const char*)sqlite3_value_text(argv[3]);
109473 pTab = sqlite3FindTable(db, zTable, zDb);
109485 rc = renameParseSql(&sParse, zDb, db, zSql, bTemp);
109562 Table *pTarget = sqlite3LocateTable(&sParse, 0, pStep->zTarget, zDb);
109671 const char *zDb = (const char*)sqlite3_value_text(argv[0]);
109693 sCtx.pTab = sqlite3FindTable(db, zOld, zDb);
109700 rc = renameParseSql(&sParse, zDb, db, zInput, bTemp);
109842 char const *zDb = (const char*)sqlite3_value_text(argv[0]);
109853 if( zDb && zInput ){
109856 rc = renameParseSql(&sParse, zDb, db, zInput, 0);
109948 char const *zDb = (const char*)sqlite3_value_text(argv[0]);
109962 if( zDb && zInput ){
109967 rc = renameParseSql(&sParse, zDb, db, zInput, bTemp);
109984 int i2 = sqlite3FindDbName(db, zDb);
110022 const char *zDb = db->aDb[iSchema].zDbSName;
110036 rc = renameParseSql(&sParse, zDb, db, zSql, iSchema==1);
110082 const char *zDb; /* Database containing pTab ("main" etc.) */
110129 zDb = db->aDb[iDb].zDbSName;
110130 renameTestSchema(pParse, zDb, iDb==1, "", 0);
110131 renameFixQuotes(pParse, zDb, iDb==1);
110136 , zDb, iDb, iCol, pTab->zName
110141 renameTestSchema(pParse, zDb, iDb==1, "after drop column", 1);
111624 char *z, *zDb;
111651 zDb = pName2->n ? db->aDb[iDb].zDbSName : 0;
111654 if( (pIdx = sqlite3FindIndex(db, z, zDb))!=0 ){
111656 }else if( (pTab = sqlite3LocateTable(pParse, 0, z, zDb))!=0 ){
111906 const char *zDb
111908 Index *pIdx = sqlite3FindIndex(db, zName, zDb);
111910 Table *pTab = sqlite3FindTable(db, zName, zDb);
111932 const char *zDb /* Database name (e.g. "main") */
111941 zSql = sqlite3MPrintf(db, zSql1, zDb);
111962 pIdx = findIndexOrPrimaryKey(db, zIndex, zDb);
111994 zSql = sqlite3MPrintf(db, zSql2, zDb);
112009 pIdx = findIndexOrPrimaryKey(db, zIndex, zDb);
112049 static int loadStat4(sqlite3 *db, const char *zDb){
112054 if( (pStat4 = sqlite3FindTable(db, "sqlite_stat4", zDb))!=0
112060 zDb
112622 int iDb = sqlite3FindDbName(db, pFix->zDb);
112670 pFix->zDb = db->aDb[iDb].zDbSName;
112872 char *zDb = db->aDb[iDb].zDbSName; /* Schema name of attached database */
112876 rc = db->xAuth(db->pAuthArg, SQLITE_READ, zTab,zCol,zDb,pParse->zAuthContext
112883 if( db->nDb>2 || iDb!=0 ) z = sqlite3_mprintf("%s.%z", zDb, z);
113539 const char *zDb;
113543 zDb = pParse->db->aDb[iDb].zDbSName;
113545 zDb = p->zDatabase;
113547 return sqlite3LocateTable(pParse, flags, p->zName, zDb);
113578 SQLITE_PRIVATE Index *sqlite3FindIndex(sqlite3 *db, const char *zName, const char *zDb){
113582 assert( zDb!=0 || sqlite3BtreeHoldsAllMutexes(db) );
113587 if( zDb && sqlite3DbIsNamed(db, j, zDb)==0 ) continue;
114299 char *zDb = db->aDb[iDb].zDbSName;
114300 if( sqlite3AuthCheck(pParse, SQLITE_INSERT, SCHEMA_TABLE(isTemp), 0, zDb) ){
114304 zName, 0, zDb) ){
114318 char *zDb = db->aDb[iDb].zDbSName;
114322 pTable = sqlite3FindTable(db, zName, zDb);
114333 if( sqlite3FindIndex(db, zName, zDb)!=0 ){
116515 const char *zDb = db->aDb[iDb].zDbSName;
116517 if( sqlite3AuthCheck(pParse, SQLITE_DELETE, zTab, 0, zDb)){
116538 if( sqlite3AuthCheck(pParse, code, pTab->zName, zArg2, zDb) ){
116541 if( sqlite3AuthCheck(pParse, SQLITE_DELETE, pTab->zName, 0, zDb) ){
117099 const char *zDb = pDb->zDbSName;
117100 if( sqlite3AuthCheck(pParse, SQLITE_INSERT, SCHEMA_TABLE(iDb), 0, zDb) ){
117105 if( sqlite3AuthCheck(pParse, i, zName, pTab->zName, zDb) ){
117609 const char *zDb = db->aDb[iDb].zDbSName;
117611 if( sqlite3AuthCheck(pParse, SQLITE_DELETE, zTab, 0, zDb) ){
117615 if( sqlite3AuthCheck(pParse, code, pIndex->zName, pTab->zName, zDb) ){
118226 SQLITE_PRIVATE void sqlite3CodeVerifyNamedSchema(Parse *pParse, const char *zDb){
118231 if( pDb->pBt && (!zDb || 0==sqlite3StrICmp(zDb, pDb->zDbSName)) ){
118452 const char *zDb; /* Name of the database */
118485 zDb = db->aDb[iDb].zDbSName;
118486 pTab = sqlite3FindTable(db, z, zDb);
118492 pIndex = sqlite3FindIndex(db, z, zDb);
123446 const char *zDb; /* Name of database containing pTab */
123457 zDb = db->aDb[iDb].zDbSName;
123482 pTo = sqlite3FindTable(db, pFKey->zTo, zDb);
123484 pTo = sqlite3LocateTable(pParse, 0, pFKey->zTo, zDb);
129898 const char *zDb = 0; /* The database name */
129934 zDb = pId2->n>0 ? pDb->zDbSName : 0;
129935 if( sqlite3AuthCheck(pParse, SQLITE_PRAGMA, zLeft, zRight, zDb) ){
129959 rc = sqlite3_file_control(db, zDb, SQLITE_FCNTL_PRAGMA, (void*)aFcntl);
130431 rc = sqlite3_file_control(db, zDb, SQLITE_FCNTL_MMAP_SIZE, &sz);
130670 sqlite3CodeVerifyNamedSchema(pParse, zDb);
130671 pTab = sqlite3LocateTable(pParse, LOCATE_NOERR, zRight, zDb);
130735 sqlite3CodeVerifyNamedSchema(pParse, zDb);
130740 if( zDb && sqlite3_stricmp(zDb, db->aDb[ii].zDbSName)!=0 ) continue;
130824 pIdx = sqlite3FindIndex(db, zRight, zDb);
130829 pTab = sqlite3LocateTable(pParse, LOCATE_NOERR, zRight, zDb);
130870 pTab = sqlite3FindTable(db, zRight, zDb);
130961 pTab = sqlite3FindTable(db, zRight, zDb);
131016 pTab = sqlite3LocateTable(pParse, 0, zRight, zDb);
131024 zDb = db->aDb[iDb].zDbSName;
131032 pParent = sqlite3FindTable(db, pFK->zTo, zDb);
131055 pParent = sqlite3FindTable(db, pFK->zTo, zDb);
131723 for(iDbLast = zDb?iDb:db->nDb-1; iDb<=iDbLast; iDb++){
132930 const char *zDb = db->aDb[i].zDbSName;
132931 sqlite3ErrorWithMsg(db, rc, "database schema is locked: %s", zDb);
141221 const char *zDb = db->aDb[iTabDb].zDbSName;
141222 const char *zDbTrig = isTemp ? db->aDb[1].zDbSName : zDb;
141227 if( sqlite3AuthCheck(pParse, SQLITE_INSERT, SCHEMA_TABLE(iTabDb),0,zDb)){
141588 const char *zDb;
141598 zDb = pName->a[0].zDatabase;
141600 assert( zDb!=0 || sqlite3BtreeHoldsAllMutexes(db) );
141603 if( zDb && sqlite3DbIsNamed(db, j, zDb)==0 ) continue;
141612 sqlite3CodeVerifyNamedSchema(pParse, zDb);
141648 const char *zDb = db->aDb[iDb].zDbSName;
141651 if( sqlite3AuthCheck(pParse, code, pTrigger->zName, pTable->zName, zDb) ||
141652 sqlite3AuthCheck(pParse, SQLITE_DELETE, zTab, 0, zDb) ){
168936 const char *zDb, /* Database */
168941 sqlite3_wal_checkpoint(db, zDb);
169009 const char *zDb, /* Name of attached database (or NULL) */
169039 if( zDb && zDb[0] ){
169040 iDb = sqlite3FindDbName(db, zDb);
169046 sqlite3ErrorWithMsg(db, SQLITE_ERROR, "unknown database: %s", zDb);
169071 SQLITE_API int sqlite3_wal_checkpoint(sqlite3 *db, const char *zDb){
169074 return sqlite3_wal_checkpoint_v2(db,zDb,SQLITE_CHECKPOINT_PASSIVE,0,0);
171187 const char *zDb,
171201 int iDb = sqlite3FindDbName(db, zDb);
171223 const char *zDb,
171237 iDb = sqlite3FindDbName(db, zDb);
171277 SQLITE_API int sqlite3_snapshot_recover(sqlite3 *db, const char *zDb){
171289 iDb = sqlite3FindDbName(db, zDb);
172512 const char *zDb; /* logical database name */
173233 const char *zDb = p->zDb; /* Name of database (e.g. "main", "temp") */
173243 zDb, p->zName,
173244 zDb, p->zName,
173245 zDb, p->zName,
173246 zDb, p->zName,
173247 (p->zContentTbl ? "--" : ""), zDb,p->zName
173308 p->zDb, p->zName
173345 p->zDb, p->zName, zContentCols
173353 p->zDb, p->zName
173365 p->zDb, p->zName
173370 p->zDb, p->zName
173393 zSql = sqlite3_mprintf("PRAGMA %Q.page_size", p->zDb);
173551 p->zDb,
173733 const char *zDb, /* Name of db (i.e. "main", "temp" etc.) */
173744 zSql = sqlite3_mprintf("SELECT * FROM %Q.%Q", zDb, zTbl);
174088 p->zDb = zCsr;
176209 int res = sqlite3_table_column_metadata(p->db, p->zDb, zTbl, 0,0,0,0,0,0);
176529 p->zDb, p->zName, zName
176536 p->zDb, p->zName, zName
176542 p->zDb, p->zName, zName
176547 p->zDb, p->zName, zName
176551 p->zDb, p->zName, zName
178809 char const *zDb; /* Name of database (e.g. "main") */
178826 zDb = argv[1];
178827 nDb = (int)strlen(zDb);
178829 if( nDb==4 && 0==sqlite3_strnicmp("temp", zDb, 4) ){
178830 zDb = argv[3];
178831 nDb = (int)strlen(zDb);
178850 p->pFts3Tab->zDb = (char *)&p->pFts3Tab[1];
178851 p->pFts3Tab->zName = &p->pFts3Tab->zDb[nDb+1];
178855 memcpy((char *)p->pFts3Tab->zDb, zDb, nDb);
183273 zSql = sqlite3_mprintf(azSql[eStmt], p->zDb, p->zName, p->zWriteExprlist);
183278 zSql = sqlite3_mprintf(azSql[eStmt], p->zDb, p->zName);
184086 p->db, p->zDb, p->zSegmentsTbl, "block", iBlockid, 0, &p->pSegments
194107 char *zDb; /* Name of database containing r-tree table */
194676 rc = sqlite3_blob_open(pRtree->db, pRtree->zDb, zTab, "data", iNode, 0,
194996 pRtree->zDb, pRtree->zName,
194997 pRtree->zDb, pRtree->zName,
194998 pRtree->zDb, pRtree->zName
197131 zSql = sqlite3_mprintf("SELECT * FROM %Q.%Q", pRtree->zDb, pRtree->zName);
197339 , pRtree->zDb, pRtree->zName, zNewName
197340 , pRtree->zDb, pRtree->zName, zNewName
197341 , pRtree->zDb, pRtree->zName, zNewName
197388 db, pRtree->zDb, "sqlite_stat1",0,0,0,0,0,0
197394 zSql = sqlite3_mprintf(zFmt, pRtree->zDb, pRtree->zName);
197455 const char *zDb,
197489 zDb, zPrefix);
197495 zDb, zPrefix);
197498 zDb, zPrefix);
197501 zDb, zPrefix, pRtree->iNodeSize);
197534 zSql = sqlite3_mprintf(zFormat, zDb, zPrefix);
197545 zDb, zPrefix);
197552 sqlite3_str_appendf(p, "UPDATE \"%w\".\"%w_rowid\"SET ", zDb, zPrefix);
197625 zSql = sqlite3_mprintf("PRAGMA %Q.page_size", pRtree->zDb);
197638 pRtree->zDb, pRtree->zName
197716 pRtree->zDb = (char *)&pRtree[1];
197717 pRtree->zName = &pRtree->zDb[nDb+1];
197719 memcpy(pRtree->zDb, argv[1], nDb);
197885 const char *zDb; /* Database containing rtree table */
197986 pCheck->zDb, pCheck->zTab
198040 azSql[bLeaf], pCheck->zDb, pCheck->zTab
198189 pCheck->zDb, pCheck->zTab, zTbl
198211 const char *zDb, /* Name of db ("main", "temp" etc.) */
198223 check.zDb = zDb;
198236 pStmt = rtreeCheckPrepare(&check, "SELECT * FROM %Q.'%q_rowid'", zDb, zTab);
198247 pStmt = rtreeCheckPrepare(&check, "SELECT * FROM %Q.%Q", zDb, zTab);
198328 const char *zDb = (const char*)sqlite3_value_text(apArg[0]);
198331 zTab = zDb;
198332 zDb = "main";
198336 rc = rtreeCheckTable(sqlite3_context_db_handle(ctx), zDb, zTab, &zReport);
199601 pRtree->zDb = (char *)&pRtree[1];
199602 pRtree->zName = &pRtree->zDb[nDb+1];
199606 memcpy(pRtree->zDb, argv[1], nDb);
208497 char *zDb; /* Name of database session is attached to */
209448 const char *zDb, /* Name of attached database (e.g. "main") */
209470 rc = sqlite3_table_column_metadata(db, zDb, zThis, 0, 0, 0, 0, 0, 0);
209488 zPragma = sqlite3_mprintf("PRAGMA '%q'.table_info('%q')", zDb, zThis);
209582 pSession->rc = sessionTableInfo(pSession, pSession->db, pSession->zDb,
209946 char const *zDb, /* Database name */
209952 int nDb = sqlite3Strlen30(zDb);
209964 if( sqlite3_strnicmp(zDb, pSession->zDb, nDb+1) ) continue;
210159 pSession->zDb, zFrom, pTab->zName, pTab->azCol, pTab->abPK
210166 pSession->zDb, pTab->zName, zFrom, pTab->zName, zExpr, zExpr2
210196 const char *zDb = pSession->zDb;
210253 zDb, zFrom, pTo->zName, pTo->azCol, pTo->abPK
210259 rc = sessionDiffFindNew(SQLITE_INSERT, pSession, pTo, zDb, zFrom, zExpr);
210264 rc = sessionDiffFindNew(SQLITE_DELETE, pSession, pTo, zFrom, zDb, zExpr);
210287 const char *zDb, /* Name of db (e.g. "main") */
210292 int nDb = sqlite3Strlen30(zDb); /* Length of zDb in bytes */
210302 pNew->zDb = (char *)&pNew[1];
210304 memcpy(pNew->zDb, zDb, nDb+1);
210844 const char *zDb, /* Database name */
210858 "idx IS (CASE WHEN ?2=X'' THEN NULL ELSE ?2 END)", zDb
210867 sessionAppendIdent(&buf, zDb, &rc);
211036 rc = sessionTableInfo(0, db, pSession->zDb, zName, &nCol, 0,&azCol,&abPK);
211047 db, pSession->zDb, zName, nCol, azCol, abPK, &pSel);
215030 char *zDb; /* Database holding FTS index (e.g. "main") */
218671 pConfig->zContent = sqlite3Fts5Mprintf(&rc, "%Q.%Q", pConfig->zDb,zArg);
218865 pRet->zDb = sqlite3Fts5Strndup(&rc, azArg[1], -1);
218943 &rc, "%Q.'%q_%s'", pRet->zDb, pRet->zName, zTail
218973 sqlite3_free(pConfig->zDb);
219253 zSql = sqlite3Fts5Mprintf(&rc, zSelect, pConfig->zDb, pConfig->zName);
223579 pConfig->zDb, p->zDataTbl, "block", iRowid, 0, &p->pReader
223673 pConfig->zDb, pConfig->zName
223697 pConfig->zDb, pConfig->zName
223719 pConfig->zDb, pConfig->zName
223988 sqlite3_mprintf("PRAGMA %Q.data_version", p->pConfig->zDb)
225334 pConfig->zDb, pConfig->zName
227106 pConfig->zDb, pConfig->zName
228682 rc = sqlite3_blob_open(pConfig->db, pConfig->zDb, p->zDataTbl,
229014 pConfig->zDb, pConfig->zName, pSeg->iSegid
230749 pConfig->zDb, pConfig->zName, zRank, pConfig->zName,
232792 zSql = sqlite3_mprintf(azStmt[eStmt], pC->zDb, pC->zName, zBind);
232799 zSql = sqlite3_mprintf(azStmt[eStmt], pC->zDb, pC->zName);
232857 pConfig->zDb, pConfig->zName,
232858 pConfig->zDb, pConfig->zName,
232859 pConfig->zDb, pConfig->zName
232864 pConfig->zDb, pConfig->zName
232870 pConfig->zDb, pConfig->zName
232885 pConfig->zDb, pConfig->zName, zTail, zName, zTail
232921 pConfig->zDb, pConfig->zName, zPost, zDefn,
233247 pConfig->zDb, pConfig->zName,
233248 pConfig->zDb, pConfig->zName
233253 pConfig->zDb, pConfig->zName
233449 pConfig->zDb, pConfig->zName, zSuffix
236570 const char *zDb = bDb ? argv[3] : argv[1];
236573 int nDb = (int)strlen(zDb)+1;
236592 memcpy(pRet->zFts5Db, zDb, nDb);