Home
last modified time | relevance | path

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

/sqlite-3.40.0/test/
H A Dswarmvtab.test53 CREATE VIRTUAL TABLE temp.s1 USING swarmvtab('SELECT * FROM dir');
58 DROP TABLE s1;
62 CREATE VIRTUAL TABLE temp.s1 USING swarmvtab('SELECT * FROM dir');
63 SELECT count(*) FROM s1 WHERE rowid<50;
70 (SELECT group_concat(a || ',' || b, ',') FROM s1 WHERE $where)
89 SELECT count(*) FROM s1 a, s1 b WHERE b.rowid<=200;
92 SELECT count(*) FROM s1 a, s1 b, s1 c
160 CREATE VIRTUAL TABLE temp.s1 USING swarmvtab('SELECT * FROM dir');
180 SELECT * FROM s1 WHERE rowid BETWEEN 1 AND 100;
183 SELECT * FROM s1 WHERE rowid BETWEEN 101 AND 200;
[all …]
H A Drollbackfault.test42 set ::s1 [sqlite3_prepare db $sql1 -1 dummy]
45 for {set i 0} {$i < 10} {incr i} { sqlite3_step $::s1 }
57 while {"SQLITE_ROW" == [sqlite3_step $::s1]} {
58 lappend res1 [sqlite3_column_text $::s1 0]
63 set rc1 [sqlite3_finalize $::s1]
H A Dfkey7.test28 CREATE TABLE s1(a PRIMARY KEY, b);
29 CREATE TABLE par(a, b REFERENCES s1, c UNIQUE, PRIMARY KEY(a));
48 do_tblsread_test 1.2 { UPDATE par SET b=? WHERE a=? } {par s1}
51 do_tblsread_test 1.5 { UPDATE par SET a=?,b=?,c=? WHERE b=? } {c1 c2 c3 par s1}
H A Djoin2.test262 CREATE TABLE s1 (a INTEGER PRIMARY KEY);
268 SELECT s1.a FROM s1 left join s2 using (a);
269 } {SCAN s1}
272 SELECT s1.a FROM s1 left join s3 using (a);
273 } {SCAN s1}
H A Dcapi3d.test264 set ::s1 [sqlite3_prepare_v2 db "ROLLBACK" -1 notused]
265 sqlite3_step $::s1
269 sqlite3_stmt_busy $::s1
277 sqlite3_reset $::s1
285 sqlite3_finalize $::s1
H A Dunionvtab.test326 CREATE TABLE s1(k INTEGER PRIMARY KEY, v);
327 INSERT INTO s1 VALUES($S, 'one');
328 INSERT INTO s1 VALUES($S+1, 'two');
329 INSERT INTO s1 VALUES($S+2, 'three');
339 SELECT NULL, 's1', -9223372036854775808, -1"
H A Dfkey5.test365 CREATE TABLE k1(x REFERENCES s1);
375 } {k1 2 s1 0}
378 CREATE TABLE k2(x, y, FOREIGN KEY(x, y) REFERENCES s1(a, b));
392 } {k2 3 s1 0}
H A Dwalthread.test430 set s1 0
433 if {$c != $cnt || $s1 != $sum1 || $s2 != $sum2} {
436 incr s2 $s1
437 incr s1 $c
H A Dsavepoint.test906 SAVEPOINT s1;
915 SAVEPOINT s1;
917 ROLLBACK TO s1;
H A Dselect9.test108 set rc [regexp $RE $select -> s1 op s2 order_by]
111 set flipsql "$s2 $op $s1 $order_by"
H A Daltercol.test430 { CREATE VIEW s1 AS SELECT a, b, _x_ FROM t1 WHERE _x_='abc' COLLATE xyz }
/sqlite-3.40.0/tool/
H A Dshowwal.c35 unsigned s0, s1; /* Current checksum value */ member
74 pCksum->s1 = 0; in extendCksum()
84 pCksum->s0 += x0 + pCksum->s1; in extendCksum()
85 pCksum->s1 += x1 + pCksum->s0; in extendCksum()
229 unsigned int s0, s1; in print_oneline_frame() local
235 s1 = getInt32(aData+20); in print_oneline_frame()
243 s1, in print_oneline_frame()
244 (s0==pCksum->s0 && s1==pCksum->s1) ? "" : "cksum-fail" in print_oneline_frame()
250 pCksum->s1 = s1; in print_oneline_frame()
277 if( pCksum->s1!=getInt32(aData+28) ){ in print_wal_header()
[all …]
H A Dpagesig.c32 unsigned int s0 = 0, s1 = 0; in vlogSignature() local
40 s0 += pI[0] + s1; in vlogSignature()
41 s1 += pI[1] + s0; in vlogSignature()
45 sprintf(zCksum+i*2, "-%08x%08x", s0, s1); in vlogSignature()
H A Dlemon.c871 struct symbol *s1, *s2; in FindFirstSets() local
874 s1 = rp->lhs; in FindFirstSets()
878 progress += SetAdd(s1->firstset,s2->index); in FindFirstSets()
882 progress += SetAdd(s1->firstset,s2->subsym[j]->index); in FindFirstSets()
885 }else if( s1==s2 ){ in FindFirstSets()
886 if( s1->lambda==LEMON_FALSE ) break; in FindFirstSets()
888 progress += SetUnion(s1->firstset,s2->firstset); in FindFirstSets()
5207 int SetUnion(char *s1, char *s2) in SetUnion() argument
5213 if( s1[i]==0 ){ in SetUnion()
5215 s1[i] = 1; in SetUnion()
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5ab.test164 CREATE VIRTUAL TABLE s1 USING fts5(x, detail=%DETAIL%);
170 do_execsql_test 4.$tn { INSERT INTO s1 VALUES($doc) }
174 SELECT rowid FROM s1 WHERE s1 MATCH 'x'
179 SELECT rowid FROM s1 WHERE s1 MATCH '"a x"'
184 SELECT rowid FROM s1 WHERE s1 MATCH 'a x'
H A Dfts5aux.test168 s1 i
177 do_test 5.1.1 { sqlite3_step $s1 ; sqlite3_column_int $s1 0 } 1
182 do_test 5.2.1 { sqlite3_step $s1 ; sqlite3_column_int $s1 0 } 4
187 sqlite3_finalize $s1
H A Dfts5restart.test75 set ::s1 [sqlite3_prepare db "SELECT rowid FROM f1 WHERE f1 MATCH 'b'" -1 X]
78 sqlite3_step $::s1
85 sqlite3_finalize $::s1
/sqlite-3.40.0/ext/misc/
H A Dcksumvfs.c306 u32 s1 = 0, s2 = 0; in cksmCompute() local
318 s1 += *aData++ + s2; in cksmCompute()
319 s2 += *aData++ + s1; in cksmCompute()
324 s1 += BYTESWAP32(aData[0]) + s2; in cksmCompute()
325 s2 += BYTESWAP32(aData[1]) + s1; in cksmCompute()
328 s1 = BYTESWAP32(s1); in cksmCompute()
331 memcpy(aOut, &s1, 4); in cksmCompute()
H A Dvfslog.c355 unsigned int s0 = 0, s1 = 0; in vlogSignature() local
363 s0 += pI[0] + s1; in vlogSignature()
364 s1 += pI[1] + s0; in vlogSignature()
368 sqlite3_snprintf(18, zCksum+i*2, "-%08x%08x", s0, s1); in vlogSignature()
/sqlite-3.40.0/src/
H A Dvdbesort.c853 const int s1 = p1[1]; /* Left hand serial type */ in vdbeSorterCompareInt() local
859 assert( (s1>0 && s1<7) || s1==8 || s1==9 ); in vdbeSorterCompareInt()
862 if( s1==s2 ){ in vdbeSorterCompareInt()
865 const u8 n = aLen[s1]; in vdbeSorterCompareInt()
876 }else if( s1>7 && s2>7 ){ in vdbeSorterCompareInt()
877 res = s1 - s2; in vdbeSorterCompareInt()
881 }else if( s1>7 ){ in vdbeSorterCompareInt()
884 res = s1 - s2; in vdbeSorterCompareInt()
H A Dwal.c735 u32 s1, s2; in walChecksumBytes() local
740 s1 = aIn[0]; in walChecksumBytes()
743 s1 = s2 = 0; in walChecksumBytes()
752 s1 += *aData++ + s2; in walChecksumBytes()
753 s2 += *aData++ + s1; in walChecksumBytes()
757 s1 += BYTESWAP32(aData[0]) + s2; in walChecksumBytes()
758 s2 += BYTESWAP32(aData[1]) + s1; in walChecksumBytes()
763 aOut[0] = s1; in walChecksumBytes()
H A Dvdbeaux.c4548 u32 s1 = aKey1[1]; in sqlite3VdbeRecordCompareWithSkip() local
4549 if( s1<0x80 ){ in sqlite3VdbeRecordCompareWithSkip()
4552 idx1 = 1 + sqlite3GetVarint32(&aKey1[1], &s1); in sqlite3VdbeRecordCompareWithSkip()
4555 d1 = szHdr1 + sqlite3VdbeSerialTypeLen(s1); in sqlite3VdbeRecordCompareWithSkip()
/sqlite-3.40.0/ext/fts5/
H A Dfts5Int.h111 #define fts5Memcmp(s1, s2, n) ((n)<=0 ? 0 : memcmp((s1), (s2), (n))) argument
/sqlite-3.40.0/ext/rtree/
H A Drtree1.test444 SELECT count(*) FROM bar b1, bar b2, foo s1 WHERE s1.id = b1.id;
449 SELECT count(*) FROM bar b1, bar b2, foo s1
450 WHERE b1.minX <= b2.maxX AND s1.id = b1.id;
/sqlite-3.40.0/
H A Dconfigure3307 struct s1 {int (*f) (int a);};