Home
last modified time | relevance | path

Searched refs:left (Results 1 – 25 of 108) sorted by relevance

12345

/sqlite-3.40.0/ext/rtree/
H A DrtreeH.test24 (0,10,0,10,'lower-left corner'),
25 (0,10,90,100,'upper-left corner'),
29 (0,5,0,100,'left edge'),
34 (0,50,0,100,'left half'),
41 …left corner} {} 2 1 {upper-left corner} {} 3 1 {lower-right corner} {} 4 1 {upper-right corner} {}…
77 } {{lower-left corner} {upper-left corner} {left edge} {left half}}
80 } {{left edge} {left half}}
H A Drtreefuzz001.test145 | 3264: 2d 6c 65 66 74 20 63 6f 72 6e 65 72 0d 0d 26 00 -left corner..&.
184 | 3888: 6c 65 66 74 20 68 61 6c 66 14 0a 05 00 09 2b 00 left half.....+.
189 | 3968: 65 0e 06 05 00 09 1f 00 6c 65 66 74 20 65 64 67 e.......left edg
515 | 3888: 6c 65 66 74 20 68 61 6c 66 14 0a 05 00 09 2b 00 left half.....+.
520 | 3968: 65 0e 06 05 00 09 1f 00 6c 65 66 74 20 65 64 67 e.......left edg
527 | 4080: 6f 77 65 72 2d 6c 65 66 74 20 63 6f 72 6e 65 72 ower-left corner
612 | 3888: 6c 65 66 74 20 68 61 6c 66 14 0a 05 00 09 2b 00 left half.....+.
617 | 3968: 65 0e 06 05 00 09 1f 00 6c 65 66 74 20 65 64 67 e.......left edg
624 | 4080: 6f 77 65 72 2d 6c 65 66 74 20 63 6f 72 6e 65 72 ower-left corner
717 | 3888: 6c 65 66 74 20 68 61 6c 66 14 0a 05 00 09 2b 00 left half.....+.
[all …]
/sqlite-3.40.0/test/
H A Djoin4.test13 # This file implements tests for left outer joins containing WHERE
14 # clauses that restrict the scope of the left term of the join.
35 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
52 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
58 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
66 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
71 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
76 select * from t1 left outer join t2 on t1.a=t2.x where t2.z>='ok'
81 select * from t1 left outer join t2 on t1.a=t2.x and t2.z>='ok'
87 select * from t1 left outer join t2 on t1.a=t2.x where t2.z IN ('ok')
[all …]
H A De_select2.test62 # -left
68 # * The list of column-names from the left-hand dataset.
138 # ?-left?
152 -left { set isleft 1 }
350 # the left and right-hand datasets.
386 t1 t2 -left -using a -on {te_equals a a}
428 t1 t2 -left -using b -on {te_equals b b}
441 t1 t3 -left -using b -on {te_equals b b}
444 t3 t1 -left -using b -on {te_equals -nocase b b}
447 t1 t3 -left -on {te_equals -nocase b b}
[all …]
H A Dfts2g.test33 # Empty left in docListExceptMerge().
43 # Empty left in docListPhraseMerge().
53 # Empty left in docListOrMerge().
63 # Empty left in docListAndMerge().
87 # Empty left and right in docListOrMerge(). Each term matches neither
H A Dfts3ag.test33 # Empty left in docListExceptMerge().
43 # Empty left in docListPhraseMerge().
53 # Empty left in docListOrMerge().
63 # Empty left in docListAndMerge().
87 # Empty left and right in docListOrMerge(). Each term matches neither
H A Dmalloctraceviewer.tcl107 set left [$O(tree) item $iLeft -text]
109 set res [string compare $left $right]
112 set left [lindex [$O(tree) item $iLeft -values] 0]
114 set res [expr $left - $right]
117 set left [lindex [$O(tree) item $iLeft -values] 1]
119 set res [expr $left - $right]
H A Dbestindex6.test97 select * from t2 left join t1 on t1.id=t2.ctx where t1.value is null;
101 select * from vt2 left join vt1 on vt1.id=vt2.ctx where vt1.value is null;
106 select * from vt2 left join vt1 on vt1.id=vt2.ctx where vt1.value is $xxx;
110 select * from t2 left join vt1 on vt1.id=t2.ctx where vt1.value = 3
H A Dselect4.test402 } {1 {SELECTs to the left and right of UNION ALL do not have the same number of result columns}}
407 } {1 {SELECTs to the left and right of UNION do not have the same number of result columns}}
708 } {1 {SELECTs to the left and right of UNION do not have the same number of result columns}}
715 } {1 {SELECTs to the left and right of UNION do not have the same number of result columns}}
736 } {1 {SELECTs to the left and right of EXCEPT do not have the same number of result columns}}
743 } {1 {SELECTs to the left and right of EXCEPT do not have the same number of result columns}}
784 } {1 {SELECTs to the left and right of EXCEPT do not have the same number of result columns}}
810 } {1 {SELECTs to the left and right of UNION do not have the same number of result columns}}
823 } {1 {SELECTs to the left and right of UNION do not have the same number of result columns}}
828 } {1 {SELECTs to the left and right of UNION do not have the same number of result columns}}
[all …]
H A Djoin5.test13 # This file implements tests for left outer joins containing ON
14 # clauses that restrict the scope of the left term of the join.
40 select * from t1 left join t2 on t1.b=t2.x and t1.c=1
45 select * from t1 left join t2 on t1.b=t2.x where t1.c=1
50 select * from t1 left join t2 on t1.b=t2.x and t1.c=1
51 left join t3 on t1.b=t3.p and t1.c=2
56 select * from t1 left join t2 on t1.b=t2.x and t1.c=1
57 left join t3 on t1.b=t3.p where t1.c=2
H A Dwhere3.test22 # A comma join then a left outer join: A,B left join C.
127 # If you have a from clause of the form: A B C left join D
135 # A B C left join D
136 # B A C left join D
140 # C A B left join D
141 # A C B left join D
142 # C B A left join D
143 # B C A left join D
H A Din6.test13 # than the left-most key is able to abort the IN-operator loop early
14 # if key terms further to the left do not match.
48 # when the IN operator is on the left-most column of the index.
H A Din.test423 } {1 {SELECTs to the left and right of UNION ALL do not have the same number of result columns}}
430 } {1 {SELECTs to the left and right of UNION do not have the same number of result columns}}
437 } {1 {SELECTs to the left and right of EXCEPT do not have the same number of result columns}}
444 } {1 {SELECTs to the left and right of INTERSECT do not have the same number of result columns}}
454 } {1 {SELECTs to the left and right of UNION ALL do not have the same number of result columns}}
461 } {1 {SELECTs to the left and right of UNION do not have the same number of result columns}}
468 } {1 {SELECTs to the left and right of EXCEPT do not have the same number of result columns}}
475 } {1 {SELECTs to the left and right of INTERSECT do not have the same number of result columns}}
489 } {1 {SELECTs to the left and right of UNION ALL do not have the same number of result columns}}
H A DcorruptJ.test42 # Corrupt the root page of the t1 table such that the left-child pointer
67 # The table is three levels deep. Corrupt the left child of an intermediate
H A DcorruptB.test67 # Set the left-child of a cell in a B-Tree rootpage to refer to the
114 # Set the left-child pointer of a cell of the right-child of the root page to
142 # Set the left-child pointer of a cell of the right-child of the root page to
H A Dmisc3.test14 # left out of other test files.
215 # Ticket #601: Putting a left join inside "SELECT * FROM (<join-here>)"
338 # Ticket #668: VDBE stack overflow occurs when the left-hand side
H A De_select.test386 # the left and right-hand datasets.
426 # dataset are, in order, all the columns of the left-hand dataset
447 # left-hand and right-hand datasets.
464 # EVIDENCE-OF: R-18439-38548 In other words, if the left-hand dataset
566 # left-hand side of the join-operator is considered to be on the
567 # left-hand side of the comparison operator (=) for the purposes of
625 # original left-hand input dataset that does not match any row in the
662 # column names that appear in both the left and right-hand input
1473 # intersection of the results of the left and right SELECTs.
1481 # rows returned by the left SELECT that are not also returned by the
[all …]
H A Dnockpt.test77 # 4. The statement left unfinalized in (1) is finalized.
79 # The test is to ensure that the connection left open in step (1) does
/sqlite-3.40.0/ext/fts2/
H A Dfts2.c1342 plrDestroy(&left); in posListUnion()
1391 dlrDestroy(&left); in docListUnion()
1445 plrDestroy(&left); in posListPhraseMerge()
1487 dlrDestroy(&left); in docListPhraseMerge()
1606 dlrStep(&left); in docListExceptMerge()
3475 left = new; in docListOfTerm()
3477 *pResult = left; in docListOfTerm()
3714 left = right; in fulltextQuery()
3720 left = new; in fulltextQuery()
3742 left = new; in fulltextQuery()
[all …]
/sqlite-3.40.0/ext/fts5/
H A Dfts5parse.y76 %left OR.
77 %left AND.
78 %left NOT.
79 %left TERM.
80 %left COLON.
/sqlite-3.40.0/ext/fts1/
H A Dfts1.c735 DocListReader left, right; in docListPhraseMerge() local
738 readerInit(&left, pLeft); in docListPhraseMerge()
740 docidLeft = nextDocid(&left); in docListPhraseMerge()
767 DocListReader left, right; in docListAndMerge() local
772 readerInit(&left, pLeft); in docListAndMerge()
774 docidLeft = nextDocid(&left); in docListAndMerge()
801 DocListReader left, right; in docListOrMerge() local
804 readerInit(&left, pLeft); in docListOrMerge()
806 docidLeft = nextDocid(&left); in docListOrMerge()
846 DocListReader left, right; in docListExceptMerge() local
[all …]
/sqlite-3.40.0/ext/wasm/common/
H A Demscripten.css2 .emscripten { padding-right: 0; margin-left: auto; margin-right: auto; display: block; }
14 border-left: 10px solid rgb(0,150,240);
/sqlite-3.40.0/ext/wasm/fiddle/
H A Demscripten.css2 .emscripten { padding-right: 0; margin-left: auto; margin-right: auto; display: block; }
14 border-left: 10px solid rgb(0,150,240);
/sqlite-3.40.0/contrib/
H A Dsqlitecon.tcl50 pack $w.mb.file $w.mb.edit -side left -padx 8 -pady 1
659 -side left -padx 5 -pady 5 -expand 1
665 pack $w.t -side left -fill both -expand 1
667 pack $w.sb -side left -fill y
/sqlite-3.40.0/ext/fts3/
H A DREADME.syntax16 If the left-hand-side of the MATCH operator is set to the name of the
122 left hand side of the MATCH operator, a specific column of the fts3 table
165 as its left-hand operator matches, but that the query specified as the
202 the left and right hand side operands of NEAR operators must be either

12345