Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Remove possibly stray output from various tests. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | testerOutput |
Files: | files | file ages | folders |
SHA1: |
f38e0be56fc086a3ce08134ade83ab61 |
User & Date: | mistachkin 2015-06-10 22:51:02.529 |
Context
2015-06-10
| ||
23:02 | More test output refinements. (Closed-Leaf check-in: e64a568179 user: mistachkin tags: testerOutput) | |
22:51 | Remove possibly stray output from various tests. (check-in: f38e0be56f user: mistachkin tags: testerOutput) | |
22:03 | Fix minor typo in the quicktest MSVC makefile target. (check-in: 75b65f9d49 user: mistachkin tags: trunk) | |
Changes
Changes to test/e_walauto.test.
︙ | ︙ | |||
167 168 169 170 171 172 173 | } 0 # EVIDENCE-OF: R-33080-59193 Checkpoints initiated by this mechanism # are PASSIVE. # set ::busy_callback_count 0 proc busy_callback {args} { | < | 167 168 169 170 171 172 173 174 175 176 177 178 179 180 | } 0 # EVIDENCE-OF: R-33080-59193 Checkpoints initiated by this mechanism # are PASSIVE. # set ::busy_callback_count 0 proc busy_callback {args} { incr ::busy_callback_count return 0 } do_test 1.$tn.12.1 { sqlite3_wal_checkpoint_v2 db truncate autocheckpoint db 100 db busy busy_callback |
︙ | ︙ |
Changes to test/filectrl.test.
︙ | ︙ | |||
35 36 37 38 39 40 41 | db close sqlite3 db test_control_lockproxy.db file_control_lockproxy_test db [get_pwd] } {} do_test filectrl-1.6 { sqlite3 db test.db set fn [file_control_tempfilename db] | < | 35 36 37 38 39 40 41 42 43 44 45 46 | db close sqlite3 db test_control_lockproxy.db file_control_lockproxy_test db [get_pwd] } {} do_test filectrl-1.6 { sqlite3 db test.db set fn [file_control_tempfilename db] set fn } {/etilqs_/} db close forcedelete .test_control_lockproxy.db-conch test.proxy finish_test |
Changes to test/fts3d.test.
︙ | ︙ | |||
209 210 211 212 213 214 215 | SELECT OFFSETS(t1) FROM t1 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY docid; } } [list {0 0 0 4 0 4 5 2 0 3 8 1 0 5 10 4} \ {0 1 0 4 0 2 5 3 0 3 9 1 0 5 11 4} \ {0 0 0 4 0 4 5 2 0 3 8 1 0 5 10 4}] | | | 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 | SELECT OFFSETS(t1) FROM t1 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY docid; } } [list {0 0 0 4 0 4 5 2 0 3 8 1 0 5 10 4} \ {0 1 0 4 0 2 5 3 0 3 9 1 0 5 11 4} \ {0 0 0 4 0 4 5 2 0 3 8 1 0 5 10 4}] db eval {SELECT c FROM t1 } check_terms_all fts3d-4.1 {a four is test that this was} check_doclist_all fts3d-4.1.1 a {[1 0[2]] [2 0[2]] [3 0[2]]} check_doclist_all fts3d-4.1.2 four {} check_doclist_all fts3d-4.1.3 is {[1 0[1]] [3 0[1]]} #check_doclist_all fts3d-4.1.4 one {} check_doclist_all fts3d-4.1.5 test {[1 0[3]] [2 0[3]] [3 0[3]]} check_doclist_all fts3d-4.1.6 that {[2 0[0]]} |
︙ | ︙ |
Changes to test/fts4incr.test.
︙ | ︙ | |||
43 44 45 46 47 48 49 | MATCH '"land of canaan"' AND docid < 1030000 } 7 } { foreach s {0 1} { execsql "INSERT INTO t1(t1) VALUES('test-no-incr-doclist=$s')" do_execsql_test 2.$tn.$s $q $res set t($s) [lindex [time [list execsql $q] 100] 0] } | > | > | 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 | MATCH '"land of canaan"' AND docid < 1030000 } 7 } { foreach s {0 1} { execsql "INSERT INTO t1(t1) VALUES('test-no-incr-doclist=$s')" do_execsql_test 2.$tn.$s $q $res set t($s) [lindex [time [list execsql $q] 100] 0] } if {0} { puts "with optimization: $t(0) without: $t(1)" } } do_test 2.1 { execsql { CREATE VIRTUAL TABLE t2 USING fts4(order=DESC); } set num [list one two three four five six seven eight nine ten] |
︙ | ︙ |
Changes to test/index5.test.
︙ | ︙ | |||
63 64 65 66 67 68 69 | } elseif {$iNext==($iPrev-1)} { incr nBackward } else { incr nNoncont } set iPrev $iNext } | > | | > | 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 | } elseif {$iNext==($iPrev-1)} { incr nBackward } else { incr nNoncont } set iPrev $iNext } if {0} { puts -nonewline \ " (forward=$nForward, back=$nBackward, noncontiguous=$nNoncont)" } expr {$nForward > 2*($nBackward + $nNoncont)} } {1} db close tvfs delete finish_test |
Changes to test/select8.test.
︙ | ︙ | |||
28 29 30 31 32 33 34 | INSERT INTO songs VALUES(6,'two',11); } set result [execsql { SELECT DISTINCT artist,sum(timesplayed) AS total FROM songs GROUP BY LOWER(artist) }] | < | 28 29 30 31 32 33 34 35 36 37 38 39 40 41 | INSERT INTO songs VALUES(6,'two',11); } set result [execsql { SELECT DISTINCT artist,sum(timesplayed) AS total FROM songs GROUP BY LOWER(artist) }] do_test select8-1.1 { execsql { SELECT DISTINCT artist,sum(timesplayed) AS total FROM songs GROUP BY LOWER(artist) LIMIT 1 OFFSET 1 } |
︙ | ︙ |
Changes to test/shared4.test.
︙ | ︙ | |||
12 13 14 15 16 17 18 | # Test the btree mutex protocol for shared cache mode. # # $Id: shared4.test,v 1.2 2008/08/04 03:51:24 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl db close | < | 12 13 14 15 16 17 18 19 20 21 22 23 24 25 | # Test the btree mutex protocol for shared cache mode. # # $Id: shared4.test,v 1.2 2008/08/04 03:51:24 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl db close # This script is only valid if we are running shared-cache mode in a # threadsafe-capable database engine. # ifcapable !shared_cache||!compound { finish_test return |
︙ | ︙ |
Changes to test/tester.tcl.
︙ | ︙ | |||
1164 1165 1166 1167 1168 1169 1170 | lappend r $msg return $r } # Do an VDBE code dump on the SQL given # proc explain {sql {db db}} { | | | | | | | | | 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 | lappend r $msg return $r } # Do an VDBE code dump on the SQL given # proc explain {sql {db db}} { output1 "" output1 "addr opcode p1 p2 p3 p4 p5 #" output1 "---- ------------ ------ ------ ------ --------------- -- -" $db eval "explain $sql" {} { output1 [format {%-4d %-12.12s %-6d %-6d %-6d % -17s %s %s} \ $addr $opcode $p1 $p2 $p3 $p4 $p5 $comment ] } } proc explain_i {sql {db db}} { output1 "" output1 "addr opcode p1 p2 p3 p4 p5 #" output1 "---- ------------ ------ ------ ------ ---------------- -- -" # Set up colors for the different opcodes. Scheme is as follows: # # Red: Opcodes that write to a b-tree. # Blue: Opcodes that reposition or seek a cursor. # Green: The ResultRow opcode. |
︙ | ︙ | |||
1250 1251 1252 1253 1254 1255 1256 | puts "" } set I [string repeat " " $x($addr)] set col "" catch { set col $color($opcode) } | | | | 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 | puts "" } set I [string repeat " " $x($addr)] set col "" catch { set col $color($opcode) } output1 [format {%-4d %s%s%-12.12s%s %-6d %-6d %-6d % -17s %s %s} \ $addr $I $col $opcode $D $p1 $p2 $p3 $p4 $p5 $comment ] } output1 "---- ------------ ------ ------ ------ ---------------- -- -" } # Show the VDBE program for an SQL statement but omit the Trace # opcode at the beginning. This procedure can be used to prove # that different SQL statements generate exactly the same VDBE code. # proc explain_no_trace {sql} { |
︙ | ︙ |