System.Data.SQLite
Check-in [581613b242]
Not logged in

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

Overview
Comment:Update SQLite core library to the 3.8.1 release.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 581613b242ec8602223984d40cbdd661c907c962
User & Date: mistachkin 2013-10-17 21:54:17
Context
2013-10-17
21:58
Update estimated release date for 1.0.89.0. check-in: d801c45c81 user: mistachkin tags: trunk
21:54
Update SQLite core library to the 3.8.1 release. check-in: 581613b242 user: mistachkin tags: trunk
02:57
Minor style fix to new test. check-in: 27a2e59d56 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.89.0 - September 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/trunk">SQLite 3.8.1</a>.</li>
           48  +      <li>Updated to <a href="http://www.sqlite.org/releaselog/3_8_1.html">SQLite 3.8.1</a>.</li>
    49     49         <li>Add AutoCommit property to the SQLiteConnection class. Fix for <a href="http://system.data.sqlite.org/index.html/info/9ba9346f75">[9ba9346f75]</a>.</li>
    50     50         <li>Use declared column sizes for the AnsiStringFixedLength and StringFixedLength mapped database types. Fix for <a href="http://system.data.sqlite.org/index.html/info/3113734605">[3113734605]</a>.</li>
    51     51         <li>Check the result of sqlite3_column_name function against NULL.</li>
    52     52         <li>Return false for the SQLiteParameterCollection.IsSynchronized property because it is not thread-safe.</li>
    53     53         <li>Raise the static SQLiteConnection.Changed event when any SQLiteCommand, SQLiteDataReader, or CriticalHandle derived object instance is created. Fix for <a href="http://system.data.sqlite.org/index.html/info/aba4549801">[aba4549801]</a>.</li>
    54     54         <li>Add SQLiteCommand.Execute, SQLiteCommand.ExecuteNonQuery, and SQLiteCommand.ExecuteScalar method overloads that take a CommandBehavior parameter.</li>
    55     55         <li>Revise how the extra object data is passed to the static SQLiteConnection.Changed event.&nbsp;<b>** Potentially Incompatible Change **</b></li>

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

   133    133   **
   134    134   ** See also: [sqlite3_libversion()],
   135    135   ** [sqlite3_libversion_number()], [sqlite3_sourceid()],
   136    136   ** [sqlite_version()] and [sqlite_source_id()].
   137    137   */
   138    138   #define SQLITE_VERSION        "3.8.1"
   139    139   #define SQLITE_VERSION_NUMBER 3008001
   140         -#define SQLITE_SOURCE_ID      "2013-10-16 09:49:10 2470d1bb08b2661bcfde7a605208eb6044836d5c"
          140  +#define SQLITE_SOURCE_ID      "2013-10-17 12:57:35 c78be6d786c19073b3a6730dfe3fb1be54f5657a"
   141    141   
   142    142   /*
   143    143   ** CAPI3REF: Run-Time Library Version Numbers
   144    144   ** KEYWORDS: sqlite3_version, sqlite3_sourceid
   145    145   **
   146    146   ** These interfaces provide the same information as the [SQLITE_VERSION],
   147    147   ** [SQLITE_VERSION_NUMBER], and [SQLITE_SOURCE_ID] C preprocessor macros
................................................................................
 34036  34036     assert( winShmMutexHeld() );
 34037  34037     OSTRACE(("SHM-PURGE pid=%lu, deleteFlag=%d\n",
 34038  34038              osGetCurrentProcessId(), deleteFlag));
 34039  34039     pp = &winShmNodeList;
 34040  34040     while( (p = *pp)!=0 ){
 34041  34041       if( p->nRef==0 ){
 34042  34042         int i;
 34043         -      if( p->mutex ) sqlite3_mutex_free(p->mutex);
        34043  +      if( p->mutex ){ sqlite3_mutex_free(p->mutex); }
 34044  34044         for(i=0; i<p->nRegion; i++){
 34045  34045           BOOL bRc = osUnmapViewOfFile(p->aRegion[i].pMap);
 34046  34046           OSTRACE(("SHM-PURGE-UNMAP pid=%lu, region=%d, rc=%s\n",
 34047  34047                    osGetCurrentProcessId(), i, bRc ? "ok" : "failed"));
 34048  34048           UNUSED_VARIABLE_VALUE(bRc);
 34049  34049           bRc = osCloseHandle(p->aRegion[i].hMap);
 34050  34050           OSTRACE(("SHM-PURGE-CLOSE pid=%lu, region=%d, rc=%s\n",
................................................................................
 52042  52042   /*
 52043  52043   ** Make sure pBt->pTmpSpace points to an allocation of 
 52044  52044   ** MX_CELL_SIZE(pBt) bytes.
 52045  52045   */
 52046  52046   static void allocateTempSpace(BtShared *pBt){
 52047  52047     if( !pBt->pTmpSpace ){
 52048  52048       pBt->pTmpSpace = sqlite3PageMalloc( pBt->pageSize );
        52049  +
        52050  +    /* One of the uses of pBt->pTmpSpace is to format cells before
        52051  +    ** inserting them into a leaf page (function fillInCell()). If
        52052  +    ** a cell is less than 4 bytes in size, it is rounded up to 4 bytes
        52053  +    ** by the various routines that manipulate binary cells. Which
        52054  +    ** can mean that fillInCell() only initializes the first 2 or 3
        52055  +    ** bytes of pTmpSpace, but that the first 4 bytes are copied from
        52056  +    ** it into a database page. This is not actually a problem, but it
        52057  +    ** does cause a valgrind error when the 1 or 2 bytes of unitialized 
        52058  +    ** data is passed to system call write(). So to avoid this error,
        52059  +    ** zero the first 4 bytes of temp space here.  */
        52060  +    if( pBt->pTmpSpace ) memset(pBt->pTmpSpace, 0, 4);
 52049  52061     }
 52050  52062   }
 52051  52063   
 52052  52064   /*
 52053  52065   ** Free the pBt->pTmpSpace allocation
 52054  52066   */
 52055  52067   static void freeTempSpace(BtShared *pBt){
................................................................................
 75424  75436                 sqlite3ErrorMsg(pParse, "second argument to likelihood() must be a "
 75425  75437                                         "constant between 0.0 and 1.0");
 75426  75438                 pNC->nErr++;
 75427  75439               }
 75428  75440             }else{
 75429  75441               /* EVIDENCE-OF: R-61304-29449 The unlikely(X) function is equivalent to
 75430  75442               ** likelihood(X, 0.0625).
 75431         -            ** EVIDENCE-OF: R-35738-39582 The unlikely(X) fucntion is short-hand for
        75443  +            ** EVIDENCE-OF: R-01283-11636 The unlikely(X) function is short-hand for
 75432  75444               ** likelihood(X,0.0625). */
 75433  75445               pExpr->iTable = 62;  /* TUNING:  Default 2nd arg to unlikely() is 0.0625 */
 75434  75446             }             
 75435  75447           }
 75436  75448         }
 75437  75449   #ifndef SQLITE_OMIT_AUTHORIZATION
 75438  75450         if( pDef ){

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

   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    110   #define SQLITE_VERSION        "3.8.1"
   111    111   #define SQLITE_VERSION_NUMBER 3008001
   112         -#define SQLITE_SOURCE_ID      "2013-10-16 09:49:10 2470d1bb08b2661bcfde7a605208eb6044836d5c"
          112  +#define SQLITE_SOURCE_ID      "2013-10-17 12:57:35 c78be6d786c19073b3a6730dfe3fb1be54f5657a"
   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 readme.htm.

   186    186   
   187    187   <h2><b>Version History</b></h2>
   188    188   
   189    189   <p>
   190    190       <b>1.0.89.0 - September 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/trunk">SQLite 3.8.1</a>.</li>
          193  +    <li>Updated to <a href="http://www.sqlite.org/releaselog/3_8_1.html">SQLite 3.8.1</a>.</li>
   194    194       <li>Add AutoCommit property to the SQLiteConnection class. Fix for [9ba9346f75].</li>
   195    195       <li>Use declared column sizes for the AnsiStringFixedLength and StringFixedLength mapped database types. Fix for [3113734605].</li>
   196    196       <li>Check the result of sqlite3_column_name function against NULL.</li>
   197    197       <li>Return false for the SQLiteParameterCollection.IsSynchronized property because it is not thread-safe.</li>
   198    198       <li>Raise the static SQLiteConnection.Changed event when any SQLiteCommand, SQLiteDataReader, or CriticalHandle derived object instance is created. Fix for [aba4549801].</li>
   199    199       <li>Add SQLiteCommand.Execute, SQLiteCommand.ExecuteNonQuery, and SQLiteCommand.ExecuteScalar method overloads that take a CommandBehavior parameter.</li>
   200    200       <li>Revise how the extra object data is passed to the static SQLiteConnection.Changed event.&nbsp;<b>** Potentially Incompatible Change **</b></li>

Changes to www/news.wiki.

     2      2   
     3      3   <b>Version History</b>
     4      4   
     5      5   <p>
     6      6       <b>1.0.89.0 - September 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/trunk|SQLite 3.8.1].</li>
            9  +    <li>Updated to [http://www.sqlite.org/releaselog/3_8_1.html|SQLite 3.8.1].</li>
    10     10       <li>Add AutoCommit property to the SQLiteConnection class. Fix for [9ba9346f75].</li>
    11     11       <li>Use declared column sizes for the AnsiStringFixedLength and StringFixedLength mapped database types. Fix for [3113734605].</li>
    12     12       <li>Check the result of sqlite3_column_name function against NULL.</li>
    13     13       <li>Return false for the SQLiteParameterCollection.IsSynchronized property because it is not thread-safe.</li>
    14     14       <li>Raise the static SQLiteConnection.Changed event when any SQLiteCommand, SQLiteDataReader, or CriticalHandle derived object instance is created. Fix for [aba4549801].</li>
    15     15       <li>Add SQLiteCommand.Execute, SQLiteCommand.ExecuteNonQuery, and SQLiteCommand.ExecuteScalar method overloads that take a CommandBehavior parameter.</li>
    16     16       <li>Revise how the extra object data is passed to the static SQLiteConnection.Changed event.&nbsp;<b>** Potentially Incompatible Change **</b></li>