Home
last modified time | relevance | path

Searched refs:k (Results 1 – 25 of 204) sorted by relevance

123456789

/sqlite-3.40.0/ext/fts5/test/
H A Dfts5auto.test41 {p i k j k q c t g u s} {g u y s m h q k g t e s o r}
69 {m k q} {k b a v o}
77 {o a f k k q p h g x e n z x} {h d w c o l}
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}
140 {l b p d v t k h y y} {u m k e c}
153 {r w k d l s y b} {q g k b}
155 {k k b x k l f} {r}
156 {} {q m z b k h k u n e z}
167 {y e} {e g s k e w t p v o b k}
204 {o e k t b k a z l w} {o p i h k c x}
[all …]
H A Dfts5ad.test93 3 {ab pqrst a fghi ab pqr fg} {k klmno a fg abcd}
95 5 {uvwxyz k abcde u a} {uv k k kl klmn}
96 6 {uvwxyz k klmn pqrst uv} {fghi pqrs abcde u k}
105 15 {abc abcde uvwxyz abc kl k pqr} {klm k k klmno u fgh}
125 35 {uvwxy ab uvwxy klmno kl pqrs} {abcde uvw pqrs uvwx k k}
127 37 {k kl uv abcde uvwx fg u} {u abc uvwxy k fg abcd}
129 39 {k pqrst k uvw fg pqrst fghij} {uvwxy ab kl klmn uvwxyz abcde}
130 40 {fg uvwxy pqrs klmn uvwxyz klm p} {k uv ab fghij fgh k pqrs}
133 43 {abcde ab pqrs fg f fgh} {abc fghij fghi k k}
174 84 {k klm abc uv uvwxy klm klmn} {k abc pqr a abc p kl}
[all …]
H A Dfts5ac.test28 0 {p o q e z k z p n f y u z y n y} {l o o l v v k}
31 3 {x g y m y m h p} {k j j b r e y y a k y}
34 6 {d a q i z h b l c p k j g k} {p x u j x t v c z}
37 9 {r k o m c c j s x m x m x m q r} {y r c a q d z k n x n}
40 12 {s y w a w d o h x m k} {c w k z b p o r a}
42 14 {b f i c s u z t k} {c k q s j u i z o}
44 16 {k s q e j n p} {t r j f t o e k k l m i}
51 23 {w u i u x t c h k i b} {b y k h b v r t g j}
54 26 {g s q w t d k x g f m j p k y} {r m b x e l t d}
114 86 {z n a y f b t k k t d b z a v} {r p c n r u k u}
[all …]
H A Dfts5ag.test44 {j s m y m r n l u k} {z k f u z g h s w g} {r n o s s b v n w w}
48 {v r w l e e t d z p} {c s b w k m n k o u} {w g y f v w v w v p}
55 {h d t o i a g b b p} {k x c i g f g b b k} {x f i v n a n n j i}
56 {f z k r b u s k z e} {n z v z w l e r h t} {t i s v v a v p n s}
57 {k f e c t z r e f d} {f m g r c w q k b v} {v y s y f r b f e f}
61 {y m s x k i m n x c} {b i a n v h z n k a} {w l q p b h h g d y}
63 {r k k j e o m k g b} {h b d c h m y b t u} {u j s h k z c u d y}
64 {v h i v s y z i k l} {d t m w q w c a z p} {r s e s x v d w k b}
69 {u w k a q b u w k w} {a h j u o w f s k p} {j o f s h y t j h g}
78 {v s g x k z a k a r} {l t g v j q l k p l} {f h n a x t v s t y}
[all …]
H A Dfts5al.test159 INSERT INTO t2 VALUES('q k n i k c a a e m', 'c h n j p g s c i t');
160 INSERT INTO t2 VALUES('h j g t r e l s g s', 'k q k c i i c k n s');
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');
162 INSERT INTO t2 VALUES('k r i l j b g i p a', 't q c h a i m g n l');
165 INSERT INTO t2 VALUES('s q k f q b j g h f', 'n m a o p e i e k t');
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');
/sqlite-3.40.0/test/
H A Dlastinsert.test53 update t1 set k=4 where k=2;
61 delete from t1 where k=4;
99 update t2 set k=k+10, val2=100+last_insert_rowid();
138 update t2 set k=k+10, val2=100+last_insert_rowid();
141 update t1 set k=14 where k=3;
180 update t2 set k=k+10, val2=100+last_insert_rowid();
222 update t2 set k=k+10, val2=100+last_insert_rowid();
225 delete from t1 where k=1;
263 update t2 set k=k+10, val2=100+last_insert_rowid();
266 update v set k=16 where k=14;
[all …]
H A Dunionall.test120 INSERT INTO t2_a SELECT new.k, new.v WHERE (new.k%2)==0;
121 INSERT INTO t2_b SELECT new.k, new.v WHERE (new.k%2)==1;
128 SELECT * FROM t1, t2 WHERE x=k;
142 SELECT x1.*, x2.* FROM t2 AS x1, t2 AS x2 WHERE x1.k=x2.k+1
182 SELECT * FROM t1, t2 WHERE x=k ORDER BY k,v||''
275 ORDER BY k;
294 ORDER BY k;
319 CREATE TABLE t2(k,v);
339 INSERT INTO t3_a SELECT new.k, new.v WHERE (new.k%2)==0;
340 INSERT INTO t3_b SELECT new.k, new.v WHERE (new.k%2)==1;
[all …]
H A Djoin2.test161 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
164 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v1+1);
176 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
184 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v1+1);
195 CREATE TABLE c1(k UNIQUE, v1);
196 CREATE TABLE c2(k UNIQUE, v2);
197 CREATE TABLE c3(k UNIQUE, v3);
208 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
211 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v1+1);
223 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
[all …]
H A Dfts3conf.test78 2 "INSERT OR ABORT $T1" 0 1 {{a b c d} {e f g h} {i j k l}}
79 3 "INSERT OR FAIL $T1" 0 1 {{a b c d} {e f g h} {i j k l}}
80 4 "INSERT OR IGNORE $T1" 0 0 {{a b c d} {e f g h} {i j k l}}
81 5 "INSERT OR REPLACE $T1" 0 0 {x {e f g h} {i j k l}}
84 7 "INSERT OR ABORT $T2" 1 1 {{a b c d} {e f g h} {i j k l}}
87 10 "INSERT OR REPLACE $T2" 1 0 {{a b c d} y {i j k l} z}
90 12 "UPDATE OR ABORT $T3" 0 1 {{a b c d} {e f g h} {i j k l}}
91 13 "UPDATE OR FAIL $T3" 0 1 {{a b c d} {e f g h} {i j k l}}
92 14 "UPDATE OR IGNORE $T3" 0 0 {{a b c d} {e f g h} {i j k l}}
93 15 "UPDATE OR REPLACE $T3" 0 0 {{a b c d} {i j k l}}
[all …]
H A Dupfrom2.test56 WITH data(k, v) AS (
59 UPDATE t1 SET z=v FROM data WHERE x=k;
71 CREATE TABLE t3(k, v);
92 WITH data(k, v) AS (
95 UPDATE t1 SET z=v FROM data WHERE x=k;
114 WITH data(k, v) AS (
117 UPDATE v1 SET z=v FROM data WHERE x=k;
152 WITH data(k, v) AS (
179 WITH data(k, v) AS (
201 WITH data(k, v) AS (
[all …]
H A Dtriggerupfrom.test18 CREATE TABLE map(k, v);
24 UPDATE t1 SET c = v FROM map WHERE k=new.a AND a=new.a;
50 UPDATE t1 SET b = y FROM aux.t3 WHERE k=new.a;
125 CREATE TABLE t1(k, a, b);
132 CREATE VIEW v1 AS SELECT k, a, b AS __hidden__b FROM t1;
151 UPDATE v1 SET a='xyz' WHERE k IN ('a', 'c');
160 CREATE TABLE map(k, v);
163 UPDATE v1 SET a=map.v FROM map WHERE v1.k=map.k;
H A Dincrblob_err.test34 CREATE TABLE blobs(k, v BLOB);
46 CREATE TABLE blobs(k, v BLOB);
61 CREATE TABLE blobs(k, v BLOB);
79 CREATE TABLE blobs(k, v BLOB);
87 CREATE TABLE blobs(k, v BLOB);
97 CREATE TABLE blobs(k, v BLOB);
109 CREATE TABLE blobs(k INTEGER PRIMARY KEY, v BLOB);
125 CREATE TABLE blobs(k INTEGER PRIMARY KEY, v BLOB);
H A Dlaststmtchanges.test106 create table t1 (k integer primary key);
107 create table t2 (k integer primary key, v1, v2);
156 update t1 set k=k;
217 create temp table t1 (k integer primary key);
218 create temp table t2 (k integer primary key);
221 create temp table n1 (k integer primary key, n);
222 create temp table n2 (k integer primary key, n);
235 insert into t1 values (NEW.k);
238 insert into v2 values (100+NEW.k);
243 insert into t2 values (1000+NEW.k);
[all …]
H A Dincrblob4.test21 CREATE TABLE t1(k INTEGER PRIMARY KEY, v);
26 set data [list a b c d e f g h i j k l m n o p q r s t u v w x y z]
64 execsql { DELETE FROM t1 WHERE k=10 }
65 execsql { DELETE FROM t1 WHERE k=9 }
84 execsql { UPDATE t1 SET v = $new WHERE k = 20 }
85 execsql { DELETE FROM t1 WHERE k=19 }
/sqlite-3.40.0/ext/misc/
H A Duint.c52 int k; in uintCollFunc() local
56 k = 0; in uintCollFunc()
57 while( i+k<nKey1 && isdigit(zA[i+k]) in uintCollFunc()
58 && j+k<nKey2 && isdigit(zB[j+k]) ){ in uintCollFunc()
59 k++; in uintCollFunc()
61 if( i+k<nKey1 && isdigit(zA[i+k]) ){ in uintCollFunc()
63 }else if( j+k<nKey2 && isdigit(zB[j+k]) ){ in uintCollFunc()
66 x = memcmp(zA+i, zB+j, k); in uintCollFunc()
68 i += k; in uintCollFunc()
69 j += k; in uintCollFunc()
H A Dnormalize.c563 int k; /* Loop counter */ in sqlite3_normalize() local
597 for(k=0; k<n; k++){ in sqlite3_normalize()
618 for(nParen=1, k=0; z[n+k]; k++){ in sqlite3_normalize()
619 if( z[n+k]=='(' ) nParen++; in sqlite3_normalize()
620 if( z[n+k]==')' ){ in sqlite3_normalize()
626 if( k<5 ){ in sqlite3_normalize()
627 z = sqlite3_realloc64(z, j+(5-k)+1); in sqlite3_normalize()
629 memmove(z+n+5, z+n+k, j-(n+k)); in sqlite3_normalize()
630 }else if( k>5 ){ in sqlite3_normalize()
631 memmove(z+n+5, z+n+k, j-(n+k)); in sqlite3_normalize()
[all …]
H A Duuid.c97 int i, k; in sqlite3UuidBlobToStr() local
99 k = 0; in sqlite3UuidBlobToStr()
100 for(i=0, k=0x550; i<16; i++, k=k>>1){ in sqlite3UuidBlobToStr()
101 if( k&1 ){ in sqlite3UuidBlobToStr()
H A Dfossildelta.c400 int j, k, x, y; in delta_create() local
416 for(k=1; k<iSrc && k<=i; k++){ in delta_create()
417 if( zSrc[iSrc-k]!=zOut[base+i-k] ) break; in delta_create()
419 k--; in delta_create()
422 ofst = iSrc-k; in delta_create()
423 cnt = j+k+1; in delta_create()
424 litsz = i-k; /* Number of bytes of literal text before the copy */ in delta_create()
427 sz = digit_count(i-k)+digit_count(cnt)+digit_count(ofst)+3; in delta_create()
432 bestOfst = iSrc-k; in delta_create()
/sqlite-3.40.0/tool/
H A Dmkkeywordhash.c405 int i, j, k, h; in main() local
446 for(k=0; k<=pOther->len-p->len; k++){ in main()
465 for(k=p->longestSuffix+1; k<p->len && k<pOther->len; k++){ in main()
466 if( memcmp(&p->zName[p->len-k], pOther->zName, k)==0 ){ in main()
483 for(k=p->len-1; k>=1; k--){ in main()
488 if( memcmp(&p->zName[p->len-k], pOther->zName, k)==0 ){ in main()
492 p->zName += k; in main()
493 p->len -= k; in main()
496 k = p->len; in main()
548 k += p->len; in main()
[all …]
H A Dsqldiff.c1086 for(k=1; k<iSrc && (unsigned int)k<=i; k++){ in rbuDeltaCreate()
1087 if( zSrc[iSrc-k]!=zOut[base+i-k] ) break; in rbuDeltaCreate()
1089 k--; in rbuDeltaCreate()
1702 k++; in changeset_one_table()
1705 k += 3; in changeset_one_table()
1708 k += 3; in changeset_one_table()
1714 k++; in changeset_one_table()
1717 k += 3; in changeset_one_table()
1720 k += 3; in changeset_one_table()
1729 k++; in changeset_one_table()
[all …]
/sqlite-3.40.0/ext/wasm/fiddle/
H A Dfiddle.js54 setItem: function(k,v){this.$$$[k]=v}, argument
55 getItem: function(k){ argument
56 return this.$$$.hasOwnProperty(k) ? this.$$$[k] : undefined;
58 removeItem: function(k){delete this.$$$[k]}, argument
124 set: (k,v)=>$storage.setItem(storageKeyPrefix+k,v),
126 setJSON: (k,v)=>$storage.setItem(storageKeyPrefix+k,JSON.stringify(v)),
130 storageKeyPrefix+k
151 contains: (k)=>$storageHolder.hasOwnProperty(storageKeyPrefix+k),
153 remove: function(k){
159 this.keys().forEach((k)=>$storage.removeItem(/*w/o prefix*/k));
[all …]
/sqlite-3.40.0/ext/wasm/api/
H A Dsqlite3-api-prologue.js170 ].forEach((k)=>{
171 if('function' === typeof config[k]){
172 config[k] = config[k]();
844 let i = 0, k;
846 f._opt(k,ov);
858 optName[k] = capi.sqlite3_compileoption_used(k);
1406 const k = s.key(i);
1407 if(k.startsWith(kvinfo.prefix)) toRm.push(k);
1438 const k = s.key(i);
1440 sz += k.length;
[all …]
/sqlite-3.40.0/src/
H A Dvdbevtab.c207 HashElem *k; in bytecodevtabColumn() local
213 for(k=sqliteHashFirst(&pSchema->tblHash); k; k=sqliteHashNext(k)){ in bytecodevtabColumn()
214 Table *pTab = (Table*)sqliteHashData(k); in bytecodevtabColumn()
222 for(k=sqliteHashFirst(&pSchema->idxHash); k; k=sqliteHashNext(k)){ in bytecodevtabColumn()
223 Index *pIdx = (Index*)sqliteHashData(k); in bytecodevtabColumn()
H A Dpragma.c1171 int i, k; in sqlite3Pragma() local
1194 k = 0; in sqlite3Pragma()
1196 k = 1; in sqlite3Pragma()
1198 for(k=1; k<=pTab->nCol && pPk->aiColumn[k-1]!=i; k++){} in sqlite3Pragma()
1248 for(k=sqliteHashFirst(pHash); 1; k=sqliteHashNext(k) ){ in sqlite3Pragma()
1270 for(k=sqliteHashFirst(pHash); k; k=sqliteHashNext(k) ){ in sqlite3Pragma()
1514 while( k ){ in sqlite3Pragma()
1517 k = 0; in sqlite3Pragma()
1520 k = sqliteHashNext(k); in sqlite3Pragma()
1943 for(k=pCheck->nExpr-1; k>0; k--){ in sqlite3Pragma()
[all …]
/sqlite-3.40.0/ext/wasm/jaccwabyt/
H A Djaccwabyt.js47 ['alloc','dealloc'].forEach(function(k){ argument
48 (config[k] instanceof Function) ||
49 toss("Config option '"+k+"' must be a function.");
214 const sPropName = (s,k)=>s+'::'+k; argument
334 const __memberKey = (k)=>memberPrefix + k + memberSuffix; argument
391 Object.keys(this.structInfo.members).forEach((k)=>a.push(this.memberKey(k)));
667 Object.keys(structInfo.members).forEach((k)=>{
668 const m = structInfo.members[k];
669 if(!m.sizeof) toss(structName,"member",k,"is missing sizeof.");
671 toss(structName,"member",k,"sizeof is not aligned.");
[all …]

123456789