System.Data.SQLite
Check-in [42798551ca]
Not logged in

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

Overview
Comment:Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to [71bedaca19].
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 42798551ca839974edc4b2b51a90cfadd457aea9
User & Date: mistachkin 2015-07-13 19:51:09
References
2015-07-13
19:51 Closed ticket [71bedaca19]: Add enumeration for extended return codes plus 4 other changes artifact: 3fef8b81ec user: mistachkin
Context
2015-07-13
22:41
Add tests for ticket [71bedaca19]. check-in: 1ddef23eb9 user: mistachkin tags: trunk
19:51
Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to [71bedaca19]. check-in: 42798551ca user: mistachkin tags: trunk
2015-07-11
08:06
Small HTML style fix for the previous check-in. check-in: 59e075a640 user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Show Whitespace Changes Patch

Changes to Doc/Extra/Provider/version.html.

    45     45       <h1 class="heading">Version History</h1>
    46     46       <p><b>1.0.98.0 - August XX, 2015 <font color="red">(release scheduled)</font></b></p>
    47     47       <ul>
    48     48         <li>Updated to <a href="https://www.sqlite.org/draft/releaselog/3_8_11.html">SQLite 3.8.11</a>.</li>
    49     49         <li>Implement the Substring method for LINQ using the &quot;substr&quot; core SQL function.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    50     50         <li>Remove errant semi-colons from the SQL used by LINQ to INSERT and then SELECT rows with composite primary keys. Fix for <a href="https://system.data.sqlite.org/index.html/info/9d353b0bd8">[9d353b0bd8]</a>.</li>
    51     51         <li>Change the base type for the SQLiteConnectionFlags enumeration to long integer.&nbsp;<b>** Potentially Incompatible Change **</b></li>
           52  +      <li>Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/71bedaca19">[71bedaca19]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    52     53         <li>Improve exception handling in all native callbacks implemented in the SQLiteConnection class.</li>
    53     54         <li>Add Progress event and ProgressOps connection string property to enable raising progress events during long-running queries.</li>
    54     55         <li>Add VfsName connection string property to allow a non-default VFS to be used by the SQLite core library.</li>
    55     56         <li>Add BusyTimeout connection string property to set the busy timeout to be used by the SQLite core library.</li>
    56     57         <li>Enable integration with the <a href="http://www.hwaci.com/sw/sqlite/zipvfs.html">ZipVFS</a> extension.</li>
    57     58       </ul>
    58     59       <p><b>1.0.97.0 - May 26, 2015</b></p>

