Home
last modified time | relevance | path

Searched refs:r3 (Results 1 – 22 of 22) sorted by relevance

/sqlite-3.40.0/test/
H A DtriggerD.test44 CREATE TRIGGER r3 BEFORE UPDATE ON t1 BEGIN
45 INSERT INTO log VALUES('r3.old', old.rowid, old.oid, old._rowid_, old.x);
46 INSERT INTO log VALUES('r3.new', new.rowid, new.oid, new._rowid_, new.x);
72 } {r3.old 100 200 300 400 r3.new 101 200 300 400 r4.old 100 200 300 400 r4.new 101 200 300 400}
94 CREATE TRIGGER r3 BEFORE UPDATE ON t1 BEGIN
95 INSERT INTO log VALUES('r3.old', old.rowid, old.oid, old._rowid_, old.x);
96 INSERT INTO log VALUES('r3.new', new.rowid, new.oid, new._rowid_, new.x);
123 } {r3.old 1 1 1 200 r3.new 1 1 1 201 r4.old 1 1 1 200 r4.new 1 1 1 201}
H A DjoinH.test43 CREATE TABLE r3(x);
49 SELECT 'value!' FROM r3 FULL JOIN r4 ON (y=x);
53 SELECT 'value!' FROM r3 FULL JOIN r4 ON (y=x) WHERE +y=55;
H A Daltertab2.test245 CREATE TRIGGER r3 AFTER INSERT ON t3 WHEN new.a NOT NULL BEGIN
253 SELECT sql FROM sqlite_master WHERE name = 'r3';
255 {CREATE TRIGGER r3 AFTER INSERT ON "t3x" WHEN new.a NOT NULL BEGIN
263 SELECT sql FROM sqlite_master WHERE name = 'r3';
265 {CREATE TRIGGER r3 AFTER INSERT ON "t3x" WHEN new.abcd NOT NULL BEGIN
H A Dzipfile.test114 set r3 [db eval $q3]
117 #puts $r3
120 uplevel [list do_test $tn.2 [list set {} $r3] $r1]
152 set r3 [do_unzip test_unzip.zip]
155 uplevel [list do_test $tn.2 [list set {} $r3] $r1]
H A Dupsert2.test81 CREATE TRIGGER r3 BEFORE UPDATE ON t1 BEGIN
132 CREATE TRIGGER r3 BEFORE UPDATE ON t1 BEGIN
H A De_expr.test1376 # second: CASE x WHEN w1 THEN r1 WHEN w2 THEN r2 ELSE r3 END CASE WHEN
1377 # x=w1 THEN r1 WHEN x=w2 THEN r2 ELSE r3 END
1387 CREATE TABLE t2(x, w1, r1, w2, r2, r3);
1393 SELECT CASE x WHEN w1 THEN r1 WHEN w2 THEN r2 ELSE r3 END FROM t2
1396 SELECT CASE WHEN x=w1 THEN r1 WHEN x=w2 THEN r2 ELSE r3 END FROM t2
1400 SELECT CASE ceval(x) WHEN w1 THEN r1 WHEN w2 THEN r2 ELSE r3 END FROM t2
1408 ELSE r3 END
1764 set r3 [db3 eval "SELECT typeof($castexpr), quote($castexpr)"]
1767 set res [expr {$r1!=$r2 && $r2!=$r3}]
1769 set res [expr {$r1==$r2 && $r2==$r3}]
H A Dtkt2767.test44 CREATE TRIGGER r3 BEFORE INSERT ON t1 BEGIN
H A Davtrans.test684 set r3 [expr {rand()}]
685 execsql "INSERT INTO t2 VALUES($r1,$r2,$r3)"
H A Dconflict.test66 set r3 $::sqlite_opentemp_count
67 list $r0 $r1 $r2 $r3
H A Dtrans.test717 set r3 [expr {rand()}]
718 execsql "INSERT INTO t2 VALUES($r1,$r2,$r3)"
H A Dconflict2.test66 set r3 $::sqlite_opentemp_count
67 list $r0 $r1 $r2 $r3
H A Daltercol.test899 CREATE TRIGGER r3 AFTER INSERT ON t1 BEGIN
908 } {1 {error in trigger r3: no such table: main.t3}}
H A Dauth.test2443 CREATE TRIGGER r3 INSTEAD OF DELETE ON v1 BEGIN
2464 SQLITE_INSERT v1chng {} main r3 \
2465 SQLITE_READ v1 x main r3 \
H A Dwithout_rowid4.test739 CREATE TRIGGER r3 INSTEAD OF UPDATE ON v1 BEGIN
H A Dtrigger2.test735 CREATE TRIGGER r3 INSTEAD OF UPDATE ON v1 BEGIN
H A Drowid.test397 CREATE TRIGGER r3 AFTER INSERT on t3 FOR EACH ROW BEGIN
/sqlite-3.40.0/ext/rtree/
H A Drtreecheck.test139 CREATE VIRTUAL TABLE r3 USING rtree_i32(id, x1, x2, y1, y2);
143 INSERT INTO r3 SELECT i, i, i, i, i FROM x;
150 SELECT rtreecheck('r3')=='ok'
157 SELECT rtreecheck('r3')=='ok'
H A Dgeopoly.c571 double r3 = r2*r; in geopolySine() local
572 double r5 = r3*r2; in geopolySine()
573 return 0.9996949*r - 0.1656700*r3 + 0.0075134*r5; in geopolySine()
/sqlite-3.40.0/ext/rbu/
H A Drbuprogress.test304 foreach {tn2 rbusql r1 r3} {
349 set R(pk) $r3
/sqlite-3.40.0/src/
H A Dexpr.c3632 int r3 = sqlite3GetTempReg(pParse); in sqlite3ExprCodeIN() local
3635 sqlite3VdbeAddOp3(v, OP_Column, iTab, i, r3); in sqlite3ExprCodeIN()
3636 sqlite3VdbeAddOp4(v, OP_Ne, rLhs+i, destNotNull, r3, in sqlite3ExprCodeIN()
3639 sqlite3ReleaseTempReg(pParse, r3); in sqlite3ExprCodeIN()
H A Dselect.c1421 int r1, r2, r3; in selectInnerLoop() local
1429 r3 = r2+nKey+1; in selectInnerLoop()
1438 sqlite3VdbeAddOp3(v, OP_MakeRecord, regResult, nResultCol, r3); in selectInnerLoop()
1440 sqlite3VdbeAddOp2(v, OP_IdxInsert, iParm+1, r3); in selectInnerLoop()
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5corrupt3.test12522 | 3056: 19 01 6d b3 0e 5f 55 6c 2b 21 72 33 84 a9 ab fb ..m.._Ul+!r3....