| /sqlite-3.40.0/ext/fts5/test/ |
| H A D | fts5af.test | 63 1.1 {X o o o o o o} {[X] o o o o o o} 82 2.11 {o o o o o o o X o o o} {...o o o [X] o o o} 83 2.12 {o o o o o o o X o o o o} {...o o o [X] o o o...} 91 3.5 {o o o o o o o X o o o o} {...o o o [X] o o o...} 92 3.6 {o o o o o o o o X o o o} {...o o o [X] o o o} 93 3.7 {o o o o o o o o o X o o} {...o o o o [X] o o} 94 3.8 {o o o o o o o o o o X o} {...o o o o o [X] o} 95 3.9 {o o o o o o o o o o o X} {...o o o o o o [X]} 119 8.1 {o o o o o o o o o X o o o o o o o o o o o o o o o o X X X o o o} 121 8.2 {o o o o o o o. o o X o o o o o o o o o o o o o o o o X X X o o o} [all …]
|
| H A D | fts5ae.test | 61 INSERT INTO t2 VALUES('u t l w w m s', 'm f m o l t k o p e'); 217 {v v c j o d a s c p} {f f v o k p o f o g} 251 0 {A o} {o o o C o o o o o o o o} 252 1 {o o B} {o o o C C o o o o o o o} 253 2 {A o o} {o o o o D D o o o o o o} 254 3 {o B} {o o o o o D o o o o o o} 255 4 {E o G} {H o o o o o o o o o o o} 256 5 {F o G} {I o J o o o o o o o o o} 257 6 {E o o} {H o J o o o o o o o o o} 258 7 {o o o} {o o o o o o o o o o o o} [all …]
|
| H A D | fts5auto.test | 45 {t m w z b g q t s d d h} {o n v u i t o y k j} 47 {} {m o s o x d y f a x j z} 59 {p x r u} {x i s w o t o g x m z i w} 63 {o u d n w o m o o s n t r h} {k p e u y p e z d j r y g} 68 {m f p v m a s p v c o s} {s c r z o t w l b e a q} 77 {o a f k k q p h g x e n z x} {h d w c o l} 111 {s o o s d s k q b f q v p e} {j r o b t o p d l o o x} 119 {l n p u o j d x t u u c o j} {k r n a r e k v i t o e} 135 {o d b s d o a u m o x y} {c} 151 {y e t j j z f p o m m z} {h k o g o} [all …]
|
| H A D | fts5ac.test | 28 0 {p o q e z k z p n f y u z y n y} {l o o l v v k} 40 12 {s y w a w d o h x m k} {c w k z b p o r a} 45 17 {g d t u w r o p m n m n p h b o u} {h s w o s l j e} 61 33 {c g n f u d o y o b} {e y o h x x y y i z s b h a j} 97 69 {c x f d x o n p o b r t b l p l} {m i t k b x v f p t m l l y r o} 102 74 {g d y n o h p s y q z j d w n h w} {x o d l t j i b r d o r y} 119 91 {c b o k l i c b s j n m b l} {y f p q o w g} 124 96 {f c x p y r b m o l m o a} {p c a q s u n n x d c f a o} 163 1.3 "o" 167 1.7 "l o o l v v k" [all …]
|
| H A D | fts5ag.test | 49 {k d g o u j p z n o} {t g e q l z i g b j} {f i q q j y h b g h} 52 {b c k s c w j p w b} {m o c o w o b d q q} {n t y o y z y r z e} 53 {p n q l e l h z q c} {n s e i h c v b b u} {m p d i t a o o f f} 54 {k c o n v e z l b m} {s m n i n s d e s u} {t a u e q d a o u c} 59 {u n p n u t i m e j} {p j j d m f k p m z} {d o l v c o e a h w} 66 {q l f d a p w l q o} {y z q w j o p b o v} {s u h z h f d f n l} 67 {q o e o x x l g q i} {j g m h q q w c d b} {o m d h w a g b f n} 74 {d g i o o x l f x d} {r t m f b n q y c b} {i u g k w x n m p o} 75 {t o s i q d z x d t} {v a k s q z j c o o} {z f n n r l y w v v} 80 {q z l t w o l m p e} {t s g h r p r o t z} {y b f a o n u m z g} [all …]
|
| H A D | fts5corrupt.test | 85 INSERT INTO t3 VALUES('one o'); 87 INSERT INTO t3 VALUES('three o'); 89 INSERT INTO t3 VALUES('five o'); 92 SELECT * FROM t3 WHERE t3 MATCH 'o' 93 } {{one o} {three o} {five o}} 97 SELECT * FROM t3 WHERE t3 MATCH 'o';
|
| H A D | fts5al.test | 157 INSERT INTO t2 VALUES('a s h g s b j m r h', 's b p a d b b a o e'); 158 INSERT INTO t2 VALUES('r h n t a g r d d i', 'l d n j r c f t o q'); 161 INSERT INTO t2 VALUES('b l k h d n n n m i', 'p t i a r b t q o l'); 163 INSERT INTO t2 VALUES('a e c q n m o m d g', 'l c t g i s q g q e'); 164 INSERT INTO t2 VALUES('b o j h f o g b p e', 'r t l h s b g i c p'); 166 INSERT INTO t2 VALUES('o q g g q c o k a b', 'r t k p t f t h p c'); 170 foreach {p c o} [$cmd xInst 0] {} 171 expr $c*100 + $o 228 SELECT rowid, rank FROM t2 WHERE t2 MATCH 'o + q + g' 234 SELECT rowid, rank FROM t2 WHERE t2 MATCH 'o + q + g' [all …]
|
| H A D | fts5content.test | 29 INSERT INTO f1(rowid, a, b) VALUES(1, 'one', 'o n e'); 30 INSERT INTO f1(rowid, a, b) VALUES(2, 'two', 't w o'); 35 SELECT rowid FROM f1 WHERE f1 MATCH 'o'; 39 INSERT INTO f1(a, b) VALUES('four', 'f o u r'); 40 SELECT rowid FROM f1 WHERE f1 MATCH 'o'; 44 SELECT rowid, a, b FROM f1 WHERE f1 MATCH 'o'; 57 FROM f1 WHERE f1 MATCH 'o'; 62 FROM f1 WHERE f1 MATCH 'o'; 94 SELECT rowid FROM f1 WHERE f1 MATCH 'o'; 126 INSERT INTO tbl VALUES(1, 'one', 'o n e'); [all …]
|
| /sqlite-3.40.0/ |
| H A D | main.mk | 57 alter.o analyze.o attach.o auth.o \ 58 backup.o bitvec.o btmutex.o btree.o build.o \ 60 date.o dbpage.o dbstat.o delete.o expr.o \ 62 fts3.o fts3_aux.o fts3_expr.o fts3_hash.o fts3_icu.o fts3_porter.o \ 66 fts3_write.o fts5.o func.o global.o hash.o \ 67 icu.o insert.o json.o legacy.o loadext.o \ 68 main.o malloc.o mem0.o mem1.o mem2.o mem3.o mem5.o \ 71 notify.o opcodes.o os.o os_kv.o os_unix.o os_win.o \ 72 pager.o pcache.o pcache1.o pragma.o prepare.o printf.o \ 76 update.o upsert.o userauth.o util.o vacuum.o \ [all …]
|
| H A D | mkso.sh | 25 echo gcc -shared *.o $TCLSTUBLIB -o tclsqlite3.so 26 gcc -shared *.o $TCLSTUBLIB -o tclsqlite3.so 28 rm tclsqlite.c tclsqlite.o 29 echo gcc -shared *.o -o sqlite3.so 30 gcc -shared *.o -o sqlite3.so
|
| H A D | aclocal.m4 | 244 test -z "$ac_objext" && ac_objext=o 1012 …p_private_externs -nostdlib -o \${lib}-master.o \$libobjs~\$CC -dynamiclib \$allow_undefined_flag … 1282 case `/usr/bin/file conftest.o` in 1343 case `/usr/bin/file conftest.o` in 1348 if ${LD-ld} -64 -r -o conftest2.o conftest.o >/dev/null 2>&1; then 5262 objext=o 5389 objext=o 6628 objext=o 6771 objext=o 6878 objext=o [all …]
|
| /sqlite-3.40.0/ext/lsm1/ |
| H A D | Makefile | 13 lsm_ckpt.o \ 14 lsm_file.o \ 15 lsm_log.o \ 16 lsm_main.o \ 17 lsm_mem.o \ 18 lsm_mutex.o \ 21 lsm_str.o \ 22 lsm_tree.o \ 23 lsm_unix.o \ 24 lsm_win32.o \ [all …]
|
| /sqlite-3.40.0/ext/session/ |
| H A D | session_speed_test.c | 269 struct Options o = { 2500, 0, 0, 0, "session_speed_test.db" }; in main() local 313 parse_command_line(argc, argv, 1, aOpt, (void*)&o, in main() 322 zDb2 = sqlite3_mprintf("%s2", o.zDb); in main() 326 if( o.bAll || (o.bWithoutRowid==bWithoutRowid && o.bInteger==bInteger) ){ in main() 333 unlink(o.zDb); in main() 334 rc = sqlite3_open(o.zDb, &db); in main() 341 execsql(db, azCreate[o.bWithoutRowid]); in main() 342 execsql(db2, azCreate[o.bWithoutRowid]); in main() 345 run_test(db, db2, o.nRow, azInsert[o.bInteger]); in main() 346 run_test(db, db2, o.nRow, azUpdate[o.bInteger]); in main() [all …]
|
| /sqlite-3.40.0/ext/fts5/tool/ |
| H A D | fts5txt2db.tcl | 54 foreach o $O { 55 if {[llength $o]==1} { 63 foreach o $O { 64 if {[llength $o]==3} { 65 foreach {a b c} $o {} 68 foreach {a b} $o {} 91 foreach o $O { 92 set nm [lindex $o 0] 93 set nArg [llength $o] 104 set idx(-$nm) $o [all …]
|
| /sqlite-3.40.0/test/ |
| H A D | types2.test | 109 CREATE INDEX t2i4 ON t2(o); 137 test_boolset types2-2.10 {o = 30} {9 10} 138 test_boolset types2-2.11 {o = 30.0} {9 10} 139 test_boolset types2-2.12 {o = '30'} 11 140 test_boolset types2-2.13 {o = '30.0'} 12 157 test_boolset types2-3.1 {o < 20} {1 2} 158 test_boolset types2-3.2 {o < 20.0} {1 2} 159 test_boolset types2-3.3 {o < '20'} {1 2 3 4 5 6 9 10} 269 test_boolset types2-6.1 {o IN ('10', 30)} {3 9 10} 336 test_boolset types2-8.7 {t IN (SELECT o FROM t4)} {} [all …]
|
| H A D | fts4opt.test | 49 1024*(o.level / 1024) + 32, -- level 50 sum(o.level<i.level OR (o.level=i.level AND o.idx>i.idx)), -- idx 51 o.start_block, o.leaves_end_block, o.end_block, o.root -- other 52 FROM %_segdir o, %_segdir i 53 WHERE (o.level / 1024) = (i.level / 1024) 54 GROUP BY o.level, o.idx;
|
| H A D | bigmmap.test | 90 SELECT * FROM t$t AS o WHERE 91 NOT EXISTS( SELECT * FROM t$t AS i WHERE a=o.a AND +b=o.b AND +c=o.c ) 96 SELECT * FROM t$t AS o WHERE 97 NOT EXISTS( SELECT * FROM t$t AS i WHERE a=o.a AND +b=o.b AND +c=o.c ) 101 |--SCAN o USING COVERING INDEX sqlite_autoindex_t${t}_1
|
| H A D | printf.test | 21 sqlite3_mprintf_int {abc: %d %x %o :xyz}\ 49 sqlite3_mprintf_int {abc: %d %x %o :xyz}\ 77 sqlite3_mprintf_int {abc: %d %x %o :xyz}\ 105 sqlite3_mprintf_int {abc: %d %x %o :xyz}\ 133 sqlite3_mprintf_int {abc: %d %x %o :xyz}\ 161 sqlite3_mprintf_int {abc: %d %x %o :xyz}\ 189 sqlite3_mprintf_int {abc: %d %x %o :xyz}\ 217 sqlite3_mprintf_int {abc: %d %x %o :xyz}\ 245 sqlite3_mprintf_int {abc: %d %x %o :xyz}\ 274 sqlite3_mprintf_int {abc: %d %x %o :xyz}\ [all …]
|
| H A D | fts4upfrom.test | 67 UPDATE ft SET b=o.c FROM ft AS o WHERE (ft.a == char(unicode(o.a)+1)) 106 WITH x1(o, n) AS ( 112 SELECT ft.rowid, a, b, c, o, n FROM ft, x1 WHERE ft.rowid = o; 123 WITH x1(o, n) AS ( 129 UPDATE ft SET $ROWID = n FROM x1 WHERE ft.rowid = o;
|
| H A D | spellfix4.test | 99 (0, 'a', 'o', 75), 103 (0, 'e', 'o', 72), 107 (0, 'i', 'o', 75), 109 (0, 'o', 'a', 75), 110 (0, 'o', 'e', 72), 111 (0, 'o', 'i', 75), 112 (0, 'o', 'u', 40), 116 (0, 'u', 'o', 40),
|
| H A D | upfrom3.test | 50 CREATE TABLE x1(o, n); 55 UPDATE t1 SET x=n FROM x1 WHERE x=o; 76 UPDATE t1 SET x=n FROM x1 WHERE x=o; 86 UPDATE t1 SET x=n FROM x1 WHERE x=o; 98 UPDATE OR REPLACE t1 SET x=n FROM x1 WHERE x=o; 111 CREATE TABLE x2(o, n, zz); 114 UPDATE OR IGNORE t1 SET x=n, z=zz FROM x2 WHERE x=o; 124 UPDATE OR REPLACE t1 SET x=n, z=zz FROM x2 WHERE x=o;
|
| /sqlite-3.40.0/tool/ |
| H A D | symbols-mingw.sh | 14 nm sqlite3.o | grep " [TD] " 17 nm sqlite3.o | grep " [TD] " | grep -v " .*sqlite3_" 25 nm sqlite3.o | grep " U " 33 nm sqlite3.o | grep " U "
|
| H A D | symbols.sh | 16 nm sqlite3.o | grep ' [TD] ' | sort -k 3 19 nm sqlite3.o | grep ' [TD] ' | 28 nm sqlite3.o | grep ' U ' | sort -k 3 36 nm sqlite3.o | grep ' U ' | sort -k 3
|
| H A D | run-speed-test.sh | 72 rm -f cachegrind.out.* speedtest1 speedtest1.db sqlite3.o 74 size sqlite3.o | tee -a summary-$NAME.txt 81 gcc -g -Os -Wall -I. $CC_OPTS $SRC ./sqlite3.o -o speedtest1 -ldl -lpthread 85 size sqlite3.o | tee -a summary-$NAME.txt
|
| /sqlite-3.40.0/ext/wasm/fiddle/ |
| H A D | fiddle.js | 159 this.keys().forEach((k)=>$storage.removeItem(/*w/o prefix*/k)); 766 const o = document.createElement('option'); 768 o.value = val; 769 if(!val) o.setAttribute('disabled',true); 770 o.appendChild(document.createTextNode(lbl)); 771 xElem.appendChild(o); 774 examples.forEach((o)=>newOpt(o.name, o.sql));
|