/ Check-in [a4e3e075]
Login

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

Overview
Comment:Change the CVSTrac website to www.sqlite.org. Update change summary for the 2.8.6 release. (CVS 1079)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: a4e3e075e3b36e0f5f692067c5bf5e1b660d893d
User & Date: drh 2003-08-22 02:34:30
Context
2003-08-22
03:00
Version 2.8.6 (CVS 1080) check-in: 0bde7ae2 user: drh tags: trunk
02:34
Change the CVSTrac website to www.sqlite.org. Update change summary for the 2.8.6 release. (CVS 1079) check-in: a4e3e075 user: drh tags: trunk
2003-08-21
14:36
Update the -version-info number on libtool in Makefile.in. (CVS 1078) check-in: dc36365e user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to www/changes.tcl.

     8      8   <body bgcolor="white">
     9      9   <h1 align="center">Recent Changes To SQLite</h1>
    10     10   
    11     11   <p>
    12     12   This file provides a high-level summary of changes to SQLite.
    13     13   For more detail, refer the the checkin logs generated by
    14     14   CVS at
    15         -<a href="http://cvs.hwaci.com/sqlite/timeline">
    16         -http://cvs.hwaci.com/sqlite/timeline</a>.
           15  +<a href="http://www.sqlite.org/cvstrac/timeline">
           16  +http:/www.sqlite.org/cvstrac/timeline</a>.
    17     17   </p>
    18     18   
    19     19   <DL>
    20     20   }
    21     21   
    22     22   
    23     23   proc chng {date desc} {
    24     24     puts "<DT><B>$date</B></DT>"
    25     25     puts "<DD><P><UL>$desc</UL></P></DD>"
    26     26   }
           27  +
           28  +chng {2003 August 21 (2.8.6)} {
           29  +<li>Moved the CVS repository to www.sqlite.org</li>
           30  +<li>Update the NULL-handling documentation.</li>
           31  +<li>Experimental date/time functions added.</li>
           32  +<li>Bug fix: correctly evaluate a view of a view without segfaulting.</li>
           33  +<li>Bug fix: prevent database corruption if you dropped a
           34  +    trigger that had the same name as a table.</li>
           35  +<li>Bug fix: allow a VACUUM (without segfaulting) on an empty
           36  +    database after setting the EMPTY_RESULT_CALLBACKS pragma.</li>
           37  +<li>Bug fix: if an integer value will not fit in a 32-bit int, store it in
           38  +    a double instead.</li>
           39  +<li>Bug fix: Make sure the journal file directory entry is committed to disk
           40  +    before writing the database file.</li>
           41  +}
    27     42   
    28     43   chng {2003 July 22 (2.8.5)} {
    29     44   <li>Make LIMIT work on a compound SELECT statement.</li>
    30     45   <li>LIMIT 0 now shows no rows.  Use LIMIT -1 to see all rows.</li>
    31     46   <li>Correctly handle comparisons between an INTEGER PRIMARY KEY and
    32     47       a floating point number.</li>
    33     48   <li>Fix several important bugs in the new ATTACH and DETACH commands.</li>

Changes to www/index.tcl.

     1      1   #
     2      2   # Run this TCL script to generate HTML for the index.html file.
     3      3   #
     4         -set rcsid {$Id: index.tcl,v 1.77 2003/07/22 12:44:54 drh Exp $}
            4  +set rcsid {$Id: index.tcl,v 1.78 2003/08/22 02:34:30 drh Exp $}
     5      5   
     6      6   puts {<html>
     7      7   <head><title>SQLite: An Embeddable SQL Database Engine</title></head>
     8      8   <body bgcolor=white>
     9      9   <h1 align=center>SQLite<br>An Embeddable SQL Database Engine</h1>
    10     10   <p align=center>}
    11     11   puts "This page was last modified on [lrange $rcsid 3 4] UTC<br>"
................................................................................
    32     32   puts {
    33     33   <table align="right" hspace="10" cellpadding=0 cellspacing=0 broder=0>
    34     34   <tr><td align="right" bgcolor="#cacae4">
    35     35   <table border="2" width="100%" cellspacing=0 cellpadding=5><tr><td align="left">
    36     36   Quick Links:
    37     37   <ul>
    38     38   <li><a href="download.html">Download</a></li>
    39         -<li><a href="http://cvs.hwaci.com/sqlite/timeline">Change Log</a></li>
    40         -<li><a href="http://cvs.hwaci.com/sqlite/tktnew">Report a bug</a></li>
           39  +<li><a href="http://www.sqlite.org/cvstrac/timeline">Change Log</a></li>
           40  +<li><a href="http://www.sqlite.org/cvstrac/tktnew">Report a bug</a></li>
    41     41   <li><a href="quickstart.html">Quick start</a></li>
    42     42   </ul>
    43     43   </td></tr></table>
    44     44   </td></tr>
    45     45   </table>
    46     46   }
    47     47   
................................................................................
    60     60   <li><a href="speed.html">Two times faster</a> than PostgreSQL and
    61     61       MySQL for many common operations.</li>
    62     62   <li>Very simple 
    63     63   <a href="c_interface.html">C/C++ interface</a> requires the use of only
    64     64   three functions and one opaque structure.</li>
    65     65   <li><a href="tclsqlite.html">TCL bindings</a> included.
    66     66       Bindings for many other languages 
    67         -    <a href="http://cvs.hwaci.com/sqlite/wiki?p=SqliteWrappers">
           67  +    <a href="http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers">
    68     68       available separately.</a></li>
    69     69   <li>Simple, well-commented source code.</li>
    70     70   <li>Automated test suite provides near 100% code coverage.</li>
    71     71   <li>Self-contained: no external dependencies.</li>
    72     72   <li>Built and tested under Linux and Windows.</li>
    73     73   <li>Sources are in the public domain.  Use for any purpose.</li>
    74     74   </ul>
................................................................................
    75     75   </p>
    76     76   }
    77     77   
    78     78   puts {<h2>Current Status</h2>
    79     79   
    80     80   <p>A <a href="changes.html">Change Summary</a> is available on this
    81     81   website.  You can also access a detailed
    82         -<a href="http://cvs.hwaci.com/sqlite/timeline">change history</a>,
    83         -<a href="http://cvs.hwaci.com/sqlite/rptview?rn=2">view open bugs</a>,
           82  +<a href="http://www.sqlite.org/cvstrac/timeline">change history</a>,
           83  +<a href="http://www.sqlite.org/cvstrac/rptview?rn=2">view open bugs</a>,
    84     84   or
    85         -<a href="http://cvs.hwaci.com/sqlite/tktnew">report new bugs</a>
           85  +<a href="http://www.sqlite.org/cvstrac/tktnew">report new bugs</a>
    86     86   at the
    87         -<a href="http://cvs.hwaci.com/sqlite/">CVS server</a>.</p>
           87  +<a href="http://www.sqlite.org/cvstrac/">CVS server</a>.</p>
    88     88   
    89     89   <p>Complete source code and precompiled binaries for the latest release are
    90     90   <a href="download.html">available for download</a> on this site.  You
    91     91   can also obtain the latest changes by anonymous CVS access:
    92     92   <blockquote><pre>
    93     93   cvs -d :pserver:anonymous@cvs.hwaci.com:/home/cvs/sqlite login
    94     94   cvs -d :pserver:anonymous@cvs.hwaci.com:/home/cvs/sqlite checkout sqlite
................................................................................
   134    134   <li>A description of the <a href="opcode.html">virtual machine</a> that
   135    135       SQLite uses to access the database.</li>
   136    136   <li>A description of the 
   137    137       <a href="fileformat.html">database file format</a> used by SQLite.
   138    138   <li>A <a href="speed.html">speed comparison</a> between SQLite, PostgreSQL,
   139    139       and MySQL.</li>
   140    140   <li>User-written documentation is available on the
   141         -    <a href="http://cvs.hwaci.com/sqlite/wiki">SQLite Wiki</a>.  Please
          141  +    <a href="http://www.sqlite.org/cvstrac/wiki">SQLite Wiki</a>.  Please
   142    142       contribute if you can.</li>
   143    143   </ul>
   144    144   </p>
   145    145   
   146    146   <p>The SQLite source code is 30% comment.  These comments are
   147    147   another important source of information.  </p>
   148    148   
................................................................................
   210    210   <p>
   211    211   For information bindings of SQLite to other programming languages
   212    212   (Perl, Python, Ruby, PHP, etc.) and for a list of programs currently
   213    213   using SQLite, visit the Wiki documentation at:
   214    214   </p>
   215    215   
   216    216   <blockquote>
   217         -<a href="http://cvs.hwaci.com/sqlite/wiki">
   218         -http://cvs.hwaci.com/sqlite/wiki</a>
          217  +<a href="http://www.sqlite.org/cvstrac/wiki">
          218  +http://www.sqlite.org/cvstrac/wiki</a>
   219    219   </blockquote>
   220    220   }
   221    221   
   222    222   puts {
   223    223   </body></html>}

