| /sqlite-3.40.0/test/ |
| H A D | whereG.test | 67 AND composer.cid=track.cid
74 AND composer.cid=track.cid
82 AND composer.cid=track.cid
89 AND composer.cid=track.cid
97 AND composer.cid=track.cid
104 AND composer.cid=track.cid
112 AND unlikely(composer.cid=track.cid)
119 AND unlikely(composer.cid=track.cid)
128 AND composer.cid=track.cid
137 AND composer.cid=track.cid
[all …]
|
| H A D | cost.test | 180 cid INTEGER PRIMARY KEY,
189 cid INTEGER REFERENCES composer,
193 CREATE INDEX track_i1 ON track(cid);
201 AND unlikely(composer.cid=track.cid)
|
| H A D | whereJ.test | 28 cid,
49 CREATE INDEX ix0 on tx1(a1,curx,aid,cid,sid,ftype,fp,fyear DESC,edate DESC,fid);
50 CREATE INDEX ix1 on tx1(a1,curx,aid,ftype,fp,fyear DESC,fid,edate DESC,cid,sid);
51 CREATE INDEX ix2 on tx1(a1,curx,cid,sid,ftype,fp,fyear DESC,edate DESC,aid,fid);
52 CREATE INDEX ix3 on tx1(a1,curx,fid,ftype,fp,fyear DESC,cid,sid,aid,edate DESC);
53 CREATE INDEX ix4 on tx1(a1,curx,ftype,cid,sid,aid,edate DESC,fid,fp,fyear DESC);
54 CREATE INDEX ix5 on tx1(a1,curx,ftype,aid,fid,cid,sid,edate DESC,fp,fyear DESC);
55 …CREATE INDEX ix6 on tx1(ftype,fp,fyear DESC,cid,sid,edate DESC,a1,fid,aid,curx,est,rstat,cx,acode,…
56 …CREATE INDEX ix7 on tx1(cid,a1,curx,sid,ftype,est,fid,aid,edate,rstat,cx,fyear,fp,acode,tdate,gsta…
57 CREATE INDEX ix8 on tx1(cid,sid,edate DESC,aid,est);
[all …]
|
| H A D | bestindex6.test | 46 SELECT name FROM pragma_table_info($src) WHERE cid=$C(column)
|
| H A D | pragma.test | 739 db eval {SELECT seqno, cid, name FROM out ORDER BY seqno}
748 db eval {SELECT seqno, cid, name FROM out ORDER BY seqno}
816 db eval {SELECT cid, "name", type, "notnull", dflt_value, pk FROM out
817 ORDER BY cid}
1885 db2 eval {SELECT cid, name, '|' FROM out ORDER BY seqno}
1897 db2 eval {SELECT cid, name, "desc", coll, "key", '|' FROM out ORDER BY seqno}
|
| H A D | vtab2.test | 32 main schema 2 cid {} 0 {} 0 \
|
| H A D | fts3corrupt4.test | 807 | 3936: 63 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d cid INTEGER PRIM
1030 | 3936: 63 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d cid INTEGER PRIM
1259 | 3936: 63 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d cid INTEGER PRIM
1483 | 3936: 63 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d cid INTEGER PRIM
1771 | 3936: 63 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d cid INTEGER PRIM
2414 | 3936: 63 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d cid INTEGER PRIM
2651 | 3936: 63 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d cid INTEGER PRIM
2875 | 3936: 63 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d cid INTEGER PRIM
3306 | 3936: 63 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d cid INTEGER PRIM
3524 | 3936: 63 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d cid INTEGER PRIM
[all …]
|
| H A D | auth.test | 2206 SELECT name FROM pragma_table_info('t1') ORDER BY cid;
2224 SELECT name FROM pragma_table_info('t1') ORDER BY cid;
2242 SELECT name FROM pragma_table_info('t1') ORDER BY cid;
|
| /sqlite-3.40.0/tool/ |
| H A D | mkpragmatab.tcl | 224 COLS: cid name type notnull dflt_value pk
231 COLS: cid name type notnull dflt_value pk hidden
249 COLS: seqno cid name
256 COLS: seqno cid name desc coll key
|
| /sqlite-3.40.0/src/ |
| H A D | test8.c | 281 int cid = sqlite3_column_int(pStmt2, 1); in getIndexArray() local
282 assert( cid>=0 && cid<nCol ); in getIndexArray()
283 aIndex[cid] = 1; in getIndexArray()
|
| /sqlite-3.40.0/ext/rtree/ |
| H A D | rtreedoc.test | 416 SELECT type FROM pragma_table_info('abc') ORDER BY cid
428 SELECT type FROM pragma_table_info('abc2') ORDER BY cid
|