Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Improved test coverage for update.c. (CVS 2214) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
3ef95d5fe98e7451f8b87b3f5259163f |
User & Date: | drh 2005-01-15 00:40:43.000 |
Context
2005-01-15
| ||
01:52 | Test coverage improvements. (CVS 2215) (check-in: 92f9d2b2f4 user: drh tags: trunk) | |
00:40 | Improved test coverage for update.c. (CVS 2214) (check-in: 3ef95d5fe9 user: drh tags: trunk) | |
00:36 | Improved coverage for insert.c. (CVS 2213) (check-in: 997d8afff9 user: drh tags: trunk) | |
Changes
Changes to test/update.test.
1 2 3 4 5 6 7 8 9 10 11 12 13 | # 2001 September 15 # # The author disclaims copyright to this source code. In place of # a legal notice, here is a blessing: # # May you do good and not evil. # 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. # | | | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | # 2001 September 15 # # The author disclaims copyright to this source code. In place of # a legal notice, here is a blessing: # # May you do good and not evil. # 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 { |
︙ | ︙ | |||
554 555 556 557 558 559 560 | UPDATE t2 SET rowid=rowid-1; SELECT count(*) FROM t2 WHERE a=rowid+1; } } 16384 integrity_check update-13.6 | > > | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 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 | 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 |