Lines Matching defs:temp
1508 ** database is not a temp db, then this file-control purges the contents
1510 ** the db is a temp-db, it is a no-op, not an error.
3495 ** authorizer callback is the name of the database ("main", "temp",
6693 ** the "temp" schema. Larger values of N correspond to various ATTACH-ed
7163 ** (i.e. "main", "temp", or an attached database) containing the specified
7810 ** tables, the database name is "temp".)^
8337 ** name of the database is "main" for the main database or "temp" for the
8816 ** with the connection - main, temp, and any [ATTACH]-ed databases.)^
9258 ** ^The database name is "main" for the main database, "temp" for the
10373 ** interface flushes caches for all schemas - "main", "temp", and
10425 ** will be "main" for the main database or "temp" for TEMP tables or
10750 const char *zSchema, /* Which DB to serialize. ex: "main", "temp", ... */
10794 ** S argument to sqlite3_deserialize(D,S,P,N,M,F) is "temp" then the
11026 ** database zDb, where zDb is either "main", or "temp", or the name of an
11353 ** Argument zFromDb must be the name of a database ("main", "temp" etc.)
13410 ** and we have to allow 2 extra counts for the "main" and "temp" databases.
14660 ** Note that "sqlite_temp_schema" can also be called "temp.sqlite_schema".
15004 ** started putting files with the "sqlite" name in the c:/temp folder.
15009 ** spelled backwards. So the temp files are still identified, but
17001 ** databases plus 2 for "main" and "temp".
18950 ** pDest->iSDParm. If (pDest->iSDParm<0), then the temp
23387 ** to store the schema for all databases (main, temp, and any ATTACHed
30113 ** If the requested size of the temp buffer is larger than the size
33272 u8 temp;
33282 temp = *zIn;
33285 *zIn++ = temp;
40178 /* If this is a database file (not a journal, super-journal or temp
40314 /* If this is a database file (not a journal, super-journal or temp
42708 ** Directories to consider for temp files.
43087 /* If zName is NULL, the upper layer is requesting a temp file. */
43792 ** a proxy path based on the user's temp dir
45052 /* Initialize temp file dir array. */
55673 ** running in locking_mode=exclusive (including temp databases) remains in
56366 /* Regardless of the current state, a temp-file connection always behaves
59285 char *pNew = NULL; /* New temp space */
59910 ** If the pager is a temp-file pager and the actual file-system file
59939 /* If the file is a temp-file has not yet been opened, open it now. It
59941 ** is taken, as pager_wait_on_lock() is a no-op for temp-files.
60255 int tempFile = 0; /* True for temp files (incl. in-memory files) */
60514 ** database is the same as a temp-file that is never written out to
61784 ** This optimization cannot be used with a temp-file, as the page may
62403 ** Return true if this is an in-memory or temp-file backed pager.
62546 ** If this is a temp-file, it is possible that the journal file has
63152 ** file (not a temp file or an in-memory database), and the WAL file
63158 ** If the pager is open on a temp-file (or in-memory database), or if
70123 unsigned char *temp; /* Temp area for cell content */
70189 temp = sqlite3PagerTempSpace(pPage->pBt->pPager);
70190 memcpy(&temp[iCellStart], &data[iCellStart], usableSize - iCellStart);
70191 src = temp;
71430 ** zero the first 4 bytes of temp space here.
79716 ** If no transaction is active and the database is not a temp-db, clear
79820 ** Return a pointer corresponding to database zDb (i.e. "main", "temp")
79824 ** If the "temp" database is requested, it may need to be opened by this
85320 ** including the temp database. (b) is important because if more than
85370 ** string, it means the main database is :memory: or a temp file. In
98149 ** for an attached database. The "temp" database may not be vacuumed.
99946 ** A container for a temp file handle and the current amount of data
100142 ** within a temp file. However, if the PmaReader.pIncr variable points to
101312 ** PMA in the temp file belonging to sub-task pTask. Return SQLITE_OK if
101914 ** reading from the same temp file this makes for more linear file IO.
101936 ** and/or initialize the temp file related fields of the IncrMerge
101978 ** requires two temp files to itself, whereas a single-threaded object
102188 ** that has already written two or more level-0 PMAs to one or more temp
103763 Expr temp;
103769 memcpy(&temp, pDup, sizeof(Expr));
103771 memcpy(pExpr, &temp, sizeof(Expr));
105609 ** X: The name of a database. Ex: "main" or "temp" or
109023 /* Evaluate the expression and insert it into the temp table */
112374 ** bTemp is not true, database "temp", can still be parsed. This is
112382 int bTemp, /* True if this is the temp db */
112400 "FROM temp." LEGACY_SCHEMA_TABLE " "
112414 ** of the temp db.
112425 "UPDATE temp." LEGACY_SCHEMA_TABLE
112426 " SET sql = sqlite_rename_quotefix('temp', sql)"
112435 ** the temp database as well.
112579 /* If the table being renamed is not itself part of the temp database,
112580 ** edit view and trigger definitions within the temp database
112988 "UPDATE temp." LEGACY_SCHEMA_TABLE " SET "
113458 int bTemp /* True if SQL is from temp schema */
113776 ** 8. bTemp: True if zSql comes from temp schema
114005 ** 6: True if the schema statement comes from the temp db.
114178 ** 0: Database name ("main", "temp" etc.).
114295 ** 0: Database name ("main", "temp" etc.).
114299 ** 4: True if object is from temp schema.
117661 ** (Bit 0 is for main, bit 1 is for temp, and so forth.) Bits are
118067 ** Entry 0 (the "main" database) and entry 1 (the "temp" database)
118119 ** "main" and "temp") for a single database connection.
118411 ** of a database ("main", "temp" or the name of an attached db). This
118431 ** "temp" or the name of an attached db). This routine returns the
118710 /* If creating a temp table, the name may not be qualified. Unless
118711 ** the database name is "temp" anyway. */
120565 ** SELECT * FROM temp.ex1;
120869 ** created in the temp database that refers to a table in another
121434 ** is a temp table. If so, set the database to 1. Do not do this
129274 ** B: open temp table
129276 ** insert row from R..R+n into temp table
129279 ** rewind temp table
129539 ** A temp table must be used if the table being updated is also one
129541 ** temp table in the case of row triggers.
129552 ** B: open temp table
129554 ** insert row from R..R+n into temp table
129559 int regTempRowid; /* Register to hold temp table ROWID */
129702 ** rewind temp table, if empty goto D
134347 ** Interpret the given string as a temp db location. Return 1 for file
134366 ** Invalidate temp storage, either when the temp storage is changed
134654 /* If the temp database has been explicitly named as part of the
137594 /* All other schemas after the main schema. The "temp" schema must be last */
141167 int unionTab; /* Cursor number of the temp table holding result */
141350 ** no temp tables are required.
142488 int iParent; /* VDBE cursor number of the pSub result set temp table */
144976 ** as part of populating the temp table for an UPDATE...FROM statement.
145393 ** The second form is preferred as a single index (or temp-table) may be
145395 ** written the query must use a temp-table for at least one of the ORDER
145396 ** BY and DISTINCT, and an index or separate temp-table for the other.
146521 /* If the trigger name was unqualified, and the table is a temp table,
154234 /* Read the PK into an array of temp registers. */
154241 /* Check if the temp table already contains this key. If so,
154244 ** insert the key into the temp table and proceed with processing
154249 ** the temp table. And if iSet is -1, assume that there is no
154250 ** need to insert the key into the temp table, as it will never
154263 /* Release the array of temp registers */
163220 ** temp table Window.iEphCsr.
163224 ** in a temp table before returning any rows. In other cases it does not.
164681 ** variable indicates when rows may be removed from the temp table (in
164701 ** The windows functions implmentation caches the input rows in a temp
164704 ** a mere detail). It keeps three cursors open on the temp table. One
167925 /* 198 */ "temp",
168066 /* 13 */ "create_table ::= createkw temp TABLE ifnotexists nm dbnm",
168070 /* 17 */ "temp ::= TEMP",
168071 /* 18 */ "temp ::=",
168135 /* 82 */ "cmd ::= createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS select",
168312 /* 259 */ "trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause",
168977 195, /* (13) create_table ::= createkw temp TABLE ifnotexists nm dbnm */
168981 198, /* (17) temp ::= TEMP */
168982 198, /* (18) temp ::= */
169046 190, /* (82) cmd ::= createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS select */
169223 285, /* (259) trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause */
169387 -6, /* (13) create_table ::= createkw temp TABLE ifnotexists nm dbnm */
169391 -1, /* (17) temp ::= TEMP */
169392 0, /* (18) temp ::= */
169456 -9, /* (82) cmd ::= createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS select */
169633 -11, /* (259) trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause */
169860 case 13: /* create_table ::= createkw temp TABLE ifnotexists nm dbnm */
169869 case 18: /* temp ::= */ yytestcase(yyruleno==18);
169881 case 17: /* temp ::= TEMP */
170105 case 82: /* cmd ::= createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS select */
170920 case 259: /* trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause */
173113 ** (5) tkTEMP The "temp" or "temporary" keyword.
173240 }else if( nId==4 && sqlite3StrNICmp(zSql, "temp", 4)==0 ){
174829 /* The temp-database schema is allocated differently from the other schema
174831 ** So it needs to be freed here. Todo: Why not roll the temp schema into
176888 /* The default safety_level for the main database is FULL; for the temp
176893 db->aDb[1].zDbSName = "temp";
177800 ** "temp") which will receive the imposter. "onOff" turns imposter mode on
180240 const char *zDb = p->zDb; /* Name of database (e.g. "main", "temp") */
180740 const char *zDb, /* Name of db (i.e. "main", "temp" etc.) */
185097 sqlite3_int64 nTmp = 0; /* Bytes of temp space */
185845 if( nDb==4 && 0==sqlite3_strnicmp("temp", zDb, 4) ){
205212 const char *zDb, /* Name of db ("main", "temp" etc.) */
208623 ** Configure a limit for the amount of temp space that may be used by
208633 ** If the temp space limit is exceeded during operation, an SQLITE_FULL
208639 ** Return the current amount of temp file space, in bytes, currently used by
209219 i64 szTemp; /* Current size of all temp files in use */
209220 i64 szTempLimit; /* Total size limit for temp files */
209232 ** sqlite3rbu_create_vfs(). It is used to track the total amount of temp
209256 i64 sz; /* Size of file in bytes (temp only) */
209681 "DROP TRIGGER IF EXISTS temp.rbu_insert_tr;"
209682 "DROP TRIGGER IF EXISTS temp.rbu_update1_tr;"
209683 "DROP TRIGGER IF EXISTS temp.rbu_update2_tr;"
209684 "DROP TRIGGER IF EXISTS temp.rbu_delete_tr;"
212901 ** generating a large journal using a temp file. */
214165 ** Configure the aggregate temp file size limit for this RBU handle.
217021 /* If this session is attached to a different database ("main", "temp"
243651 bDb = (argc==6 && strlen(argv[1])==4 && memcmp("temp", argv[1], 4)==0);