/ Check-in [cdab6dad]
Login

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

Overview
Comment:Add tests to prevent a recurrance of bug #16. Also: put a hyperlink to the new ticket screen on the main page of the website. (CVS 527)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:cdab6dad323dd1e95ec8b7684a7c4b06c75905e0
User & Date: drh 2002-04-12 13:11:53
Context
2002-04-12
13:12
Version 2.4.7 (CVS 528) check-in: 977abbae user: drh tags: trunk
13:11
Add tests to prevent a recurrance of bug #16. Also: put a hyperlink to the new ticket screen on the main page of the website. (CVS 527) check-in: cdab6dad user: drh tags: trunk
10:08
Fix for bug #15: Add the sqlite_changes() API function for retrieving the number of rows that changed in the previous operation. (CVS 526) check-in: 6e71493b user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/insert.test.

     7      7   #    May you find forgiveness for yourself and forgive others.
     8      8   #    May you share freely, never taking more than you give.
     9      9   #
    10     10   #***********************************************************************
    11     11   # This file implements regression tests for SQLite library.  The
    12     12   # focus of this file is testing the INSERT statement.
    13     13   #
    14         -# $Id: insert.test,v 1.9 2002/02/19 13:39:23 drh Exp $
           14  +# $Id: insert.test,v 1.10 2002/04/12 13:11:53 drh Exp $
    15     15   
    16     16   set testdir [file dirname $argv0]
    17     17   source $testdir/tester.tcl
    18     18   
    19     19   # Try to insert into a non-existant table.
    20     20   #
    21     21   do_test insert-1.1 {
................................................................................
   158    158   } {22 -4.44 hi abc-123 wham}
   159    159   do_test insert-3.5 {
   160    160     set x [execsql {PRAGMA integrity_check}]
   161    161     if {$x==""} {set x ok}
   162    162     set x
   163    163   } {ok}
   164    164   
          165  +# Test of expressions in the VALUES clause
          166  +#
   165    167   do_test insert-4.1 {
   166    168     execsql {
   167    169       CREATE TABLE t3(a,b,c);
   168    170       INSERT INTO t3 VALUES(1+2+3,4,5);
   169    171       SELECT * FROM t3;
   170    172     }
   171    173   } {6 4 5}
................................................................................
   188    190     }
   189    191   } {{} 6 7 6 4 5 7 5 6}
   190    192   do_test insert-4.5 {
   191    193     execsql {
   192    194       SELECT b,c FROM t3 WHERE a IS NULL;
   193    195     }
   194    196   } {6 7}
          197  +do_test insert-4.6 {
          198  +  catchsql {
          199  +    INSERT INTO t3 VALUES(notafunc(2,3),2,3);
          200  +  }
          201  +} {1 {no such function: notafunc}}
          202  +do_test insert-4.7 {
          203  +  execsql {
          204  +    INSERT INTO t3 VALUES(min(1,2,3),max(1,2,3),99);
          205  +    SELECT * FROM t3 WHERE c=99;
          206  +  }
          207  +} {1 3 99}
          208  +
          209  +# Test
   195    210   
   196    211   finish_test

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.58 2002/04/03 20:50:21 drh Exp $}
            4  +set rcsid {$Id: index.tcl,v 1.59 2002/04/12 13:11:53 drh Exp $}
     5      5   
     6      6   puts {<html>
     7      7   <head><title>SQLite: An SQL Database Engine In A C Library</title></head>
     8      8   <body bgcolor=white>
     9      9   <h1 align=center>SQLite: An SQL Database Engine In A C Library</h1>
    10     10   <p align=center>}
    11     11   puts "This page was last modified on [lrange $rcsid 3 4] UTC<br>"
................................................................................
    25     25   an example of how to use the SQLite library.</p>
    26     26   
    27     27   <p>SQLite is <b>not</b> a client library used to connect to a
    28     28   big database server.  SQLite <b>is</b> the server.  The SQLite
    29     29   library reads and writes directly to and from the database files
    30     30   on disk.</p>}
    31     31   
    32         -puts {<table align="right"hspace="10">
    33         -<tr><td align="center" bgcolor="#8ee5ee">
    34         -<table border="2"><tr><td align="center">
    35         -<a href="download.html"><big><b>Download<br>SQLite
           32  +puts {
           33  +<table align="right" hspace="10" cellpadding=0 cellspacing=0 broder=0>
           34  +<tr><td align="right" bgcolor="#cacae4">
           35  +<table border="2" width="100%" cellspacing=0 cellpadding=5><tr><td align="left">
           36  +Quick Links:
           37  +<ul>
           38  +<li><a href="download.html">Download</a></li>
           39  +<li><a href="http://cvs.hwaci.com:2080/sqlite/timeline">Change Log</a></li>
           40  +<li><a href="http://cvs.hwaci.com:2080/sqlite/tktnew">Report a bug</a></li>
           41  +</ul>
    36     42   </td></tr></table>
    37     43   </td></tr>
    38         -</table>}
           44  +</table>
           45  +}
    39     46   
    40     47   puts {<h2>Features</h2>
    41     48   
    42     49   <p><ul>
    43     50   <li>Implements a large subset of SQL92.</li>
    44     51   <li>A complete database (with multiple tables and indices) is
    45     52       stored in a single disk file.</li>
................................................................................
    59     66   </p>
    60     67   }
    61     68   
    62     69   puts {<h2>Current Status</h2>
    63     70   
    64     71   <p>A <a href="changes.html">Change Summary</a> is available on this
    65     72   website.  You can also access a detailed
    66         -<a href="http://cvs.hwaci.com:2080/sqlite/timeline">change history</a>
    67         -and a list of
    68         -<a href="http://cvs.hwaci.com:2080/sqlite/rptview?rn=2">open bugs</a> 
    69         -from the 
           73  +<a href="http://cvs.hwaci.com:2080/sqlite/timeline">change history</a>,
           74  +<a href="http://cvs.hwaci.com:2080/sqlite/rptview?rn=2">view open bugs</a>,
           75  +or
           76  +<a href="http://cvs.hwaci.com:2080/sqlite/tktnew">report new bugs</a>
           77  +at the
    70     78   <a href="http://cvs.hwaci.com:2080/sqlite/">CVS server</a>.</p>
    71     79   
    72     80   <p>Complete source code and precompiled binaries for the latest release are
    73     81   <a href="download.html">available for download</a> on this site.  You
    74     82   can also obtain the latest changes by anonymous CVS access:
    75     83   <blockquote><pre>
    76     84   cvs -d :pserver:anonymous@cvs.hwaci.com:/home/cvs/sqlite login