Home
last modified time | relevance | path

Searched refs:f2 (Results 1 – 25 of 33) sorted by relevance

12

/sqlite-3.40.0/test/
H A Dupdate.test63 execsql {UPDATE test1 SET f2=f2*3}
82 execsql {UPDATE test1 SET f2=f2/3 WHERE f1<=5}
88 execsql {UPDATE test1 SET f2=f2/3 WHERE f1>5}
128 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
132 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
167 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
171 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
252 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
256 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
336 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
[all …]
H A Dtrustschema1.test25 db function f2 -deterministic f1
43 } {1 {unsafe use of f2()}}
65 } {1 {unsafe use of f2()}}
77 } {1 {unsafe use of f2()}}
98 } {1 {unsafe use of f2()}}
123 } {1 {unsafe use of f2()}}
154 } {1 {unsafe use of f2()}}
174 db function f2 -deterministic f1
197 SELECT f2(b+c) FROM t1;
206 } {1 {unsafe use of f2()}}
[all …]
H A Dselect2.test21 execsql {CREATE TABLE tbl1(f1 int, f2 int)}
37 set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
39 lappend r $d2(f2)
51 set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
53 lappend r $d2(f2)
107 execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
111 execsql {CREATE INDEX idx1 ON tbl2(f2)}
114 execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
117 execsql {SELECT f1 FROM tbl2 WHERE f2=1000}
121 execsql {SELECT * FROM tbl2 WHERE 1000=f2}
[all …]
H A Dselect1.test62 execsql {SELECT *, min(f1,f2), max(f1,f2) FROM test1}
432 } {0 {f1 11 f2 22}}
437 } {0 {f1 11 f2 22}}
441 } {0 {f1 11 f2 22}}
445 } {0 {f1 11 f2 22}}
543 } {a.f1 11 a.f2 22 b.f1 11 b.f2 22}
621 ORDER BY f2;
781 } {f1 f2}
787 } {f1 f2}
793 } {f1 f2}
[all …]
H A Dtkt3718.test37 # Uses database handle [db] to execute "SELECT f2(<arg>)". Returns either
38 # the results or error message from the "SELECT f2(<arg>)" query to the
43 catch { db eval {SELECT f2($a)} } msg
49 # f2(<arg>)
54 proc f2 {args} {
61 db func f2 f2
99 catch { db eval {SELECT f2('three')} } msg
132 'INSERT INTO t2 SELECT a+10, f2(b) FROM t1'
H A Dfunc3.test24 sqlite3_create_function_v2 db f2 -1 any -func f2 -destroy destroy
28 sqlite3_create_function_v2 db f2 -1 utf8 -func f2
32 sqlite3_create_function_v2 db f2 -1 utf16le -func f2
36 sqlite3_create_function_v2 db f2 -1 utf16be -func f2
H A DwhereF.test126 # t2.rowid = +t1.rowid OR (t2.f2 = t1.f1 AND t1.f1!=-1)
129 # where there is an index on t2(f2). The planner should use "t1" as the
137 # t2.f2=$1 AND $1!=-1
141 # the loop through the f2=$1 range of the t2(f2) index.
146 CREATE TABLE t2(f2);
147 CREATE INDEX t2f ON t2(f2);
167 t2.rowid = +t1.rowid OR t2.f2 = t1.f1
174 t2.rowid = +t1.rowid OR (t2.f2 = t1.f1 AND t1.f1!=-1)
H A Dinsert.test94 f2 real default +4.32,
106 execsql {INSERT INTO test2(f2,f4) VALUES(1.23,-3.45)}
110 execsql {INSERT INTO test2(f1,f2,f4) VALUES(77,+1.23,3.45)}
118 f2 real default -4.32,
127 execsql {INSERT INTO test2(f2,f4) VALUES(-2.22,'hi!')}
142 CREATE INDEX index9 ON test2(f1,f2);
152 execsql {INSERT INTO test2(f2,f4) VALUES(-3.33,'hum')}
153 execsql {SELECT * FROM test2 WHERE f1='111' AND f2=-3.33}
156 execsql {INSERT INTO test2(f1,f2,f5) VALUES(22,-4.44,'wham')}
157 execsql {SELECT * FROM test2 WHERE f1='111' AND f2=-3.33}
[all …]
H A Dshell7.test25 CREATE TABLE f2(tn INTEGER PRIMARY KEY, x BLOB);
42 catchcmd test.db "INSERT INTO f2 VALUES($tn, readfile('shell7_test.bin'));"
46 SELECT (SELECT x FROM f1 WHERE tn=1)==(SELECT x FROM f2 WHERE tn=1)
H A Dwindow8.tcl91 set f2 "$frame EXCLUDE CURRENT ROW"
94 SELECT a, b, sum(c) OVER (ORDER BY a $f2) FROM t3 ORDER BY 1, 2, 3;
97 SELECT a, b, sum(c) OVER (ORDER BY a,b $f2) FROM t3 ORDER BY 1, 2, 3;
102 sum(c) OVER (ORDER BY a $f2),
104 sum(c) OVER (ORDER BY a,b $f2),
H A Dfuzzer1.test1487 AND f2.distance<=150
1495 AND f2.distance<=150
1503 AND f2.distance<=200
1504 AND streetname.n>=f2.word AND streetname.n<=(f2.word || x'F7BFBFBF')
1510 FROM f2 JOIN streetname
1511 ON (streetname.n>=f2.word AND streetname.n<=(f2.word || 'zzzzzz'))
1513 AND f2.distance<150
1514 AND f2.ruleset=3
1522 ON (streetname.n>=f2.word AND streetname.n<=(f2.word || 'zzzzzz'))
1524 AND f2.distance<150
[all …]
H A DcorruptL.test210 | 0: 0a 00 00 00 0a 0f aa 00 0f fa 0f f2 0f e9 0f e0 ................
219 | 0: 0a 00 00 00 0a 0f cf 00 0f fc 0f f7 0f f2 0f ed ................
278 | 160: 00 00 00 00 00 00 00 00 f2 00 00 00 00 00 00 00 ................
365 | 0: 0a 00 00 00 08 01 96 00 01 fa 01 c5 01 f2 01 bc ................
461 | 4064: 00 00 01 32 0f f2 00 07 00 00 00 06 05 00 00 00 ...2............
711 | 0: 0a 00 00 00 0a 0f aa 00 0f fa 0f f2 0f e9 0f e0 ................
720 | 0: 0a 00 00 00 0a 0f cf 00 0f fc 0f f7 0f f2 0f ed ................
746 | 64: 00 00 00 00 f2 ff 00 00 00 00 00 00 00 00 00 00 ................
752 | 160: 00 00 00 00 00 00 00 00 f2 00 00 00 00 00 00 00 ................
790 | 272: f2 00 00 00 00 00 00 00 00 00 f9 ff ff ff ff ff ................
[all …]
H A Dindex.test22 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
60 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
68 set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
80 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int, f4 int, f5 int)}
179 execsql {CREATE TABLE test1(f1 int, f2 int)}
222 execsql {CREATE TABLE test1(f1 int, f2 int primary key)}
229 execsql {SELECT f1 FROM test1 WHERE f2=65536}
H A Drowvalue9.test249 CREATE TABLE f2(c, d);
255 SELECT a, b FROM f1 UNION ALL SELECT c, d FROM f2
261 SELECT a, b FROM f1 UNION ALL SELECT c, d FROM f2
H A Ddbfuzz001.test126 | 32: 01 3d 01 2e 01 1f 01 10 01 01 00 f2 00 e3 00 d4 .=..............
259 | 0: 0a 00 00 00 08 01 96 00 01 fa 01 c4 01 f2 01 bc ................
340 | 0: 0a 00 00 00 08 01 96 00 01 fa 01 c4 01 f2 01 bc ................
H A Dtester.tcl2437 set f2 "sv_$f"
2438 forcecopy $f $f2
2448 foreach f2 [glob -nocomplain sv_test.db*] {
2449 set f [string range $f2 3 end]
2450 forcecopy $f2 $f
H A Ddelete.test36 execsql {CREATE TABLE table1(f1 int, f2 int)}
74 execsql {CREATE TABLE table2(f1 int, f2 int)}
/sqlite-3.40.0/ext/rbu/
H A Drburesume.test101 set f2 [string map [list test.db test.db2] $f]
103 forcecopy $f $f2
105 forcedelete $f2
160 set f2 [string map [list test.db test.db2] $f]
162 forcecopy $f $f2
164 forcedelete $f2
227 set f2 [string map [list test.db test.db2] $f]
229 forcecopy $f $f2
231 forcedelete $f2
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5fuzz1.test79 CREATE VIRTUAL TABLE f2 USING fts5(o, t, tokenize="ascii separators abc");
80 SELECT * FROM f2('a+4');
88 CREATE VIRTUAL TABLE f2 USING fts5(o, t);
89 SELECT * FROM f2('(8 AND 9)`AND 10');
H A Dfts5restart.test93 CREATE VIRTUAL TABLE f2 USING fts5(gg);
94 INSERT INTO f2 SELECT ff FROM f1 WHERE f1 MATCH 'b+c+d';
97 SELECT rowid FROM f2 WHERE f2 MATCH 'a+b+c+d+e'
H A Dfts5corrupt3.test3328 | 3824: f4 00 f3 80 f3 00 f2 80 f2 00 f1 80 f1 00 f0 80 ................
4479 | 0: 0d 00 00 00 03 0f f2 00 0f fc 0f f7 0f f2 00 00 ................
5107 | 0: 0d 00 00 00 03 0f f2 00 0f fc 0f f7 0f f2 00 00 ................
5324 | 0: 0d 00 00 00 03 0f f2 00 0f fc 0f f7 0f f2 00 00 ................
5785 | 0: 0d 00 00 00 03 0f f2 00 0f fc 0f f7 0f f2 00 00 ................
6029 | 0: 0d 00 00 00 03 0f f2 00 0f fc 0f f7 0f f2 00 00 ................
7558 | 0: 0d 00 00 00 03 0f f2 00 0f fc 0f f7 0f f2 00 00 ................
7997 | 0: 0d 00 00 00 03 0f f2 00 0f fc 0f f7 0f f2 00 00 ................
11147 | 2448: ff a9 f2 18 fe 46 5c 29 4b 43 df f2 7e 06 15 28 .....F.)KC..~..(
11752 | 2960: 21 f2 8d 34 37 b9 eb a0 86 d8 1a f2 9d aa 6a 53 !..47.........jS
[all …]
/sqlite-3.40.0/ext/rtree/
H A Drtree_util.tcl157 set f2 [lindex $cell $ii]
158 if {($ii%2)==1 && $f2<$f} {set f $f2}
159 if {($ii%2)==0 && $f2>$f} {set f $f2}
H A Drtreefuzz001.test72 | 176: 08 a5 0e 88 0d f2 0d 5c 0c 55 0b b5 0b 15 0a 75 .........U.....u
606 | 16: f9 10 f8 10 f7 00 f5 e0 f4 f0 f3 90 f2 90 f1 80 ................
865 | 3552: 00 01 12 f2 33 78 34 08 9f 24 04 00 01 13 02 34 ....3x4..$.....4
1002 | 2160: 08 00 00 00 0a 00 00 00 00 00 00 0b f2 00 00 00 ................
1020 | 2448: 0a 00 00 00 0c 00 00 00 00 00 00 03 f2 00 00 00 ................
1036 | 2704: 05 00 00 00 06 ff ff ff f2 00 00 00 04 00 00 00 ................
1101 | 3696: 00 00 f2 42 0a d7 04 44 00 00 ca 42 0a 77 05 44 ...B...D...B.w.D
1139 | 3024: 74 44 04 d7 0a 44 0e 20 00 42 c1 57 0a 42 f2 00 tD...D. .B.W.B..
/sqlite-3.40.0/ext/recover/
H A Drecovercorrupt2.test196 | 3296: c5 4c 31 13 05 06 1f 32 07 dd f2 2a a5 7e b2 4d .L1....2...*.~.M
257 | 3968: 06 01 dd f2 2a a5 7e b2 4d 82 13 0c 03 06 01 d9 ....*.~.M.......
273 | 4000: f2 07 04 01 01 01 02 41 ad 07 04 01 01 01 14 3e .......A.......>
/sqlite-3.40.0/src/
H A Dvdbeaux.c4376 int f1, f2; in sqlite3MemCompare() local
4380 f2 = pMem2->flags; in sqlite3MemCompare()
4381 combined_flags = f1|f2; in sqlite3MemCompare()
4388 return (f2&MEM_Null) - (f1&MEM_Null); in sqlite3MemCompare()
4398 testcase( f1 & f2 & MEM_Int ); in sqlite3MemCompare()
4399 testcase( f1 & f2 & MEM_IntReal ); in sqlite3MemCompare()
4404 if( (f1 & f2 & MEM_Real)!=0 ){ in sqlite3MemCompare()
4412 if( (f2&MEM_Real)!=0 ){ in sqlite3MemCompare()
4424 testcase( f2 & MEM_Int ); in sqlite3MemCompare()
4425 testcase( f2 & MEM_IntReal ); in sqlite3MemCompare()
[all …]

12