/ Check-in [f38e0be5]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Remove possibly stray output from various tests.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | testerOutput
Files: files | file ages | folders
SHA1: f38e0be56fc086a3ce08134ade83ab61c9fca106
User & Date: mistachkin 2015-06-10 22:51:02
Context
2015-06-10
23:02
More test output refinements. Closed-Leaf check-in: e64a5681 user: mistachkin tags: testerOutput
22:51
Remove possibly stray output from various tests. check-in: f38e0be5 user: mistachkin tags: testerOutput
22:03
Fix minor typo in the quicktest MSVC makefile target. check-in: 75b65f9d user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/e_walauto.test.

   167    167     } 0
   168    168   
   169    169     # EVIDENCE-OF: R-33080-59193 Checkpoints initiated by this mechanism 
   170    170     # are PASSIVE.
   171    171     #
   172    172     set ::busy_callback_count 0
   173    173     proc busy_callback {args} {
   174         -  puts Hello
   175    174       incr ::busy_callback_count
   176    175       return 0
   177    176     }
   178    177     do_test 1.$tn.12.1 {
   179    178       sqlite3_wal_checkpoint_v2 db truncate
   180    179       autocheckpoint db 100 
   181    180       db busy busy_callback

Changes to test/filectrl.test.

    35     35     db close
    36     36     sqlite3 db test_control_lockproxy.db
    37     37     file_control_lockproxy_test db [get_pwd]
    38     38   } {}
    39     39   do_test filectrl-1.6 {
    40     40     sqlite3 db test.db
    41     41     set fn [file_control_tempfilename db]
    42         -  puts -nonewline \[$fn\]
    43     42     set fn
    44     43   } {/etilqs_/}
    45     44   db close
    46     45   forcedelete .test_control_lockproxy.db-conch test.proxy
    47     46   finish_test

Changes to test/fts3d.test.

   209    209       SELECT OFFSETS(t1) FROM t1
   210    210        WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY docid;
   211    211     }
   212    212   } [list {0 0 0 4 0 4 5 2 0 3 8 1 0 5 10 4} \
   213    213           {0 1 0 4 0 2 5 3 0 3 9 1 0 5 11 4} \
   214    214           {0 0 0 4 0 4 5 2 0 3 8 1 0 5 10 4}]
   215    215   
   216         -puts [db eval {SELECT c FROM t1 } ]
          216  +db eval {SELECT c FROM t1 }
   217    217   check_terms_all fts3d-4.1      {a four is test that this was}
   218    218   check_doclist_all fts3d-4.1.1  a {[1 0[2]] [2 0[2]] [3 0[2]]}
   219    219   check_doclist_all fts3d-4.1.2  four {}
   220    220   check_doclist_all fts3d-4.1.3  is {[1 0[1]] [3 0[1]]}
   221    221   #check_doclist_all fts3d-4.1.4  one {}
   222    222   check_doclist_all fts3d-4.1.5  test {[1 0[3]] [2 0[3]] [3 0[3]]}
   223    223   check_doclist_all fts3d-4.1.6  that {[2 0[0]]}

Changes to test/fts4incr.test.

    43     43         MATCH '"land of canaan"' AND docid < 1030000 } 7
    44     44   } {
    45     45     foreach s {0 1} {
    46     46       execsql "INSERT INTO t1(t1) VALUES('test-no-incr-doclist=$s')"
    47     47       do_execsql_test 2.$tn.$s $q $res
    48     48       set t($s) [lindex [time [list execsql $q] 100] 0]
    49     49     }
    50         -  puts "with optimization: $t(0)    without: $t(1)"
           50  +  if {0} {
           51  +    puts "with optimization: $t(0)    without: $t(1)"
           52  +  }
    51     53   }
    52     54   
    53     55   do_test 2.1 {
    54     56     execsql {
    55     57       CREATE VIRTUAL TABLE t2 USING fts4(order=DESC);
    56     58     }
    57     59     set num [list one two three four five six seven eight nine ten]

Changes to test/index5.test.

    63     63       } elseif {$iNext==($iPrev-1)} { 
    64     64         incr nBackward 
    65     65       } else {
    66     66         incr nNoncont
    67     67       }
    68     68       set iPrev $iNext
    69     69     }
    70         -  puts -nonewline \
    71         -      " (forward=$nForward, back=$nBackward, noncontiguous=$nNoncont)"
           70  +  if {0} {
           71  +    puts -nonewline \
           72  +        " (forward=$nForward, back=$nBackward, noncontiguous=$nNoncont)"
           73  +  }
    72     74   
    73     75     expr {$nForward > 2*($nBackward + $nNoncont)}
    74     76   } {1}
    75     77   db close
    76     78   tvfs delete
    77     79   
    78     80   finish_test

