/ Check-in [acf5d87f]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
Comment:Fix sqlilimits.test module so that it knows that the SELECT in a CREATE VIEW is not checked until the view is actually used.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: acf5d87f9456a1d0d69fe0ebc753211e1be07eaf
User & Date: drh 2015-09-18 15:13:29
Context
2015-09-18
15:35
Adjust two test cases so that they conform to the current code. check-in: 228e3d7c user: drh tags: trunk
15:13
Fix sqlilimits.test module so that it knows that the SELECT in a CREATE VIEW is not checked until the view is actually used. check-in: acf5d87f user: drh tags: trunk
14:45
Ensure that "PRAGMA integrity_check" reports an error if the free-list count header field contains a value smaller than the actual number of pages on the database free-list. check-in: 26f64986 user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/sqllimits1.test.

   639    639   
   640    640   do_test sqllimits1-8.8 {
   641    641     # Columns in a view definition:
   642    642     set cols [list]
   643    643     for {set i 0} {$i <= $SQLITE_LIMIT_COLUMN} {incr i} {
   644    644       lappend cols "c$i"
   645    645     }
   646         -  catchsql "CREATE VIEW v1 AS SELECT [join $cols ,] FROM t1;"
          646  +  execsql "CREATE VIEW v1 AS SELECT [join $cols ,] FROM t1;"
          647  +  catchsql {SELECT * FROM v1}
   647    648   } {1 {too many columns in result set}}
   648    649   
   649    650   do_test sqllimits1-8.9 {
   650    651     # Columns in a view definition (testing * expansion):
   651    652     set cols [list]
   652    653     for {set i 0} {$i < $SQLITE_LIMIT_COLUMN} {incr i} {
   653    654       lappend cols "c$i"
   654    655     }
          656  +  execsql {DROP VIEW IF EXISTS v1}
   655    657     catchsql "CREATE TABLE t2([join $cols ,])"
   656    658     catchsql "CREATE VIEW v1 AS SELECT *, c1 AS o FROM t2;"
          659  +  catchsql "SELECT * FROM v1"
   657    660   } {1 {too many columns in result set}}
          661  +
   658    662   do_test sqllimits1-8.10 {
   659    663     # ORDER BY columns
   660    664     set cols [list]
   661    665     for {set i 0} {$i <= $SQLITE_LIMIT_COLUMN} {incr i} {
   662    666       lappend cols c
   663    667     }
   664    668     set sql "SELECT c FROM t1 ORDER BY [join $cols ,]"