Home
last modified time | relevance | path

Searched refs:d1 (Results 1 – 23 of 23) sorted by relevance

/sqlite-3.40.0/test/
H A Drowvalue9.test154 INSERT INTO d1 VALUES(1, 1, 1);
155 INSERT INTO d1 VALUES(2, 2, 2);
156 INSERT INTO d1 VALUES(3, 3, 3);
157 INSERT INTO d1 VALUES(4, 4, 4);
167 2 { CREATE INDEX idx ON d1(a) }
169 4 { CREATE INDEX idx ON d1(c) }
173 CREATE INDEX idx ON d1(c, a) ;
178 CREATE INDEX idx ON d1(c, a) ;
183 CREATE INDEX idx ON d1(c) ;
212 SELECT d1.rowid FROM d1, d2 WHERE a = y;
[all …]
H A Dtkt2640.test55 SELECT person_id FROM directors d1 WHERE d1.person_id=p.person_id
67 SELECT person_id FROM directors d1 WHERE d1.person_id=p.person_id
79 SELECT person_id FROM directors d1 WHERE d1.person_id=p.person_id
91 SELECT person_id FROM directors d1 WHERE d1.person_id=d.person_id
103 SELECT person_id FROM directors d1 WHERE d1.person_id=d.person_id
115 SELECT person_id FROM directors d1 WHERE d1.person_id=d.person_id
H A Dvtab9.test39 CREATE TABLE d1(a,b,c);
40 INSERT INTO d1 VALUES(1,2,3);
41 INSERT INTO d1 VALUES('a','b','c');
42 INSERT INTO d1 VALUES(NULL,'x',123.456);
43 INSERT INTO d1 VALUES(x'6869',123456789,-12345);
44 INSERT INTO t3(a,b,c) SELECT * FROM d1;
H A Dinsert2.test24 execsql {CREATE TABLE d1(n int, log int);}
27 execsql "INSERT INTO d1 VALUES($i,$j)"
29 execsql {SELECT * FROM d1 ORDER BY n}
41 EXPLAIN INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
45 INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
61 SELECT log, count(*) FROM d1 GROUP BY log
62 EXCEPT SELECT n-1,log FROM d1;
76 SELECT log, count(*) FROM d1 GROUP BY log
77 INTERSECT SELECT n-1,log FROM d1;
94 INSERT INTO t1 SELECT log, count() FROM d1 GROUP BY log;
H A Dhook2.test104 CREATE TABLE d1(a DEFAULT 4, b, c, PRIMARY KEY(b, c)) WITHOUT ROWID;
105 CREATE UNIQUE INDEX d1a ON d1(a);
106 INSERT INTO d1 VALUES(1, 2, 3);
107 INSERT INTO d1 VALUES(11, 12, 13);
110 INSERT INTO t2 SELECT * FROM d1;
116 INSERT INTO t2 SELECT a+20, b+20, c+20 FROM d1;
H A Dupdate2.test205 CREATE TABLE d1(a,b);
206 CREATE INDEX d1b ON d1(a);
207 CREATE INDEX d1c ON d1(b);
208 INSERT INTO d1 VALUES(1,2);
212 UPDATE d1 SET a = a+2 WHERE a>0 OR b>0;
216 SELECT * FROM d1;
H A De_select.test1641 CREATE TABLE d1(x, y, z);
1643 INSERT INTO d1 VALUES(1, 2, 3);
1644 INSERT INTO d1 VALUES(2, 5, -1);
1645 INSERT INTO d1 VALUES(1, 2, 8);
1646 INSERT INTO d1 VALUES(1, 2, 7);
1647 INSERT INTO d1 VALUES(2, 4, 93);
1648 INSERT INTO d1 VALUES(1, 2, -20);
1649 INSERT INTO d1 VALUES(1, 4, 93);
1650 INSERT INTO d1 VALUES(1, 5, -1);
1754 8 "SELECT z, x FROM d1 ORDER BY 2" {
[all …]
H A Drowvalue4.test219 CREATE TABLE d1(x, y);
233 (a, b) IN (SELECT x, y FROM d1) AND
234 (c) IN (SELECT y FROM d1)
239 | `--SCAN d1
241 `--SCAN d1
H A Dshell8.test77 proc dir_compare {d1 d2} {
78 set l1 [dir_to_list $d1]
79 set l2 [dir_to_list $d1]
H A Djoin9.test323 FROM t3 JOIN dual AS d1 ON true
347 FROM t3 JOIN dual AS d1 ON true
H A Daltercorrupt.test72 | 16: 0f e3 0f dd 0f d7 0f d1 0f cb 0f c5 00 00 00 00 ................
H A DcorruptL.test153 | 112: 0e f9 0e d1 0e 55 00 00 00 00 00 00 00 00 00 00 .....U..........
654 | 112: 0e f9 0e d1 0e 55 00 00 00 00 00 00 00 00 00 00 .....U..........
1236 | 16: 0f d1 0f c7 0f bd 00 00 00 00 01 00 00 00 00 00 ................
H A Dfts3corrupt4.test3856 | 3264: 12 d1 06 00 01 06 00 01 06 00 1f 03 00 01 03 00 ................
3982 | 2944: e4 d1 54 41 42 20 45 4e 41 42 4c 45 20 46 54 53 ..TAB ENABLE FTS
/sqlite-3.40.0/ext/misc/
H A Dshathree.c86 u64 d0, d1, d2, d3, d4; in KeccakF1600Step() local
135 d1 = c0^ROL64(c2, 1); in KeccakF1600Step()
141 b1 = ROL64((a11^d1), 44); in KeccakF1600Step()
153 b3 = ROL64((a31^d1), 45); in KeccakF1600Step()
164 b0 = ROL64((a01^d1), 1); in KeccakF1600Step()
186 b4 = ROL64((a41^d1), 2); in KeccakF1600Step()
202 d1 = c0^ROL64(c2, 1); in KeccakF1600Step()
231 b0 = ROL64((a11^d1), 1); in KeccakF1600Step()
253 b4 = ROL64((a41^d1), 2); in KeccakF1600Step()
269 d1 = c0^ROL64(c2, 1); in KeccakF1600Step()
[all …]
/sqlite-3.40.0/ext/session/
H A Dsession1.test407 CREATE TABLE d1("z""z" PRIMARY KEY, y)%WR%;
408 INSERT INTO d1 VALUES(1, 'one');
409 INSERT INTO d1 VALUES(2, 'two');
415 UPDATE d1 SET y = 'TWO' WHERE "z""z" = 2;
420 do_conflict_test $tn.5.$tn2.2 -tables d1 -sql {
421 DELETE FROM d1 WHERE "z""z" = 2;
423 {DELETE d1 DATA {i 2 t two} {i 2 t TWO}}
428 do_db2_test $tn.5.$tn2.3 "SELECT * FROM d1" $res($conflict_return)
/sqlite-3.40.0/src/
H A Dvdbeaux.c4149 d1 = szHdr1; in vdbeRecordCompareDebug()
4166 if( d1+(u64)serial_type1+2>(u64)nKey1 in vdbeRecordCompareDebug()
4555 d1 = szHdr1 + sqlite3VdbeSerialTypeLen(s1); in sqlite3VdbeRecordCompareWithSkip()
4564 d1 = szHdr1; in sqlite3VdbeRecordCompareWithSkip()
4567 if( d1>(unsigned)nKey1 ){ in sqlite3VdbeRecordCompareWithSkip()
4642 if( (d1+mem1.n) > (unsigned)nKey1 in sqlite3VdbeRecordCompareWithSkip()
4651 mem1.z = (char*)&aKey1[d1]; in sqlite3VdbeRecordCompareWithSkip()
4672 testcase( (d1+nStr)==(unsigned)nKey1 ); in sqlite3VdbeRecordCompareWithSkip()
4674 if( (d1+nStr) > (unsigned)nKey1 ){ in sqlite3VdbeRecordCompareWithSkip()
4715 d1 += sqlite3VdbeSerialTypeLen(serial_type); in sqlite3VdbeRecordCompareWithSkip()
[all …]
H A Dwherecode.c960 int d1; in codeCursorHintIsOrFunction() local
962 if( 0==sqlite3IsLikeFunction(pWalker->pParse->db, pExpr, &d1, d2) ){ in codeCursorHintIsOrFunction()
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5corrupt3.test1908 | 3488: 64 31 05 02 05 02 27 65 37 34 36 35 36 65 37 34 d1....'e74656e74
1967 | 2240: 30 35 32 34 39 34 34 64 31 0a 35 32 35 39 32 30 0524944d1.525920
2342 | 3248: 34 94 f4 e5 85 25 45 24 94 d1 f1 e0 50 03 30 f1 4....%E$....P.0.
2348 | 3344: 03 03 03 03 03 05 85 25 45 24 94 d1 81 b0 50 02 .......%E$....P.
2353 | 3424: 24 54 55 85 25 45 24 94 d1 a1 80 50 02 90 f1 94 $TU.%E$....P....
2358 | 3504: 54 d5 35 95 33 55 85 25 45 24 94 d1 81 50 50 02 T.5.3U.%E$...PP.
2363 | 3584: f4 e3 15 85 25 45 24 94 d1 a1 20 50 02 90 f1 94 ....%E$... P....
11261 | 1216: d1 23 33 d1 c0 65 b6 8e 5a 4a 03 2f 74 27 0f 3d .#3..e..ZJ./t'.=
12364 | 3584: f8 5a 4e d1 34 af 19 3f dc 4f 93 29 83 d1 af 7a .ZN.4..?.O.)...z
12844 | 2096: 43 ef 07 e2 d1 d1 13 38 67 54 88 e2 6f 03 fe 05 C......8gT..o...
[all …]
H A Dfts5corrupt5.test191 | 16: 0f d8 0f d1 0f c9 0f c1 0f b9 0f b1 0f a9 0f a0 ................
405 | 16: 0f d8 0f d1 0f c9 0f c1 0f b9 0f b1 0f a9 0f a0 ................
736 | 16: 0f d8 0f d1 0f c9 0f c1 0f b9 0f b1 0f a9 0f a0 ................
H A Dfts5misc.test226 INSERT INTO vt0(c0) VALUES (x'd1');
/sqlite-3.40.0/ext/rtree/
H A Drtreefuzz001.test822 | 32: 0f 86 0d d1 0f 62 0f 67 0f 5c 0f 51 1f 46 0f 3a .....b.g...Q.F.:
873 | 3680: 78 33 0e d1 00 08 a7 09 04 00 01 13 02 35 78 31 x3...........5x1
1038 | 2736: 01 00 00 00 03 00 00 00 00 00 00 07 d1 00 00 00 ................
H A DrtreeC.test181 CREATE VIRTUAL TABLE rt USING rtree(id, x1, x2, +d1);
/sqlite-3.40.0/ext/recover/
H A Drecovercorrupt2.test267 | 16: 0f 81 0f d1 0f f1 0f f9 0f e1 0f 89 0e 6a 0f c1 .............j..