System.Data.SQLite
Check-in [a469ccf170]
Not logged in

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

Overview
Comment:Update SQLite core library to the 3.7.16.2 release.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: a469ccf1704084c0bd14e4913938e9cc0d8c01b3
User & Date: mistachkin 2013-04-13 17:00:03
Context
2013-04-18
04:55
When the legacy unit test application is running in automatic mode, hide the form. check-in: 4a31424a6b user: mistachkin tags: trunk
2013-04-13
17:00
Update SQLite core library to the 3.7.16.2 release. check-in: a469ccf170 user: mistachkin tags: trunk
2013-04-11
22:58
Add new error codes from the SQLite core library. check-in: d834d6896e user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to Doc/Extra/version.html.

    41     41         </table>
    42     42       </div>
    43     43       <div id="mainSection">
    44     44       <div id="mainBody">
    45     45       <h1 class="heading">Version History</h1>
    46     46       <p><b>1.0.85.0 - April XX, 2013 <font color="red">(release scheduled)</font></b></p>
    47     47       <ul>
    48         -      <li>Updated to <a href="http://www.sqlite.org/src/info/527231bc67">SQLite 3.7.16.1</a>.</li>
           48  +      <li>Updated to <a href="http://www.sqlite.org/releaselog/3_7_16_2.html">SQLite 3.7.16.2</a>.</li>
    49     49         <li>Properly handle embedded NUL characters in parameter and column values. Fix for <a href="http://system.data.sqlite.org/index.html/info/3567020edf">[3567020edf]</a>.</li>
    50     50         <li>Make use of the sqlite3_prepare_v2 function when applicable.</li>
    51     51         <li>Check for a valid row in the SQLiteDataReader.GetValue method.</li>
    52     52         <li>Implement processor architecture detection when running on the .NET Compact Framework (via P/Invoke).</li>
    53     53         <li>Support automated testing when running on the .NET Compact Framework 2.0.</li>
    54     54         <li>Skip checking loaded assemblies for types tagged with the SQLiteFunction attribute when the No_SQLiteFunctions environment variable is set. Pursuant to <a href="http://system.data.sqlite.org/index.html/info/e4c8121f7b">[e4c8121f7b]</a>.</li>
    55     55         <li>Add HexPassword connection string property to work around the inability to include a literal semicolon in a connection string property value. Pursuant to <a href="http://system.data.sqlite.org/index.html/info/1c456ae75f">[1c456ae75f]</a>.</li>

Changes to SQLite.Interop/props/sqlite3.props.

     5      5    *
     6      6    * Written by Joe Mistachkin.
     7      7    * Released to the public domain, use at your own risk!
     8      8    *
     9      9   -->
    10     10   <Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0">
    11     11     <PropertyGroup Label="UserMacros">
    12         -    <SQLITE_MANIFEST_VERSION>3.7.16.1</SQLITE_MANIFEST_VERSION>
    13         -    <SQLITE_RC_VERSION>3,7,16,1</SQLITE_RC_VERSION>
           12  +    <SQLITE_MANIFEST_VERSION>3.7.16.2</SQLITE_MANIFEST_VERSION>
           13  +    <SQLITE_RC_VERSION>3,7,16,2</SQLITE_RC_VERSION>
    14     14       <SQLITE_COMMON_DEFINES>_CRT_SECURE_NO_DEPRECATE;_CRT_SECURE_NO_WARNINGS;_CRT_NONSTDC_NO_DEPRECATE;_CRT_NONSTDC_NO_WARNINGS;SQLITE_THREADSAFE=1;SQLITE_USE_URI=1;SQLITE_ENABLE_COLUMN_METADATA=1;SQLITE_ENABLE_STAT3=1;SQLITE_ENABLE_FTS3=1;SQLITE_ENABLE_LOAD_EXTENSION=1;SQLITE_ENABLE_RTREE=1;SQLITE_SOUNDEX=1</SQLITE_COMMON_DEFINES>
    15     15       <SQLITE_EXTRA_DEFINES>SQLITE_HAS_CODEC=1</SQLITE_EXTRA_DEFINES>
    16     16       <SQLITE_WINCE_DEFINES>SQLITE_OMIT_WAL=1</SQLITE_WINCE_DEFINES>
    17     17       <SQLITE_DEBUG_DEFINES>SQLITE_DEBUG=1;SQLITE_MEMDEBUG=1;SQLITE_ENABLE_EXPENSIVE_ASSERT=1</SQLITE_DEBUG_DEFINES>
    18     18       <SQLITE_RELEASE_DEFINES>SQLITE_WIN32_MALLOC=1</SQLITE_RELEASE_DEFINES>
    19     19       <SQLITE_DISABLE_WARNINGS>4055;4100;4127;4146;4210;4232;4244;4245;4267;4306;4389;4701;4703;4706</SQLITE_DISABLE_WARNINGS>
    20     20       <SQLITE_DISABLE_X64_WARNINGS></SQLITE_DISABLE_X64_WARNINGS>

