/ Check-in [c2af7d2c]
Login

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

Overview
Comment:Fix a datatype in trigger6.test that changed due to the previous check-in. (CVS 2454)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: c2af7d2c947bcec507087cc3a1e5b21e6322e4cd
User & Date: drh 2005-05-05 11:04:50
Context
2005-05-05
18:14
Patch to fix an alignment problem on sparc. Ticket #1234. (CVS 2455) check-in: 240cce10 user: drh tags: trunk
11:04
Fix a datatype in trigger6.test that changed due to the previous check-in. (CVS 2454) check-in: c2af7d2c user: drh tags: trunk
10:30
In the TCL interface, user-defined functions preserve the datatype returned by the Tcl procedure. (CVS 2453) check-in: 99dcba1f user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/trigger6.test.

    13     13   # This file implements tests to make sure expression of an INSERT
    14     14   # and UPDATE statement are only evaluated once.  See ticket #980.
    15     15   # If an expression uses a function that has side-effects or which
    16     16   # is not deterministic (ex: random()) then we want to make sure
    17     17   # that the same evaluation occurs for the actual INSERT/UPDATE and
    18     18   # for the NEW.* fields of any triggers that fire.
    19     19   #
    20         -# $Id: trigger6.test,v 1.1 2004/12/07 15:41:50 drh Exp $
           20  +# $Id: trigger6.test,v 1.2 2005/05/05 11:04:50 drh Exp $
    21     21   
    22     22   set testdir [file dirname $argv0]
    23     23   source $testdir/tester.tcl
    24     24   ifcapable {!trigger} {
    25     25     finish_test
    26     26     return
    27     27   }
................................................................................
    56     56   do_test trigger6-1.3 {
    57     57     execsql {
    58     58       DELETE FROM t1;
    59     59       DELETE FROM log;
    60     60       INSERT INTO t1 VALUES(2,counter(2,3)+4);
    61     61       SELECT * FROM t1;
    62     62     }
    63         -} {2 6.0}
           63  +} {2 6}
    64     64   do_test trigger6-1.4 {
    65     65     execsql {
    66     66       SELECT * FROM log;
    67     67     }
    68         -} {1 2 6.0}
           68  +} {1 2 6}
    69     69   do_test trigger6-1.5 {
    70     70     execsql {
    71     71       DELETE FROM log;
    72     72       UPDATE t1 SET y=counter(5);
    73     73       SELECT * FROM t1;
    74     74     }
    75     75   } {2 3}