Home
last modified time | relevance | path

Searched refs:o1 (Results 1 – 10 of 10) sorted by relevance

/sqlite-3.40.0/test/
H A Dtypes2.test92 test_bool types2-1.21 {o1=500} {500 = o1} 1
93 test_bool types2-1.22 {o1=500} {'500' = o1} 0
94 test_bool types2-1.23 {o1=500} {500.0 = o1} 1
95 test_bool types2-1.24 {o1=500} {'500.0' = o1} 0
96 test_bool types2-1.25 {o1='500'} {500 = o1} 0
97 test_bool types2-1.26 {o1='500'} {'500' = o1} 1
98 test_bool types2-1.27 {o1='500'} {500.0 = o1} 0
190 test_bool types2-4.21 {o1=500} {500 > o1} 0
191 test_bool types2-4.22 {o1=500} {'500' > o1} 1
192 test_bool types2-4.23 {o1=500} {500.0 > o1} 0
[all …]
H A Dupfrom2.test137 INSERT INTO o1 VALUES(0, 0, 'i', 'one');
138 INSERT INTO o1 VALUES(0, 1, 'ii', 'two');
139 INSERT INTO o1 VALUES(1, 0, 'iii', 'three');
140 INSERT INTO o1 VALUES(1, 1, 'iv', 'four');
142 CREATE TRIGGER tro1 BEFORE UPDATE ON o1 BEGIN
145 CREATE TRIGGER tro2 AFTER UPDATE ON o1 BEGIN
157 SELECT * FROM o1;
167 UPDATE o1 SET y=v FROM t2, t3 WHERE (1+o1.w*2+o1.x)=t2.a AND t3.k=t2.b;
169 SELECT * FROM o1;
184 SELECT * FROM o1;
[all …]
H A Dindexedby.test368 CREATE TABLE o1(x INTEGER PRIMARY KEY, y, z);
369 CREATE INDEX p1 ON o1(z);
370 CREATE INDEX p2 ON o1(y) WHERE z=1;
373 SELECT * FROM o1 INDEXED BY p2 ORDER BY 1;
378 CREATE INDEX p2 ON o1(y) WHERE z=1;
379 CREATE INDEX p1 ON o1(z);
382 SELECT * FROM o1 INDEXED BY p2 ORDER BY 1;
H A Dwindow4.tcl187 SELECT max(c) OVER ($p1 $o1 $r1),
192 SELECT sum(c) OVER ($p1 $o1 $r1),
197 set o1 [lindex $lOrder 0]
207 set o1 [lindex $lOrder 0]
226 foreach o1 $lOrder { foreach o2 $lOrder {
H A Dupfrom3.test166 CREATE TABLE map2(o1, o2, n1, n2);
170 UPDATE u1 SET b=n1, c=n2 FROM map2 WHERE b=o1 AND c=o2;
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5faultD.test29 CREATE VIRTUAL TABLE o1 USING fts5(a, b, c, detail=%DETAIL%);
30 INSERT INTO o1(o1, rank) VALUES('pgsz', 32);
33 INSERT INTO o1 SELECT 'A', 'B', 'C' FROM s;
36 INSERT INTO o1 SELECT 'C', 'A', 'B' FROM s;
39 INSERT INTO o1 SELECT 'B', 'C', 'A' FROM s;
45 execsql { SELECT count(*) FROM o1('a') }
53 execsql { SELECT * FROM o1('a:a AND {b c}:b') ORDER BY rank }
56 faultsim_test_result {0 1} {1 {vtable constructor failed: o1}}
62 execsql { SELECT * FROM o1('{b c}:b NOT a:a') ORDER BY rank }
71 execsql { SELECT * FROM o1('b:b OR a:a') }
[all …]
H A Dfts5faultA.test27 CREATE VIRTUAL TABLE o1 USING fts5(a, detail=%DETAIL%);
28 INSERT INTO o1(o1, rank) VALUES('pgsz', 32);
31 INSERT INTO o1 SELECT 'A B C' FROM s;
33 INSERT INTO o1 VALUES('A X C');
36 INSERT INTO o1 SELECT 'A B C' FROM s;
42 execsql { SELECT rowid FROM o1('a NOT b') }
H A Dfts5_common.tcl357 foreach {p1 c1 o1} [split $lhs .] {}
361 if {$res==0} { set res [expr $o1 - $o2] }
H A Dfts5corrupt3.test11658 | 1456: db fd 5a 7a 8c c7 43 c7 29 57 8b 6f 31 ea 13 af ..Zz..C.)W.o1...
/sqlite-3.40.0/ext/wasm/
H A DGNUmakefile560 .PHONY: o0 o1 o2 o3 os oz
567 o1: clean target