| 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 |