/ Check-in [51cbddd5]
Login

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

Overview
Comment:Modify a query in test/thread001.test to ensure that results are returned in the order expected by the test.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:51cbddd51d02bcd954be411ecc83556c049a2680
User & Date: dan 2012-12-05 16:44:13
Context
2012-12-05
19:04
Disable a couple of tests in where.test when running the "no_optimization" permutation. check-in: 5e961e37 user: dan tags: trunk
16:44
Modify a query in test/thread001.test to ensure that results are returned in the order expected by the test. check-in: 51cbddd5 user: dan tags: trunk
14:37
Fixes to a test case in shared_err.test. The fix is to prevent sqlite3_prepare() from being called when the test intends to test the response of sqlite3_step() to an OOM condition. check-in: 40c14395 user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/thread001.test.

    83     83       }
    84     84     
    85     85       for {set i 0} {$i < 100} {incr i} {
    86     86         # Test that the invariant is true.
    87     87         do_test t1 {
    88     88           execsql {
    89     89             SELECT 
    90         -            (SELECT md5sum(a, b) FROM ab WHERE a < (SELECT max(a) FROM ab)) ==
           90  +            (SELECT md5sum(a, b) FROM ab WHERE +a < (SELECT max(a) FROM ab)) ==
    91     91               (SELECT b FROM ab WHERE a = (SELECT max(a) FROM ab))
    92     92           }
    93     93         } {1}
    94     94     
    95     95         # Add another row to the database.
    96     96         execsql { INSERT INTO ab SELECT NULL, md5sum(a, b) FROM ab }
    97     97       }
................................................................................
   127    127     #
   128    128     do_test thread001.$tn.5 {
   129    129       execsql { SELECT count(*) FROM ab; }
   130    130     } [expr {1 + $::NTHREAD*100}]
   131    131     do_test thread001.$tn.6 {
   132    132       execsql {
   133    133         SELECT 
   134         -        (SELECT md5sum(a, b) FROM ab WHERE a < (SELECT max(a) FROM ab)) ==
          134  +        (SELECT md5sum(a, b) FROM ab WHERE +a < (SELECT max(a) FROM ab)) ==
   135    135           (SELECT b FROM ab WHERE a = (SELECT max(a) FROM ab))
   136    136       }
   137    137     } {1}
   138    138     do_test thread001.$tn.7 {
   139    139       execsql { PRAGMA integrity_check }
   140    140     } {ok}
   141    141   }
   142    142   
   143    143   sqlite3_enable_shared_cache $::enable_shared_cache
   144    144   set sqlite_open_file_count 0
   145    145   finish_test