Home
last modified time | relevance | path

Searched refs:seq (Results 1 – 12 of 12) sorted by relevance

/sqlite-3.40.0/test/
H A Ddecimal.test54 CREATE TABLE t1(seq INTEGER PRIMARY KEY, val TEXT);
70 WHERE a.seq<b.seq
76 WHERE a.seq<>b.seq
82 WHERE a.seq>b.seq
86 SELECT seq FROM t1 ORDER BY val COLLATE decimal;
89 SELECT seq FROM t1 ORDER BY val COLLATE decimal DESC;
93 CREATE TABLE t3(seq INTEGER PRIMARY KEY, val TEXT);
95 INSERT INTO t3(seq, val) SELECT x, x FROM c;
98 SELECT decimal(val) FROM t3 ORDER BY seq;
101 SELECT decimal_add(val,'0.5') FROM t3 WHERE seq>5 ORDER BY seq
[all …]
H A Dalias.test27 namespace eval ::seq {
52 ::seq::reset
58 ::seq::reset
64 ::seq::reset
70 ::seq::reset
78 ::seq::reset
84 # ::seq::reset
90 ::seq::reset
96 ::seq::reset
102 ::seq::reset
[all …]
H A Dautoinc.test177 UPDATE sqlite_sequence SET seq=1234 WHERE name='t1';
189 UPDATE sqlite_sequence SET seq=NULL WHERE name='t1';
201 UPDATE sqlite_sequence SET seq='a-string' WHERE name='t1';
225 UPDATE sqlite_sequence SET seq='-12345678901234567890'
481 SELECT seq FROM main.sqlite_sequence WHERE name='t6';
490 SELECT seq FROM main.sqlite_sequence WHERE name='t6';
690 SELECT seq FROM sqlite_sequence WHERE name='t11';
703 CREATE TABLE fake_sequence(name TEXT PRIMARY KEY,seq) WITHOUT ROWID;
773 CREATE TABLE fake(name TEXT PRIMARY KEY,seq) WITHOUT ROWID;
H A Dshared.test228 # This test case starts a linear scan of table 'seq' using a
230 # to the end of the seq table (ahead of the current cursor position).
233 CREATE TABLE seq(i PRIMARY KEY, x);
234 INSERT INTO seq VALUES(1, '[string repeat X 500]');
235 INSERT INTO seq VALUES(2, '[string repeat X 500]');
241 db2 eval {SELECT i FROM seq ORDER BY i} {
243 set max [execsql {SELECT max(i) FROM seq}]
245 INSERT INTO seq SELECT i + :max, x FROM seq;
258 db2 eval {SELECT i FROM seq} {
259 db eval {DELETE FROM seq WHERE i = :i}
[all …]
H A Dfuzzcheck.c130 int seq; /* Sequence number */ member
534 pNew->seq = n++; in blobListLoadFromDb()
2227 g.pFirstDb->seq = 0; in main()
2301 int idx = pSql->seq; in main()
2309 int idx = pSql->seq; in main()
2340 int idx = pSql->seq*g.nDb + pDb->id - 1; in main()
2348 int idx = pSql->seq*g.nDb + pDb->id - 1; in main()
H A Dpragma.test726 db eval {SELECT seq, "name", "unique" FROM out ORDER BY seq}
1379 } {seq 0 name RTRIM seq 1 name NOCASE seq 2 name BINARY}
1960 db2 eval {SELECT seq, name, "unique", origin, '|' FROM out ORDER BY seq}
H A Dwith1.test158 CREATE TABLE edge(xfrom, xto, seq, PRIMARY KEY(xfrom, xto)) WITHOUT ROWID;
176 SELECT edge.xto, edge.seq FROM edge, ancest
187 SELECT edge.xto, edge.seq FROM edge, ancest
198 SELECT edge.xto, edge.seq FROM edge, ancest
H A DcorruptN.test160 SET sql = 'CREATE TABLE sqlite_sequence(name-seq)'
H A DcorruptL.test414 | 3984: 65 2c 73 65 71 29 68 01 07 17 11 11 01 81 3b 74 e,seq)h.......;t
612 | 3904: 63 65 28 6e 61 6d 65 2c 73 65 71 29 81 04 01 07 ce(name,seq)....
900 | 3984: 65 2c 73 65 71 29 68 00 07 17 11 11 01 81 3b 74 e,seq)h.......;t
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5fault9.test34 WITH seq(s) AS ( SELECT 1 UNION ALL SELECT s+1 FROM seq WHERE s<50)
35 INSERT INTO t1 SELECT 'x x x y y y', 'a b c d e f' FROM seq;
/sqlite-3.40.0/tool/
H A Dmkpragmatab.tcl261 COLS: seq name unique origin partial
266 COLS: seq name file
289 COLS: seq name
294 COLS: id seq table from to on_update on_delete match
/sqlite-3.40.0/src/
H A Dshell.c.in6324 "LEFT JOIN pragma_table_info AS p ON (pk-1=seq AND p.arg=f.[table]) "
10109 appendText(&sQuery,"SELECT name,seq FROM sqlite_sequence"