contrib/sqlite3/sqlite3.c

190 ** version information, among other things.  Normally, this internal MinGW
192 ** files; however, the contained version information is now required by this
347 ** These interfaces provide the same information as the [SQLITE_VERSION],
439 ** See the [threading mode] documentation for additional information.
670 ** much information about problems as programmers might like.  In an effort to
672 ** support for additional result codes that provide more detailed information
782 ** information is written to disk in the same order as calls
830 ** information need not be flushed. If the lower four bits of the flag
948 ** information is written to disk in the same order as calls
1181 ** The [SQLITE_FCNTL_TRACE] file control provides advisory information
1269 ** the [VFS | VFS documentation] for further information.
2897 ** information.
3121 ** information.
3202 ** additional information.
3435 ** Additional information is available at [limits | Limits in SQLite].
3790 ** information is in static, unmanaged space and does not need to be freed.
3979 ** or until the same information is requested
3986 ** ^These functions return information about the Nth result column returned by
4091 ** the VM. More information may be found by calling [sqlite3_errmsg()].
4189 ** ^These routines return information about a single column of the current
4193 ** and the second argument is the index of the column for which information
4611 ** such a conversion is possible without loss of information (in other
4644 ** information can be used to pass a limited amount of context from
4823 ** for additional information.
4827 ** Refer to the [SQL parameter] documentation for additional information.
5598 ** information about column C of table T in database D
5862 ** pass information into and receive the reply from the [xBestIndex]
5899 ** The [xBestIndex] method must fill aConstraintUsage[] with information
6759 ** ^These interfaces are used to retrieve runtime status information
6889 ** ^This interface is used to retrieve runtime status information
7091 ** See [sqlite3_pcache_methods2] for additional information.
7103 ** See [sqlite3_pcache_methods2] for additional information.
7108   void *pExtra;      /* Extra information associated with the page */
7312 ** The sqlite3_backup object records state information about an ongoing
7796 ** information.
7813 ** information is written back into integers pointed to by L and C.)^
7893 ** sets the error information that is queried by
8066 ** This interface returns information about the predicted and measured
8075 ** The "iScanStatusOp" parameter determines which status information to return.
8171 ** The sqlite3_snapshot object records state information about an historical
8587 **   the current row. This is the same information as is accessible via the
8637 **   The information accessed using this API and its companion
12075 ** The Lookaside structure holds configuration information about the
12081 ** with a particular database connection.  Hence, schema information cannot
12082 ** be stored in lookaside because in shared cache mode the schema information
12084 ** schema information, the Lookaside.bEnabled flag is cleared so that
12269   sqlite3_userauth auth;        /* User authentication information */
12526 ** information about each column of an SQL table is held in an instance
12892   KeyInfo *pKeyInfo;  /* Collation and sort-order information */
12992 ** analyze.c source file for additional information.
13016 ** An instance of this structure contains information needed to generate
13021 ** AggInfo.aCol[] or AggInfo.aFunc[] of information needed to generate
13487 ** An instance of the following structure contains all information
13501 ** enough information about the compound query is known at that point.
13649 ** tables, the following information is attached to the Table.u.autoInc.p
13650 ** pointer of each autoincrement table to record some side information that
13652 ** information in case inserts are done within triggers.  Triggers do not
13654 ** loading and saving of autoincrement information.
13718 ** carry around information that is global to the entire parse.
13967 ** The following structure contains information used by the sqliteFix...
14005 ** A pointer to this structure is used to communicate information
14018 ** This structure also contains some state information.
14330 ** An instance of the following structure holds information about SQL
15857 ** This is the header file for information that is private to the
15858 ** VDBE.  This information used to all be at the top of the single
15861 ** this header information was factored out.
15956   /* Cached information about the header for the data record that the
16047   /* ShallowCopy only needs to copy the information above */
16157   FuncDef *pFunc;         /* Pointer to function information */
16390 ** Variables in which to record status information.
16421 /* The "wsdStat" macro will resolve to the status information
16503 ** Query status information.
16545 ** Query status information for a single database connection
18004 ** when simply tossing information over the wall to the VFS and we do not
18005 ** really care if the VFS receives and understands the information since it
18769 ** information to each allocation in order to help detect and fix memory
22070 ** State information local to the memory allocation subsystem.
26435   /* A 32-bit varint is used to store size information in btrees.
27525   unixShm *pShm;                      /* Shared memory segment information */
28203 ** Helper function for printing out trace information from debugging
28221 ** Print out information about all locking operations.
28770   struct stat statbuf;           /* Low-level file information */
28775   /* Get low-level information about the file that we can used to
31518 ** open files) would have to carry around this extra information.  So
32333     struct stat statbuf;          /* Low-level file information */
35000   ** macro for addition information on finder-functions.
35675 ** The winMemData structure stores information required by the Win32-specific
40696 /* State information for the randomness gatherer. */
42122 ** is the extension added by the btree.c module containing information such
42124 ** is added by the pcache.c layer and contains information used to keep track
42127 ** PgHdr1 contains information needed to look up a page by its page number.
44736 ** checking information.  If the power fails while the journal is being
44743 ** The sanity checking information for the new journal format consists
47354     ** pager_playback() function for additional information.
47459 **              database (with some additional information - the nRec field
47533 ** attempts to open a temporary file.  This information is used for
48528 ** all information is held in cache. It is never written to disk.
49959 ** write the information on page pPg back to the disk, even though
51518 ** Each index block except for the first contains information on
51519 ** HASHTABLE_NPAGE frames. The first index block contains information on
51685 ** information used by checkpoint.
52023 ** Write the header information in pWal->hdr into the wal-index.
53060 ** The amount of information copies from WAL to database might be limited
53103   volatile WalCkptInfo *pInfo;    /* The checkpoint status information */
53540   volatile WalCkptInfo *pInfo;    /* Checkpoint information in wal-index */
54196   Wal *pWal;                   /* The complete WAL information */
54405   /* Setup information needed to write frames into the WAL */
54544 ** Obtain a CHECKPOINT lock and then backfill as much information as
54850 ** information such as the size of key and data.
55071 ** information about the page that is decoded from the raw file page.
55112 ** The in-memory image of a disk page has the auxiliary information appended
55114 ** that extra information.
55270 ** An instance of the following structure is used to hold information
55272 ** based on information extract from the raw disk page.
55470 ** in order to keep track of some global state information.
55814 ** See the header comment on "btreeInt.h" for additional information.
57388   /* Overwrite deleted information with zeros when the secure_delete
57519 ** Initialize the auxiliary information for a disk block.
57875 ** During a rollback, when the pager reloads information into the cache
59497 ** and populated with enough information so that if a power loss occurs
59589 ** routine did all the work of writing information out to disk and flushing the
60030 ** BtCursor.info is a cache of the information in the current cell.
60217 ** This function is used to read or overwrite payload information
60495 ** Return a pointer to payload information from the entry that the
60984         ** varint. This information is used to attempt to avoid parsing
61681     ** always fully overwrite deleted information with zeros.
62824   CellArray b;                  /* Parsed information on cells being balanced */
64290 ** Delete all information from a single table in the database.  iTable is
64322 ** Delete all information from the single table that pCur is open on.
64331 ** Erase all information in a table and add the root of the table to
64465 ** Read the meta-information out of a database file.  Meta[0]
64508 ** Write meta-information back into the database.  Meta[0] is
69458   ** information from the vdbe.c source text */
70833   ** instructions yet, leave the main database error information unchanged.
70855   /* Save profiling information from this VDBE run.
72676 ** The following routines extract information from a Mem or sqlite3_value
74427 ** procedures use this information to make sure that indices are
74449 ** is executed.  The test procedures use this information to make sure that
74461 ** use this information to make sure that the zero-blob functionality
74615 ** do so without loss of information.  In other words, if the string
74693 ** loss of information and return the revised type of the argument.
75201 ** the mkopcodeh.awk script for additional information.
76299 ** This opcode is used when extracting information from a column that
76386 ** additional information.
76399 ** See the Lt opcode for additional information.
76412 ** register P1.  See the Lt opcode for additional information.
76419 ** register P1.  See the Lt opcode for additional information.
76426 ** register P1.  See the Lt opcode for additional information.
76827 ** information about the format of the data.)  Extract the P2-th column
76964   ** parsed and valid information is in aOffset[] and pC->aType[].
77780 ** See the OpenRead opcode documentation for additional information.
78219     ** loss of information, then special processing is required... */
79464 ** from P1.  This information is stored in P3 and used to redirect
79760 ** See documentation on OP_CreateTable for additional information.
81249 ** This opcode records information from the optimizer.  It is the
87439 ** During expression analysis, extra information is computed and moved into
87440 ** later parts of teh Expr object and that extra information might get chopped
88577       KeyInfo *pKeyInfo = 0;      /* Key information */
90678 ** for additional information.
91814 ** 3.6.18 and 3.7.8.  The "stat2" table contains additional information
91839 ** sqlite_stat4 format will be described first.  Further information
92006 ** information.
92445 ** extract relevant information for constructing the sqlite_statN tables.
92537 ** used to query statistical information that has been gathered into
92546 ** stat1 table entry information.
93147 ** Used to pass information from the analyzer reader through to the
95014 ** Erase all schema information from all attached databases (including
95305 ** routines will be called to add more information to this record.
96459     ** the information we've collected.
96740 ** Ticket #1728:  The symbol table might still contain information
96796   ** token for additional information.
97069 ** information about the conflict resolution algorithms specified
97352   Parse *pParse,     /* All information about this parse */
97883 ** Fill the Index.aiRowEst[] array with default information - information
99280   ** have fields overwritten with new information appropriate for the
101760 ** The following structure keeps track of state information for the
102215 ** accessed). No information is required by the code-generator before
102217 ** generation code to query for this information are:
104054   /* Locate the table into which we will be inserting new information.
104223       /* Invoke the coroutine to extract information from the SELECT
104469         ** taking up data space with information that will never be used.
109669   const char *zExtra   /* Error information */
109685 ** database.  See sqlite3Init() below for additional information.
109688 ** Each callback contains the following information:
109838   /* Get the database meta information.
109926   /* Read the schema information out of the schema tables
110536 ** An instance of the following object is used to record information about
110537 ** how to process the DISTINCT keyword, to simplify passing that information
110549 ** An instance of the following object is used to record information about
110863 ** explicitly mentioned in the expression.  That information is needed
110893 ** This routine processes the join information for a SELECT statement.
112027 ** in the result set.  This information is used to provide the
112200 ** Add type and collation information to a column list based on
112212   Table *pTab,          /* Add column type information to this table */
113327   KeyInfo *pKeyDup = 0; /* Comparison information for duplicate removal */
113328   KeyInfo *pKeyMerge;   /* Comparison information for merging rows */
114275 **       information to know.)
115005 ** For additional information on what it means to "expand" a SELECT
115039 ** information to the Table structure that represents the result set
115043 ** by selectExpander() but the type and collation information was omitted
115075 ** This routine adds datatype and collating sequence information to
115295 ** See comments in sqliteInt.h for further information.
115693     NameContext sNC;    /* Name context for processing aggregate information */
115771       KeyInfo *pKeyInfo;  /* Keying information for the group by clause */
115812       ** it might be a single loop that uses an index to extract information
116454 ** structure is generated based on the information available and stored
117148 ** (trigger program). If an error has occurred, transfer error information
117427 ** old.* or new.* tables actually are used by triggers. This information
117955   ** information is needed */
118928 ** Clear any and all virtual-table information from the Table record.
119070     ** the information we've collected.
119842 ** the SQLite core with additional information about the behavior
119949 ** This object contains information needed to implement a single nested
120049 ** See WhereOrSet for additional information
120122 ** and the WhereTerm.u.pOrInfo field points to auxiliary information that
120152     WhereOrInfo *pOrInfo;   /* Extra information if (eOperator & WO_OR)!=0 */
120153     WhereAndInfo *pAndInfo; /* Extra information if (eOperator& WO_AND)!=0 */
120204 ** An instance of the following structure holds all information about a
120283 ** This object is a convenience wrapper holding all information needed
120373   WhereInfo *pWInfo,   /* Complete information about the WHERE clause */
121219   WhereInfo *pWInfo,   /* Complete information about the WHERE clause */
122708   WhereOrInfo *pOrInfo;     /* Additional information associated with pTerm */
123308   ** This information is used by the xBestIndex methods of
125517 ** information is gathered in the pBuilder->pOrSet object.  This special
126122   WhereLoopBuilder *pBuilder, /* WHERE clause information */
126491   WhereLoopBuilder *pBuilder,  /* WHERE clause information */
127565 ** information needed to terminate the loop.  Later, the calling routine
128110 ** sqlite3WhereBegin() for additional information.
128346 ** An instance of this structure holds information about the
129215 **      the information used by the action routines in the grammar.
130022 ** Print tracing information for a SHIFT action
130078 /* The following table contains information about every rule that
132882 ** comments on that procedure for additional information.
133295 ** extra diagnostic information.
136495 ** Return meta information about a specific column of a database table.
136563   /* The following block stores the meta information that will be returned
136571   **        explicitly declared column. Copy meta information from *pCol.
136728     ** See the sqlite3BitvecBuiltinTest() for additional information.
137645 ** A bare doclist omits the position information, becoming an
137737 ** The segment directory in table %_segdir stores meta-information for
137749 ** The meta-information in the segment directory is:
137885 ** including customization information defined at creation time.
140118 ** Close the cursor.  For additional information see the documentation
141579 ** information.
144108 ** expression node for the following information:
145080 ** and other information (column names etc.) in pParse. Create an Fts3Expr
147865   ** track such information in the database, then we'd only want this
147866   ** information on the initial create.
153837 ** A deferred-doclist is like any other doclist with position information
154576 ** Retrieve information about the current candidate snippet of snippet
155744   /* Loop through the table columns, appending offset information to
158117   sqlite3_rtree_query_info *pInfo;   /* Callback information */
161301 ** time sqlite3rbu_close() is called, various state information is saved
161305 ** To remove all RBU extension state information, returning an RBU database
162825 ** to obtain the required information.
165773 ** information from an SQLite database in order to implement the
165777 ** Additional information is available on the "dbstat.html" page of the
168876 **   the current row. This is the same information as is accessible via the
168926 **   The information accessed using this API and its companion
169369 ** An instance of the following structure encodes all information that can
169372 ** And all information loaded from the %_config table.
170333 **      the information used by the action routines in the grammar.
170739 ** Print tracing information for a SHIFT action
170795 /* The following table contains information about every rule that
182905 ** structure is used to record the current transaction state. This information
183541 ** Close the cursor.  For additional information see the documentation
183942 ** information.
188376   /* A 32-bit varint is used to store size information in btrees.
189015 ** Close the cursor.  For additional information see the documentation