contrib/sqlite3/sqlite3.c

483 ** condition/decision coverage is inadequate.  For example, testcase()
1244 ** locking strategy (for example to use dot-file locks), to inquire
1587 ** change the way it deals with files.  For example, an application
1812 ** invoke sqlite3_initialize() directly.  For example, [sqlite3_open()]
1944 ** The xInit method initializes the memory allocator.  (For example,
2047 ** tracks memory usage, for example. </dd>
2138 ** profiling or testing, for example.   ^If SQLite is compiled with
2229 ** third parameter is passed NULL In this case.  An example of using this
2659 ** ^(As an example of the result table format, suppose a query result
2760 ** For example, assume the string variable zText contains text as follows:
2788 ** This second example is an SQL syntax error.  As a general rule you should
2794 ** single quotes).)^  So, for example, one could say:
2981 ** example, an application may allow a user to enter arbitrary
3127 ** database connection D.  An example use for this
3321 **          C:. Note that the %20 escaping in this example is not strictly
3510 ** by untrusted external sources.  An example application might be a
3718 ** ^(For example, if an application defines a function "eval()" that
3754 ** for example, in diagnostic routines to search for prepared
3994 ** statement that does not return data (for example an [UPDATE]).
4018 ** (for example during a conversion from UTF-8 to UTF-16) then a
4092 ** ^(For example, given the database schema:
4153 ** ^With the legacy interface, a more specific error code (for example,
4318 ** example, if the internal representation is FLOAT and a text result
4757 ** be used, for example, to add a regular-expression matching scalar
5176 ** example of how to do this using C++ with the Windows Runtime:
5440 ** pages to improve performance is an example of non-essential memory.
5610 ** So for example, if "samplelib" cannot be loaded, then names like
6326 ** ^(Some systems (for example, Windows 95) do not support the operation
6828 ** statements.  For example, if the number of table steps greatly exceeds
7388 ** application to deadlock. For example, if connection X is waiting for
8422 ** a function is called via a function pointer. For example the
8431 ** For example those parameters only used in assert() statements. In these
8622 ** For example, the free-page-count field is located at byte offset 36 of
10450 ** When an in-memory Table object is deleted (for example when the
10565 ** Consider this example:
10682 ** by the aiColumn[] field of this structure.  For example, suppose
10820 ** as opcodes here. For example, the parser defines TK_GE to be an integer
12564 ** example above are placed on the non-lookaside free() routines to verify
15272   ** down into the VFS layer.  Some SQLITE_OPEN_ flags (for example,
15494 ** fatal. For example, if a malloc fails while resizing a hash table, this
15665 **                                for example.
16298 ** verify the type of an allocation.  For example:
16320 ** verify the type of an allocation.  For example:
18785 ** held by SQLite. An example of non-essential memory is memory used to
20381 ** to modify an existing string.  For example:
21293   **      involving NaN. For example, x != x evaluates to true if x is NaN
21410 ** brackets from around identifers.  For example:  "[a-b-c]" becomes
21666 ** last digit.  So, for example,
22143   ** A 3-byte varint is sufficient, for example, to record the size
25049 ** (ex: databases that are burned into CD-ROM, for example.)  It can
27214 ** file with the "-shm" suffix added.  For example, if the database file
28985   ** function failing. This function could fail if, for example, the
29287 ** database file.  For example:
35274   ** function failing. This function could fail if, for example, the
35650 ** But sometimes (for example when during a DROP of a large table) most
38622 **    For example, if an IO error occurs while performing a rollback,
39292 ** is intended to be used within debuggers. For example, as an alternative
44164 ** that page might be marked as dirty.  This happens, for example, when
49138 **   Cursor does not point to a valid entry. This can happen (for example)
49432 ** connection.  This is needed (for example) prior to parsing
49601 ** defined, or 0 if it is. For example:
49670 ** For example, when writing to a table with root-page iRoot via
49762 ** For example, before writing to any part of the table or index
55902   ** be so out of balance as to be illegal.  For example, the right-most
56509   ** example, when inserting data into a table with auto-generated integer
57845 ** purposes (for example, to store a high-level schema associated with
58107 **   Non-sharable Btrees (in-memory databases for example), do not have
59079 ** inconsistent state, for example with (Mem.z==0) and
61534 ** is used, for example, when a trigger sub-program is halted to restore
63224 ** that sqlite3_prepare() generates.  For example, if new functions or
72188 ** example, by CREATE INDEX statements on tables too large to fit in main
73960 ** the COLLATE operator is preserved.  For example:
74269     ** might refer to an result-set alias.  This happens, for example, when
74275     ** forms the result set entry ("a+b" in the example) and return immediately.
75137 ** tree.  For example, in:
78013       ** example, if the table on which triggers are being fired is
79511 ** It returns the new CREATE TABLE statement. For example:
82868 ** pName1 and pName2. If the table name was fully qualified, for example:
82963   ** pName1 and pName2. If the table name was fully qualified, for example:
83233 ** the table take priority. For example, if zType is 'BLOBINT',
85327 ** For example, suppose a SrcList initially contains two entries: A,B.
85802 ** more than one entry (example: deleting one row then inserting another,
86662   ** term for the DELETE or UPDATE statement.  For example:
89464 ** constraints for which table pTab is the parent table. For example,
89837 ** For example, if pFKey is the foreign key and pTab is table "p" in
96578 ** (example:  "a IN (SELECT * FROM table)") but it has more than 1 result
100108     ** for example.  In that case, do not regenerate the code to manifest
100151       ** example to initialize a LIMIT register from a sub-select), it would
102192 ** may be used by the caller, for example, to avoid having to load the entire
102626   ** for example, then jump to the next iteration of the RowSet loop.  */
103521 ** This routine is called, for example, just before deleting the Table
104455 ** spread out over the non-negative integers.  For example, the cursor
104459 ** bits in the Bitmask.  So, in the example above, the cursor numbers
104560 ** For example, if the WHERE clause expression used these VDBE
104564 ** Note that the mapping is not necessarily ordered.  In the example
104790 ** is filled with pointers to subexpressions.  For example:
105276 ** This routine analyzes terms such as the middle term in the above example.
105296 ** a single table T (as shown in example B above) then create a new virtual
105332 ** It might be the case that multiple tables are indexable.  For example,
105697   ** that define the range that the BETWEEN implements.  For example:
105937 ** For example, the query
107025 ** example, assuming that index p is on t1(a):
107037 ** optimized by the proposed index scan. For example, assuming index p is
107627     **    SQLite must perform on the index in question. For example, if the
107674     **    For example, given the index on (a, b), the second of the following
108257 ** For example, consider table t1(a,b,c,d,e,f) with index i1(a,b,c).
108260 ** example, the third "c" value is an inequality.  So only two
108265 ** In the example above nEq==2.  But this subroutine works for any value
108286 ** In the example above, the index on t1(a) has TEXT affinity. But since
108290 ** string in this example would be set to SQLITE_AFF_NONE.
108392 ** For example, if the query:
108751     **         use the "==" and "IN" operators. For example, if the
109002     ** In the example, there are three indexed terms connected by OR.
109349 ** example, if the SQL is this:
112203   /* Beginning here are the reduction cases.  A typical example
113574       ** Applications can set this macro (for example inside %include) if
118844   ** TABLE statement that created the fts3 table. For example, if
119320 ** of the column to be searched.  For example, in
119421 ** example, the following:
120039 ** with all double quote characters escaped. For example:
120075 ** function named zFunc first. For example, if zFunc is "unzip" and the
120133 ** bracket. For example, if zFunc is "zip" and the FTS3 table has three
121295 ** the part of a doclist that follows each document id. For example, if a row
121434 ** in the example above).
123789 ** condition. For example:
123794 ** the example above). When this function is called, *paPoslist points to
123796 ** phrase on the other side of the NEAR operator to pPhrase. For example,
124011   ** For example, the query:
124113         ** For example if this expression:
124497 ** compression and is terminated by either an 0x01 or 0x00 byte. For example,
125682 ** group more tightly). For example, in the C language, the == operator
125820         ** operator something other than a phrase. For example, either of
126310 ** For example:
127674 ** substring of <input-string> associated with the token. For example,
127833 ** in the README.tokenizer file as an example, so it is important to
128677 ** method before retrieving all query results (as may happen, for example,
129254 ** For example, to create a new PendingList structure containing two
129605   ** same value. For example:
130053 ** lists, not including the nul-terminator byte. For example:
130264 ** non-zero, it iterates through each term and its prefixes. For example, if
130565 ** zNext, in bytes. For example,
134157 ** two. For example, to store the position-list:
134562 ** that requires highlighting. For example, if 'X' is a highlighted term
134570 ** are to the left of the first highlighted term. For example, to this:
136118 ** of the ASCII letter only. For example, if passed 235 - "LATIN
138206 ** example, assuming the inputs: