/ Check-in [87946c62]
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 misc3.test so that it works with OMIT_MERGE_SORT builds.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 87946c627f7230bea3739fd6aeec3e56115a3f93
User & Date: dan 2011-09-24 09:54:14
Context
2011-09-25
17:49
If an open as read/write fails, do not try to reopen as read-only if in exclusive access mode. check-in: 263c5fb2 user: drh tags: trunk
2011-09-24
09:54
Fix misc3.test so that it works with OMIT_MERGE_SORT builds. check-in: 87946c62 user: dan tags: trunk
05:55
Fix some test files so that they work with SQLITE_OMIT_WAL builds. check-in: a38668dc user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/misc3.test.

   266    266           a INTEGER DEFAULT 54321,
   267    267           b TEXT DEFAULT "hello",
   268    268           c REAL DEFAULT 3.1415926
   269    269         );
   270    270         CREATE UNIQUE INDEX ex1i1 ON ex1(a);
   271    271         EXPLAIN REINDEX;
   272    272       }]
   273         -    regexp { SorterCompare \d+ \d+ \d+ } $x
          273  +    ifcapable mergesort {
          274  +      regexp { SorterCompare \d+ \d+ \d+ } $x
          275  +    } else {
          276  +      regexp { IsUnique \d+ \d+ \d+ \d+ } $x
          277  +    }
   274    278     } {1}
   275    279     if {[regexp {16} [db one {PRAGMA encoding}]]} {
   276    280       do_test misc3-6.11-utf16 {
   277    281         set x [execsql {
   278    282           EXPLAIN SELECT a+123456789012, b*4.5678, c FROM ex1 ORDER BY +a, b DESC
   279    283         }]
   280    284         set y [regexp { 123456789012 } $x]