Changes to System.Data.SQLite/SQLiteException.cs.

   328    328       /// <summary>
   329    329       /// sqlite3_step() has finished executing
   330    330       /// </summary>
   331    331       Done, /* 101 */
   332    332       /// <summary>
   333    333       /// Used to mask off extended result codes
   334    334       /// </summary>
   335         -    NonExtendedMask = 0xFF
          335  +    NonExtendedMask = 0xFF,
          336  +
          337  +    ///////////////////////////////////////////////////////////////////////////
          338  +    // BEGIN EXTENDED RESULT CODES
          339  +    ///////////////////////////////////////////////////////////////////////////
          340  +
          341  +    /// <summary>
          342  +    /// A file read operation failed.
          343  +    /// </summary>
          344  +    IoErr_Read = (IoErr | (1 << 8)),
          345  +    /// <summary>
          346  +    /// A file read operation returned less data than requested.
          347  +    /// </summary>
          348  +    IoErr_Short_Read = (IoErr | (2 << 8)),
          349  +    /// <summary>
          350  +    /// A file write operation failed.
          351  +    /// </summary>
          352  +    IoErr_Write = (IoErr | (3 << 8)),
          353  +    /// <summary>
          354  +    /// A file synchronization operation failed.
          355  +    /// </summary>
          356  +    IoErr_Fsync = (IoErr | (4 << 8)),
          357  +    /// <summary>
          358  +    /// A directory synchronization operation failed.
          359  +    /// </summary>
          360  +    IoErr_Dir_Fsync = (IoErr | (5 << 8)),
          361  +    /// <summary>
          362  +    /// A file truncate operation failed.
          363  +    /// </summary>
          364  +    IoErr_Truncate = (IoErr | (6 << 8)),
          365  +    /// <summary>
          366  +    /// A file metadata operation failed.
          367  +    /// </summary>
          368  +    IoErr_Fstat = (IoErr | (7 << 8)),
          369  +    /// <summary>
          370  +    /// A file unlock operation failed.
          371  +    /// </summary>
          372  +    IoErr_Unlock = (IoErr | (8 << 8)),
          373  +    /// <summary>
          374  +    /// A file lock operation failed.
          375  +    /// </summary>
          376  +    IoErr_RdLock = (IoErr | (9 << 8)),
          377  +    /// <summary>
          378  +    /// A file delete operation failed.
          379  +    /// </summary>
          380  +    IoErr_Delete = (IoErr | (10 << 8)),
          381  +    /// <summary>
          382  +    /// Not currently used.
          383  +    /// </summary>
          384  +    IoErr_Blocked = (IoErr | (11 << 8)),
          385  +    /// <summary>
          386  +    /// Out-of-memory during a file operation.
          387  +    /// </summary>
          388  +    IoErr_NoMem = (IoErr | (12 << 8)),
          389  +    /// <summary>
          390  +    /// A file existence/status operation failed.
          391  +    /// </summary>
          392  +    IoErr_Access = (IoErr | (13 << 8)),
          393  +    /// <summary>
          394  +    /// A check for a reserved lock failed.
          395  +    /// </summary>
          396  +    IoErr_CheckReservedLock = (IoErr | (14 << 8)),
          397  +    /// <summary>
          398  +    /// A file lock operation failed.
          399  +    /// </summary>
          400  +    IoErr_Lock = (IoErr | (15 << 8)),
          401  +    /// <summary>
          402  +    /// A file close operation failed.
          403  +    /// </summary>
          404  +    IoErr_Close = (IoErr | (16 << 8)),
          405  +    /// <summary>
          406  +    /// A directory close operation failed.
          407  +    /// </summary>
          408  +    IoErr_Dir_Close = (IoErr | (17 << 8)),
          409  +    /// <summary>
          410  +    /// A shared memory open operation failed.
          411  +    /// </summary>
          412  +    IoErr_ShmOpen = (IoErr | (18 << 8)),
          413  +    /// <summary>
          414  +    /// A shared memory size operation failed.
          415  +    /// </summary>
          416  +    IoErr_ShmSize = (IoErr | (19 << 8)),
          417  +    /// <summary>
          418  +    /// A shared memory lock operation failed.
          419  +    /// </summary>
          420  +    IoErr_ShmLock = (IoErr | (20 << 8)),
          421  +    /// <summary>
          422  +    /// A shared memory map operation failed.
          423  +    /// </summary>
          424  +    IoErr_ShmMap = (IoErr | (21 << 8)),
          425  +    /// <summary>
          426  +    /// A file seek operation failed.
          427  +    /// </summary>
          428  +    IoErr_Seek = (IoErr | (22 << 8)),
          429  +    /// <summary>
          430  +    /// A file delete operation failed because it does not exist.
          431  +    /// </summary>
          432  +    IoErr_Delete_NoEnt = (IoErr | (23 << 8)),
          433  +    /// <summary>
          434  +    /// A file memory mapping operation failed.
          435  +    /// </summary>
          436  +    IoErr_Mmap = (IoErr | (24 << 8)),
          437  +    /// <summary>
          438  +    /// The temporary directory path could not be obtained.
          439  +    /// </summary>
          440  +    IoErr_GetTempPath = (IoErr | (25 << 8)),
          441  +    /// <summary>
          442  +    /// A path string conversion operation failed.
          443  +    /// </summary>
          444  +    IoErr_ConvPath = (IoErr | (26 << 8)),
          445  +    /// <summary>
          446  +    /// A database table is locked in shared-cache mode.
          447  +    /// </summary>
          448  +    Locked_SharedCache = (Locked | (1 << 8)),
          449  +    /// <summary>
          450  +    /// A database file is locked due to a recovery operation.
          451  +    /// </summary>
          452  +    Busy_Recovery = (Busy | (1 << 8)),
          453  +    /// <summary>
          454  +    /// A database file is locked due to snapshot semantics.
          455  +    /// </summary>
          456  +    Busy_Snapshot = (Busy | (2 << 8)),
          457  +    /// <summary>
          458  +    /// A database file cannot be opened because no temporary directory is available.
          459  +    /// </summary>
          460  +    CantOpen_NoTempDir = (CantOpen | (1 << 8)),
          461  +    /// <summary>
          462  +    /// A database file cannot be opened because its path represents a directory.
          463  +    /// </summary>
          464  +    CantOpen_IsDir = (CantOpen | (2 << 8)),
          465  +    /// <summary>
          466  +    /// A database file cannot be opened because its full path could not be obtained.
          467  +    /// </summary>
          468  +    CantOpen_FullPath = (CantOpen | (3 << 8)),
          469  +    /// <summary>
          470  +    /// A database file cannot be opened because a path string conversion operation failed.
          471  +    /// </summary>
          472  +    CantOpen_ConvPath = (CantOpen | (4 << 8)),
          473  +    /// <summary>
          474  +    /// A virtual table is malformed.
          475  +    /// </summary>
          476  +    Corrupt_Vtab = (Corrupt | (1 << 8)),
          477  +    /// <summary>
          478  +    /// A database file is read-only due to a recovery operation.
          479  +    /// </summary>
          480  +    ReadOnly_Recovery = (ReadOnly | (1 << 8)),
          481  +    /// <summary>
          482  +    /// A database file is read-only because a lock could not be obtained.
          483  +    /// </summary>
          484  +    ReadOnly_CantLock = (ReadOnly | (2 << 8)),
          485  +    /// <summary>
          486  +    /// A database file is read-only because it needs rollback processing.
          487  +    /// </summary>
          488  +    ReadOnly_Rollback = (ReadOnly | (3 << 8)),
          489  +    /// <summary>
          490  +    /// A database file is read-only because it was moved while open.
          491  +    /// </summary>
          492  +    ReadOnly_DbMoved = (ReadOnly | (4 << 8)),
          493  +    /// <summary>
          494  +    /// An operation is being aborted due to rollback processing.
          495  +    /// </summary>
          496  +    Abort_Rollback = (Abort | (2 << 8)),
          497  +    /// <summary>
          498  +    /// A CHECK constraint failed.
          499  +    /// </summary>
          500  +    Constraint_Check = (Constraint | (1 << 8)),
          501  +    /// <summary>
          502  +    /// A commit hook produced a unsuccessful return code.
          503  +    /// </summary>
          504  +    Constraint_CommitHook = (Constraint | (2 << 8)),
          505  +    /// <summary>
          506  +    /// A FOREIGN KEY constraint failed.
          507  +    /// </summary>
          508  +    Constraint_ForeignKey = (Constraint | (3 << 8)),
          509  +    /// <summary>
          510  +    /// Not currently used.
          511  +    /// </summary>
          512  +    Constraint_Function = (Constraint | (4 << 8)),
          513  +    /// <summary>
          514  +    /// A NOT NULL constraint failed.
          515  +    /// </summary>
          516  +    Constraint_NotNull = (Constraint | (5 << 8)),
          517  +    /// <summary>
          518  +    /// A PRIMARY KEY constraint failed.
          519  +    /// </summary>
          520  +    Constraint_PrimaryKey = (Constraint | (6 << 8)),
          521  +    /// <summary>
          522  +    /// The RAISE function was used by a trigger-program.
          523  +    /// </summary>
          524  +    Constraint_Trigger = (Constraint | (7 << 8)),
          525  +    /// <summary>
          526  +    /// A UNIQUE constraint failed.
          527  +    /// </summary>
          528  +    Constraint_Unique = (Constraint | (8 << 8)),
          529  +    /// <summary>
          530  +    /// Not currently used.
          531  +    /// </summary>
          532  +    Constraint_Vtab = (Constraint | (9 << 8)),
          533  +    /// <summary>
          534  +    /// A ROWID constraint failed.
          535  +    /// </summary>
          536  +    Constraint_RowId = (Constraint | (10 << 8)),
          537  +    /// <summary>
          538  +    /// Frames were recovered from the WAL log file.
          539  +    /// </summary>
          540  +    Notice_Recover_Wal = (Notice | (1 << 8)),
          541  +    /// <summary>
          542  +    /// Pages were recovered from the journal file.
          543  +    /// </summary>
          544  +    Notice_Recover_Rollback = (Notice | (2 << 8)),
          545  +    /// <summary>
          546  +    /// An automatic index was created to process a query.
          547  +    /// </summary>
          548  +    Warning_AutoIndex = (Warning | (1 << 8)),
          549  +    /// <summary>
          550  +    /// User authentication failed.
          551  +    /// </summary>
          552  +    Auth_User = (Auth | (1 << 8))
   336    553     }
   337    554   }

