Annotation of embedaddon/sqlite3/ext/rtree/rtree3.test, revision 1.1.1.1
1.1 misho 1: # 2008 Feb 19
2: #
3: # The author disclaims copyright to this source code. In place of
4: # a legal notice, here is a blessing:
5: #
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.
9: #
10: #***********************************************************************
11: #
12: # The focus of this file is testing that the r-tree correctly handles
13: # out-of-memory conditions.
14: #
15:
16: if {![info exists testdir]} {
17: set testdir [file join [file dirname [info script]] .. .. test]
18: }
19: source $testdir/tester.tcl
20: source $testdir/malloc_common.tcl
21: ifcapable !rtree {
22: finish_test
23: return
24: }
25:
26: # Test summary:
27: #
28: # rtree3-1: Test OOM in simple CREATE TABLE, INSERT, DELETE and SELECT
29: # commands on an almost empty table.
30: #
31: # rtree3-2: Test OOM in a DROP TABLE command.
32: #
33: # rtree3-3a: Test OOM during a transaction to insert 100 pseudo-random rows.
34: #
35: # rtree3-3b: Test OOM during a transaction deleting all entries in the
36: # database constructed in [rtree3-3a] in pseudo-random order.
37: #
38: # rtree3-4a: OOM during "SELECT count(*) FROM ..." on a big table.
39: #
40: # rtree3-4b: OOM while deleting rows from a big table.
41: #
42: # rtree3-5: Test OOM while inserting rows into a big table.
43: #
44: # rtree3-6: Test OOM while deleting all rows of a table, one at a time.
45: #
46: # rtree3-7: OOM during an ALTER TABLE RENAME TABLE command.
47: #
48: # rtree3-8: Test OOM while registering the r-tree module with sqlite.
49: #
50:
51: do_faultsim_test rtree3-1 -faults oom* -prep {
52: faultsim_delete_and_reopen
53: } -body {
54: execsql {
55: BEGIN TRANSACTION;
56: CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
57: INSERT INTO rt VALUES(NULL, 3, 5, 7, 9);
58: INSERT INTO rt VALUES(NULL, 13, 15, 17, 19);
59: DELETE FROM rt WHERE ii = 1;
60: SELECT * FROM rt;
61: SELECT ii FROM rt WHERE ii = 2;
62: COMMIT;
63: }
64: }
65:
66: do_test rtree3-2.prep {
67: faultsim_delete_and_reopen
68: execsql {
69: CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
70: INSERT INTO rt VALUES(NULL, 3, 5, 7, 9);
71: }
72: faultsim_save_and_close
73: } {}
74: do_faultsim_test rtree3-2 -faults oom* -prep {
75: faultsim_restore_and_reopen
76: } -body {
77: execsql { DROP TABLE rt }
78: }
79:
80: do_malloc_test rtree3-3.prep {
81: faultsim_delete_and_reopen
82: execsql {
83: CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
84: INSERT INTO rt VALUES(NULL, 3, 5, 7, 9);
85: }
86: faultsim_save_and_close
87: } {}
88:
89: do_faultsim_test rtree3-3a -faults oom* -prep {
90: faultsim_restore_and_reopen
91: } -body {
92: db eval BEGIN
93: for {set ii 0} {$ii < 100} {incr ii} {
94: set f [expr rand()]
95: db eval {INSERT INTO rt VALUES(NULL, $f*10.0, $f*10.0, $f*15.0, $f*15.0)}
96: }
97: db eval COMMIT
98: }
99: faultsim_save_and_close
100:
101: do_faultsim_test rtree3-3b -faults oom* -prep {
102: faultsim_restore_and_reopen
103: } -body {
104: db eval BEGIN
105: for {set ii 0} {$ii < 100} {incr ii} {
106: set f [expr rand()]
107: db eval { DELETE FROM rt WHERE x1<($f*10.0) AND x1>($f*10.5) }
108: }
109: db eval COMMIT
110: }
111:
112: do_test rtree3-4.prep {
113: faultsim_delete_and_reopen
114: execsql {
115: BEGIN;
116: PRAGMA page_size = 512;
117: CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
118: }
119: for {set i 0} {$i < 1500} {incr i} {
120: execsql { INSERT INTO rt VALUES($i, $i, $i+1, $i, $i+1) }
121: }
122: execsql { COMMIT }
123: faultsim_save_and_close
124: } {}
125:
126: do_faultsim_test rtree3-4a -faults oom-* -prep {
127: faultsim_restore_and_reopen
128: } -body {
129: db eval { SELECT count(*) FROM rt }
130: } -test {
131: faultsim_test_result {0 1500}
132: }
133:
134: do_faultsim_test rtree3-4b -faults oom-transient -prep {
135: faultsim_restore_and_reopen
136: } -body {
137: db eval { DELETE FROM rt WHERE ii BETWEEN 1 AND 100 }
138: } -test {
139: faultsim_test_result {0 {}}
140: }
141:
142: do_test rtree3-5.prep {
143: faultsim_delete_and_reopen
144: execsql {
145: BEGIN;
146: PRAGMA page_size = 512;
147: CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
148: }
149: for {set i 0} {$i < 100} {incr i} {
150: execsql { INSERT INTO rt VALUES($i, $i, $i+1, $i, $i+1) }
151: }
152: execsql { COMMIT }
153: faultsim_save_and_close
154: } {}
155: do_faultsim_test rtree3-5 -faults oom-* -prep {
156: faultsim_restore_and_reopen
157: } -body {
158: for {set i 100} {$i < 110} {incr i} {
159: execsql { INSERT INTO rt VALUES($i, $i, $i+1, $i, $i+1) }
160: }
161: } -test {
162: faultsim_test_result {0 {}}
163: }
164:
165: do_test rtree3-6.prep {
166: faultsim_delete_and_reopen
167: execsql {
168: BEGIN;
169: PRAGMA page_size = 512;
170: CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
171: }
172: for {set i 0} {$i < 50} {incr i} {
173: execsql { INSERT INTO rt VALUES($i, $i, $i+1, $i, $i+1) }
174: }
175: execsql { COMMIT }
176: faultsim_save_and_close
177: } {}
178: do_faultsim_test rtree3-6 -faults oom-* -prep {
179: faultsim_restore_and_reopen
180: } -body {
181: execsql BEGIN
182: for {set i 0} {$i < 50} {incr i} {
183: execsql { DELETE FROM rt WHERE ii=$i }
184: }
185: execsql COMMIT
186: } -test {
187: faultsim_test_result {0 {}}
188: }
189:
190: do_test rtree3-7.prep {
191: faultsim_delete_and_reopen
192: execsql { CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2) }
193: faultsim_save_and_close
194: } {}
195: do_faultsim_test rtree3-7 -faults oom-* -prep {
196: faultsim_restore_and_reopen
197: } -body {
198: execsql { ALTER TABLE rt RENAME TO rt2 }
199: } -test {
200: faultsim_test_result {0 {}}
201: }
202:
203: do_faultsim_test rtree3-8 -faults oom-* -prep {
204: catch { db close }
205: } -body {
206: sqlite3 db test.db
207: }
208:
209: do_faultsim_test rtree3-9 -faults oom-* -prep {
210: sqlite3 db :memory:
211: } -body {
212: set rc [register_cube_geom db]
213: if {$rc != "SQLITE_OK"} { error $rc }
214: } -test {
215: faultsim_test_result {0 {}} {1 SQLITE_NOMEM}
216: }
217:
218: do_test rtree3-10.prep {
219: faultsim_delete_and_reopen
220: execsql {
221: CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2, z1, z2);
222: INSERT INTO rt VALUES(1, 10, 10, 10, 11, 11, 11);
223: INSERT INTO rt VALUES(2, 5, 6, 6, 7, 7, 8);
224: }
225: faultsim_save_and_close
226: } {}
227: do_faultsim_test rtree3-10 -faults oom-* -prep {
228: faultsim_restore_and_reopen
229: register_cube_geom db
230: execsql { SELECT * FROM rt }
231: } -body {
232: execsql { SELECT ii FROM rt WHERE ii MATCH cube(4.5, 5.5, 6.5, 1, 1, 1) }
233: } -test {
234: faultsim_test_result {0 2}
235: }
236:
237: finish_test
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/cvsweb/back.gif){kind=icon}
Return to rtree3.test CVS log ![[TXT]](/icons/cvsweb/text.gif){kind=icon}
![[DIR]](/icons/cvsweb/dir.gif){kind=icon}
Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / ext / rtree