Home
last modified time | relevance | path

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

123

/sqlite-3.40.0/test/
H A Dwindow3.test381 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
398 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
415 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
432 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
449 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
466 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
483 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
500 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
517 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
534 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
[all …]
H A Dexpr.test373 test_expr expr-2.6 {r1=1.23, r2=2.34} {r2<r1} 0
374 test_expr expr-2.7 {r1=1.23, r2=2.34} {r2<=r1} 0
375 test_expr expr-2.8 {r1=1.23, r2=2.34} {r2>r1} 1
376 test_expr expr-2.9 {r1=1.23, r2=2.34} {r2>=r1} 1
377 test_expr expr-2.10 {r1=1.23, r2=2.34} {r2!=r1} 1
378 test_expr expr-2.11 {r1=1.23, r2=2.34} {r2=r1} 0
381 test_expr expr-2.14 {r1=2.34, r2=2.34} {r2<r1} 0
383 test_expr expr-2.16 {r1=2.34, r2=2.34} {r2>r1} 0
386 test_expr expr-2.19 {r1=2.34, r2=2.34} {r2=r1} 1
389 test_expr expr-2.22 {r1=1.23, r2=2.34} {min(r1,r2,r1+r2,r1-r2)} {-1.11}
[all …]
H A Dvtab_err.test36 CREATE TABLE r2(a, b, c);
37 INSERT INTO r2 SELECT * FROM e;
38 INSERT INTO e SELECT a||'x', b, c FROM r2;
57 CREATE TABLE r2(a, b, c);
58 INSERT INTO r2 SELECT * FROM e;
59 INSERT INTO e SELECT a||'x', b, c FROM r2;
H A Dtkt3121.test30 CREATE TABLE r2(col PRIMARY KEY, descr);
33 INSERT INTO r2 VALUES('abcd', 'A nice description');
34 INSERT INTO r2 VALUES('efgh', 'Another description');
37 CREATE VIRTUAL TABLE t2 USING echo(r2);
H A Dwindow2.test887 foreach r [set myres] r2 [set res2] {
888 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
889 error "list element [set i] does not match: got=[set r] expected=[set r2]"
924 foreach r [set myres] r2 [set res2] {
925 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
926 error "list element [set i] does not match: got=[set r] expected=[set r2]"
H A Drowvalue2.test252 CREATE TABLE r2(x TEXT, zY INTEGER);
256 INSERT INTO r2 VALUES(35, 36);
257 INSERT INTO r2 VALUES(35, 4);
258 INSERT INTO r2 VALUES(35, 35);
272 "SELECT * FROM r1, r2 WHERE $e2 ORDER BY iB" [db eval \
273 "SELECT * FROM r1, r2 WHERE $e1 ORDER BY iB"
H A DtriggerD.test41 CREATE TRIGGER r2 AFTER INSERT ON t1 BEGIN
42 INSERT INTO log VALUES('r2', new.rowid, new.oid, new._rowid_, new.x);
65 } {r1 100 200 300 400 r2 100 200 300 400}
91 CREATE TRIGGER r2 AFTER INSERT ON t1 BEGIN
92 INSERT INTO log VALUES('r2', new.rowid, new.oid, new._rowid_, new.x);
116 } {r1 -1 -1 -1 200 r2 1 1 1 200}
H A Dfilter2.test134 foreach r [set myres] r2 [set res2] {
135 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
136 error "list element [set i] does not match: got=[set r] expected=[set r2]"
H A Drecover.test26 set r2 [$db2 eval $sql]
27 if {$r1 != $r2} {
29 puts "r2: $r2"
H A Dpg_common.tcl119 foreach r [set myres] r2 [set res2] {
120 if {[set r]<([set r2]-$T) || [set r]>([set r2]+$T)} {
H A Dconflict.test65 set r2 [execsql {SELECT x FROM t2}]
67 list $r0 $r1 $r2 $r3
111 set r2 [execsql {SELECT x FROM t2}]
112 list $r0 $r1 $r2
156 set r2 [execsql {SELECT x FROM t2}]
157 list $r0 $r1 $r2
204 set r2 [execsql {SELECT x FROM t2}]
205 list $r0 $r1 $r2
257 set r2 [execsql {SELECT x FROM t2}]
258 list $r0 $r1 $r2
[all …]
H A Dconflict2.test65 set r2 [execsql {SELECT x FROM t2}]
67 list $r0 $r1 $r2 $r3
111 set r2 [execsql {SELECT x FROM t2}]
112 list $r0 $r1 $r2
156 set r2 [execsql {SELECT x FROM t2}]
157 list $r0 $r1 $r2
204 set r2 [execsql {SELECT x FROM t2}]
205 list $r0 $r1 $r2
257 set r2 [execsql {SELECT x FROM t2}]
258 list $r0 $r1 $r2
[all …]
H A Dauth.test882 } {r2 t2 main {}}
918 } {r2 t2 main {}}
955 } {r2 t2 main {}}
960 } {r2}
979 } {t2 tx r2}
1084 } {t2 tx r2}
1097 } {r2 t2 main {}}
1100 } {t2 tx r2}
1112 } {t2 tx r2}
1125 } {r2 t2 main {}}
[all …]
H A Dwindow4.tcl188 min(c) OVER ($p2 $o2 $r2)
193 sum(c) OVER ($p2 $o2 $r2)
200 set r2 [lindex $lRange 0]
211 foreach r1 $lRange { foreach r2 $lRange {
216 foreach r1 $lRows { foreach r2 $lRows {
223 set r2 [lindex $lRange 0]
H A Dround1.test34 set r2 $x1.$x4
35 set ans [string trimright $r2 0]
H A Daltertab2.test185 CREATE TRIGGER r2 AFTER INSERT ON t2 WHEN new.a NOT NULL BEGIN
204 SELECT sql FROM sqlite_master WHERE name = 'r2';
206 {CREATE TRIGGER r2 AFTER INSERT ON "t2x" WHEN new.a NOT NULL BEGIN
221 SELECT sql FROM sqlite_master WHERE name = 'r2';
223 {CREATE TRIGGER r2 AFTER INSERT ON "t2x" WHEN new.aaaa NOT NULL BEGIN
/sqlite-3.40.0/ext/lsm1/lsm-test/
H A Dlsmtest2.c224 int r2 = -1; in testCompareCksumLsmdb() local
227 if( zExpect2 ) r2 = strcmp(zCksum, zExpect2); in testCompareCksumLsmdb()
228 if( r1 && r2 ){ in testCompareCksumLsmdb()
262 int r2 = -1;
265 if( zExpect2 ) r2 = strcmp(zCksum, zExpect2);
266 if( r1 && r2 ){
/sqlite-3.40.0/ext/recover/
H A Drecoverfault.test20 set r2 [$db2 eval $sql]
21 if {$r1 != $r2} {
23 puts "r2: $r2"
H A Drecoverfault2.test20 set r2 [$db2 eval $sql]
21 if {$r1 != $r2} {
23 puts "r2: $r2"
H A Drecoverold.test19 set r2 [$db2 eval $sql]
20 if {$r1 != $r2} {
23 puts "r2: $r2"
H A Drecover1.test18 set r2 [$db2 eval $sql]
19 if {$r1 != $r2} {
21 puts "r2: $r2"
/sqlite-3.40.0/ext/rtree/
H A Drtreecheck.test111 CREATE VIRTUAL TABLE r2 USING rtree_i32(id, x1, x2);
112 INSERT INTO r2 VALUES(2, -1*(1<<31), -1*(1<<31)+5);
113 SELECT rtreecheck('r2')
120 SELECT rtreecheck('r2')!='ok';
126 SELECT rtreecheck('r2')!='ok';
/sqlite-3.40.0/ext/rbu/
H A Drbumulti.test70 set rc2 [r2 step]
75 if {$b2==0} { r2 close }
80 set rc2 [r2 close]
121 sqlite3rbu r2 test.db2 rbu.db2
155 sqlite3rbu r2 test.db2 rbu.db2
/sqlite-3.40.0/src/
H A Dvdbesort.c763 UnpackedRecord *r2 = pTask->pUnpacked; in vdbeSorterCompareTail() local
790 UnpackedRecord *r2 = pTask->pUnpacked; in vdbeSorterCompare() local
795 return sqlite3VdbeRecordCompare(nKey1, pKey1, r2); in vdbeSorterCompare()
2739 UnpackedRecord *r2; in sqlite3VdbeSorterCompare() local
2746 r2 = pSorter->pUnpacked; in sqlite3VdbeSorterCompare()
2748 if( r2==0 ){ in sqlite3VdbeSorterCompare()
2750 if( r2==0 ) return SQLITE_NOMEM_BKPT; in sqlite3VdbeSorterCompare()
2751 r2->nField = nKeyCol; in sqlite3VdbeSorterCompare()
2753 assert( r2->nField==nKeyCol ); in sqlite3VdbeSorterCompare()
2756 sqlite3VdbeRecordUnpack(pKeyInfo, nKey, pKey, r2); in sqlite3VdbeSorterCompare()
[all …]
H A Dexpr.c660 int r1, r2; in codeVectorCompare() local
3180 int r1, r2; in sqlite3CodeRhsOfIN() local
3194 r2 = sqlite3GetTempReg(pParse); in sqlite3CodeRhsOfIN()
3216 sqlite3ReleaseTempReg(pParse, r2); in sqlite3CodeRhsOfIN()
3513 int r2, regToFree; in sqlite3ExprCodeIN() local
3539 int op = rLhs!=r2 ? OP_Ne : OP_IsNull; in sqlite3ExprCodeIN()
4953 int r2; in sqlite3ExprCodeTemp() local
4965 if( r2==r1 ){ in sqlite3ExprCodeTemp()
4972 return r2; in sqlite3ExprCodeTemp()
5197 int r1, r2; in sqlite3ExprIfTrue() local
[all …]

123