OLD | NEW |
1 # 2010 September 22 | 1 # 2010 September 22 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
(...skipping 91 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
102 } {} | 102 } {} |
103 | 103 |
104 do_corruption_tests rtreeA-1.1 { | 104 do_corruption_tests rtreeA-1.1 { |
105 1 "SELECT * FROM t1" | 105 1 "SELECT * FROM t1" |
106 2 "SELECT * FROM t1 WHERE rowid=5" | 106 2 "SELECT * FROM t1 WHERE rowid=5" |
107 3 "INSERT INTO t1 VALUES(1000, 1, 2, 3, 4)" | 107 3 "INSERT INTO t1 VALUES(1000, 1, 2, 3, 4)" |
108 4 "SELECT * FROM t1 WHERE x1<10 AND x2>12" | 108 4 "SELECT * FROM t1 WHERE x1<10 AND x2>12" |
109 } | 109 } |
110 | 110 |
111 do_execsql_test rtreeA-1.2.0 { DROP TABLE t1_node } {} | 111 do_execsql_test rtreeA-1.2.0 { DROP TABLE t1_node } {} |
112 do_corruption_tests rtreeA-1.2 -error "SQL logic error or missing database" { | 112 do_corruption_tests rtreeA-1.2 -error "database disk image is malformed" { |
113 1 "SELECT * FROM t1" | 113 1 "SELECT * FROM t1" |
114 2 "SELECT * FROM t1 WHERE rowid=5" | 114 2 "SELECT * FROM t1 WHERE rowid=5" |
115 3 "INSERT INTO t1 VALUES(1000, 1, 2, 3, 4)" | 115 3 "INSERT INTO t1 VALUES(1000, 1, 2, 3, 4)" |
116 4 "SELECT * FROM t1 WHERE x1<10 AND x2>12" | 116 4 "SELECT * FROM t1 WHERE x1<10 AND x2>12" |
117 } | 117 } |
118 | 118 |
119 #------------------------------------------------------------------------- | 119 #------------------------------------------------------------------------- |
120 # Test the libraries response if some of the entries in the %_node table | 120 # Test the libraries response if some of the entries in the %_node table |
121 # are the wrong size. | 121 # are the wrong size. |
122 # | 122 # |
(...skipping 88 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
211 do_execsql_test rtreeA-6.1.0 { | 211 do_execsql_test rtreeA-6.1.0 { |
212 UPDATE t1_parent set parentnode = parentnode+1 | 212 UPDATE t1_parent set parentnode = parentnode+1 |
213 } {} | 213 } {} |
214 do_corruption_tests rtreeA-6.1 { | 214 do_corruption_tests rtreeA-6.1 { |
215 1 "DELETE FROM t1 WHERE rowid = 5" | 215 1 "DELETE FROM t1 WHERE rowid = 5" |
216 2 "UPDATE t1 SET x1=x1+1, x2=x2+1" | 216 2 "UPDATE t1 SET x1=x1+1, x2=x2+1" |
217 } | 217 } |
218 | 218 |
219 | 219 |
220 finish_test | 220 finish_test |
OLD | NEW |