trace1.html

sqlite的帮助文档

</pre></blockquote><ol><li value="1"><p>S70200
  The SQLite library shall provide interfaces that test to see if an
  SQL statement being received incrementally is complete.
</p></li><li value="2"><p>S70000
  The SQLite library shall provide interfaces that promote the safe
  construction and processing of SQL statements and data from
  untrusted sources.
</p></li></ol></td></tr><tr><td valign="top">H10511</td><td valign="top">A successful evaluation of <a href="c3ref/complete.html">sqlite3_complete()</a> or
<a href="c3ref/complete.html">sqlite3_complete16()</a> functions shall
return a numeric 1 if and only if the last non-whitespace
token in their input is a semicolon that is not in between
the BEGIN and END of a CREATE TRIGGER statement. <ol><li value="1"><p>S70200
  The SQLite library shall provide interfaces that test to see if an
  SQL statement being received incrementally is complete.
</p></li><li value="2"><p>S70000
  The SQLite library shall provide interfaces that promote the safe
  construction and processing of SQL statements and data from
  untrusted sources.
</p></li></ol></td></tr><tr><td valign="top">H10512</td><td valign="top">If a memory allocation error occurs during an invocation
of <a href="c3ref/complete.html">sqlite3_complete()</a> or <a href="c3ref/complete.html">sqlite3_complete16()</a> then the
routine shall return <a href="c3ref/c_abort.html">SQLITE_NOMEM</a>. <ol><li value="1"><p>S70200
  The SQLite library shall provide interfaces that test to see if an
  SQL statement being received incrementally is complete.
</p></li><li value="2"><p>S70000
  The SQLite library shall provide interfaces that promote the safe
  construction and processing of SQL statements and data from
  untrusted sources.
</p></li></ol></td></tr><tr><td valign="top">H10530</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_sleep(int);

</pre></blockquote><ol><li value="1"><p>S40410
  The SQLite library shall provide interfaces to assist the application
  in responding appropriately when an operation can
  not be completed due to concurrent access constraints.
</p></li><li value="2"><p>S40000
  The SQLite library shall be safe for use in applications that
  make concurrent access to the underlying database from different
  threads and/or processes.
</p></li></ol></td></tr><tr><td valign="top">H10533</td><td valign="top">The <a href="c3ref/sleep.html">sqlite3_sleep(M)</a> interface invokes the xSleep
method of the default <a href="c3ref/vfs.html">VFS</a> in order to
suspend execution of the current thread for at least
M milliseconds. <ol><li value="1"><p>S40410
  The SQLite library shall provide interfaces to assist the application
  in responding appropriately when an operation can
  not be completed due to concurrent access constraints.
</p></li><li value="2"><p>S40000
  The SQLite library shall be safe for use in applications that
  make concurrent access to the underlying database from different
  threads and/or processes.
</p></li></ol></td></tr><tr><td valign="top">H10536</td><td valign="top">The <a href="c3ref/sleep.html">sqlite3_sleep(M)</a> interface returns the number of
milliseconds of sleep actually requested of the operating
system, which might be larger than the parameter M. <ol><li value="1"><p>S40410
  The SQLite library shall provide interfaces to assist the application
  in responding appropriately when an operation can
  not be completed due to concurrent access constraints.
</p></li><li value="2"><p>S40000
  The SQLite library shall be safe for use in applications that
  make concurrent access to the underlying database from different
  threads and/or processes.
</p></li></ol></td></tr><tr><td valign="top">H11110</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
typedef struct sqlite3_file sqlite3_file;
struct sqlite3_file {
  const struct sqlite3_io_methods *pMethods;  /* Methods for an open file */
};

</pre></blockquote><ol><li value="1"><p>S20110
  The SQLite library shall provide interfaces that permit the application
  to override the interfaces used to read and write persistent storage.
</p></li><li value="2"><p>S20100
  The SQLite library shall provide interfaces that permit the application
  to override interfaces to the platform on which the application is running.
</p></li><li value="3"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li></ol></td></tr><tr><td valign="top">H11190</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_ACCESS_EXISTS    0
#define SQLITE_ACCESS_READWRITE 1
#define SQLITE_ACCESS_READ      2