Changes to www/omitted.tcl.

     1      1   #
     2      2   # Run this script to generated a omitted.html output file
     3      3   #
     4         -set rcsid {$Id: omitted.tcl,v 1.4 2003/06/30 10:36:23 drh Exp $}
            4  +set rcsid {$Id: omitted.tcl,v 1.5 2003/08/22 02:34:30 drh Exp $}
     5      5   
     6      6   puts {<html>
     7      7   <head>
     8      8     <title>SQL Features That SQLite Does Not Implement</title>
     9      9   </head>
    10     10   <body bgcolor="white">
    11     11   <h1 align="center">
................................................................................
    97     97   
    98     98   puts {
    99     99   </table>
   100    100   
   101    101   <p>
   102    102   If you find other SQL92 features that SQLite does not support, please
   103    103   add them to the Wiki page at 
   104         -<a href="http://cvs.hwaci.com/sqlite/wiki?p=UnsupportedSql">
   105         -http://cvs.hwaci.com/sqlite/wiki?p=Unsupported</a>
          104  +<a href="http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql">
          105  +http://www.sqlite.org/cvstrac/wiki?p=Unsupported</a>
   106    106   </p>
   107    107   <p><hr /></p>
   108    108   <p><a href="index.html"><img src="/goback.jpg" border=0 />
   109    109   Back to the SQLite Home Page</a>
   110    110   </p>
   111    111   
   112    112   </body></html>}