Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add more test cases to prove that ticket #2920 does not exist in CVS HEAD. The problem was previously fixed by the changes to ticket #2686. Ticket #2920 is a duplicate of #2686. (CVS 4772) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
b3259e872124fd7e17bbc23e582aa4d8 |
User & Date: | drh 2008-02-02 02:48:52.000 |
Context
2008-02-02
| ||
04:47 | When OMIT_TRIGGER is defined, provide a no-op macro for sqlite3SelectMask(). Fix for #2918. (CVS 4773) (check-in: 1d478e9091 user: danielk1977 tags: trunk) | |
02:48 | Add more test cases to prove that ticket #2920 does not exist in CVS HEAD. The problem was previously fixed by the changes to ticket #2686. Ticket #2920 is a duplicate of #2686. (CVS 4772) (check-in: b3259e8721 user: drh tags: trunk) | |
2008-02-01
| ||
19:44 | Use the buffer size as limit for temp file names. This is done for windows too, see check-in (4595). (CVS 4771) (check-in: 99275bcd62 user: pweilbacher tags: trunk) | |
Changes
Changes to test/tkt2686.test.
1 2 3 4 5 6 7 8 9 10 11 12 13 | # 2007 Oct 3 # # 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 is to test that ticket #2686 has been fixed. # | | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 | # 2007 Oct 3 # # 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 is to test that ticket #2686 has been fixed. # # $Id: tkt2686.test,v 1.3 2008/02/02 02:48:52 drh Exp $ # set testdir [file dirname $argv0] source $testdir/tester.tcl ifcapable !subquery { finish_test return } db eval { PRAGMA page_size=1024; PRAGMA max_page_count=50; PRAGMA auto_vacuum=0; CREATE TABLE filler (fill); } for {set i 1} {$i<2000} {incr i} { do_test tkt2686-$i.1 { db eval BEGIN set rc [catch { while 1 { db eval {INSERT INTO filler (fill) VALUES (randstr(1000, 10000)) } } } msg] lappend rc $msg } {1 {database or disk is full}} do_test tkt2686-$i.2 { execsql { DELETE FROM filler WHERE rowid <= (SELECT MAX(rowid) FROM filler LIMIT 20) } } {} integrity_check tkt2686-$i.3 catch {db eval COMMIT} } db close file delete -force test.db test.db-journal sqlite3 db test.db db eval { PRAGMA page_size=1024; PRAGMA max_page_count=50; PRAGMA auto_vacuum=1; CREATE TABLE filler (fill); } for {set i 10000} {$i<12000} {incr i} { do_test tkt2686-$i.1 { db eval BEGIN set rc [catch { while 1 { db eval {INSERT INTO filler (fill) VALUES (randstr(1000, 10000)) } } } msg] lappend rc $msg } {1 {database or disk is full}} do_test tkt2686-$i.2 { |
︙ | ︙ |
Added test/tkt2920.test.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 | # 2008 Feb 1 # # 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 is to test that ticket #2920 is fixed. # # $Id: tkt2920.test,v 1.1 2008/02/02 02:48:52 drh Exp $ # set testdir [file dirname $argv0] source $testdir/tester.tcl # Create a database file that is full. # do_test tkt2920-1.1 { db eval { PRAGMA page_size=1024; PRAGMA max_page_count=40; PRAGMA auto_vacuum=0; CREATE TABLE filler (fill); } file size test.db } {2048} do_test tkt2920-1.2 { db eval BEGIN for {set i 0} {$i<34} {incr i} { db eval {INSERT INTO filler VALUES(randomblob(1024))} } db eval COMMIT } {} # Try to add a single new page to the full database. We get # a disk full error. But this does not corrupt the database. # do_test tkt2920-1.3 { db eval BEGIN catchsql { INSERT INTO filler VALUES(randomblob(1024)) } } {1 {database or disk is full}} integrity_check tkt2920-1.4 # Increase the maximum size of the database file by 1 page, # but then try to add a two-page record. This also fails. # do_test tkt2920-1.5 { db eval {PRAGMA max_page_count=41} catchsql { INSERT INTO filler VALUES(randomblob(2048)) } } {1 {database or disk is full}} integrity_check tkt2920-1.6 # Increase the maximum size of the database by one more page. # This time the insert works. # do_test tkt2920-1.7 { db eval {PRAGMA max_page_count=42} catchsql { INSERT INTO filler VALUES(randomblob(2048)) } } {0 {}} integrity_check tkt2920-1.8 # The previous errors cancelled the transaction. # do_test tkt2920-1.9 { catchsql {COMMIT} } {1 {cannot commit - no transaction is active}} finish_test |