Changes to SQLite.Interop/props/sqlite3.vsprops.

    10     10   <VisualStudioPropertySheet
    11     11   	ProjectType="Visual C++"
    12     12   	Version="8.00"
    13     13   	Name="sqlite3"
    14     14   	>
    15     15   	<UserMacro
    16     16   		Name="SQLITE_MANIFEST_VERSION"
    17         -		Value="3.7.16.1"
           17  +		Value="3.7.16.2"
    18     18   		PerformEnvironmentSet="true"
    19     19   	/>
    20     20   	<UserMacro
    21     21   		Name="SQLITE_RC_VERSION"
    22         -		Value="3,7,16,1"
           22  +		Value="3,7,16,2"
    23     23   		PerformEnvironmentSet="true"
    24     24   	/>
    25     25   	<UserMacro
    26     26   		Name="SQLITE_COMMON_DEFINES"
    27     27   		Value="_CRT_SECURE_NO_DEPRECATE;_CRT_SECURE_NO_WARNINGS;_CRT_NONSTDC_NO_DEPRECATE;_CRT_NONSTDC_NO_WARNINGS;SQLITE_THREADSAFE=1;SQLITE_USE_URI=1;SQLITE_ENABLE_COLUMN_METADATA=1;SQLITE_ENABLE_STAT3=1;SQLITE_ENABLE_FTS3=1;SQLITE_ENABLE_LOAD_EXTENSION=1;SQLITE_ENABLE_RTREE=1;SQLITE_SOUNDEX=1"
    28     28   		PerformEnvironmentSet="true"
    29     29   	/>

