Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Improved test coverage for update.c. (CVS 2214) |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
3ef95d5fe98e7451f8b87b3f5259163f |
User & Date: | drh 2005-01-15 00:40:43 |
Context
2005-01-15
| ||
01:52 | Test coverage improvements. (CVS 2215) check-in: 92f9d2b2 user: drh tags: trunk | |
00:40 | Improved test coverage for update.c. (CVS 2214) check-in: 3ef95d5f user: drh tags: trunk | |
00:36 | Improved coverage for insert.c. (CVS 2213) check-in: 997d8aff user: drh tags: trunk | |
Changes
Changes to test/update.test.
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
554
555
556
557
558
559
560
561
562
|
# May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The # focus of this file is testing the UPDATE statement. # # $Id: update.test,v 1.15 2004/02/10 13:41:53 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Try to update an non-existent table # do_test update-1.1 { ................................................................................ UPDATE t2 SET rowid=rowid-1; SELECT count(*) FROM t2 WHERE a=rowid+1; } } 16384 integrity_check update-13.6 finish_test |
|
>
>
|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
|
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
|
# May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The # focus of this file is testing the UPDATE statement. # # $Id: update.test,v 1.16 2005/01/15 00:40:43 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Try to update an non-existent table # do_test update-1.1 { ................................................................................ UPDATE t2 SET rowid=rowid-1; SELECT count(*) FROM t2 WHERE a=rowid+1; } } 16384 integrity_check update-13.6 ifcapable {trigger} { # Test for proper detection of malformed WHEN clauses on UPDATE triggers. # do_test update-14.1 { execsql { CREATE TABLE t3(a,b,c); CREATE TRIGGER t3r1 BEFORE UPDATE on t3 WHEN nosuchcol BEGIN SELECT 'illegal WHEN clause'; END; } } {} do_test update-14.2 { catchsql { UPDATE t3 SET a=1; } } {1 {no such column: nosuchcol}} do_test update-14.3 { execsql { CREATE TABLE t4(a,b,c); CREATE TRIGGER t4r1 AFTER UPDATE on t4 WHEN nosuchcol BEGIN SELECT 'illegal WHEN clause'; END; } } {} do_test update-14.4 { catchsql { UPDATE t4 SET a=1; } } {1 {no such column: nosuchcol}} } ;# ifcapable {trigger} finish_test |