Home
last modified time | relevance | path

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

/sqlite-3.40.0/test/
H A DjoinE.test399 # set q1 ""
400 # append q1 "SELECT a, b\n"
401 # append q1 " FROM t1 $j1 JOIN t2 ON $on1\n"
402 # append q1 " ORDER BY coalesce(a,b,3);"
405 # echo "\\qecho X " $q1
407 # puts $q1
431 # set q1 ""
432 # append q1 "SELECT a, b\n"
434 # append q1 " ORDER BY coalesce(a,b,3);"
437 # echo "\\qecho X " $q1
[all …]
H A DjoinF.test582 # set q1 ""
583 # append q1 "SELECT *\n"
584 # append q1 " FROM t1 $j1 JOIN t2 ON true\n"
586 # append q1 " $j3 JOIN t4 ON true\n"
590 # echo "\\qecho X " $q1
592 # puts $q1
596 # set q1 ""
597 # append q1 "SELECT *\n"
598 # append q1 " FROM t1 $j1 JOIN t2 ON true\n"
605 # echo "\\qecho X " $q1
[all …]
H A De_blobbytes.test23 CREATE TABLE q1(r INTEGER PRIMARY KEY, s TEXT);
29 INSERT INTO q1 SELECT * FROM d;
39 sqlite3_blob_open db main q1 s $rowid 0 B
74 sqlite3_blob_open db main q1 s 86 1 B
H A Dthreadtest5.c164 sqlite3_stmt *q1; in worker() local
166 q1 = prepare(db, zName, __LINE__, in worker()
171 if( sqlite3_step(q1)==SQLITE_ROW ){ in worker()
172 tid = sqlite3_column_int(q1,0); in worker()
174 sqlite3_finalize(q1); in worker()
H A De_changes.test404 CREATE TABLE q1(t);
411 INSERT INTO q1 VALUES('1:' || changes());
415 INSERT INTO q1 VALUES('2:' || changes());
418 INSERT INTO q1 VALUES('3:' || changes());
420 INSERT INTO q1 VALUES('4:' || changes());
422 INSERT INTO q1 VALUES('5:' || changes());
428 SELECT * FROM q1;
434 DELETE FROM q1;
436 SELECT * FROM q1;
H A DjoinD.test34856 # puts $q1
34887 # puts $q1
34902 # puts $q1
34917 # puts $q1
34932 # puts $q1
34947 # puts $q1
34962 # puts $q1
34977 # puts $q1
34992 # puts $q1
35007 # puts $q1
[all …]
H A De_select.test1424 CREATE TABLE q1(a TEXT, b INTEGER, c);
1428 INSERT INTO q1 VALUES(16, -87.66, NULL);
1429 INSERT INTO q1 VALUES('legible', 94, -42.47);
1430 INSERT INTO q1 VALUES('beauty', 36, NULL);
1441 1 {SELECT a FROM q1 UNION ALL SELECT d FROM q2}
1447 3 {SELECT count(*) FROM q1 UNION ALL SELECT min(e) FROM q2}
1459 1 {SELECT a FROM q1 UNION SELECT d FROM q2}
1465 3 {SELECT count(*) FROM q1 UNION SELECT min(e) FROM q2}
1485 1 {SELECT a FROM q1 EXCEPT SELECT d FROM q2} {16}
1498 2 {SELECT * FROM q3 EXCEPT SELECT a,b FROM q1} {beauty 2}
[all …]
H A Dzipfile.test105 set q1 {SELECT name,mode,mtime,method,quote(data) FROM zipfile($file)}
112 set r1 [db eval $q1]
H A DjoinB.test7164 # set q1 ""
7165 # append q1 "SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a\n"
7166 # append q1 " FROM t1\n"
7167 # append q1 " $j1 JOIN t2 USING(a)\n"
7168 # append q1 " $j2 JOIN t3 USING(a)\n"
7169 # append q1 " $j3 JOIN t4 USING(a)\n"
7170 # append q1 " $j4 JOIN t5 USING(a)\n"
7171 # append q1 " ORDER BY 1 NULLS FIRST;"
7174 # echo "\\qecho X " $q1
7176 # puts $q1
H A DselectA.test1385 proc do_same_test {tn q1 args} {
1386 set r2 [strip_rnd [db eval "EXPLAIN $q1"]]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5multi.test78 set q1 "t1 MATCH '($lhs) AND ($rhs)'"
81 set ret [execsql "SELECT rowid FROM t1 WHERE $q1"]
85 set ret [execsql "SELECT fts5_test_poslist(t1) FROM t1 WHERE $q1"]
H A Dfts5ag.test103 set q1 {SELECT fts5_test_all(t1) FROM t1 WHERE t1 MATCH $E ORDER BY rank}
106 set res [execsql $q1]
110 append q1 " DESC"
113 set res [execsql $q1]