Changes to SQLite.Interop/src/core/sqlite3.c.

     1      1   /******************************************************************************
     2      2   ** This file is an amalgamation of many separate C source files from SQLite
     3         -** version 3.7.16.1.  By combining all the individual C code files into this 
            3  +** version 3.7.16.2.  By combining all the individual C code files into this 
     4      4   ** single large file, the entire code can be compiled as a single translation
     5      5   ** unit.  This allows many compilers to do optimizations that would not be
     6      6   ** possible if the files were compiled separately.  Performance improvements
     7      7   ** of 5% or more are commonly seen when SQLite is compiled as a single
     8      8   ** translation unit.
     9      9   **
    10     10   ** This file is all you need to compile SQLite.  To use SQLite in other
................................................................................
   674    674   ** string contains the date and time of the check-in (UTC) and an SHA1
   675    675   ** hash of the entire source tree.
   676    676   **
   677    677   ** See also: [sqlite3_libversion()],
   678    678   ** [sqlite3_libversion_number()], [sqlite3_sourceid()],
   679    679   ** [sqlite_version()] and [sqlite_source_id()].
   680    680   */
   681         -#define SQLITE_VERSION        "3.7.16.1"
          681  +#define SQLITE_VERSION        "3.7.16.2"
   682    682   #define SQLITE_VERSION_NUMBER 3007016
   683         -#define SQLITE_SOURCE_ID      "2013-03-29 13:44:34 527231bc67285f01fb18d4451b28f61da3c4e39d"
          683  +#define SQLITE_SOURCE_ID      "2013-04-12 11:52:43 cbea02d93865ce0e06789db95fd9168ebac970c7"
   684    684   
   685    685   /*
   686    686   ** CAPI3REF: Run-Time Library Version Numbers
   687    687   ** KEYWORDS: sqlite3_version, sqlite3_sourceid
   688    688   **
   689    689   ** These interfaces provide the same information as the [SQLITE_VERSION],
   690    690   ** [SQLITE_VERSION_NUMBER], and [SQLITE_SOURCE_ID] C preprocessor macros
................................................................................
 32788  32788     SimulateIOError( return SQLITE_IOERR_CHECKRESERVEDLOCK; );
 32789  32789   
 32790  32790     assert( id!=0 );
 32791  32791     if( pFile->locktype>=RESERVED_LOCK ){
 32792  32792       rc = 1;
 32793  32793       OSTRACE(("TEST WR-LOCK %d %d (local)\n", pFile->h, rc));
 32794  32794     }else{
 32795         -    rc = winLockFile(&pFile->h, SQLITE_LOCKFILE_FLAGS, RESERVED_BYTE, 0, 1, 0);
        32795  +    rc = winLockFile(&pFile->h, SQLITE_LOCKFILEEX_FLAGS,RESERVED_BYTE, 0, 1, 0);
 32796  32796       if( rc ){
 32797  32797         winUnlockFile(&pFile->h, RESERVED_BYTE, 0, 1, 0);
 32798  32798       }
 32799  32799       rc = !rc;
 32800  32800       OSTRACE(("TEST WR-LOCK %d %d (remote)\n", pFile->h, rc));
 32801  32801     }
 32802  32802     *pResOut = rc;

Changes to SQLite.Interop/src/core/sqlite3.h.

   103    103   ** string contains the date and time of the check-in (UTC) and an SHA1
   104    104   ** hash of the entire source tree.
   105    105   **
   106    106   ** See also: [sqlite3_libversion()],
   107    107   ** [sqlite3_libversion_number()], [sqlite3_sourceid()],
   108    108   ** [sqlite_version()] and [sqlite_source_id()].
   109    109   */
   110         -#define SQLITE_VERSION        "3.7.16.1"
          110  +#define SQLITE_VERSION        "3.7.16.2"
   111    111   #define SQLITE_VERSION_NUMBER 3007016
   112         -#define SQLITE_SOURCE_ID      "2013-03-29 13:44:34 527231bc67285f01fb18d4451b28f61da3c4e39d"
          112  +#define SQLITE_SOURCE_ID      "2013-04-12 11:52:43 cbea02d93865ce0e06789db95fd9168ebac970c7"
   113    113   
   114    114   /*
   115    115   ** CAPI3REF: Run-Time Library Version Numbers
   116    116   ** KEYWORDS: sqlite3_version, sqlite3_sourceid
   117    117   **
   118    118   ** These interfaces provide the same information as the [SQLITE_VERSION],
   119    119   ** [SQLITE_VERSION_NUMBER], and [SQLITE_SOURCE_ID] C preprocessor macros

Changes to Setup/clean.bat.

    71     71         %_AECHO%.
    72     72       )
    73     73     ) ELSE (
    74     74       %_AECHO% Directory "%SOURCE%\%%D" does not exist.
    75     75       %_AECHO%.
    76     76     )
    77     77   )
           78  +
           79  +IF EXIST "%SOURCE%\*.cache" (
           80  +  REM
           81  +  REM NOTE: *WARNING* Deleting from the entire source tree.
           82  +  REM
           83  +  %__ECHO% DEL /S /Q "%SOURCE%\*.cache"
           84  +
           85  +  IF ERRORLEVEL 1 (
           86  +    ECHO Could not delete "%SOURCE%\*.cache".
           87  +    ECHO.
           88  +    GOTO errors
           89  +  ) ELSE (
           90  +    %_AECHO% Deleted "%SOURCE%\*.cache".
           91  +    %_AECHO%.
           92  +  )
           93  +) ELSE (
           94  +  %_AECHO% No files matching "%SOURCE%\*.cache" exist.
           95  +  %_AECHO%.
           96  +)
           97  +
           98  +IF EXIST "%SOURCE%\*.ncb" (
           99  +  REM
          100  +  REM NOTE: *WARNING* Deleting from the entire source tree.
          101  +  REM
          102  +  %__ECHO% DEL /S /Q "%SOURCE%\*.ncb"
          103  +
          104  +  IF ERRORLEVEL 1 (
          105  +    ECHO Could not delete "%SOURCE%\*.ncb".
          106  +    ECHO.
          107  +    GOTO errors
          108  +  ) ELSE (
          109  +    %_AECHO% Deleted "%SOURCE%\*.ncb".
          110  +    %_AECHO%.
          111  +  )
          112  +) ELSE (
          113  +  %_AECHO% No files matching "%SOURCE%\*.ncb" exist.
          114  +  %_AECHO%.
          115  +)
          116  +
          117  +IF EXIST "%SOURCE%\*.psess" (
          118  +  %__ECHO% DEL /Q "%SOURCE%\*.psess"
          119  +
          120  +  IF ERRORLEVEL 1 (
          121  +    ECHO Could not delete "%SOURCE%\*.psess".
          122  +    ECHO.
          123  +    GOTO errors
          124  +  ) ELSE (
          125  +    %_AECHO% Deleted "%SOURCE%\*.psess".
          126  +    %_AECHO%.
          127  +  )
          128  +) ELSE (
          129  +  %_AECHO% No files matching "%SOURCE%\*.psess" exist.
          130  +  %_AECHO%.
          131  +)
          132  +
          133  +IF EXIST "%SOURCE%\*.sdf" (
          134  +  %__ECHO% DEL /Q "%SOURCE%\*.sdf"
          135  +
          136  +  IF ERRORLEVEL 1 (
          137  +    ECHO Could not delete "%SOURCE%\*.sdf".
          138  +    ECHO.
          139  +    GOTO errors
          140  +  ) ELSE (
          141  +    %_AECHO% Deleted "%SOURCE%\*.sdf".
          142  +    %_AECHO%.
          143  +  )
          144  +) ELSE (
          145  +  %_AECHO% No files matching "%SOURCE%\*.sdf" exist.
          146  +  %_AECHO%.
          147  +)
          148  +
          149  +IF EXIST "%SOURCE%\*.suo" (
          150  +  REM
          151  +  REM NOTE: *WARNING* Unhiding in the entire source tree.
          152  +  REM
          153  +  %__ECHO% ATTRIB -H "%SOURCE%\*.suo" /S
          154  +
          155  +  IF ERRORLEVEL 1 (
          156  +    ECHO Could not make "%SOURCE%\*.suo" visible.
          157  +    ECHO.
          158  +    GOTO errors
          159  +  ) ELSE (
          160  +    %_AECHO% Made "%SOURCE%\*.suo" visible.
          161  +    %_AECHO%.
          162  +  )
          163  +
          164  +  REM
          165  +  REM NOTE: *WARNING* Deleting from the entire source tree.
          166  +  REM
          167  +  %__ECHO% DEL /S /Q "%SOURCE%\*.suo"
          168  +
          169  +  IF ERRORLEVEL 1 (
          170  +    ECHO Could not delete "%SOURCE%\*.suo".
          171  +    ECHO.
          172  +    GOTO errors
          173  +  ) ELSE (
          174  +    %_AECHO% Deleted "%SOURCE%\*.suo".
          175  +    %_AECHO%.
          176  +  )
          177  +) ELSE (
          178  +  %_AECHO% No files matching "%SOURCE%\*.suo" exist.
          179  +  %_AECHO%.
          180  +)
          181  +
          182  +IF EXIST "%SOURCE%\*.vsp" (
          183  +  %__ECHO% DEL /Q "%SOURCE%\*.vsp"
          184  +
          185  +  IF ERRORLEVEL 1 (
          186  +    ECHO Could not delete "%SOURCE%\*.vsp".
          187  +    ECHO.
          188  +    GOTO errors
          189  +  ) ELSE (
          190  +    %_AECHO% Deleted "%SOURCE%\*.vsp".
          191  +    %_AECHO%.
          192  +  )
          193  +) ELSE (
          194  +  %_AECHO% No files matching "%SOURCE%\*.vsp" exist.
          195  +  %_AECHO%.
          196  +)
          197  +
          198  +IF EXIST "%SOURCE%\*.vsps" (
          199  +  %__ECHO% DEL /Q "%SOURCE%\*.vsps"
          200  +
          201  +  IF ERRORLEVEL 1 (
          202  +    ECHO Could not delete "%SOURCE%\*.vsps".
          203  +    ECHO.
          204  +    GOTO errors
          205  +  ) ELSE (
          206  +    %_AECHO% Deleted "%SOURCE%\*.vsps".
          207  +    %_AECHO%.
          208  +  )
          209  +) ELSE (
          210  +  %_AECHO% No files matching "%SOURCE%\*.vsps" exist.
          211  +  %_AECHO%.
          212  +)
    78    213   
    79    214   IF EXIST "%SOURCE%\*.nupkg" (
    80    215     %__ECHO% DEL /Q "%SOURCE%\*.nupkg"
    81    216   
    82    217     IF ERRORLEVEL 1 (
    83    218       ECHO Could not delete "%SOURCE%\*.nupkg".
    84    219       ECHO.

Changes to readme.htm.

     2      2   <html>
     3      3   <head>
     4      4   <title></title>
     5      5   </head>
     6      6   <body>
     7      7   ADO.NET SQLite Data Provider<br />
     8      8   Version 1.0.85.0 April XX, 2013 <font color="red">(release scheduled)</font><br />
     9         -Using <a href="http://www.sqlite.org/src/info/527231bc67">SQLite 3.7.16.1</a><br />
            9  +Using <a href="http://www.sqlite.org/releaselog/3_7_16_2.html">SQLite 3.7.16.2</a><br />
    10     10   Originally written by Robert Simpson<br />
    11     11   Released to the public domain, use at your own risk!<br />
    12     12   Official provider website:&nbsp;<a href="http://system.data.sqlite.org/">http://system.data.sqlite.org/</a><br />
    13     13   Legacy versions:&nbsp;<a href="http://sqlite.phxsoftware.com/">http://sqlite.phxsoftware.com/</a><br />
    14     14   <br />
    15     15   The current development version can be downloaded from <a href="http://system.data.sqlite.org/index.html/timeline?y=ci">
    16     16   http://system.data.sqlite.org/index.html/timeline?y=ci</a>
................................................................................
   186    186   
   187    187   <h2><b>Version History</b></h2>
   188    188   
   189    189   <p>
   190    190       <b>1.0.85.0 - April XX, 2013 <font color="red">(release scheduled)</font></b>
   191    191   </p>
   192    192   <ul>
   193         -    <li>Updated to <a href="http://www.sqlite.org/src/info/527231bc67">SQLite 3.7.16.1</a>.</li>
          193  +    <li>Updated to <a href="http://www.sqlite.org/releaselog/3_7_16_2.html">SQLite 3.7.16.2</a>.</li>
   194    194       <li>Properly handle embedded NUL characters in parameter and column values. Fix for [3567020edf].</li>
   195    195       <li>Make use of the sqlite3_prepare_v2 function when applicable.</li>
   196    196       <li>Check for a valid row in the SQLiteDataReader.GetValue method.</li>
   197    197       <li>Implement processor architecture detection when running on the .NET Compact Framework (via P/Invoke).</li>
   198    198       <li>Support automated testing when running on the .NET Compact Framework 2.0.</li>
   199    199       <li>Skip checking loaded assemblies for types tagged with the SQLiteFunction attribute when the No_SQLiteFunctions environment variable is set. Pursuant to [e4c8121f7b].</li>
   200    200       <li>Add HexPassword connection string property to work around the inability to include a literal semicolon in a connection string property value. Pursuant to [1c456ae75f].</li>

Changes to www/news.wiki.

     2      2   
     3      3   <b>Version History</b>
     4      4   
     5      5   <p>
     6      6       <b>1.0.85.0 - April XX, 2013 <font color="red">(release scheduled)</font></b>
     7      7   </p>
     8      8   <ul>
     9         -    <li>Updated to [http://www.sqlite.org/src/info/527231bc67|SQLite 3.7.16.1].</li>
            9  +    <li>Updated to [http://www.sqlite.org/releaselog/3_7_16_2.html|SQLite 3.7.16.2].</li>
    10     10       <li>Properly handle embedded NUL characters in parameter and column values. Fix for [3567020edf].</li>
    11     11       <li>Make use of the sqlite3_prepare_v2 function when applicable.</li>
    12     12       <li>Check for a valid row in the SQLiteDataReader.GetValue method.</li>
    13     13       <li>Implement processor architecture detection when running on the .NET Compact Framework (via P/Invoke).</li>
    14     14       <li>Support automated testing when running on the .NET Compact Framework 2.0.</li>
    15     15       <li>Skip checking loaded assemblies for types tagged with the SQLiteFunction attribute when the No_SQLiteFunctions environment variable is set. Pursuant to [e4c8121f7b].</li>
    16     16       <li>Add HexPassword connection string property to work around the inability to include a literal semicolon in a connection string property value. Pursuant to [1c456ae75f].</li>