3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give.
10 #***********************************************************************
12 # The focus of this file is testing that the r-tree correctly handles
13 # out-of-memory conditions.
16 if {![info exists testdir]} {
17 set testdir [file join [file dirname [info script]] .. .. test]
19 source $testdir/tester.tcl
20 source $testdir/malloc_common.tcl
28 # rtree3-1: Test OOM in simple CREATE TABLE, INSERT, DELETE and SELECT
29 # commands on an almost empty table.
31 # rtree3-2: Test OOM in a DROP TABLE command.
33 # rtree3-3a: Test OOM during a transaction to insert 100 pseudo-random rows.
35 # rtree3-3b: Test OOM during a transaction deleting all entries in the
36 # database constructed in [rtree3-3a] in pseudo-random order.
38 # rtree3-4a: OOM during "SELECT count(*) FROM ..." on a big table.
40 # rtree3-4b: OOM while deleting rows from a big table.
42 # rtree3-5: Test OOM while inserting rows into a big table.
44 # rtree3-6: Test OOM while deleting all rows of a table, one at a time.
46 # rtree3-7: OOM during an ALTER TABLE RENAME TABLE command.
48 # rtree3-8: Test OOM while registering the r-tree module with sqlite.
50 # rtree3-11: OOM following a constraint failure
52 do_faultsim_test rtree3-1 -faults oom* -prep {
53 faultsim_delete_and_reopen
57 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
58 INSERT INTO rt VALUES(NULL, 3, 5, 7, 9);
59 INSERT INTO rt VALUES(NULL, 13, 15, 17, 19);
60 DELETE FROM rt WHERE ii = 1;
62 SELECT ii FROM rt WHERE ii = 2;
67 do_test rtree3-2.prep {
68 faultsim_delete_and_reopen
70 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
71 INSERT INTO rt VALUES(NULL, 3, 5, 7, 9);
73 faultsim_save_and_close
75 do_faultsim_test rtree3-2 -faults oom* -prep {
76 faultsim_restore_and_reopen
78 execsql { DROP TABLE rt }
81 do_malloc_test rtree3-3.prep {
82 faultsim_delete_and_reopen
84 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
85 INSERT INTO rt VALUES(NULL, 3, 5, 7, 9);
87 faultsim_save_and_close
90 do_faultsim_test rtree3-3a -faults oom* -prep {
91 faultsim_restore_and_reopen
94 for {set ii 0} {$ii < 100} {incr ii} {
96 db eval {INSERT INTO rt VALUES(NULL, $f*10.0, $f*10.0, $f*15.0, $f*15.0)}
100 faultsim_save_and_close
102 do_faultsim_test rtree3-3b -faults oom* -prep {
103 faultsim_restore_and_reopen
106 for {set ii 0} {$ii < 100} {incr ii} {
108 db eval { DELETE FROM rt WHERE x1<($f*10.0) AND x1>($f*10.5) }
113 do_test rtree3-4.prep {
114 faultsim_delete_and_reopen
117 PRAGMA page_size = 512;
118 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
120 for {set i 0} {$i < 1500} {incr i} {
121 execsql { INSERT INTO rt VALUES($i, $i, $i+1, $i, $i+1) }
124 faultsim_save_and_close
127 do_faultsim_test rtree3-4a -faults oom-* -prep {
128 faultsim_restore_and_reopen
130 db eval { SELECT count(*) FROM rt }
132 faultsim_test_result {0 1500}
135 do_faultsim_test rtree3-4b -faults oom-transient -prep {
136 faultsim_restore_and_reopen
138 db eval { DELETE FROM rt WHERE ii BETWEEN 1 AND 100 }
140 faultsim_test_result {0 {}}
143 do_test rtree3-5.prep {
144 faultsim_delete_and_reopen
147 PRAGMA page_size = 512;
148 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
150 for {set i 0} {$i < 100} {incr i} {
151 execsql { INSERT INTO rt VALUES($i, $i, $i+1, $i, $i+1) }
154 faultsim_save_and_close
156 do_faultsim_test rtree3-5 -faults oom-* -prep {
157 faultsim_restore_and_reopen
159 for {set i 100} {$i < 110} {incr i} {
160 execsql { INSERT INTO rt VALUES($i, $i, $i+1, $i, $i+1) }
163 faultsim_test_result {0 {}}
166 do_test rtree3-6.prep {
167 faultsim_delete_and_reopen
170 PRAGMA page_size = 512;
171 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
173 for {set i 0} {$i < 50} {incr i} {
174 execsql { INSERT INTO rt VALUES($i, $i, $i+1, $i, $i+1) }
177 faultsim_save_and_close
179 do_faultsim_test rtree3-6 -faults oom-* -prep {
180 faultsim_restore_and_reopen
183 for {set i 0} {$i < 50} {incr i} {
184 execsql { DELETE FROM rt WHERE ii=$i }
188 faultsim_test_result {0 {}}
191 do_test rtree3-7.prep {
192 faultsim_delete_and_reopen
193 execsql { CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2) }
194 faultsim_save_and_close
196 do_faultsim_test rtree3-7 -faults oom-* -prep {
197 faultsim_restore_and_reopen
199 execsql { ALTER TABLE rt RENAME TO rt2 }
201 faultsim_test_result {0 {}}
204 do_faultsim_test rtree3-8 -faults oom-* -prep {
210 do_faultsim_test rtree3-9 -faults oom-* -prep {
213 set rc [register_cube_geom db]
214 if {$rc != "SQLITE_OK"} { error $rc }
216 faultsim_test_result {0 {}} {1 SQLITE_NOMEM}
219 do_test rtree3-10.prep {
220 faultsim_delete_and_reopen
222 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2, z1, z2);
223 INSERT INTO rt VALUES(1, 10, 10, 10, 11, 11, 11);
224 INSERT INTO rt VALUES(2, 5, 6, 6, 7, 7, 8);
226 faultsim_save_and_close
228 do_faultsim_test rtree3-10 -faults oom-* -prep {
229 faultsim_restore_and_reopen
230 register_cube_geom db
231 execsql { SELECT * FROM rt }
233 execsql { SELECT ii FROM rt WHERE ii MATCH cube(4.5, 5.5, 6.5, 1, 1, 1) }
235 faultsim_test_result {0 2}
239 do_test rtree3-11.prep {
240 faultsim_delete_and_reopen
242 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
243 INSERT INTO rt VALUES(1, 2, 3, 4, 5);
245 faultsim_save_and_close
247 do_faultsim_test rtree3-10.1 -faults oom-* -prep {
248 faultsim_restore_and_reopen
249 execsql { SELECT * FROM rt }
251 execsql { INSERT INTO rt VALUES(1, 2, 3, 4, 5) }
253 faultsim_test_result {1 {UNIQUE constraint failed: rt.ii}} \
254 {1 {constraint failed}}
256 do_faultsim_test rtree3-10.2 -faults oom-* -prep {
257 faultsim_restore_and_reopen
258 execsql { SELECT * FROM rt }
260 execsql { INSERT INTO rt VALUES(2, 2, 3, 5, 4) }
262 faultsim_test_result {1 {rtree constraint failed: rt.(y1<=y2)}} \
263 {1 {constraint failed}}