Home
last modified time | relevance | path

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

/titanic_44/usr/src/lib/libsqlite/test/
H A Drowid.test18 # $Id: rowid.test,v 1.13 2004/01/14 21:59:24 drh Exp $
25 do_test rowid-1.1 {
33 do_test rowid-1.2 {
34 set r [execsql {SELECT rowid FROM t1 ORDER BY x}]
42 do_test rowid-1.3 {
44 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(1)"
47 do_test rowid-1.4 {
49 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(3)"
52 do_test rowid-1.5 {
57 do_test rowid-1.6 {
[all …]
H A Dioerr.test87 INSERT INTO t1 SELECT a+2, b||'-'||rowid, c||'-'||rowid FROM t1;
88 INSERT INTO t1 SELECT a+4, b||'-'||rowid, c||'-'||rowid FROM t1;
89 INSERT INTO t1 SELECT a+8, b||'-'||rowid, c||'-'||rowid FROM t1;
90 INSERT INTO t1 SELECT a+16, b||'-'||rowid, c||'-'||rowid FROM t1;
91 INSERT INTO t1 SELECT a+32, b||'-'||rowid, c||'-'||rowid FROM t1;
92 INSERT INTO t1 SELECT a+64, b||'-'||rowid, c||'-'||rowid FROM t1;
93 INSERT INTO t1 SELECT a+128, b||'-'||rowid, c||'-'||rowid FROM t1;
H A Dintpkey.test70 SELECT rowid, * FROM t1;
85 SELECT rowid, * FROM t1;
99 SELECT rowid, * FROM t1;
173 SELECT * FROM t1 WHERE b=='y' AND rowid<0
178 SELECT * FROM t1 WHERE b=='y' AND rowid<0 AND rowid>=-20
188 SELECT * FROM t1 WHERE b>='y' AND rowid<10
200 SELECT rowid, * FROM t1;
205 SELECT rowid, * FROM t1 WHERE b<'second'
210 SELECT rowid, * FROM t1 WHERE 'second'>b
215 SELECT rowid, * FROM t1 WHERE 8>rowid AND 'second'>b
[all …]
H A Dvacuum.test40 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
41 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
42 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
43 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
44 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
45 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
46 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
H A Dbind.test34 execsql {SELECT rowid, * FROM t1}
42 execsql {SELECT rowid, * FROM t1}
50 execsql {SELECT rowid, * FROM t1}
60 execsql {SELECT rowid, * FROM t1}
66 execsql {SELECT rowid, * FROM t1}
H A Dmisc2.test50 SELECT rowid, * FROM (SELECT * FROM t1, t2);
56 SELECT rowid, * FROM v1;
148 db eval {SELECT rowid FROM t1} {} {
149 db eval "DELETE FROM t1 WHERE rowid=$rowid"
156 db eval {SELECT rowid FROM t1} {} {
171 db eval {SELECT rowid FROM t1} {} {
172 db eval "DELETE FROM t1 WHERE rowid=$rowid"
179 db eval {SELECT rowid FROM t1} {} {
H A Dbigfile.test41 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
42 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
43 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
44 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
45 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
46 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
47 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
H A Dminmax.test160 SELECT coalesce(min(rowid),999) FROM t3;
170 SELECT coalesce(max(rowid),999) FROM t3;
175 SELECT coalesce(max(rowid),999) FROM t3 WHERE rowid<25;
269 SELECT max(rowid) FROM (
270 SELECT max(rowid) FROM t4 UNION SELECT max(rowid) FROM t5
276 SELECT max(rowid) FROM (
277 SELECT max(rowid) FROM t4 EXCEPT SELECT max(rowid) FROM t5
H A Dupdate.test529 SELECT count(*) FROM t2 WHERE a=rowid;
534 UPDATE t2 SET rowid=rowid-1;
535 SELECT count(*) FROM t2 WHERE a=rowid+1;
540 UPDATE t2 SET rowid=rowid+10000;
541 UPDATE t2 SET rowid=rowid-9999;
542 SELECT count(*) FROM t2 WHERE a=rowid;
551 SELECT count(*) FROM t2 WHERE a=rowid;
557 UPDATE t2 SET rowid=rowid-1;
558 SELECT count(*) FROM t2 WHERE a=rowid+1;
H A Dcapi2.test29 set VM [sqlite_compile $DB {SELECT name, rowid FROM sqlite_master} TAIL]
43 } {name rowid text INTEGER}
52 } {2 {} {name rowid text INTEGER}}
71 SELECT name, rowid FROM sqlite_master;
72 SELECT name, rowid FROM sqlite_temp_master;
78 SELECT name, rowid FROM sqlite_temp_master;
84 } {SQLITE_ROW 2 {t1 1} {name rowid text INTEGER}}
88 } {SQLITE_DONE 2 {} {name rowid text INTEGER}}
101 } {SQLITE_DONE 2 {} {name rowid text INTEGER}}
H A Dformat3.test483 SELECT * FROM t1 WHERE rowid IN (1,2,3,1234) order by 1;
488 SELECT * FROM t1 WHERE rowid+0 IN (1,2,3,1234) order by 1;
503 SELECT * FROM t1 WHERE rowid IN
504 (select rowid from t1 where rowid IN (-1,2,4))
510 SELECT * FROM t1 WHERE rowid+0 IN
511 (select rowid from t1 where rowid IN (-1,2,4))
518 (select rowid from t1 where rowid IN (-1,2,4))
525 (select rowid from t1 where rowid IN (-1,2,4))
H A Dwhere.test284 SELECT * FROM t1 WHERE rowid IN (1,2,3,1234) order by 1;
289 SELECT * FROM t1 WHERE rowid+0 IN (1,2,3,1234) order by 1;
304 SELECT * FROM t1 WHERE rowid IN
305 (select rowid from t1 where rowid IN (-1,2,4))
311 SELECT * FROM t1 WHERE rowid+0 IN
312 (select rowid from t1 where rowid IN (-1,2,4))
319 (select rowid from t1 where rowid IN (-1,2,4))
326 (select rowid from t1 where rowid IN (-1,2,4))
H A Dmisc1.test122 SELECT rowid, * FROM t1;
285 catchsql "SELECT count(*) FROM manycol $::where AND rowid>0"
295 catchsql "DELETE FROM manycol $::where AND rowid>0"
308 catchsql "UPDATE manycol SET x1=x1+1 $::where AND rowid>0"
508 SELECT rowid, a FROM test;
514 SELECT rowid, a FROM test;
520 SELECT rowid, a FROM test;
H A Dpragma.test258 SELECT rowid, * from t2;
271 } {{rowid 1 missing from index i2} {wrong # of entries in index i2}}
H A Dlimit.test85 SELECT count(*) FROM t1 WHERE rowid IN (SELECT rowid FROM t1 LIMIT 2);
H A Dmalloc.test209 INSERT INTO t2(x,y) VALUES(new.rowid,1);
H A Dmemdb.test354 SELECT rowid,* FROM t5;
H A Dauth.test925 INSERT INTO tx VALUES(NEW.rowid);
1733 catchsql {SELECT rowid,y,z FROM t3}
/titanic_44/usr/src/lib/libsqlite/src/
H A Dtclsqlite.c877 int rowid; in DbObjCmd() local
882 rowid = sqlite_last_insert_rowid(pDb->db); in DbObjCmd()
884 Tcl_SetIntObj(pResult, rowid); in DbObjCmd()