Home
last modified time | relevance | path

Searched refs:j2 (Results 1 – 8 of 8) sorted by relevance

/sqlite-3.40.0/test/
H A Djson101.test134 INSERT INTO j2(id,json,src)
159 INSERT INTO j2(id,json,src)
257 SELECT count(*) FROM j2;
273 FROM j2, json_tree(j2.json) AS jx
279 FROM j2, json_each(j2.json) AS jx
290 FROM j2, json_each(j2.json) AS jx
291 WHERE jx.json<>j2.json;
295 FROM j2, json_tree(j2.json) AS jx
296 WHERE jx.json<>j2.json;
300 FROM j2, json_each(j2.json) AS jx
[all …]
H A De_select.test1281 CREATE TABLE j2(e, f);
1327 6 "SELECT a FROM j1 LIMIT (SELECT e FROM j2) UNION ALL SELECT g FROM j2,j3"
1336 10 "SELECT * FROM j1 LIMIT 10 UNION SELECT * FROM j2,j3"
1340 12 "SELECT a FROM j1 LIMIT (SELECT e FROM j2) UNION SELECT g FROM j2,j3"
1349 16 "SELECT * FROM j1 LIMIT 10 EXCEPT SELECT * FROM j2,j3"
1353 18 "SELECT a FROM j1 LIMIT (SELECT e FROM j2) EXCEPT SELECT g FROM j2,j3"
1366 24 "SELECT a FROM j1 LIMIT (SELECT e FROM j2) INTERSECT SELECT g FROM j2,j3"
1385 7 "SELECT * FROM j1 UNION SELECT * FROM j2,j3 ORDER BY a"
1387 8b "VALUES('8b') UNION SELECT max(e) FROM j2 ORDER BY 1"
1389 10 "SELECT * FROM j1 UNION SELECT * FROM j2,j3 LIMIT 10"
[all …]
H A DjoinF.test578 # foreach j2 {INNER LEFT RIGHT} {
585 # append q1 " $j2 JOIN t3 ON t2.y IS NOT NULL\n"
599 # append q1 " $j2 JOIN t3 ON t2.y IS NOT NULL\n"
H A Dshell8.test182 junk2 "j2"
H A DjoinD.test34842 # foreach j2 {INNER LEFT RIGHT FULL} {
34849 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34879 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34924 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
34939 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
34999 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
35014 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
35029 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
35041 # set op2 [expr {$j2=="FULL"?"=":"IS NOT DISTINCT FROM"}]
35076 # append q1 " $j2 JOIN t3 ON t3.y>0\n"
[all …]
H A DjoinB.test7158 # foreach j2 {INNER LEFT RIGHT FULL} {
7168 # append q1 " $j2 JOIN t3 USING(a)\n"
7185 # append q2 " NATURAL $j2 JOIN t3\n"
7202 # append q2 " $j2 JOIN t3 USING(a,b)\n"
7218 # append q2 " $j1 JOIN (t2 $j2 JOIN t3 USING(a)) USING(a)\n"
7234 # append q2 " $j2 JOIN t3 USING(a,b)\n"
/sqlite-3.40.0/src/
H A Danalyze.c1241 int j1, j2, j3; in analyzeOneTable() local
1243 j2 = sqlite3VdbeAddOp1(v, OP_If, regTemp); VdbeCoverage(v); in analyzeOneTable()
1248 sqlite3VdbeJumpHere(v, j2); in analyzeOneTable()
H A Dbuild.c3792 int j2 = sqlite3VdbeGoto(v, 1); in sqlite3RefillIndex() local
3795 sqlite3VdbeAddOp4Int(v, OP_SorterCompare, iSorter, j2, regRecord, in sqlite3RefillIndex()
3798 sqlite3VdbeJumpHere(v, j2); in sqlite3RefillIndex()