Changes to readme.htm.

   212    212       <b>1.0.98.0 - August XX, 2015 <font color="red">(release scheduled)</font></b>
   213    213   </p>
   214    214   <ul>
   215    215       <li>Updated to <a href="https://www.sqlite.org/draft/releaselog/3_8_11.html">SQLite 3.8.11</a>.</li>
   216    216       <li>Implement the Substring method for LINQ using the &quot;substr&quot; core SQL function.&nbsp;<b>** Potentially Incompatible Change **</b></li>
   217    217       <li>Remove errant semi-colons from the SQL used by LINQ to INSERT and then SELECT rows with composite primary keys. Fix for [9d353b0bd8].</li>
   218    218       <li>Change the base type for the SQLiteConnectionFlags enumeration to long integer.&nbsp;<b>** Potentially Incompatible Change **</b></li>
          219  +    <li>Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to [71bedaca19].&nbsp;<b>** Potentially Incompatible Change **</b></li>
   219    220       <li>Improve exception handling in all native callbacks implemented in the SQLiteConnection class.</li>
   220    221       <li>Add Progress event and ProgressOps connection string property to enable raising progress events during long-running queries.</li>
   221    222       <li>Add VfsName connection string property to allow a non-default VFS to be used by the SQLite core library.</li>
   222    223       <li>Add BusyTimeout connection string property to set the busy timeout to be used by the SQLite core library.</li>
   223    224       <li>Enable integration with the <a href="http://www.hwaci.com/sw/sqlite/zipvfs.html">ZipVFS</a> extension.</li>
   224    225   </ul>
   225    226   <p>