Changes to test/select8.test.

    28     28     INSERT INTO songs VALUES(6,'two',11);
    29     29   }
    30     30   set result [execsql {
    31     31     SELECT DISTINCT artist,sum(timesplayed) AS total      
    32     32     FROM songs      
    33     33     GROUP BY LOWER(artist)      
    34     34   }]
    35         -puts result=$result
    36     35   do_test select8-1.1 {
    37     36     execsql {
    38     37       SELECT DISTINCT artist,sum(timesplayed) AS total      
    39     38       FROM songs      
    40     39       GROUP BY LOWER(artist)      
    41     40       LIMIT 1 OFFSET 1
    42     41     }

Changes to test/shared4.test.

    12     12   # Test the btree mutex protocol for shared cache mode.
    13     13   #
    14     14   # $Id: shared4.test,v 1.2 2008/08/04 03:51:24 danielk1977 Exp $
    15     15   
    16     16   set testdir [file dirname $argv0]
    17     17   source $testdir/tester.tcl
    18     18   db close
    19         -puts hello
    20     19   
    21     20   # This script is only valid if we are running shared-cache mode in a
    22     21   # threadsafe-capable database engine.
    23     22   #
    24     23   ifcapable !shared_cache||!compound {
    25     24     finish_test
    26     25     return

Changes to test/tester.tcl.

  1164   1164     lappend r $msg
  1165   1165     return $r
  1166   1166   }
  1167   1167   
  1168   1168   # Do an VDBE code dump on the SQL given
  1169   1169   #
  1170   1170   proc explain {sql {db db}} {
  1171         -  puts ""
  1172         -  puts "addr  opcode        p1      p2      p3      p4               p5  #"
  1173         -  puts "----  ------------  ------  ------  ------  ---------------  --  -"
         1171  +  output1 ""
         1172  +  output1 "addr  opcode        p1      p2      p3      p4               p5  #"
         1173  +  output1 "----  ------------  ------  ------  ------  ---------------  --  -"
  1174   1174     $db eval "explain $sql" {} {
  1175         -    puts [format {%-4d  %-12.12s  %-6d  %-6d  %-6d  % -17s %s  %s} \
         1175  +    output1 [format {%-4d  %-12.12s  %-6d  %-6d  %-6d  % -17s %s  %s} \
  1176   1176         $addr $opcode $p1 $p2 $p3 $p4 $p5 $comment
  1177   1177       ]
  1178   1178     }
  1179   1179   }
  1180   1180   
  1181   1181   proc explain_i {sql {db db}} {
  1182         -  puts ""
  1183         -  puts "addr  opcode        p1      p2      p3      p4                p5  #"
  1184         -  puts "----  ------------  ------  ------  ------  ----------------  --  -"
         1182  +  output1 ""
         1183  +  output1 "addr  opcode        p1      p2      p3      p4                p5  #"
         1184  +  output1 "----  ------------  ------  ------  ------  ----------------  --  -"
  1185   1185   
  1186   1186   
  1187   1187     # Set up colors for the different opcodes. Scheme is as follows:
  1188   1188     #
  1189   1189     #   Red:   Opcodes that write to a b-tree.
  1190   1190     #   Blue:  Opcodes that reposition or seek a cursor. 
  1191   1191     #   Green: The ResultRow opcode.
................................................................................
  1250   1250         puts ""
  1251   1251       }
  1252   1252       set I [string repeat " " $x($addr)]
  1253   1253   
  1254   1254       set col ""
  1255   1255       catch { set col $color($opcode) }
  1256   1256   
  1257         -    puts [format {%-4d  %s%s%-12.12s%s  %-6d  %-6d  %-6d  % -17s %s  %s} \
         1257  +    output1 [format {%-4d  %s%s%-12.12s%s  %-6d  %-6d  %-6d  % -17s %s  %s} \
  1258   1258         $addr $I $col $opcode $D $p1 $p2 $p3 $p4 $p5 $comment
  1259   1259       ]
  1260   1260     }
  1261         -  puts "----  ------------  ------  ------  ------  ----------------  --  -"
         1261  +  output1 "----  ------------  ------  ------  ------  ----------------  --  -"
  1262   1262   }
  1263   1263   
  1264   1264   # Show the VDBE program for an SQL statement but omit the Trace
  1265   1265   # opcode at the beginning.  This procedure can be used to prove
  1266   1266   # that different SQL statements generate exactly the same VDBE code.
  1267   1267   #
  1268   1268   proc explain_no_trace {sql} {