Home
last modified time | relevance | path

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

1234

/sqlite-3.40.0/ext/rtree/
H A Drtreecheck.test69 SELECT rtreecheck('r1')
78 SELECT rtreecheck('r1')
85 SELECT rtreecheck('r1')
92 SELECT rtreecheck('r1')
100 INSERT INTO r1 VALUES(3, -5, 5);
101 INSERT INTO r1 VALUES(4, 5, 0x11111111);
102 INSERT INTO r1 VALUES(5, 5, 0x00800000);
103 INSERT INTO r1 VALUES(6, 5, 0x00008000);
104 INSERT INTO r1 VALUES(7, 5, 0x00000080);
105 INSERT INTO r1 VALUES(8, 5, 0x40490fdb);
[all …]
H A Drtreeconnect.test30 CREATE VIRTUAL TABLE r1 USING rtree(id, x1, x2, y1, y2);
35 INSERT INTO r1 VALUES(new.id, new.x1, new.x2, new.y1, new.y2);
36 INSERT INTO log VALUES('r1: ' || new.id);
/sqlite-3.40.0/test/
H A DcorruptM.test43 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN SELECT 5; END;
45 } {table t1 t1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
50 } {table t1 {} | index i1 t1 | view v2 v2 | trigger r1 t1 |}
60 } {table t1 tx | index i1 t1 | view v2 v2 | trigger r1 t1 |}
69 } {tabl t1 t1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
78 } {table t9 t9 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
99 } {view t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
166 UPDATE sqlite_master SET type='view' WHERE name='r1';
168 } {table t1 t1 | index i1 t1 | view v2 v2 | view r1 t1 |}
174 } {1 {malformed database schema (r1)}}
[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 Dconflict.test62 }]} r1]
64 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
108 }]} r1]
110 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
112 list $r0 $r1 $r2
153 }]} r1]
155 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
201 }]} r1]
203 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
254 }]} r1]
[all …]
H A Dconflict2.test62 }]} r1]
64 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
108 }]} r1]
110 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
112 list $r0 $r1 $r2
153 }]} r1]
155 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
201 }]} r1]
203 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
254 }]} r1]
[all …]
H A Daltertrig.test43 CREATE TRIGGER r1 INSERT ON t1 BEGIN
52 CREATE TRIGGER r1 INSERT ON t1 BEGIN
58 DROP TRIGGER r1;
59 CREATE TRIGGER r1 INSERT ON t1 BEGIN
68 CREATE TRIGGER r1 INSERT ON t1 BEGIN
147 CREATE TRIGGER r1 INSERT ON t1 BEGIN
156 CREATE TRIGGER r1 INSERT ON t1 BEGIN
H A Dlastinsert.test97 create trigger r1 after insert on t1 for each row begin
135 drop trigger r1;
136 create trigger r1 after update on t1 for each row begin
177 drop trigger r1;
178 create trigger r1 instead of insert on v for each row begin
216 drop trigger r1; -- This was not created if views are disabled.
220 create trigger r1 before delete on t1 for each row begin
260 drop trigger r1;
261 create trigger r1 instead of update on v for each row begin
300 drop table t1; drop table t2; drop trigger r1;
[all …]
H A De_changes.test213 CREATE TABLE r1(a UNIQUE, b UNIQUE);
214 INSERT INTO r1 VALUES('i', 'i');
215 INSERT INTO r1 VALUES('ii', 'ii');
216 INSERT INTO r1 VALUES('iii', 'iii');
217 INSERT INTO r1 VALUES('iv', 'iv');
218 INSERT INTO r1 VALUES('v', 'v');
219 INSERT INTO r1 VALUES('vi', 'vi');
220 INSERT INTO r1 VALUES('vii', 'vii');
223 do_changes_test 3.3.1 { INSERT OR REPLACE INTO r1 VALUES('i', 1) } 1
224 do_changes_test 3.3.2 { INSERT OR REPLACE INTO r1 VALUES('iv', 'v') } 1
[all …]
H A Dtkt3810.test52 CREATE TEMP TRIGGER r1 AFTER INSERT ON t1 BEGIN
66 } {r1}
71 catchsql {DROP TRIGGER r1}
72 } {1 {no such trigger: r1}}
94 CREATE TEMP TRIGGER r1 DELETE ON t1 BEGIN SELECT *; END;
H A DtriggerD.test38 CREATE TRIGGER r1 BEFORE INSERT ON t1 BEGIN
39 INSERT INTO log VALUES('r1', new.rowid, new.oid, new._rowid_, new.x);
65 } {r1 100 200 300 400 r2 100 200 300 400}
88 CREATE TRIGGER r1 BEFORE INSERT ON t1 BEGIN
89 INSERT INTO log VALUES('r1', new.rowid, new.oid, new._rowid_, new.x);
116 } {r1 -1 -1 -1 200 r2 1 1 1 200}
144 # CREATE TRIGGER main.r1 AFTER INSERT ON t1 BEGIN
151 # The r1 trigger fires when the value 4 is inserted into the temp.t1
H A Dmemdb.test60 # set r1 [md5 $rx\n]
67 # puts "SIG($fn)=$r1"
186 }]} r1]
188 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
190 list $r0 $r1 $r2
256 "} r1]
258 if {!$r0} {set r1 [execsql {SELECT a FROM t1 ORDER BY b}]}
260 list $r0 $r1 $r2
H A Daltertab2.test149 CREATE TRIGGER r1 AFTER INSERT ON t1 WHEN new.a NOT NULL BEGIN
158 {CREATE TRIGGER r1 AFTER INSERT ON "t1x" WHEN new.a NOT NULL BEGIN
167 {CREATE TRIGGER r1 AFTER INSERT ON "t1x" WHEN new.aaa NOT NULL BEGIN
176 {CREATE TRIGGER r1 AFTER INSERT ON "t1x" WHEN new.aaa NOT NULL BEGIN
285 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
295 SELECT sql FROM sqlite_master WHERE name='r1'
297 {CREATE TRIGGER r1 AFTER INSERT ON "xyzzy" BEGIN
305 SELECT sql FROM sqlite_master WHERE name='r1'
307 {CREATE TRIGGER r1 AFTER INSERT ON "xyzzy" BEGIN
H A Dtkt3121.test29 CREATE TABLE r1(field);
32 INSERT INTO r1 VALUES('abcd');
36 CREATE VIRTUAL TABLE t1 USING echo(r1);
H A Drecover.test25 set r1 [$db1 eval $sql]
27 if {$r1 != $r2} {
28 puts "r1: $r1"
H A Dwith4.test42 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
45 } {1 {trigger r1 cannot reference objects in database aux}}
47 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
H A Dlaststmtchanges.test108 create trigger r1 after insert on t1 for each row begin
149 drop trigger r1;
151 create trigger r1 after update on t1 for each row begin
181 drop trigger r1;
183 create trigger r1 before delete on t1 for each row begin
231 create temp trigger r1 instead of insert on v1 for each row begin
H A Dauth.test996 } {r1 t1 temp {}}
1032 } {r1 t1 temp {}}
1068 } {r1 t1 temp {}}
1071 } {t1 r1}
1161 } {t1 r1}
1174 } {r1 t1 temp {}}
1177 } {t1 r1}
1189 } {t1 r1}
1202 } {r1 t1 temp {}}
1205 } {t1 r1}
[all …]
/sqlite-3.40.0/ext/lsm1/lsm-test/
H A Dlsmtest2.c223 int r1 = 0; in testCompareCksumLsmdb() local
226 r1 = strcmp(zCksum, zExpect1); in testCompareCksumLsmdb()
228 if( r1 && r2 ){ in testCompareCksumLsmdb()
261 int r1 = 0;
264 r1 = strcmp(zCksum, zExpect1);
266 if( r1 && r2 ){
/sqlite-3.40.0/ext/recover/
H A Drecoverfault.test19 set r1 [$db1 eval $sql]
21 if {$r1 != $r2} {
22 puts "r1: $r1"
H A Drecoverfault2.test19 set r1 [$db1 eval $sql]
21 if {$r1 != $r2} {
22 puts "r1: $r1"
H A Drecoverold.test18 set r1 [$db1 eval $sql]
20 if {$r1 != $r2} {
22 puts "r1: $r1"
/sqlite-3.40.0/src/
H A Dexpr.c660 int r1, r2; in codeVectorCompare() local
3180 int r1, r2; in sqlite3CodeRhsOfIN() local
3193 r1 = sqlite3GetTempReg(pParse); in sqlite3CodeRhsOfIN()
4118 return r1; in sqlite3ExprCodeTarget()
4506 r1 = pParse->nMem+1; in sqlite3ExprCodeTarget()
4534 r1 = 0; in sqlite3ExprCodeTarget()
4965 if( r2==r1 ){ in sqlite3ExprCodeTemp()
4966 *pReg = r1; in sqlite3ExprCodeTemp()
5197 int r1, r2; in sqlite3ExprIfTrue() local
5284 sqlite3VdbeTypeofColumn(v, r1); in sqlite3ExprIfTrue()
[all …]
H A Dselect.c935 sqlite3ReleaseTempReg(pParse, r1); in codeDistinct()
1260 int r1; in selectInnerLoop() local
1261 r1 = sqlite3GetTempReg(pParse); in selectInnerLoop()
1264 sqlite3ReleaseTempReg(pParse, r1); in selectInnerLoop()
1421 int r1, r2, r3; in selectInnerLoop() local
1427 r1 = sqlite3GetTempReg(pParse); in selectInnerLoop()
1452 sqlite3ReleaseTempReg(pParse, r1); in selectInnerLoop()
3013 int r1; in multiSelect() local
3069 r1 = sqlite3GetTempReg(pParse); in multiSelect()
3244 int r1; in generateOutputSubroutine() local
[all …]
/sqlite-3.40.0/ext/rbu/
H A Drbumulti.test66 set rc1 [r1 step]
74 if {$b1==0} { r1 close }
79 set rc1 [r1 close]
119 sqlite3rbu r1 test.db rbu.db
153 sqlite3rbu_vacuum r1 test.db

1234