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.
Downloads: Tarball | ZIP archive
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.102
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
Unified Diff Ignore Whitespace Patch
Changes to pages/rescode.in.
740
741
742
743
744
745
746








































747
748
749
750
751
752
753
}
RESCODE SQLITE_READONLY_DIRECTORY {SQLITE_READONLY | (6<<8)} {
  The SQLITE_READONLY_DIRECTORY result code indicates that the database
  is read-only because process does not have permission to create
  a journal file in the same directory as the database and the creation of
  a journal file is a prerequisite for writing.
}









































#############################################################################
# Code to process the RESCODE values
#
# Convert formula RESCODE values into numerics
set nResCode 0
set nPrimCode 0







>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
}
RESCODE SQLITE_READONLY_DIRECTORY {SQLITE_READONLY | (6<<8)} {
  The SQLITE_READONLY_DIRECTORY result code indicates that the database
  is read-only because process does not have permission to create
  a journal file in the same directory as the database and the creation of
  a journal file is a prerequisite for writing.
}

RESCODE SQLITE_ERROR_SNAPSHOT {SQLITE_ERROR | (3<<8)} {
  The SQLITE_ERROR_SNAPSHOT result code might be returned when attempting
  to start a read transaction on an historical version of the database
  by using the [sqlite3_snapshot_open()] interface.  If the historical
  snapshot is no longer available, then the read transaction will fail
  with the SQLITE_ERROR_SNAPSHOT.  This error code is only possible if
  SQLite is compiled with [-DSQLITE_ENABLE_SNAPSHOT].
}

RESCODE SQLITE_LOCKED_VTAB {SQLITE_LOCKED | (2<<8)} {
  The SQLITE_LOCKED_VTAB result code is not used by the SQLite core, but
  it is available for use by extensions.  Virtual table implementations
  can return this result code to indicate that they cannot complete the
  current operation because of locks held by other threads or processes.
  <p>
  The [R-Tree extension] returns this result code when an attempt is made
  to update the R-Tree while another prepared statement is actively reading
  the R-Tree.  The update cannot proceed because any change to an R-Tree
  might involve reshuffling and rebalancing of nodes, which would disrupt
  read cursors, causing some rows to be repeated and other rows to be
  omitted.
}

RESCODE SQLITE_CORRUPT_SEQUENCE {SQLITE_CORRUPT | (2<<8)} {
  The SQLITE_CORRUPT_SEQUENCE result code means that the schema of
  the sqlite_sequence table is corrupt.  The sqlite_sequence table
  is used to help implement the [AUTOINCREMENT] feature.  The
  sqlite_sequence table should have the following format:
  <blockquote><pre>
  CREATE TABLE sqlite_sequence(name,seq);
  </pre></blockquote>
  <p>If SQLite discovers that the sqlite_sequence table has any other
  format, it returns the SQLITE_CORRUPT_SEQUENCE error.
}

RESCODE SQLITE_CANTOPEN_DIRTYWAL {SQLITE_CANTOPEN | (5<<8)} {
  The SQLITE_CANTOPEN_DIRTYWAL result code is not used at this time.
}


#############################################################################
# Code to process the RESCODE values
#
# Convert formula RESCODE values into numerics
set nResCode 0
set nPrimCode 0