Changes to www/news.wiki.

     6      6       <b>1.0.98.0 - August XX, 2015 <font color="red">(release scheduled)</font></b>
     7      7   </p>
     8      8   <ul>
     9      9       <li>Updated to [https://www.sqlite.org/draft/releaselog/3_8_11.html|SQLite 3.8.11].</li>
    10     10       <li>Implement the Substring method for LINQ using the &quot;substr&quot; core SQL function.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    11     11       <li>Remove errant semi-colons from the SQL used by LINQ to INSERT and then SELECT rows with composite primary keys. Fix for [9d353b0bd8].</li>
    12     12       <li>Change the base type for the SQLiteConnectionFlags enumeration to long integer.&nbsp;<b>** Potentially Incompatible Change **</b></li>
           13  +    <li>Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to [71bedaca19].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    13     14       <li>Improve exception handling in all native callbacks implemented in the SQLiteConnection class.</li>
    14     15       <li>Add Progress event and ProgressOps connection string property to enable raising progress events during long-running queries.</li>
    15     16       <li>Add VfsName connection string property to allow a non-default VFS to be used by the SQLite core library.</li>
    16     17       <li>Add BusyTimeout connection string property to set the busy timeout to be used by the SQLite core library.</li>
    17     18       <li>Enable integration with the [http://www.hwaci.com/sw/sqlite/zipvfs.html|ZipVFS] extension.</li>
    18     19   </ul>
    19     20   <p>