Lines Matching refs:EXISTS
1087 ** if such a lock exists and false otherwise.
1500 ** mode database and there exists at least one client in another process that
1712 ** be created, and that it is an error if it already exists.
1824 ** simply checks whether the file exists.
3886 ** the open to fail if the database already exists. The SQLITE_OPEN_EXCLUSIVE
4089 ** parameter if it exists or a NULL pointer if P does not appear as a
4719 ** be false. ^Similarly, a CREATE TABLE IF NOT EXISTS statement is a
4720 ** read-only no-op if the table already exists, but
6750 ** that exists for backwards compatibility of legacy applications and should
7369 ** column exists. ^The sqlite3_table_column_metadata() interface returns
7373 ** table and returns SQLITE_OK if the table exists and SQLITE_ERROR if it
7436 int *pNotNull, /* OUTPUT: True if NOT NULL constraint exists */
7944 ** This superclass exists in order to define fields of the cursor that
7972 ** name and number of parameters exists. If no such function exists
8584 ** This interface is not for use by applications. It exists solely
10969 ** memory representation of the database exists. A contiguous memory
10975 ** of the database exists.
11654 ** <li> For each row (primary key) that exists in the to-table but not in
11657 ** <li> For each row (primary key) that exists in the to-table but not in
11660 ** <li> For each row (primary key) that exists in both tables, but features
12193 ** table in the changeset, there exists a database table with:
18605 ** eqSeen field will indicate whether or not an exact match exists in the
18932 ExprList *pList; /* op = IN, EXISTS, SELECT, CASE, FUNCTION, BETWEEN */
18933 Select *pSelect; /* EP_xIsSelect and op = IN, EXISTS, SELECT */
19495 /* True if S exists and has SF_NestedFrom */
19737 u8 ifNotExists; /* Might be true if IF NOT EXISTS. Assert()s only */
21597 ** If the SQLITE_ENABLE IOTRACE exists then the global variable
26388 ** the malloc_usable_size() interface exists
26391 ** If an equivalent interface exists by
33013 sqlite3TreeViewLine(pView, "EXISTS-expr flags=0x%x", pExpr->flags);
33778 ** This interface exists so that applications that want to take advantage
36781 ** If no element exists with a matching key, then a new
36784 ** If another element already exists with the same key, then the
40300 ** In dotfile locking, either a lock exists or it does not. So in this
40351 /* If we have any lock, then the lock file already exists. All we have
41781 ** SQLite to access the file will not know that the journal exists (because
42705 /* Check to see if a unixShmNode object already exists. Reuse an existing
43404 ** there already exists a mapping for this file, and there are still
43914 /* NB: zFilename exists and remains valid until the file is closed
44589 ** SQLITE_ACCESS_EXISTS: Return 1 if the file exists
45548 /* if the host id matches and the lock path already exists in the conch
50246 ** If no matching winShmNode currently exists, create a new one.
50702 ** there already exists a mapping for this file, and there are still
51159 /* At this point, we know the candidate directory exists and should
51455 /* If the file exists, it fails. */
51461 /* Opens a file, only if it exists. */
55135 ** such buffer exists or there is no space left in it, this function falls
55286 ** exists, this function falls back to sqlite3Malloc().
57149 ** lock. Instead, it assumes a hot-journal exists and obtains an EXCLUSIVE
57809 ** A page needs to be written into the sub-journal if there exists one
59118 ** pager cache if it exists and the main file. The page is then marked
59256 ** * if the child journal exists, and if so
59324 int exists;
59325 rc = sqlite3OsAccess(pVfs, zJournal, SQLITE_ACCESS_EXISTS, &exists);
59329 if( exists ){
59330 /* One of the journals pointed to by the super-journal exists.
60061 ** exists if the database is not empty, or verify that the *-wal file does
60064 ** If the database is not empty and the *-wal file exists, open the pager
60065 ** in WAL mode. If the database is empty or if no *-wal file exists and
60083 int isWal; /* True if WAL file exists */
61045 ** problematic header will occur, if it exists. aMagic is used
61829 ** file exists if the following criteria are met:
61831 ** * The journal file exists in the file system, and
61834 ** * The first byte of the journal file exists and is not 0x00.
61837 ** exists, that is probably an old journal left over from a prior
61852 ** to determine whether or not a hot-journal file exists, the IO error
61858 int exists = 1; /* True if a journal file is present */
61871 rc = sqlite3OsAccess(pVfs, pPager->zJournal, SQLITE_ACCESS_EXISTS, &exists);
61873 if( rc==SQLITE_OK && exists ){
61907 /* The journal file exists and no other connection has a reserved
61988 int bHotJournal = 1; /* True if there exists a hot journal-file */
61999 /* If a journal file exists, and there is no RESERVED lock on the
62034 /* If it is not already open and the file exists on disk, open the
62049 int bExists; /* True if journal file exists */
63411 ** synced to disk. The journal file still exists in the file-system
63835 ** Return the file handle for the journal file (if it exists).
63981 ** Currently, no such page exists in the page-cache and the
64768 ** where aHash[iMax]==P. If there is no iMax entry (if there exists
64778 ** establish that no such entry exists in the block. Each index block
64914 ** a special case; its value is never used and it exists as a place-holder
67975 ** the file because there exists a frame after iSnapshot that
69493 ** The pBt pointer itself may not be changed while there exists cursors
69563 ** table (because there exists one or more read-locks on the table),
69734 ** The table that this cursor was opened on still exists, but has been
70636 ** transaction. If there currently exists a writer, and p is not
70756 ** The BtShared.pHasContent bitvec exists to work around an obscure
74384 ** At the end of this call, the rollback journal still exists on the
76057 ** exists an entry in the table that exactly matches pIdxKey.
76528 ** If the eMode parameter is BTALLOC_EXACT and the nearby page exists
76531 ** to nearby if any such page exists. If eMode is BTALLOC_ANY then there
77045 ** So if there exists more than one reference to this page, then it
77577 ** content exists only in leaves and there are no divider cells.
80267 ** the root page is empty, but still exists.
80885 /* Check that the page exists
82640 ** The pMem->xDel destructor is called, if it exists. Though MEM_Str
97224 ** This opcode (which only exists if SQLite was compiled with
97813 ** A value of N in the seekHit flag of cursor P1 means that there exists
98124 ** it already exists in the table. If it does not exist, we have
99824 int exists;
99841 exists = sqlite3RowSetTest((RowSet*)pIn1->z, iSet, pIn3->u.i);
99842 VdbeBranchTaken(exists!=0,2);
99843 if( exists ) goto jump_to_p2;
101631 /* Never happens. This code exists to avoid a harmless linkage
104344 ** when there exists one or more separate worker threads.
107230 int no_such_func = 0; /* True if no such function exists */
107749 ** taking care to preserve the COLLATE clause if it exists. */
109302 ** If dequote is true, then the token (if it exists) is dequoted.
111881 ** or EXISTS operator:
111884 ** EXISTS (SELECT a FROM b) -- EXISTS subquery
111886 ** The pExpr parameter is the SELECT or EXISTS operator to be coded.
111932 /* The evaluation of the EXISTS/SELECT must be repeated every time it
111950 ** If this is an EXISTS, write an integer 0 (not exists) or 1 (exists)
111971 VdbeComment((v, "Init EXISTS result"));
113496 ** X (if it exists) is in pExpr->pLeft.
115428 ** The code in this file only exists if we are not omitting the
115653 /* If the sqlite_sequence table exists in this database, then update
117941 /* The table already exists. If zWhere is not NULL, delete all entries
117956 /* The sqlite_stat[134] table already exists. Delete all rows. */
120978 ** exists */
121799 ** is used by CREATE TABLE IF NOT EXISTS and similar if the table already
121800 ** exists, so that the prepared statement for CREATE TABLE IF NOT EXISTS
121836 int noErr /* Do nothing if table already exists */
121908 sqlite3ErrorMsg(pParse, "%s %T already exists",
122596 /* generated column in an CREATE TABLE IF NOT EXISTS that already exists */
123140 ** exists and has an xShadowName method, then loop over all other ordinary
123234 ** recently changed, so the entry for this table already exists in
123603 int noErr /* Suppress error messages if VIEW already exists */
124367 ** the index already exists and must be cleared before being refilled and
124547 int ifNotExist, /* Omit error if index already exists */
124687 sqlite3ErrorMsg(pParse, "index %s already exists", zName);
126393 ** check that it is defined. An undefined collation sequence exists when
127632 /* Seek cursor iCur to the row to delete. If this row no longer exists
128920 ** sqlite3_log(). The return value is NULL. The function exists purely for
132560 /* Verify that the sqlite_sequence table exists and is an ordinary
134208 /* Check to see if the new rowid already exists in the table. Skip
139784 /* Verify that an index entry exists for the current table row */
139832 /* For UNIQUE indexes, verify that only one entry exists with the
139952 ** initialized. If the main database exists, the new sqlite.enc value
139954 ** already exists, it will be created to use the new encoding value.
142955 /* If the destination is an EXISTS(...) expression, the actual
144243 ** The iOffset register (if it exists) is initialized to the value
148583 /* If regAcc==0, there there exists some min() or max() function
150673 int noErr /* Suppress errors if the trigger already exists */
150730 /* Ensure the table name matches database name and that the table exists */
150752 ** specified name exists */
150765 sqlite3ErrorMsg(pParse, "trigger %T already exists", pName);
151322 ** Return a list of all triggers on table pTab if there exists at least
151833 ** TriggerPrg object exists, a new object is allocated and populated before
153972 sqlite3SetString(pzErrMsg, db, "output file already exists");
154192 ** If there already exists a module with zName, replace it with the new one.
154193 ** If pModule==0, then delete the module zName if it exists.
154546 int ifNotExists /* No error if the table already exists */
155378 ** exists when this routine returns or if an attempt to create it failed
155425 ** virtual table module pMod, if it exists.
159563 ** potentially be used with an index if an appropriate index exists.
159564 ** This analysis does not consider whether or not the index exists; that
163494 /* There already exists a WhereLoop on the list that is better
163508 ** with pTemplate[] if p[] exists, or if p==NULL then allocate a new
163580 ** Heuristic 2: If there exists one or more WHERE clause terms of the
172202 0, /* EXISTS => nothing */
172475 /* 20 */ "EXISTS",
172797 /* 16 */ "ifnotexists ::= IF NOT EXISTS",
172861 /* 80 */ "ifexists ::= IF EXISTS",
173006 /* 225 */ "expr ::= EXISTS LP select RP",
173446 ** If the YYPARSEFREENEVERNULL macro exists (for example because it
173708 199, /* (16) ifnotexists ::= IF NOT EXISTS */
173772 237, /* (80) ifexists ::= IF EXISTS */
173917 217, /* (225) expr ::= EXISTS LP select RP */
174118 -3, /* (16) ifnotexists ::= IF NOT EXISTS */
174182 -2, /* (80) ifexists ::= IF EXISTS */
174327 -4, /* (225) expr ::= EXISTS LP select RP */
174606 case 16: /* ifnotexists ::= IF NOT EXISTS */
174786 case 80: /* ifexists ::= IF EXISTS */ yytestcase(yyruleno==80);
175566 case 225: /* expr ::= EXISTS LP select RP */
176808 ** 76: EXISTS DEFAULT
176932 testcase( i==49 ); /* EXISTS */
180319 ** If the function already exists as a regular global function, then
180324 ** should call this routine to make sure the global function exists.
182073 int *pNotNull, /* OUTPUT: True if NOT NULL constraint exists */
182926 ** parameter if it exists. If the parameter does not exist, this routine
183052 ** no such database exists.
184424 u8 bHasStat; /* True if %_stat table exists (2==unknown) */
184425 u8 bHasDocsize; /* True if %_docsize table exists */
185138 "DROP TABLE IF EXISTS %Q.'%q_segments';"
185139 "DROP TABLE IF EXISTS %Q.'%q_segdir';"
185140 "DROP TABLE IF EXISTS %Q.'%q_docsize';"
185141 "DROP TABLE IF EXISTS %Q.'%q_stat';"
185142 "%s DROP TABLE IF EXISTS %Q.'%q_content';",
185207 "CREATE TABLE IF NOT EXISTS %Q.'%q_stat'"
186171 /* There exists an unusable MATCH constraint. This means that if
186853 ** each position in *pp2 for which there exists one or more positions in
188412 /* At this point it must be known if the %_stat table exists or not.
188748 ** there exists prefix b-tree of the right length) then it may be traversed
192893 ** If no element exists with a matching key, then a new
192897 ** If another element already exists with the same key, then the
195148 /* 1 */ "SELECT NOT EXISTS(SELECT docid FROM %Q.'%q_content' WHERE rowid!=?)",
199255 ** Determine the largest segment index value that exists within absolute
199685 ** exists, is stored in the rowid==1 row of the %_stat table.
200534 /* At this point it must be known if the %_stat table exists or not.
203549 #define JEDIT_DEL 1 /* Delete if exists */
203550 #define JEDIT_REPL 2 /* Overwrite if exists */
203551 #define JEDIT_INS 3 /* Insert if not exists */
205925 /* Already exists, so json_insert() is a no-op */
207049 ** if Name exists in Target:
207067 ** 08 if Name exists in Target:
207387 ** Create PATH and initialize it to VALUE. If PATH already exists, this
208554 ** The root node of an r-tree always exists, even if the r-tree table is
210528 int bMatch = 0; /* True if there exists a MATCH constraint */
210535 /* Check if there exists a MATCH constraint - even an unusable one. If there
212037 ** table already exists. In this case the node-size is determined by inspecting
212455 ** In both cases, this function checks that there exists an entry with
216222 ** exists
216235 ** table exists but is not correctly populated, the value of the *pnOne
216464 "CREATE TABLE IF NOT EXISTS %s.rbu_state(k INTEGER PRIMARY KEY, v)"
217149 "DROP TRIGGER IF EXISTS temp.rbu_insert_tr;"
217150 "DROP TRIGGER IF EXISTS temp.rbu_update1_tr;"
217151 "DROP TRIGGER IF EXISTS temp.rbu_update2_tr;"
217152 "DROP TRIGGER IF EXISTS temp.rbu_delete_tr;"
217445 ** if( no entry exists in sqlite_schema ){
217450 ** if( the index that is the pk exists in sqlite_schema ){
218760 "CREATE TABLE IF NOT EXISTS %s.'rbu_tmp_%q' AS "
220225 int bExists = 0; /* True if rbu_count exists */
220739 ** 3a. If xAccess() is called to check if there exists a *-wal file
221465 ** database connection exists, and the RBU update is in RBU_STAGE_OAL,
223352 ** For each row modified during a session, there exists a single instance of
225100 "SELECT %s FROM \"%w\".\"%w\" WHERE NOT EXISTS ("
227825 /* There exists another row with the new.* primary key. */
227925 ** values and, if it exists, set (nCol+1) to false. Conflict handling
230312 ** This exists in order to allow the fts5_index.c module to return a
231707 ** If the fts5YYPARSEFREENEVERNULL macro exists (for example because it
238767 ** * The byte offset of the first rowid on the page, if it exists
243333 ** segment exists. */
245636 ** prefix-query. Instead of using a prefix-index (if one exists),
246126 ** 2. The hash table exists but is currently a single page. In this
248190 ** there exists an "=" then there is no "<" or ">".
248258 /* As there exists an unusable MATCH constraint this is an
248762 ** structure. Otherwise, if no such function exists, return NULL.
250189 ** The first varint (if it exists) contains the size of the position list
250966 "DROP TABLE IF EXISTS %Q.'%q_data';"
250967 "DROP TABLE IF EXISTS %Q.'%q_idx';"
250968 "DROP TABLE IF EXISTS %Q.'%q_config';",
250975 "DROP TABLE IF EXISTS %Q.'%q_docsize';",
250981 "DROP TABLE IF EXISTS %Q.'%q_content';",
Indexes created Sun Mar 01 05:31:48 UTC 2026