</pre></blockquote><ol><li value="1"><p>H11140The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
typedef struct sqlite3_vfs sqlite3_vfs;
struct sqlite3_vfs {
  int iVersion;            /* Structure version number */
  int szOsFile;            /* Size of subclassed sqlite3_file */
  int mxPathname;          /* Maximum file pathname length */
  sqlite3_vfs *pNext;      /* Next registered VFS */
  const char *zName;       /* Name of this virtual file system */
  void *pAppData;          /* Pointer to application-specific data */
  int (*xOpen)(sqlite3_vfs*, const char *zName, sqlite3_file*,
               int flags, int *pOutFlags);
  int (*xDelete)(sqlite3_vfs*, const char *zName, int syncDir);
  int (*xAccess)(sqlite3_vfs*, const char *zName, int flags, int *pResOut);
  int (*xFullPathname)(sqlite3_vfs*, const char *zName, int nOut, char *zOut);
  void *(*xDlOpen)(sqlite3_vfs*, const char *zFilename);
  void (*xDlError)(sqlite3_vfs*, int nByte, char *zErrMsg);
  void *(*xDlSym)(sqlite3_vfs*,void*, const char *zSymbol);
  void (*xDlClose)(sqlite3_vfs*, void*);
  int (*xRandomness)(sqlite3_vfs*, int nByte, char *zOut);
  int (*xSleep)(sqlite3_vfs*, int microseconds);
  int (*xCurrentTime)(sqlite3_vfs*, double*);
  int (*xGetLastError)(sqlite3_vfs*, int, char *);
  /* New fields may be appended in figure versions.  The iVersion
  ** value will increment whenever this happens. */
};

</pre></blockquote></p></li><li value="2"><p>S20100
  The SQLite library shall provide interfaces that permit the application
  to override interfaces to the platform on which the application is running.
</p></li><li value="3"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li></ol></td></tr><tr><td valign="top">H11200</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
sqlite3_vfs *sqlite3_vfs_find(const char *zVfsName);
int sqlite3_vfs_register(sqlite3_vfs*, int makeDflt);
int sqlite3_vfs_unregister(sqlite3_vfs*);

</pre></blockquote><ol><li value="1"><p>S20100
  The SQLite library shall provide interfaces that permit the application
  to override interfaces to the platform on which the application is running.
</p></li><li value="2"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li></ol></td></tr><tr><td valign="top">H11203</td><td valign="top">The <a href="c3ref/vfs_find.html">sqlite3_vfs_find(N)</a> interface returns a pointer to the
registered <a href="c3ref/vfs.html">sqlite3_vfs</a> object whose name exactly matches
the zero-terminated UTF-8 string N, or it returns NULL if
there is no match. <ol><li value="1"><p>S20100
  The SQLite library shall provide interfaces that permit the application
  to override interfaces to the platform on which the application is running.
</p></li><li value="2"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li></ol></td></tr><tr><td valign="top">H11206</td><td valign="top">If the N parameter to <a href="c3ref/vfs_find.html">sqlite3_vfs_find(N)</a> is NULL then
the function returns a pointer to the default <a href="c3ref/vfs.html">sqlite3_vfs</a>
object if there is one, or NULL if there is no default
<a href="c3ref/vfs.html">sqlite3_vfs</a> object. <ol><li value="1"><p>S20100
  The SQLite library shall provide interfaces that permit the application
  to override interfaces to the platform on which the application is running.
</p></li><li value="2"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li></ol></td></tr><tr><td valign="top">H11209</td><td valign="top">The <a href="c3ref/vfs_find.html">sqlite3_vfs_register(P,F)</a> interface registers the
well-formed <a href="c3ref/vfs.html">sqlite3_vfs</a> object P using the name given
by the zName field of the object. <ol><li value="1"><p>S20100
  The SQLite library shall provide interfaces that permit the application
  to override interfaces to the platform on which the application is running.
