Lines Matching refs:zTab
11105 ** If argument zTab is not NULL, then it is the name of a table to attach
11110 ** Or, if argument zTab is NULL, then changes are recorded for all tables
11161 const char *zTab /* Table name */
11178 const char *zTab /* Table name */
12106 const char *zTab /* Table name */
12121 const char *zTab /* Table name */
12504 const char *zTab /* Table name */
12519 const char *zTab /* Table name */
92323 const char *zTab; /* Name of the virtual table */
92333 zTab = (const char*)sqlite3_value_text(&sMem);
92334 assert( zTab || db->mallocFailed );
92335 if( zTab ){
92336 rc = sqlite3VtabCallCreate(db, pOp->p1, zTab, &p->zErrMsg);
97661 ** Check to see if the zSpan given to this routine matches the zDb, zTab,
97662 ** and zCol. If any of zDb, zTab, and zCol are NULL then those fields will
97668 const char *zTab,
97681 if( zTab && (sqlite3StrNICmp(zSpan, zTab, n)!=0 || zTab[n]!=0) ){
97763 const char *zTab, /* Name of table containing column, or NULL */
97835 if( sqlite3MatchEName(&pEList->a[j], zCol, zTab, zDb) ){
97843 if( hit || zTab==0 ) continue;
97848 if( zTab ){
97851 if( sqlite3StrICmp(zTabName, zTab)!=0 ){
97897 if( zDb==0 && zTab!=0 && cntTab==0 ){
97903 if( op!=TK_DELETE && sqlite3StrICmp("new",zTab) == 0 ){
97906 }else if( op!=TK_INSERT && sqlite3StrICmp("old",zTab)==0 ){
97915 if( pUpsert && sqlite3StrICmp("excluded",zTab)==0 ){
98013 && zTab==0
98044 assert( zTab==0 && zDb==0 );
98072 if( cnt==0 && zTab==0 ){
98113 sqlite3ErrorMsg(pParse, "%s: %s.%s.%s", zErr, zDb, zTab, zCol);
98114 }else if( zTab ){
98115 sqlite3ErrorMsg(pParse, "%s: %s.%s", zErr, zTab, zCol);
105750 ** zDb and zTab is not empty.
105755 const char *zTab, /* Table to check for empty */
105760 zErr, zDb, zTab
105777 const char *zTab; /* Table name */
105793 zTab = &pNew->zName[16]; /* Skip the "sqlite_altertab_" prefix on the name */
105796 pTab = sqlite3FindTable(db, zTab, zDb);
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");
105876 zTab
107436 const char *zTab = aTable[i].zName;
107439 if( (pStat = sqlite3FindTable(db, zTab, pDb->zDbSName))==0 ){
107446 "CREATE TABLE %Q.%s(%s)", pDb->zDbSName, zTab, aTable[i].zCols
107456 sqlite3TableLock(pParse, iDb, aRoot[i], 1, zTab);
107460 pDb->zDbSName, zTab, zWhereType, zWhere
107464 sqlite3NestedParse(pParse, "DELETE FROM %Q.%s", pDb->zDbSName, zTab);
109869 ** table zTab in database zDb. This function assumes that an authorization
109878 const char *zTab, /* Table name */
109887 rc = db->xAuth(db->pAuthArg, SQLITE_READ, zTab,zCol,zDb,pParse->zAuthContext
109893 char *z = sqlite3_mprintf("%s.%s", zTab, zCol);
112949 char zTab[24];
112950 sqlite3_snprintf(sizeof(zTab),zTab,"sqlite_stat%d",i);
112951 if( sqlite3FindTable(pParse->db, zTab, zDbName) ){
112954 zDbName, zTab, zType, zName
113099 const char *zTab = SCHEMA_TABLE(iDb);
113102 if( sqlite3AuthCheck(pParse, SQLITE_DELETE, zTab, 0, zDb)){
114164 const char *zTab = SCHEMA_TABLE(iDb);
114165 if( sqlite3AuthCheck(pParse, SQLITE_DELETE, zTab, 0, zDb) ){
136472 const char *zTab = SCHEMA_TABLE(iDb);
136475 sqlite3AuthCheck(pParse, SQLITE_DELETE, zTab, 0, zDb) ){
139537 ** of the virtual table named zTab in database iDb.
139543 SQLITE_PRIVATE int sqlite3VtabCallCreate(sqlite3 *db, int iDb, const char *zTab, char **pzErr){
139549 pTab = sqlite3FindTable(db, zTab, db->aDb[iDb].zDbSName);
139664 ** of the virtual table named zTab in database iDb. This occurs
139667 ** This call is a no-op if zTab is not a virtual table.
139669 SQLITE_PRIVATE int sqlite3VtabCallDestroy(sqlite3 *db, int iDb, const char *zTab){
139673 pTab = sqlite3FindTable(db, zTab, db->aDb[iDb].zDbSName);
187893 char *zTab = sqlite3_mprintf("%s_node", pRtree->zName);
187894 if( zTab==0 ) return SQLITE_NOMEM;
187895 rc = sqlite3_blob_open(pRtree->db, pRtree->zDb, zTab, "data", iNode, 0,
187897 sqlite3_free(zTab);
191078 const char *zTab; /* Name of rtree table */
191178 pCheck->zDb, pCheck->zTab
191232 azSql[bLeaf], pCheck->zDb, pCheck->zTab
191381 pCheck->zDb, pCheck->zTab, zTbl
191404 const char *zTab, /* Name of rtree table to check */
191416 check.zTab = zTab;
191428 pStmt = rtreeCheckPrepare(&check, "SELECT * FROM %Q.'%q_rowid'", zDb, zTab);
191437 pStmt = rtreeCheckPrepare(&check, "SELECT * FROM %Q.%Q", zDb, zTab);
191519 const char *zTab;
191521 zTab = zDb;
191524 zTab = (const char*)sqlite3_value_text(apArg[1]);
191526 rc = rtreeCheckTable(sqlite3_context_db_handle(ctx), zDb, zTab, &zReport);
196138 const char *zTab,
196159 " WHERE name=%Q", zTab
196172 sqlite3_mprintf("PRAGMA index_list=%Q",zTab)
196196 sqlite3_mprintf("PRAGMA table_info=%Q",zTab)
201592 int (*xTableFilter)(void *pCtx, const char *zTab);
201632 SessionBuffer tblhdr; /* Buffer to hold apValue/zTab/abPK/ */
201637 char *zTab; /* Current table */
201638 int nCol; /* Number of columns in zTab */
202981 const char *zTab,
202991 zRet, zSep, zDb1, zTab, azCol[i], zDb2, zTab, azCol[i]
203004 const char *zTab,
203017 zRet, zSep, zDb1, zTab, azCol[i], zDb2, zTab, azCol[i]
203747 ** zTab in database zDb based on its primary key. i.e.
203749 ** SELECT * FROM zDb.zTab WHERE pk1 = ? AND pk2 = ? AND ...
203754 const char *zTab, /* Table name */
203764 if( 0==sqlite3_stricmp("sqlite_stat1", zTab) ){
203778 sessionAppendIdent(&buf, zTab, &rc);
204464 ** p->zTab and p->abPK[] variables accordingly. The p->apValue[] array is
204502 p->zTab = (char*)&p->abPK[p->nCol];
204570 if( p->zTab==0 || (p->bPatchset && p->bInvert) ){
204573 assert( p->in.iNext==1 || p->zTab );
204663 *pzTab = pIter->zTab;
205049 const char *zTab, /* Table name */
205059 sessionAppendIdent(&buf, zTab, &rc);
205132 const char *zTab, /* Table name */
205142 sessionAppendIdent(&buf, zTab, &rc);
205197 ** Formulate and prepare an SQL statement to query table zTab by primary
205211 const char *zTab, /* Table name */
205215 db, "main", zTab, p->nCol, p->azCol, p->abPK, &p->pSelect);
205219 ** Formulate and prepare an INSERT statement to add a record to table zTab.
205222 ** INSERT INTO main."zTab" VALUES(?1, ?2, ?3 ...);
205229 const char *zTab, /* Table name */
205237 sessionAppendIdent(&buf, zTab, &rc);
205429 const char *zTab = pIter->zTab;
205433 sessionAppendBlob(&p->rebase, (u8*)zTab, (int)strlen(zTab)+1, &rc);
205784 const char *zTab,
205801 pIter2->zTab = (char*)zTab;
205840 const char *zTab /* Table name */
205853 const char *zTab = 0; /* Name of current table */
205854 int nTab = 0; /* Result of sqlite3Strlen30(zTab) */
205877 if( zTab==0 || sqlite3_strnicmp(zNew, zTab, nTab+1) ){
205881 db, pIter->bPatchset, zTab, &sApply, xConflict, pCtx
205908 zTab = sqlite3_mprintf("%s", zNew);
205909 if( zTab==0 ){
205913 nTab = (int)strlen(zTab);
205914 sApply.azCol = (const char **)zTab;
205921 db, "main", zNew, &sApply.nCol, &zTab, &sApply.azCol, &sApply.abPK
205931 "sqlite3changeset_apply(): no such table: %s", zTab
205939 zTab, sApply.nCol, nCol
205945 "primary key mismatch for table %s", zTab
205950 if( 0==sqlite3_stricmp(zTab, "sqlite_stat1") ){
205956 if((rc = sessionSelectRow(db, zTab, &sApply))
205957 || (rc = sessionUpdateRow(db, zTab, &sApply))
205958 || (rc = sessionDeleteRow(db, zTab, &sApply))
205959 || (rc = sessionInsertRow(db, zTab, &sApply))
205966 nTab = sqlite3Strlen30(zTab);
205985 rc = sessionRetryConstraints(db, bPatchset, zTab, &sApply, xConflict, pCtx);
206040 const char *zTab /* Table name */
206073 const char *zTab /* Table name */
206098 const char *zTab /* Table name */
206125 const char *zTab /* Table name */
206798 const char *zTab = pIter->zTab;
206800 if( 0==sqlite3_stricmp(pTab->zName, zTab) ) break;
206813 sessionAppendBlob(&sOut,(u8*)pIter->zTab,(int)strlen(pIter->zTab)+1,&rc);
228711 const char *zTab = bDb ? argv[4] : argv[3];
228714 int nTab = (int)strlen(zTab)+1;
228731 memcpy(pRet->zFts5Tbl, zTab, nTab);