Home
last modified time | relevance | path

Searched refs:append (Results 1 – 25 of 123) sorted by relevance

12345

/sqlite-3.40.0/test/
H A Dspeed2.test49 append txt " [lindex $::ones [expr {$n/100}]] hundred"
53 append txt " [lindex $::tens [expr {$n/10}]]"
57 append txt " [lindex $::ones $n]"
122 append sql \
146 append sql \
177 append sql "SELECT c=='hi' FROM t1 WHERE rowid=$id;\n"
186 append sql "SELECT c FROM t1 WHERE a=$id;"
194 append sql "SELECT c FROM t1 WHERE c='$c';"
227 append sql "SELECT c FROM t1 WHERE a=$id;"
235 append sql "SELECT c FROM t1 WHERE c='$c';"
[all …]
H A Dindex2.test23 append sql "c$i,"
25 append sql "c1000);"
31 append sql $i,
33 append sql {1000);}
44 append sql [expr {$j*10000+$i}],
46 append sql "[expr {$j*10000+1000}]);"
61 append sql c$i,
63 append sql c1000)
H A Dinstr.test162 append longstr $longstr
163 append longstr $longstr
164 append longstr $longstr
165 append longstr $longstr
166 append longstr $longstr
167 append longstr $longstr
168 append longstr $longstr
169 append longstr $longstr
170 append longstr $longstr
171 append longstr $longstr
[all …]
H A Dspeed1.test53 append txt " [lindex $::ones [expr {$n/100}]] hundred"
57 append txt " [lindex $::tens [expr {$n/10}]]"
61 append txt " [lindex $::ones $n]"
91 append sql "INSERT INTO t1 VALUES($i,$r,'[number_name $r]');\n"
128 append sql \
163 append sql "SELECT c FROM t1 WHERE rowid=$id;"
174 append sql "SELECT c FROM t1 WHERE a=$id;"
184 append sql "SELECT c FROM t1 WHERE c='$c';"
200 append sql "UPDATE t1 SET b=b*2 WHERE a>=$lwr AND a<$upr;"
211 append sql "UPDATE t1 SET b=$r WHERE a=$i;"
[all …]
H A Dfunc6.test68 append hdr 00
71 append hdr [format %02x [expr $n*2 + 13]]
72 append body [binary encode hex $x]
74 append hdr 08
76 append hdr 09
78 append hdr 01
79 append body [format %02x $x]
81 append hdr 02
82 append body [format %04x $x]
86 append res $hdr
[all …]
H A Dtableapi.test83 append manyquote $manyquote
84 append manyquote $manyquote
85 append manyquote $manyquote
86 append manyquote $manyquote
87 append manyquote $manyquote
88 append manyquote $manyquote
199 append sql ${sep}x$i
202 append sql )
207 append sql ${sep}$i
210 append sql )
[all …]
H A Dfts2token.test32 append out $char
34 append out [format {\x%.4x} $i]
145 append output "1 \u0e19\u0e30 \u0e19\u0e30 "
146 append output "2 \u0e04\u0e23\u0e31\u0e1a \u0e04\u0e23\u0e31\u0e1a"
156 append longtoken "AReallocInTheIcuTokenizerCode"
159 append input $longtoken
161 append output "1 tokens tokens "
162 append output "2 then then "
163 append output "3 [string tolower $longtoken] $longtoken"
H A Dspeed4.test55 append txt " [lindex $::ones [expr {$n/100}]] hundred"
59 append txt " [lindex $::tens [expr {$n/10}]]"
63 append txt " [lindex $::ones $n]"
134 append sql "SELECT * FROM v[expr {($ii%3)+1}] WHERE rowid = [expr {$ii*3}];"
153 append sql "
180 append sql "INSERT INTO t4 VALUES(NULL, $ii, '[number_name $ii]');"
186 append sql "
193 append sql "DELETE FROM t4 WHERE rowid = $ii;"
212 append sql "INSERT INTO t4 VALUES(NULL, $ii, '[number_name $ii]');"
218 append sql "
[all …]
H A Dwhere3.test404 append sql " NATURAL JOIN t6z "
405 append sql $::predicate
411 append sql $::predicate
417 append sql $::predicate
423 append sql $::predicate
428 append sql " NATURAL JOIN t6z "
429 append sql $::predicate
434 append sql " NATURAL JOIN t6z "
435 append sql $::predicate
441 append sql $::predicate
[all …]
H A Dfts3atoken.test34 append out $char
36 append out [format {\x%.4x} $i]
215 append output "1 \u0e19\u0e30 \u0e19\u0e30 "
216 append output "2 \u0e04\u0e23\u0e31\u0e1a \u0e04\u0e23\u0e31\u0e1a"
226 append longtoken "AReallocInTheIcuTokenizerCode"
229 append input $longtoken
231 append output "1 tokens tokens "
232 append output "2 then then "
233 append output "3 [string tolower $longtoken] $longtoken"
H A DvtabC.test61 append sql " INSERT INTO vt$i VALUES(NEW.a+$i);\n"
63 append sql "END;"
84 append sql " INSERT INTO vt$i VALUES(NEW.a+$i*100);\n"
87 append sql " INSERT INTO vt$i VALUES(NEW.a+$i*10000);\n"
89 append sql "END;"
H A Djoin3.test31 for {set i 2} {$i<=$N} {incr i} {append sql ", t$i"}
43 for {set i 2} {$i<=$N} {incr i} {append sql ", t$i"}
46 append sql " $sep t[expr {$i+1}].x==t$i.x+1"
57 for {set i 2} {$i<=$bitmask_size} {incr i} {append sql ", t$i"}
H A DselectG.test30 append sql "($i),"
32 append sql "($i);"
45 append sql "($i),"
47 append sql "($i));"
H A Dtrans2.test41 append u [format %06x [expr {int(rand()*16777216)}]]
52 append x [lindex $rec 1]
60 append x [lindex $rec 3]
147 append modsql $s\n
148 append inssql $s\n
174 append modsql $s\n
197 append modsql $inssql
H A DmallocK.test23 append sql " AND b=y"
32 append sql " AND b!=$x"
40 append sql " AND b=$x"
50 append term " AND a!=$y"
52 append sql " OR $term)"
61 append sql " AND b!=$x"
H A Dfts3offsets.test34 append res [string range $text $iOff $s-1]
35 append res "("
36 append res [string range $text $s [expr $s+$n-1]]
37 append res ")"
40 append res [string range $text $iOff end]
H A DjoinF.test583 # append q1 "SELECT *\n"
584 # append q1 " FROM t1 $j1 JOIN t2 ON true\n"
585 # append q1 " $j2 JOIN t3 ON t2.y IS NOT NULL\n"
586 # append q1 " $j3 JOIN t4 ON true\n"
587 # append q1 " ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);"
597 # append q1 "SELECT *\n"
598 # append q1 " FROM t1 $j1 JOIN t2 ON true\n"
599 # append q1 " $j2 JOIN t3 ON t2.y IS NOT NULL\n"
600 # append q1 " $j3 JOIN t4 ON true\n"
601 # append q1 " WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)\n"
[all …]
H A DjoinE.test400 # append q1 "SELECT a, b\n"
401 # append q1 " FROM t1 $j1 JOIN t2 ON $on1\n"
402 # append q1 " ORDER BY coalesce(a,b,3);"
432 # append q1 "SELECT a, b\n"
433 # append q1 " FROM t1 $j1 JOIN t2 ON $on1\n"
434 # append q1 " ORDER BY coalesce(a,b,3);"
H A Dlock6.test45 append r $line
72 append script $line
73 append script " ; "
H A Denc.test86 append utf16le_tcl "\x00\x00"
96 append utf16be_tcl "\x00\x00"
113 append utf16le_bom "\xFF\xFE" $utf16le
118 append utf16be_bom "\xFE\xFF" $utf16be
/sqlite-3.40.0/ext/session/
H A Dsessionnoop.test139 append ret [binary format H2 01]
142 append ret [binary format H2 00]
145 append ret $name
146 append ret [binary format H2 00]
154 append ret [binary format H2 00]
156 append ret [binary format H2W 01 $a]
165 append C [mk_update_change 1 {} 1 {} {} 500]
166 append C [mk_update_change 2 {} {} {} {} {}]
167 append C [mk_update_change 3 3 {} {} 600 {}]
168 append C [mk_update_change 4 {} {} {} {} {}]
H A Dsession5.test227 append sql1 "INSERT INTO x1 VALUES($i*4, $i);"
230 append sql2 "DELETE FROM x1 WHERE a = $i*4;"
267 append sql1 "INSERT INTO x1 VALUES(randomblob(20+(random()%10)), $i);"
270 append sql2 "DELETE FROM x1 WHERE rowid = $i;"
285 append sql1 {
293 append sql2 "DELETE FROM x1 WHERE rowid = $i;"
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5unicode3.test122 append str {"unicode61 separators '}
124 append str [format %c $i]
126 append str {'");}
131 append str {"unicode61 tokenchars '}
133 append str [format %c $i]
135 append str {'");}
/sqlite-3.40.0/ext/fts1/
H A Dfts1.c1127 append(sb, azString[i]); in appendList()
1141 append(&sb, ") values (?"); in contentInsertStatement()
1143 append(&sb, ", ?"); in contentInsertStatement()
1144 append(&sb, ")"); in contentInsertStatement()
1160 append(&sb, ", "); in contentUpdateStatement()
1163 append(&sb, " = ?"); in contentUpdateStatement()
2069 append(&schema, ")"); in fulltextCreate()
2327 append(&sb, zBuf); in snippetOffsetText()
2386 append(p, " "); in appendWhiteSpace()
2470 append(&sb, zEllipsis); in snippetText()
[all …]
/sqlite-3.40.0/ext/wasm/
H A Ddemo-jsstorage.js25 eOutput.append(domElement);
30 ln.append(document.createTextNode(args.join(' ')));

12345