OLD | NEW |
1 # 2004 Jun 29 | 1 # 2004 Jun 29 |
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 151 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
162 } {{INSERT INTO t2 VALUES(2,3)}} | 162 } {{INSERT INTO t2 VALUES(2,3)}} |
163 do_test trace-4.4 { | 163 do_test trace-4.4 { |
164 set TRACE_OUT {} | 164 set TRACE_OUT {} |
165 execsql {SELECT * FROM t1} | 165 execsql {SELECT * FROM t1} |
166 } {1 2 2 3 2 3} | 166 } {1 2 2 3 2 3} |
167 do_test trace-4.5 { | 167 do_test trace-4.5 { |
168 set TRACE_OUT | 168 set TRACE_OUT |
169 } {{SELECT * FROM t1}} | 169 } {{SELECT * FROM t1}} |
170 catch {sqlite3_finalize $STMT} | 170 catch {sqlite3_finalize $STMT} |
171 | 171 |
| 172 # 3.8.11: Profile output even if the statement is not run to completion. |
| 173 do_test trace-4.6 { |
| 174 set TRACE_OUT {} |
| 175 db eval {SELECT * FROM t1} {} {if {$a>=1} break} |
| 176 set TRACE_OUT |
| 177 } {{SELECT * FROM t1}} |
| 178 |
| 179 |
172 # Trigger tracing. | 180 # Trigger tracing. |
173 # | 181 # |
174 ifcapable trigger { | 182 ifcapable trigger { |
175 do_test trace-5.1 { | 183 do_test trace-5.1 { |
176 db eval { | 184 db eval { |
177 CREATE TRIGGER r1t1 AFTER UPDATE ON t1 BEGIN | 185 CREATE TRIGGER r1t1 AFTER UPDATE ON t1 BEGIN |
178 UPDATE t2 SET a=new.a WHERE rowid=new.rowid; | 186 UPDATE t2 SET a=new.a WHERE rowid=new.rowid; |
179 END; | 187 END; |
180 CREATE TRIGGER r1t2 AFTER UPDATE ON t2 BEGIN | 188 CREATE TRIGGER r1t2 AFTER UPDATE ON t2 BEGIN |
181 SELECT 'hello'; | 189 SELECT 'hello'; |
(...skipping 70 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
252 db trace trace_proc | 260 db trace trace_proc |
253 set TRACE_OUT {} | 261 set TRACE_OUT {} |
254 execsql {SELECT '$::t6str', [$::t6str], $::t6str, ?1, "?1", $::t6str FROM t6} | 262 execsql {SELECT '$::t6str', [$::t6str], $::t6str, ?1, "?1", $::t6str FROM t6} |
255 } {{$::t6str} 1 {test-six y'all} {test-six y'all} 2 {test-six y'all}} | 263 } {{$::t6str} 1 {test-six y'all} {test-six y'all} 2 {test-six y'all}} |
256 do_test trace-6.201 { | 264 do_test trace-6.201 { |
257 set TRACE_OUT | 265 set TRACE_OUT |
258 } {{SELECT '$::t6str', [$::t6str], 'test-six y''all', 'test-six y''all', "?1", '
test-six y''all' FROM t6}} | 266 } {{SELECT '$::t6str', [$::t6str], 'test-six y''all', 'test-six y''all', "?1", '
test-six y''all' FROM t6}} |
259 | 267 |
260 | 268 |
261 finish_test | 269 finish_test |
OLD | NEW |