</p></li><li value="2"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li></ol></td></tr><tr><td valign="top">H11212</td><td valign="top">Using the <a href="c3ref/vfs_find.html">sqlite3_vfs_register(P,F)</a> interface to register
the same <a href="c3ref/vfs.html">sqlite3_vfs</a> object multiple times is a harmless no-op. <ol><li value="1"><p>S20100
  The SQLite library shall provide interfaces that permit the application
  to override interfaces to the platform on which the application is running.
</p></li><li value="2"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li></ol></td></tr><tr><td valign="top">H11215</td><td valign="top">The <a href="c3ref/vfs_find.html">sqlite3_vfs_register(P,F)</a> interface makes the <a href="c3ref/vfs.html">sqlite3_vfs</a>
object P the default <a href="c3ref/vfs.html">sqlite3_vfs</a> object if F is non-zero. <ol><li value="1"><p>S20100
  The SQLite library shall provide interfaces that permit the application
  to override interfaces to the platform on which the application is running.
</p></li><li value="2"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li></ol></td></tr><tr><td valign="top">H11218</td><td valign="top">The <a href="c3ref/vfs_find.html">sqlite3_vfs_unregister(P)</a> interface unregisters the
<a href="c3ref/vfs.html">sqlite3_vfs</a> object P so that it is no longer returned by
subsequent calls to <a href="c3ref/vfs_find.html">sqlite3_vfs_find()</a>. <ol><li value="1"><p>S20100
  The SQLite library shall provide interfaces that permit the application
  to override interfaces to the platform on which the application is running.
</p></li><li value="2"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li></ol></td></tr><tr><td valign="top">H11300</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_file_control(sqlite3*, const char *zDbName, int op, void*);

</pre></blockquote><ol><li value="1"><p>S30800
  SQLite shall provide the interfaces that support testing and
  validation of the library code in an as-delivered configuration.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></td></tr><tr><td valign="top">H11302</td><td valign="top">The <a href="c3ref/finalize.html">sqlite3_finalize(S)</a> interface destroys the
<a href="c3ref/stmt.html">prepared statement</a> S and releases all
memory and file resources held by that object. <ol><li value="1"><p>S70300
  The SQLite library shall support prepared statement objects with
  late parameter binding
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li><li value="2"><p>S70000
  The SQLite library shall provide interfaces that promote the safe
  construction and processing of SQL statements and data from
  untrusted sources.
</p></li></ol></td></tr><tr><td valign="top">H11304</td><td valign="top">If the most recent call to <a href="c3ref/step.html">sqlite3_step(S)</a> for the
<a href="c3ref/stmt.html">prepared statement</a> S returned an error,
then <a href="c3ref/finalize.html">sqlite3_finalize(S)</a> returns that same error. <ol><li value="1"><p>S70300
  The SQLite library shall support prepared statement objects with
  late parameter binding
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li><li value="2"><p>S70000
  The SQLite library shall provide interfaces that promote the safe
  construction and processing of SQL statements and data from
  untrusted sources.
</p></li></ol></td></tr><tr><td valign="top">H11410</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_TESTCTRL_PRNG_SAVE                5
#define SQLITE_TESTCTRL_PRNG_RESTORE             6
#define SQLITE_TESTCTRL_PRNG_RESET               7
#define SQLITE_TESTCTRL_BITVEC_TEST              8
#define SQLITE_TESTCTRL_FAULT_INSTALL            9
#define SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS     10

</pre></blockquote><ol><li value="1"><p>H11400The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_test_control(int op, ...);

</pre></blockquote></p></li><li value="2"><p>S30800
  SQLite shall provide the interfaces that support testing and
  validation of the library code in an as-delivered configuration.
</p></li><li value="3"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></td></tr><tr><td valign="top">H12000</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
typedef struct sqlite3 sqlite3;

</pre></blockquote><ol><li value="1"><p>S40200
  The SQLite library shall support multiple independent database
  connections per thread and per process.
</p></li><li value="2"><p>S40000
  The SQLite library shall be safe for use in applications that
  make concurrent access to the underlying database from different
  threads and/or processes.
</p></li></ol></td></tr><tr><td valign="top">H12010</td><td valign="top">The sqlite3.h header file shall define the