Home
last modified time | relevance | path

Searched refs:e1 (Results 1 – 24 of 24) sorted by relevance

/sqlite-3.40.0/test/
H A Drowvaluevtab.test41 CREATE VIRTUAL TABLE e1 USING echo(t1);
55 SELECT a FROM e1 WHERE (b, c) = (2, 2)
58 SELECT a FROM e1 WHERE (b, c) = (?, ?)
62 SELECT a FROM e1 WHERE (b, c) > (2, 2)
65 SELECT a FROM e1 WHERE (b, c) > (2, 2)
71 SELECT a FROM e1 WHERE (b, c) >= (2, 2)
74 SELECT a FROM e1 WHERE (b, c) >= (2, 2)
80 SELECT a FROM e1 WHERE (b, c) BETWEEN (1, 2) AND (2, 3)
83 SELECT a FROM e1 WHERE (b, c) BETWEEN (1, 2) AND (2, 3)
89 SELECT a FROM e1 WHERE (b, c) IN ( VALUES(2, 2) )
[all …]
H A DvtabI.test28 CREATE VIRTUAL TABLE e1 USING echo(t1);
32 1 {SELECT * FROM e1}
35 2 {SELECT a, b FROM e1}
38 3 {SELECT count(*) FROM e1 GROUP BY b}
41 4 {SELECT count(*) FROM e1 GROUP BY b HAVING a=?}
44 5 {SELECT a FROM e1 WHERE c=?}
47 6 {SELECT a FROM e1 ORDER BY e}
50 7 {SELECT a FROM e1 ORDER BY e, d}
H A Drowvalue4.test245 CREATE TABLE e1(a, b, c, d, e);
246 CREATE INDEX e1ab ON e1(a, b);
247 CREATE INDEX e1cde ON e1(c, d, e);
251 SELECT * FROM e1 WHERE (a, b) > (?, ?)
252 } {SEARCH e1 USING INDEX e1ab ((a,b)>(?,?))}
255 SELECT * FROM e1 WHERE (a, b) < (?, ?)
256 } {SEARCH e1 USING INDEX e1ab ((a,b)<(?,?))}
259 SELECT * FROM e1 WHERE c = ? AND (d, e) > (?, ?)
260 } {SEARCH e1 USING INDEX e1cde (c=? AND (d,e)>(?,?))}
263 SELECT * FROM e1 WHERE c = ? AND (d, e) < (?, ?)
[all …]
H A Drowvalue9.test223 CREATE TABLE e1(a TEXT, c NUMERIC);
226 INSERT INTO e1 VALUES(2, 2);
232 CREATE INDEX e1c ON e1(c);
236 SELECT rowid FROM e1 WHERE (a, c) IN (SELECT x, y FROM e2);
239 SELECT rowid FROM e2 WHERE rowid IN (SELECT +c FROM e1);
242 SELECT rowid FROM e2 WHERE rowid IN (SELECT 0+c FROM e1);
H A Dfuzzinvariants.c332 int e1 = sqlite3_value_encoding(sqlite3_column_value(pS1,i1)); in sameValue() local
334 if( e1!=e2 ){ in sameValue()
338 printf("Encodings differ. %d on left and %d on right\n", e1, e2); in sameValue()
349 if( e1!=SQLITE_UTF8 ){ in sameValue()
H A Drowvalue2.test239 set e1 [make_expr1 {a b c} $vector $op]
244 db eval "SELECT rowid FROM t4 WHERE $e1 ORDER BY +rowid"
269 set e1 [make_expr1 $lhs $rhs $op]
273 "SELECT * FROM r1, r2 WHERE $e1 ORDER BY iB"
H A Dfts4langid.test183 set e1 [lindex $list1 $i1]
186 if {$e1==$e2} {
187 lappend res $e1
190 } elseif {$e1 < $e2} {
191 lappend res $e1
H A Dfts3expr2.test154 set e1 [tree_to_expr $t 0 0]
159 do_exprparse_test fts3expr2-$iTest.1 $e1 $t
H A Dindexexpr1.test198 CREATE TABLE e1(x,y,UNIQUE(y,substr(x,1,5)));
201 CREATE TABLE e1(x,y,PRIMARY KEY(y,substr(x,1,5)));
204 CREATE TABLE e1(x,y,PRIMARY KEY(y,substr(x,1,5))) WITHOUT ROWID;
207 CREATE TABLE e1(x,y,FOREIGN KEY(substr(y,1,5)) REFERENCES t1);
H A Daltercol.test445 { CREATE VIRTUAL TABLE e1 USING echo(t1) }
460 CREATE VIRTUAL TABLE e1 USING echo(x1);
468 } { {CREATE TABLE x1(a, bbb, c)} {CREATE VIRTUAL TABLE e1 USING echo(x1)} }
471 CREATE VIEW v1 AS SELECT e1.*, x1.c FROM e1, x1;
H A Dmjournal.test38 hexio_write test.db-journal 20 000005e1
H A DcorruptN.test75 | 16: 01 dc 01 e1 01 96 01 cc 00 00 00 00 00 00 00 00 ................
H A DcorruptL.test114 | 0: 0d 00 00 00 01 04 30 00 04 30 e1 b4 30 97 4d 46 ......0..0..0.MF
276 | 128: 00 ff 00 00 ff ff ff e1 00 00 00 00 00 00 00 00 ................
750 | 128: 00 ff 00 00 ff ff ff e1 00 00 00 00 00 00 00 00 ................
754 | 192: 00 00 00 00 00 00 00 00 00 e1 ff 00 00 00 00 00 ................
H A Dwhere8.test167 CREATE VIRTUAL TABLE e1 USING echo(t1);
168 SELECT b FROM e1;
175 SELECT c FROM e1 WHERE a=1 OR b='three';
H A De_expr.test795 foreach {e1 e2} { cname "34+22" } {
796 lappend elist [string map [list EXPR1 $e1 EXPR2 $e2] $expr]
1850 foreach {tn e1 e2} {
1854 set res [db one "SELECT $e1"]
1855 do_expr_test e_expr-34.5.${tn}a $e1 integer $res
H A Dfts4content.test540 CREATE VIRTUAL TABLE e1 USING echo(tbl1);
541 CREATE VIRTUAL TABLE ft1 USING fts4(content=e1);
H A Dfts3corrupt4.test507 | 0: 6f ee cd e1 f1 ee 1a ca be ed ee ec de ac f1 cb o...............
515 | 128: 43 52 45 41 54 e1 ec eb ea eb eb ac ee ce be de CREAT...........
4727 | 3712: 45 20 46 54 53 35 58 4e 4f 4a e1 53 45 16 0e 05 E FTS5XNOJ.SE...
5677 | 3824: 09 05 07 e1 0f 19 45 4e 41 42 4c 45 20 44 42 53 ......ENABLE DBS
6014 | 3472: 06 65 6e 60 62 6c 65 3f 07 02 00 01 02 92 e1 a4 .en`ble?........
6255 | 0: 0a 0f e7 00 05 0f da 00 0f e1 0f fa 0f f4 0f ed ................
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5eb.test85 CREATE VIRTUAL TABLE e1 USING fts5(text, tokenize = 'porter unicode61');
86 INSERT INTO e1 VALUES ('just a few words with a / inside');
89 SELECT rowid, bm25(e1) FROM e1 WHERE e1 MATCH '"just"' ORDER BY rank;
92 SELECT rowid FROM e1 WHERE e1 MATCH '"/" OR "just"'
95 SELECT rowid, bm25(e1) FROM e1 WHERE e1 MATCH '"/" OR "just"' ORDER BY rank;
H A Dfts5multi.test60 foreach {tn c1 e1 c2 e2} {
68 set lhs "( $e1 )"
70 set lhs "$c1 : ( $e1 )"
79 set q2 "$c1 MATCH '$e1' AND $c2 MATCH '$e2'"
H A Dfts5corrupt3.test486 | 0: 0d 00 00 00 03 0f d6 00 0f f4 0f e1 0f d6 00 00 ................
587 | 0: 0d 00 00 00 03 0f d6 00 0f f4 0f e1 0f d6 00 00 ................
674 | 0: 0d 00 00 00 03 0f d6 00 0f f4 0f e1 0f d6 00 00 ................
760 | 0: 0d 00 00 00 03 0f d6 00 0f f4 0f e1 0f d6 00 00 ................
864 | 0: 0d 00 00 00 03 0f d6 00 0f f4 0f e1 0f d6 00 00 ................
946 | 0: 0d 00 00 00 03 0f d6 00 0f f4 0f e1 0f d6 00 00 ................
11126 | 2112: e9 c5 64 c8 0f 03 e1 1b 12 0b ff 39 e1 49 95 fa ..d........9.I..
11293 | 1728: ee d7 8f 90 e1 78 99 09 de 27 b8 b3 e1 7a df 8a .....x...'...z..
11550 | 2784: 5b a3 7a ef ed e1 24 56 54 a4 e1 ef 07 e7 9b 0e [.z...$VT.......
11552 | 2816: 6c 8f da b7 ff aa fd a6 05 c1 31 e1 03 5c a4 e1 l.........1.....
[all …]
H A Dfts5corrupt5.test190 | 0: 0a 00 00 00 32 0e 4f 00 0f fa 0f f1 0f e9 0f e1 ....2.O.........
404 | 0: 0a 00 00 00 32 0e 4f 00 0f fa 0f f1 0f e9 0f e1 ....2.O.........
735 | 0: 0a 00 00 00 32 0e 4f 00 0f fa 0f f1 0f e9 0f e1 ....2.O.........
/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..
276 | 4048: e1 07 04 01 01 01 06 59 a7 07 04 01 01 01 04 27 .......Y.......'
/sqlite-3.40.0/ext/rtree/
H A Drtreedoc.test1396 # In this case, the auxiliary columns are named "e1" and "e2". The
1400 CREATE VIRTUAL TABLE rtaux USING rtree(id, x1,x2, y1,y2, +e1, +e2);
1406 INSERT INTO rtaux(e1, e2) VALUES('hello', 'world'), (123, 456);
H A Drtreefuzz001.test392 | 1760: 00 00 00 05 e1 40 a0 00 00 40 c0 00 00 40 a0 00 .....@...@...@..
1106 | 3776: 0a 57 e1 42 6c 69 6e 65 2d 34 30 67 72 65 65 6e .W.Bline-40green