Home
last modified time | relevance | path

Searched refs:id (Results 1 – 25 of 217) sorted by relevance

123456789

/sqlite-3.40.0/test/
H A Djoin9.test113 SELECT *, t4.id, t5.id, t6.id
124 SELECT *, t4.id, t5.id, t6.id
134 SELECT *, t4.id, t5.id, t6.id
146 SELECT id, x, y, z, t4.id, t5.id, t6.id
157 SELECT id, x, y, z, t4.id, t5.id, t6.id
169 SELECT *, t4.id, t5.id, t6.id
225 SELECT id, x, y, z, t4.id, t5.id, t6.id
240 SELECT id, x, y, z, t4.id, t5.id, t6.id
255 SELECT id, x, y, z, t4.id, t5.id, t6.id
270 SELECT id, x, y, z, t4.id, t5.id, t6.id
[all …]
H A Dclosure01.test62 SELECT id, depth FROM below ORDER BY id;
78 SELECT id, depth FROM below ORDER BY id;
86 ORDER BY id;
146 SELECT count(*), min(id), max(id) FROM cx WHERE root=1 AND depth=5;
157 SELECT count(*), min(id), max(id) FROM below WHERE depth=5;
171 SELECT count(*), min(id), max(id) FROM c2 WHERE root=1;
183 SELECT id FROM c2 WHERE root IN (10,12) ORDER BY id;
187 SELECT id FROM c2 WHERE root IN (10,12) ORDER BY +id;
214 ORDER BY id;
228 ORDER BY id;
[all …]
H A Daffinity3.test29 SELECT c.id, i.apr
31 LEFT JOIN apr i ON i.id=c.id;
34 SELECT c.id, i.apr
36 RIGHT JOIN customer c ON i.id=c.id;
39 SELECT c.id, v1.apr
41 LEFT JOIN v1 ON v1.id=c.id;
44 SELECT c.id, v1.apr
45 FROM v1 RIGHT JOIN customer c ON v1.id=c.id;
48 SELECT c.id, v1rj.apr
49 FROM v1rj RIGHT JOIN customer c ON v1rj.id=c.id;
[all …]
H A Dtkt3419.test25 create table a(id integer primary key);
26 create table b(id integer primary key, a_id integer);
27 create table c(id integer primary key, b_id integer);
44 select * FROM a, b, c WHERE a.id=2 AND b.a_id = a.id AND b.id=c.b_id;
49 select * FROM a, c, b WHERE a.id=2 AND b.a_id = a.id AND b.id=c.b_id;
54 select * FROM b, a, c WHERE a.id=2 AND b.a_id = a.id AND b.id=c.b_id;
59 select * FROM b, c, a WHERE a.id=2 AND b.a_id = a.id AND b.id=c.b_id;
64 select * FROM c, a, b WHERE a.id=2 AND b.a_id = a.id AND b.id=c.b_id;
69 select * FROM c, b, a WHERE a.id=2 AND b.a_id = a.id AND b.id=c.b_id;
H A Dcrash4.test29 {CREATE TABLE a(id INTEGER, name CHAR(50))}
30 {INSERT INTO a(id,name) VALUES(1,'one')}
31 {INSERT INTO a(id,name) VALUES(2,'two')}
32 {INSERT INTO a(id,name) VALUES(3,'three')}
33 {INSERT INTO a(id,name) VALUES(4,'four')}
34 {INSERT INTO a(id,name) VALUES(5,'five')}
35 {INSERT INTO a(id,name) VALUES(6,'six')}
36 {INSERT INTO a(id,name) VALUES(7,'seven')}
37 {INSERT INTO a(id,name) VALUES(8,'eight')}
38 {INSERT INTO a(id,name) VALUES(9,'nine')}
[all …]
H A Dtrans2.test83 id INTEGER PRIMARY KEY,
90 foreach {id u1 z u2} $rec break
111 set id [lindex $rec 0]
112 if {$id>$max1} {set max1 $id}
124 foreach id $todel {
125 set rec [list $id [random_uuid] \
131 set id [expr {$max_rowid+$j}]
132 lappend todel $id
185 z = CASE WHEN id<$max1
215 z = CASE WHEN id<$max1
[all …]
H A Djson101.test134 INSERT INTO j2(id,json,src)
159 INSERT INTO j2(id,json,src)
161 "id": "0001",
177 { "id": "5001", "type": "None" },
186 INSERT INTO j2(id,json,src)
189 "id": "0001",
215 "id": "0002",
236 "id": "0003",
261 SELECT id, json_valid(json), json_type(json), '|' FROM j2 ORDER BY id;
764 CREATE TABLE t1(id, json);
[all …]
H A Djoin7.test18 foreach {id schema} {
107 do_execsql_test join7-$id.10 {
117 do_execsql_test join7-$id.20 {
126 do_execsql_test join7-$id.30 {
134 do_execsql_test join7-$id.31 {
142 do_execsql_test join7-$id.32 {
150 do_execsql_test join7-$id.33 {
159 do_execsql_test join7-$id.34 {
169 do_execsql_test join7-$id.35 {
180 do_execsql_test join7-$id.36 {
[all …]
H A Ddelete2.test43 CREATE TABLE q(s string, id string, constraint pk_q primary key(id));
45 INSERT INTO q(s,id) VALUES('hello','id.1');
46 INSERT INTO q(s,id) VALUES('goodbye','id.2');
47 INSERT INTO q(s,id) VALUES('again','id.3');
51 } {hello id.1 goodbye id.2 again id.3}
54 SELECT * FROM q WHERE id='id.1';
56 } {hello id.1}
81 } {goodbye id.2 again id.3}
97 } {goodbye id.2 again id.3}
H A Dtkt3357.test33 SELECT cc.id, cc.b_id, cc.myvalue, dd.bvalue
35 SELECT DISTINCT a.id, a.b_id, a.myvalue FROM a
38 LEFT OUTER JOIN b dd ON cc.b_id = dd.id
44 SELECT cc.id, cc.b_id, cc.myvalue
46 SELECT a.id, a.b_id, a.myvalue
47 FROM a, b WHERE a.b_id = b.id
49 LEFT OUTER JOIN b dd ON cc.b_id = dd.id
55 SELECT cc.id, cc.b_id, cc.myvalue
57 SELECT DISTINCT a.id, a.b_id, a.myvalue
58 FROM a, b WHERE a.b_id = b.id
[all …]
H A Dtrigger4.test25 create table test2(id integer,b);
27 select test1.id as id,a as a,b as b
28 from test1 join test2 on test2.id = test1.id;
31 insert into test1 (id,a) values (NEW.id,NEW.a);
32 insert into test2 (id,b) values (NEW.id,NEW.b);
61 update test1 set a=NEW.a where id=NEW.id;
62 update test2 set b=NEW.b where id=NEW.id;
64 update test set a=22 where id=1;
77 update test set b=66 where id=4;
112 create table test2(id,b);
[all …]
H A DwhereL.test76 id INTEGER PRIMARY KEY,
83 INSERT INTO A(id) VALUES(1);
90 WHERE A.id='1'
91 AND A.id=subq.yy
92 AND B.id=subq.zz;
99 WHERE A.id=1
100 AND A.id=subq.yy
101 AND B.id=subq.zz;
108 WHERE A.id='1'
109 AND A.id=subq.yy
[all …]
H A Dinsert5.test76 uses_temp_table { INSERT INTO b SELECT (SELECT id FROM b), id1 FROM main }
79 uses_temp_table { INSERT INTO b SELECT id1, (SELECT id FROM b) FROM main }
84 SELECT * FROM main WHERE id = (SELECT id1 FROM b WHERE main.id = b.id) }
95 SELECT * FROM main WHERE id > 10 AND max(id1, (SELECT id FROM b)) > 10;
99 # UPDATE: Using a column from the outer query (main.id) in the GROUP BY
106 # WHERE id > 10 AND (SELECT count(*) FROM v2 GROUP BY main.id)
113 WHERE id > 10 AND (SELECT count(*) FROM v2 GROUP BY main.id)
115 } {1 {no such column: main.id}}
H A Dsubquery2.test114 INSERT INTO t1(id,data) VALUES(9,'nine-a');
115 INSERT INTO t1(id,data) VALUES(10,'ten-a');
118 INSERT INTO t2(id,data) VALUES(9,'nine-b');
119 INSERT INTO t2(id,data) VALUES(10,'ten-b');
122 SELECT id FROM (
123 SELECT id,data FROM (
126 WHERE id=10 ORDER BY data
139 CREATE TABLE t3(id INTEGER, data TEXT);
140 CREATE TABLE t4(id INTEGER, data TEXT);
144 SELECT data, id FROM (
[all …]
/sqlite-3.40.0/src/
H A Dos.c90 return id->pMethods->xRead(id, pBuf, amt, offset); in sqlite3OsRead()
97 return id->pMethods->xTruncate(id, size); in sqlite3OsTruncate()
105 return id->pMethods->xFileSize(id, pSize); in sqlite3OsFileSize()
110 return id->pMethods->xLock(id, lockType); in sqlite3OsLock()
114 return id->pMethods->xUnlock(id, lockType); in sqlite3OsUnlock()
155 return id->pMethods->xFileControl(id, op, pArg); in sqlite3OsFileControl()
158 if( id->pMethods ) (void)id->pMethods->xFileControl(id, op, pArg); in sqlite3OsFileControlHint()
167 return id->pMethods->xDeviceCharacteristics(id); in sqlite3OsDeviceCharacteristics()
174 id->pMethods->xShmBarrier(id); in sqlite3OsShmBarrier()
177 return id->pMethods->xShmUnmap(id, deleteFlag); in sqlite3OsShmUnmap()
[all …]
H A Dmutex_noop.c40 static sqlite3_mutex *noopMutexAlloc(int id){ in noopMutexAlloc() argument
41 UNUSED_PARAMETER(id); in noopMutexAlloc()
81 int id; /* The mutex type */ member
109 static sqlite3_mutex *debugMutexAlloc(int id){ in debugMutexAlloc() argument
112 switch( id ){ in debugMutexAlloc()
117 pNew->id = id; in debugMutexAlloc()
124 if( id-2<0 || id-2>=ArraySize(aStatic) ){ in debugMutexAlloc()
129 pNew = &aStatic[id-2]; in debugMutexAlloc()
130 pNew->id = id; in debugMutexAlloc()
143 if( p->id==SQLITE_MUTEX_RECURSIVE || p->id==SQLITE_MUTEX_FAST ){ in debugMutexFree()
[all …]
H A Dmutex_w32.c39 int id; /* Mutex type */ member
55 #define SQLITE3_MUTEX_INITIALIZER(id) { SQLITE_W32_MUTEX_INITIALIZER, id, \ argument
58 #define SQLITE3_MUTEX_INITIALIZER(id) { SQLITE_W32_MUTEX_INITIALIZER, id } argument
220 p->id = iType; in winMutexAlloc()
250 assert( p==0 || p->id==iType ); in winMutexAlloc()
263 if( p->id==SQLITE_MUTEX_FAST || p->id==SQLITE_MUTEX_RECURSIVE ){ in winMutexFree()
290 assert( p->id==SQLITE_MUTEX_RECURSIVE || winMutexNotheld2(p, tid) ); in winMutexEnter()
302 tid, p->id, p, p->trace, p->nRef)); in winMutexEnter()
313 assert( p->id==SQLITE_MUTEX_RECURSIVE || winMutexNotheld2(p, tid) ); in winMutexTry()
367 assert( p->nRef==0 || p->id==SQLITE_MUTEX_RECURSIVE ); in winMutexLeave()
[all …]
H A Dmutex_unix.c44 int id; /* Mutex type */ member
53 # define SQLITE3_MUTEX_INITIALIZER(id) \ argument
54 {PTHREAD_MUTEX_INITIALIZER,id,0,(pthread_t)0,0}
56 # define SQLITE3_MUTEX_INITIALIZER(id) { PTHREAD_MUTEX_INITIALIZER, id } argument
58 #define SQLITE3_MUTEX_INITIALIZER(id) { PTHREAD_MUTEX_INITIALIZER } argument
186 p->id = SQLITE_MUTEX_RECURSIVE; in pthreadMutexAlloc()
196 p->id = SQLITE_MUTEX_FAST; in pthreadMutexAlloc()
213 assert( p==0 || p->id==iType ); in pthreadMutexAlloc()
227 if( p->id==SQLITE_MUTEX_FAST || p->id==SQLITE_MUTEX_RECURSIVE ) in pthreadMutexFree()
252 assert( p->id==SQLITE_MUTEX_RECURSIVE || pthreadMutexNotheld(p) ); in pthreadMutexEnter()
[all …]
H A Dos_unix.c2375 assert( id!=0 ); in dotlockClose()
2578 assert( id!=0 ); in flockClose()
2744 if( id ){ in semXClose()
3206 assert( id!=0 ); in afpClose()
3295 assert( id->h>2 ); in seekAndRead()
3337 sqlite3_file *id, in unixRead() argument
3344 assert( id ); in unixRead()
3459 return seekAndWriteFd(id->h, offset, pBuf, cnt, &id->lastErrno); in seekAndWrite()
3475 assert( id ); in unixWrite()
3838 assert( id ); in unixFileSize()
[all …]
/sqlite-3.40.0/ext/rtree/
H A DrtreeE.test55 SELECT id FROM rt1 WHERE id MATCH Qcircle(0.0, 0.0, 50.0, 3) ORDER BY id;
58 SELECT id FROM rt1 WHERE id MATCH Qcircle('x:0 y:0 r:50.0 e:3') ORDER BY id;
61 SELECT id FROM rt1 WHERE id MATCH Qcircle(100.0, 0.0, 50.0, 3) ORDER BY id;
64 SELECT id FROM rt1 WHERE id MATCH Qcircle(0.0, 200.0, 50.0, 3) ORDER BY id;
72 SELECT id FROM rt1 WHERE id MATCH Qcircle('r:1000 e:3') AND id%100==0
77 SELECT id FROM rt1 WHERE id MATCH Qcircle('r:1000 e:4') ORDER BY +id
82 SELECT id FROM rt1 WHERE id MATCH Qcircle(0,0,1000,5) ORDER BY +id
88 SELECT id FROM rt1 WHERE id=18 AND id MATCH Qcircle(0,0,1000,5)
127 SELECT id FROM rt2 WHERE id MATCH breadthfirstsearch($x0,$x1,$y0,$y1) ORDER BY id
135 SELECT id FROM rt2 WHERE id MATCH breadthfirstsearch(0,5000,0,5000) ORDER BY id
[all …]
H A Drtree9.test30 SELECT * FROM rt WHERE id MATCH cube(0, 0, 0, 2, 2, 2);
33 SELECT * FROM rt WHERE id MATCH cube(3, 3, 3, 2, 2, 2);
48 SELECT id FROM rt WHERE id MATCH cube(2.5, 2.5, 2.5, 1, 1, 1) ORDER BY id;
51 SELECT id FROM rt WHERE id MATCH cube(5.5, 5.5, 5.5, 1, 1, 1) ORDER BY id;
66 SELECT id FROM rt32 WHERE id MATCH cube(3, 3, 3, 1, 1, 1) ORDER BY id;
69 SELECT id FROM rt32 WHERE id MATCH cube(5.5, 5.5, 5.5, 1, 1, 1) ORDER BY id;
74 SELECT id FROM rt32 WHERE id MATCH cube(5.5, 5.5, 1, 1, 1) ORDER BY id;
78 SELECT id FROM rt WHERE id MATCH randomblob($x)
82 SELECT id FROM rt WHERE id MATCH CAST(
120 SELECT id FROM rt2 WHERE id MATCH circle(0.0, 0.0, 2.0);
[all …]
H A Drtree4.test135 list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
136 } [list $where [db eval "SELECT id FROM bx $where ORDER BY id"]]
148 list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
149 } [list $where [db eval "SELECT id FROM bx $where ORDER BY id"]]
165 list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
166 } [list $where [db eval "SELECT id FROM bx $where ORDER BY id"]]
182 list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
198 list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
214 list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
230 list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
[all …]
H A Drtree8.test44 if {$id==3} { db eval { DELETE FROM t1 WHERE id>3 } }
51 db eval { SELECT * FROM t1 ORDER BY +id } {
52 if {$id==3} { db eval { DELETE FROM t1 WHERE id>3 } }
65 if {$id == $n} { nested_select [expr $n+1] }
108 SELECT * FROM t1 WHERE id = $i
120 CREATE VIRTUAL TABLE t1 USING rtree_i32(id, x1, x2);
130 DELETE FROM t1 WHERE id=25
134 CREATE VIRTUAL TABLE t1 USING rtree_i32(id, x1, x2);
178 execsql { DELETE FROM t2 WHERE id = $i }
199 db eval {SELECT id FROM t1} x {
[all …]
H A Drtreedoc2.test69 SELECT id FROM demo_index WHERE id MATCH circle(45.3, 22.9, 5.0)
77 SELECT id FROM demo_index WHERE id MATCH qcircle(45.3, 22.9, 5.0, 1)
94 SELECT id FROM demo_index WHERE id MATCH box(43,46, 21,25);
123 CREATE VIRTUAL TABLE rt1 USING rtree(id, x1,x2);
138 SELECT id FROM $tbl WHERE id MATCH box();
152 SELECT * FROM rt2 WHERE id MATCH box(22,23, 24,25);
172 SELECT * FROM rt1 WHERE id MATCH box(1,1);
192 SELECT * FROM rt1 WHERE id MATCH box(1,1);
246 CREATE VIRTUAL TABLE myrtree USING rtree(id, x1,x2);
260 SELECT * FROM myrtree WHERE id MATCH box(4, 5);
[all …]
H A Drtreedoc.test145 SELECT typeof(id), id FROM rt
280 1 t1 "id x1 x2"
378 1 {(id TEXT, x1 TEXT, x2 TEXT, y1 TEXT, y2 TEXT)} {id x1 x2 y1 y2}
379 2 {(id TEXT, x1 UNIQUE, x2 TEXT, y1 NOT NULL, y2 TEXT)} {id x1 x2 y1 y2}
380 3 {(id, x1 DEFAULT 4, x2 TEXT, y1 NOT NULL, y2 TEXT)} {id x1 x2 y1 y2}
598 AND B.id=28269
604 AND B.id=28269;
777 db eval { UPDATE demo_index SET maxY=maxY+0.5 WHERE id=$id }
898 INSERT INTO demo_data(id) SELECT id FROM demo_index;
910 # demo_data.id=demo_index.id AND contained_in(demo_data.boundary,
[all …]

123456789