/ Check-in [2a89fb3c]
Login

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

Overview
Comment:Bug fix in the newly revised sqllimit1.test script. (CVS 4908)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:2a89fb3c3e991b2c02e07b8b86b67b8d80e0360d
User & Date: drh 2008-03-22 23:59:58
Context
2008-03-23
00:20
Remove redundant tests from the reparenter in the btree module. (CVS 4909) check-in: a807e718 user: drh tags: trunk
2008-03-22
23:59
Bug fix in the newly revised sqllimit1.test script. (CVS 4908) check-in: 2a89fb3c user: drh tags: trunk
01:08
Add the speed1p.test script. Like speed1.test except that it tries to take advantage of prepared statements. (CVS 4907) check-in: ece4fb9f user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/sqllimits1.test.

     8      8   #    May you share freely, never taking more than you give.
     9      9   #
    10     10   #***********************************************************************
    11     11   #
    12     12   # This file contains tests to verify that the limits defined in
    13     13   # sqlite source file limits.h are enforced.
    14     14   #
    15         -# $Id: sqllimits1.test,v 1.26 2008/03/20 18:00:49 drh Exp $
           15  +# $Id: sqllimits1.test,v 1.27 2008/03/22 23:59:58 drh Exp $
    16     16   
    17     17   set testdir [file dirname $argv0]
    18     18   source $testdir/tester.tcl
    19     19   
    20     20   # Verify that the default per-connection limits are the same as
    21     21   # the compile-time hard limits.
    22     22   #
................................................................................
   284    284   
   285    285   do_test sqllimits1-5.13 {
   286    286     set ::str1 [string repeat ' [expr {$SQLITE_LIMIT_LENGTH - 10}]]
   287    287     catchsql { SELECT hex($::str1) }
   288    288   } {1 {string or blob too big}}
   289    289   
   290    290   do_test sqllimits1-5.14.1 {
   291         -  set ::STMT [sqlite3_prepare $::DB "SELECT ?" -1 TAIL]
          291  +  set ::STMT [sqlite3_prepare db "SELECT ?" -1 TAIL]
   292    292     sqlite3_bind_zeroblob $::STMT 1 [expr {$SQLITE_LIMIT_LENGTH + 1}]
   293    293   } {}
   294    294   do_test sqllimits1-5.14.2 {
   295    295     sqlite3_step $::STMT 
   296    296   } {SQLITE_ERROR}
   297    297   do_test sqllimits1-5.14.3 {
   298    298     sqlite3_finalize $::STMT 
................................................................................
   359    359     set tail " /* A comment to take up space in order to make the string\
   360    360                   longer without increasing the expression depth */\
   361    361                   AND   1  ==  1"
   362    362     set N [expr {(50000 / [string length $tail])+1}]
   363    363     append sql [string repeat $tail $N]
   364    364     set nbytes [string length $sql]
   365    365     append sql { AND 0}
   366         -  set rc [catch {sqlite3_prepare $DB $sql $nbytes TAIL} STMT]
          366  +  set rc [catch {sqlite3_prepare db $sql $nbytes TAIL} STMT]
   367    367     lappend rc $STMT
   368    368   } {1 {(18) statement too long}}
   369    369   do_test sqllimits1-6.4 {
   370         -  sqlite3_errmsg $DB
          370  +  sqlite3_errmsg db
   371    371   } {statement too long}
   372    372   
   373    373   #--------------------------------------------------------------------
   374    374   # Test cases sqllimits1-7.* test that the limit set using the
   375    375   # max_page_count pragma.
   376    376   #
   377    377   do_test sqllimits1-7.1 {