/ Check-in [50de2a0d]
Login

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

Overview
Comment:Add a couple of OOM tests.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 50de2a0d2d96b6b5b8de7ac6277d60859a8d9a56f6a792950734386bb9f10b79
User & Date: dan 2018-07-09 18:11:52
Context
2018-07-09
18:55
Avoid leaving view-definitions with an incomplete set of column names/types in the in-memory schema if an OOM strikes while allocating the same. check-in: 1ddbb537 user: dan tags: trunk
18:11
Add a couple of OOM tests. check-in: 50de2a0d user: dan tags: trunk
17:33
Remove redundant branches in window function processing. check-in: 8fdaf3f3 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/windowfault.test.

   134    134   } -body {
   135    135     execsql {
   136    136       SELECT percent_rank() OVER (), cume_dist() OVER () FROM t1
   137    137     }
   138    138   } -test {
   139    139     faultsim_test_result {0 {0.0 1.0 0.0 1.0 0.0 1.0}}
   140    140   }
          141  +
          142  +do_faultsim_test 7 -faults oom-* -prep {
          143  +  faultsim_restore_and_reopen
          144  +} -body {
          145  +  execsql {
          146  +    SELECT percent_rank() OVER (), cume_dist() OVER () FROM t1
          147  +  }
          148  +} -test {
          149  +  faultsim_test_result {0 {0.0 1.0 0.0 1.0 0.0 1.0}}
          150  +}
          151  +
          152  +do_faultsim_test 8 -faults oom-t* -prep {
          153  +  faultsim_restore_and_reopen
          154  +} -body {
          155  +  execsql {
          156  +    SELECT a, sum(b) OVER win1 FROM t1
          157  +      WINDOW win1 AS (PARTITION BY a ),
          158  +             win2 AS (PARTITION BY b )
          159  +    ORDER BY a;
          160  +  }
          161  +} -test {
          162  +  faultsim_test_result {0 {1 2 5 6 9 10}}
          163  +}
   141    164   
   142    165   finish_test
   143    166