Home
last modified time | relevance | path

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

12345678910>>...20

/sqlite-3.40.0/test/
H A Drowid.test550 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5 ORDER BY rowid DESC}
553 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0 ORDER BY rowid DESC}
556 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5 ORDER BY rowid DESC}
559 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0 ORDER BY rowid DESC}
562 execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid ORDER BY rowid DESC}
565 execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid ORDER BY rowid DESC}
568 execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5 ORDER BY rowid DESC}
571 execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5 ORDER BY rowid DESC}
574 execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid ORDER BY rowid DESC}
577 execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid ORDER BY rowid DESC}
[all …]
H A Dboundary1.test242 SELECT a FROM t1 WHERE rowid > 16384 ORDER BY rowid
267 SELECT a FROM t1 WHERE rowid >= 16384 ORDER BY rowid
292 SELECT a FROM t1 WHERE rowid < 16384 ORDER BY rowid
817 SELECT a FROM t1 WHERE rowid > 2 ORDER BY rowid
842 SELECT a FROM t1 WHERE rowid >= 2 ORDER BY rowid
867 SELECT a FROM t1 WHERE rowid < 2 ORDER BY rowid
892 SELECT a FROM t1 WHERE rowid <= 2 ORDER BY rowid
932 SELECT a FROM t1 WHERE rowid > 4 ORDER BY rowid
957 SELECT a FROM t1 WHERE rowid >= 4 ORDER BY rowid
982 SELECT a FROM t1 WHERE rowid < 4 ORDER BY rowid
[all …]
H A Dboundary3.test123 SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=17
142 ORDER BY t1.rowid
175 ORDER BY t1.rowid
208 ORDER BY t1.rowid
270 SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=16
473 SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=36
676 SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=6
879 SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=29
1082 SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=21
1229 SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=41
[all …]
H A Dfts1f.test29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
36 DELETE FROM t1 WHERE rowid = 4;
37 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
41 DELETE FROM t1 WHERE rowid = 7;
45 DELETE FROM t1 WHERE rowid = 10;
50 DELETE FROM t1 WHERE rowid = 13;
54 DELETE FROM t1 WHERE rowid = 16;
58 DELETE FROM t1 WHERE rowid = 19;
[all …]
H A Dfts2f.test29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
36 DELETE FROM t1 WHERE rowid = 4;
37 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
41 DELETE FROM t1 WHERE rowid = 7;
45 DELETE FROM t1 WHERE rowid = 10;
50 DELETE FROM t1 WHERE rowid = 13;
54 DELETE FROM t1 WHERE rowid = 16;
58 DELETE FROM t1 WHERE rowid = 19;
[all …]
H A Dfts3af.test29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
36 DELETE FROM t1 WHERE rowid = 4;
37 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
41 DELETE FROM t1 WHERE rowid = 7;
45 DELETE FROM t1 WHERE rowid = 10;
50 DELETE FROM t1 WHERE rowid = 13;
54 DELETE FROM t1 WHERE rowid = 16;
58 DELETE FROM t1 WHERE rowid = 19;
[all …]
H A Dfts2e.test29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
33 DELETE FROM t1 WHERE rowid = 1;
37 DELETE FROM t1 WHERE rowid = 4;
38 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
41 DELETE FROM t1 WHERE rowid = 7;
45 DELETE FROM t1 WHERE rowid = 10;
49 DELETE FROM t1 WHERE rowid = 13;
53 DELETE FROM t1 WHERE rowid = 16;
57 DELETE FROM t1 WHERE rowid = 19;
[all …]
H A Dfts1e.test29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
33 DELETE FROM t1 WHERE rowid = 1;
37 DELETE FROM t1 WHERE rowid = 4;
38 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
41 DELETE FROM t1 WHERE rowid = 7;
45 DELETE FROM t1 WHERE rowid = 10;
49 DELETE FROM t1 WHERE rowid = 13;
53 DELETE FROM t1 WHERE rowid = 16;
57 DELETE FROM t1 WHERE rowid = 19;
[all …]
H A Dfts3ae.test29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
33 DELETE FROM t1 WHERE rowid = 1;
37 DELETE FROM t1 WHERE rowid = 4;
38 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
41 DELETE FROM t1 WHERE rowid = 7;
45 DELETE FROM t1 WHERE rowid = 10;
49 DELETE FROM t1 WHERE rowid = 13;
53 DELETE FROM t1 WHERE rowid = 16;
57 DELETE FROM t1 WHERE rowid = 19;
[all …]
H A Dunionvtab.test62 SELECT * FROM uuu WHERE rowid = 3;
63 SELECT * FROM uuu WHERE rowid = 11;
114 # 2.3.*: Non rowid tables.
130 } {1 {no such rowid table: t555}}
133 } {1 {no such rowid table: aux.t555}}
151 } {1 {no such rowid table: v1}}
154 } {1 {no such rowid table: v2}}
157 } {1 {no such rowid table: wr2}}
160 } {1 {no such rowid table: wr3}}
210 " {1 {rowid range mismatch error}}
[all …]
H A Dfts2a.test28 # rowid for each will be a bitmask for the elements it contains.
66 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
69 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two'}
100 execsql {SELECT rowid FROM t1 WHERE content MATCH '"one"'}
140 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
177 set rowid [db last_insert_rowid]
178 execsql {SELECT content FROM t1 WHERE rowid=$rowid}
181 execsql {SELECT rowid FROM t1 WHERE content MATCH NULL}
190 execsql {SELECT content FROM t1 WHERE rowid = 0}
196 execsql {SELECT content FROM t1 WHERE rowid = -1}
[all …]
H A Dfts1a.test28 # rowid for each will be a bitmask for the elements it contains.
66 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
69 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two'}
72 execsql {SELECT rowid FROM t1 WHERE content MATCH 'two one'}
100 execsql {SELECT rowid FROM t1 WHERE content MATCH '"one"'}
140 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
143 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one -two'}
146 execsql {SELECT rowid FROM t1 WHERE content MATCH '-two one'}
177 set rowid [db last_insert_rowid]
178 execsql {SELECT content FROM t1 WHERE rowid=$rowid}
[all …]
H A Dfts3aa.test29 # rowid for each will be a bitmask for the elements it contains.
67 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
141 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
178 set rowid [db last_insert_rowid]
179 execsql {SELECT content FROM t1 WHERE rowid=$rowid}
182 execsql {SELECT rowid FROM t1 WHERE content MATCH NULL}
191 execsql {SELECT content FROM t1 WHERE rowid = 0}
197 execsql {SELECT content FROM t1 WHERE rowid = -1}
200 execsql {SELECT rowid FROM t1 WHERE t1 MATCH 'four'}
228 INSERT INTO t0(rowid, content) VALUES(1, 'abc');
[all …]
H A Dfts2r.test32 INSERT INTO t1 (rowid, c) VALUES (1, 'This is a test');
34 INSERT INTO t1 (rowid, c) VALUES (3, 'This is a test');
39 SELECT rowid FROM t1 ORDER BY rowid;
45 SELECT rowid FROM t1 WHERE c LIKE '%test' ORDER BY rowid;
51 SELECT rowid FROM t1 WHERE c LIKE 'That%' ORDER BY rowid;
57 # queries which select by the rowid implicit index.
76 SELECT rowid FROM t1 WHERE rowid in (1, 2, 10);
82 SELECT t1.rowid, weight FROM t1, t2 WHERE t2.id = t1.rowid ORDER BY weight;
88 SELECT t1.rowid, weight FROM t1, t2
110 SELECT rowid FROM t1 WHERE t1 MATCH 'this' ORDER BY rowid;
[all …]
H A Dboundary4.test85 SELECT rowid, a, x FROM t1 ORDER BY +rowid
90 SELECT rowid, a, x FROM t1 ORDER BY rowid
100 SELECT rowid, a, x FROM t1 ORDER BY rowid DESC
145 UPDATE t1 SET rowid=a, a=rowid
170 SELECT a, rowid, x FROM t1 ORDER BY +rowid
175 SELECT a, rowid, x FROM t1 ORDER BY rowid
210 UPDATE t1 SET rowid=a, a=rowid
220 SELECT rowid, a, x FROM t1 ORDER BY +rowid
225 SELECT rowid, a, x FROM t1 ORDER BY rowid
280 UPDATE t1 SET rowid=a, a=rowid, x=z, z=x
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5onepass.test63 DELETE FROM ft WHERE rowid=new.x;
109 1 { UPDATE ft2 SET rowid=2 WHERE rowid=1 }
114 UPDATE ft2 SET rowid=5 WHERE rowid=4;
115 UPDATE ft2 SET rowid=3 WHERE rowid=5;
119 UPDATE ft2 SET rowid=3 WHERE rowid=4; -- matches 0 rows
120 UPDATE ft2 SET rowid=2 WHERE rowid=3;
125 UPDATE ft2 SET rowid=-1 WHERE rowid=4;
126 UPDATE ft2 SET rowid=3 WHERE rowid=-1;
132 UPDATE ft2 SET rowid = 2 WHERE rowid = 1;
162 DELETE FROM ttt WHERE rowid=1;
[all …]
H A Dfts5simple2.test98 do_execsql_test 6.1 { SELECT rowid FROM t1('a1') ORDER BY rowid DESC } {3 2 1}
99 do_execsql_test 6.2 { SELECT rowid FROM t1('b1') ORDER BY rowid DESC } {3 2 1}
112 do_execsql_test 7.1 { SELECT rowid FROM t1('b*') ORDER BY rowid DESC } {2 1}
113 do_execsql_test 7.2 { SELECT rowid FROM t1('a1') ORDER BY rowid DESC } {2 1}
130 do_execsql_test 8.0.8 { SELECT rowid FROM t1('c2') ORDER BY rowid DESC } {2}
140 do_execsql_test 8.2.3 { SELECT rowid FROM t1('c2') ORDER BY rowid DESC} {2}
181 SELECT rowid FROM t1('b1') ORDER BY rowid DESC;
232 foreach {rowid a} {
251 INSERT INTO t1(rowid, a) VALUES($rowid, $a);
292 SELECT rowid FROM t1('sqlite') ORDER BY rowid DESC;
[all …]
H A Dfts5restart.test46 if {$rowid == 100} {
49 lappend res $rowid
58 if {$rowid == 100} {
61 lappend res $rowid
117 if {$rowid==300} {
120 lappend res $rowid
128 db eval { SELECT rowid FROM n4 WHERE n4 MATCH '3' ORDER BY rowid DESC} {
129 if {$rowid==300} {
132 lappend res $rowid
140 db eval { SELECT rowid FROM n4 WHERE n4 MATCH '3' ORDER BY rowid DESC} {
[all …]
H A Dfts5ah.test127 1 0.6 {rowid > 5000} 5000
128 2 0.2 {rowid > 9000} 1000
129 3 0.2 {rowid < 1000} 999
131 5 0.6 {rowid >= 5000} 5001
132 6 0.2 {rowid >= 9000} 1001
133 7 0.2 {rowid <= 1000} 1000
134 8 0.6 {rowid > '5000'} 5000
135 9 0.2 {rowid > '9000'} 1000
136 10 0.1 {rowid = 444} 1
151 set q "SELECT rowid FROM t1 WHERE t1 MATCH 'x' AND $tail ORDER BY rowid DESC"
[all …]
H A Dfts5connect.test70 6 "DELETE FROM ft1 WHERE rowid=2" {}
98 INSERT INTO ft2(rowid, a, b) VALUES(new.rowid, new.a, new.b);
103 DELETE FROM ft2 WHERE rowid = old.rowid;
108 UPDATE ft2 SET a=new.a, b=new.b WHERE rowid=new.rowid;
122 6 "DELETE FROM t2 WHERE rowid=2" {}
149 INSERT INTO ft3(rowid, a, b) VALUES(new.rowid, new.a, new.b);
154 DELETE FROM ft3 WHERE rowid = old.rowid;
159 UPDATE ft3 SET a=new.a, b=new.b WHERE rowid=new.rowid;
200 INSERT INTO ft4(rowid, a, b) VALUES(new.rowid, new.a, new.b);
205 DELETE FROM ft4 WHERE rowid = old.rowid;
[all …]
H A Dfts5columnsize.test62 INSERT INTO t2(rowid, x) VALUES(1, 'c d e f');
69 SELECT rowid FROM t2 WHERE t2 MATCH 'h';
75 SELECT rowid FROM t2 WHERE t2 MATCH 'h';
81 SELECT rowid FROM t2 WHERE t2 MATCH 'h';
84 INSERT INTO t2(rowid, x) VALUES(1, 'o t t f');
85 INSERT INTO t2(rowid, x) VALUES(2, 'f s s e');
86 INSERT INTO t2(rowid, x) VALUES(3, 'n t e t');
90 SELECT rowid FROM t2
93 SELECT rowid FROM t2 WHERE rowid=2
96 SELECT rowid FROM t2 WHERE rowid BETWEEN 1 AND 3
[all …]
H A Dfts5aa.test62 SELECT rowid FROM t1 WHERE t1 MATCH $w ORDER BY rowid DESC;
212 execsql { REPLACE INTO t1(rowid,x,y,z) VALUES($rowid, $x, $y, $z) }
269 execsql { REPLACE INTO t1(rowid,x,y,z) VALUES($rowid, $x, $y, $z) }
300 do_execsql_test 10.2.$rowid.1 { DELETE FROM t1 WHERE rowid = $rowid }
494 SELECT rowid FROM uio WHERE rowid BETWEEN 8 AND 17
497 SELECT rowid FROM uio WHERE rowid BETWEEN 8 AND 17 ORDER BY rowid DESC
509 SELECT min(rowid), max(rowid) FROM uio;
514 SELECT min(rowid), max(rowid), count(*) FROM uio;
518 SELECT min(rowid), max(rowid), count(*) FROM uio WHERE rowid < 10;
530 SELECT t1.rowid, t2.rowid FROM t1, t2 WHERE t2 MATCH t1.a AND t1.rowid = t2.c
[all …]
H A Dfts5simple.test108 SELECT rowid FROM yy WHERE yy MATCH 'y' ORDER BY rowid ASC
112 SELECT rowid FROM yy WHERE yy MATCH 'y' ORDER BY rowid DESC
196 UPDATE ft2 SET rowid=2 WHERE rowid=1;
237 SELECT rowid FROM ft2('a');
253 SELECT rowid FROM t3('c: c*');
301 SELECT rowid FROM xx('x:a');
316 UPDATE OR REPLACE xy SET rowid=3 WHERE rowid = 2;
317 SELECT rowid, x FROM xy;
399 SELECT rowid FROM x4('""');
462 SELECT rowid FROM x1($doc);
[all …]
H A Dfts5content.test35 SELECT rowid FROM f1 WHERE f1 MATCH 'o';
40 SELECT rowid FROM f1 WHERE f1 MATCH 'o';
66 SELECT rowid FROM f1;
74 SELECT rowid, a, b FROM f1 ORDER BY rowid ASC;
82 DELETE FROM f1 WHERE rowid = 2;
86 UPDATE f1 SET a = 'a b c' WHERE rowid = 2;
94 SELECT rowid FROM f1 WHERE f1 MATCH 'o';
98 SELECT rowid FROM f1;
136 DELETE FROM tbl WHERE rowid=2;
177 SELECT rowid FROM t3 WHERE t3 MATCH 'e';
[all …]
H A Dfts5corrupt2.test59 1 { DELETE FROM t1_data WHERE rowid=$rowid }
60 2 { UPDATE t1_data SET block=14 WHERE rowid=$rowid }
63 foreach rowid [db eval {SELECT rowid FROM t1_data WHERE rowid>10}] {
67 do_test 1.$tno.$tn.1.$rowid {
73 if {($rowid & $mask)==0} {
99 set lrowid [db one {SELECT max(rowid) FROM t1_data WHERE (rowid & $mask)=0}]
148 foreach rowid [db eval {SELECT rowid FROM x3_data WHERE rowid>10}] {
149 if {$rowid & $mask} continue
195 foreach rowid [db eval {SELECT rowid FROM x4_data WHERE rowid>10}] {
202 WHERE id = $rowid;
[all …]

12345678910>>...20