Documentation Source Text

Check-in [76e1292157]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add documentation for missing result codes.
Timelines: family | ancestors | descendants | both | branch-3.25
Files: files | file ages | folders
SHA3-256:76e1292157a08054b0b4d2415bd59cbadf12dd3e98feed66cb392a34e7878616
User & Date: drh 2018-10-03 12:59:59
Context
2018-10-14
20:33
Fix typo on the GLOB documentation. check-in: ddacae7fd0 user: drh tags: branch-3.25
2018-10-03
12:59
Add documentation for missing result codes. check-in: 76e1292157 user: drh tags: branch-3.25
2018-09-27
13:06
Say that the recursive part of a CTE may not use aggregate or window functions. check-in: cf2f8cbd8f user: drh tags: branch-3.25
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/rescode.in.

   740    740   }
   741    741   RESCODE SQLITE_READONLY_DIRECTORY {SQLITE_READONLY | (6<<8)} {
   742    742     The SQLITE_READONLY_DIRECTORY result code indicates that the database
   743    743     is read-only because process does not have permission to create
   744    744     a journal file in the same directory as the database and the creation of
   745    745     a journal file is a prerequisite for writing.
   746    746   }
          747  +
          748  +RESCODE SQLITE_ERROR_SNAPSHOT {SQLITE_ERROR | (3<<8)} {
          749  +  The SQLITE_ERROR_SNAPSHOT result code might be returned when attempting
          750  +  to start a read transaction on an historical version of the database
          751  +  by using the [sqlite3_snapshot_open()] interface.  If the historical
          752  +  snapshot is no longer available, then the read transaction will fail
          753  +  with the SQLITE_ERROR_SNAPSHOT.  This error code is only possible if
          754  +  SQLite is compiled with [-DSQLITE_ENABLE_SNAPSHOT].
          755  +}
          756  +
          757  +RESCODE SQLITE_LOCKED_VTAB {SQLITE_LOCKED | (2<<8)} {
          758  +  The SQLITE_LOCKED_VTAB result code is not used by the SQLite core, but
          759  +  it is available for use by extensions.  Virtual table implementations
          760  +  can return this result code to indicate that they cannot complete the
          761  +  current operation because of locks held by other threads or processes.
          762  +  <p>
          763  +  The [R-Tree extension] returns this result code when an attempt is made
          764  +  to update the R-Tree while another prepared statement is actively reading
          765  +  the R-Tree.  The update cannot proceed because any change to an R-Tree
          766  +  might involve reshuffling and rebalancing of nodes, which would disrupt
          767  +  read cursors, causing some rows to be repeated and other rows to be
          768  +  omitted.
          769  +}
          770  +
          771  +RESCODE SQLITE_CORRUPT_SEQUENCE {SQLITE_CORRUPT | (2<<8)} {
          772  +  The SQLITE_CORRUPT_SEQUENCE result code means that the schema of
          773  +  the sqlite_sequence table is corrupt.  The sqlite_sequence table
          774  +  is used to help implement the [AUTOINCREMENT] feature.  The
          775  +  sqlite_sequence table should have the following format:
          776  +  <blockquote><pre>
          777  +  CREATE TABLE sqlite_sequence(name,seq);
          778  +  </pre></blockquote>
          779  +  <p>If SQLite discovers that the sqlite_sequence table has any other
          780  +  format, it returns the SQLITE_CORRUPT_SEQUENCE error.
          781  +}
          782  +
          783  +RESCODE SQLITE_CANTOPEN_DIRTYWAL {SQLITE_CANTOPEN | (5<<8)} {
          784  +  The SQLITE_CANTOPEN_DIRTYWAL result code is not used at this time.
          785  +}
          786  +
   747    787   
   748    788   #############################################################################
   749    789   # Code to process the RESCODE values
   750    790   #
   751    791   # Convert formula RESCODE values into numerics
   752    792   set nResCode 0
   753    793   set nPrimCode 0