Home
last modified time | relevance | path

Searched refs:jointype (Results 1 – 11 of 11) sorted by relevance

/sqlite-3.40.0/src/
H A Dwhere.c773 if( (pSrc->fg.jointype & (JT_LEFT|JT_RIGHT))!=0 in constraintCompatibleWithOuterJoin()
797 assert( (pSrc->fg.jointype & JT_RIGHT)==0 ); in termCanDriveIndex()
798 if( (pSrc->fg.jointype & (JT_LEFT|JT_LTORJ|JT_RIGHT))!=0 in termCanDriveIndex()
3221 u8 jointype, /* The JT_* flags on the join */ in whereUsablePartialIndex() argument
3229 if( jointype & JT_LTORJ ) return 0; in whereUsablePartialIndex()
4150 if( pItem->fg.jointype & JT_RIGHT ) return SQLITE_OK; in whereLoopAddOr()
5448 testcase( pItem->fg.jointype & JT_LEFT ); in whereCheckIfBloomFilterIsUseful()
5504 testcase( pTabItem->fg.jointype & JT_LEFT ); in whereAddIndexedExpr()
5505 testcase( pTabItem->fg.jointype & JT_RIGHT ); in whereAddIndexedExpr()
5506 testcase( pTabItem->fg.jointype & JT_LTORJ ); in whereAddIndexedExpr()
[all …]
H A Dselect.c256 int jointype = 0; in sqlite3JoinType() local
283 jointype |= aKeyword[j].code; in sqlite3JoinType()
289 jointype |= JT_ERROR; in sqlite3JoinType()
295 (jointype & JT_ERROR)!=0 || in sqlite3JoinType()
304 jointype = JT_INNER; in sqlite3JoinType()
306 return jointype; in sqlite3JoinType()
505 if( pRight->fg.jointype & JT_NATURAL ){ in sqlite3ProcessJoin()
4525 u8 jointype = 0; in flattenSubquery() local
4533 jointype = pSubitem->fg.jointype; /* First time through the loop */ in flattenSubquery()
4565 pItem->fg.jointype |= ltorj; in flattenSubquery()
[all …]
H A Dwherecode.c207 if( pItem->fg.jointype & JT_LEFT ){ in sqlite3WhereExplainOneScan()
1073 if( pTabItem->fg.jointype & JT_LEFT ){ in codeCursorHint()
1383 || pLevel->iFrom>0 || (pTabItem[0].fg.jointype & JT_LEFT)==0 in sqlite3WhereCodeOneLoopStart()
1385 if( pLevel->iFrom>0 && (pTabItem[0].fg.jointype & JT_LEFT)!=0 ){ in sqlite3WhereCodeOneLoopStart()
2265 testcase( (pTabItem[0].fg.jointype & JT_LEFT)!=0 in sqlite3WhereCodeOneLoopStart()
2474 if( pTabItem->fg.jointype & (JT_LEFT|JT_LTORJ|JT_RIGHT) ){ in sqlite3WhereCodeOneLoopStart()
2479 }else if( (pTabItem->fg.jointype & JT_LEFT)==JT_LEFT in sqlite3WhereCodeOneLoopStart()
2548 if( pTabItem->fg.jointype & (JT_LEFT|JT_LTORJ|JT_RIGHT) ) continue; in sqlite3WhereCodeOneLoopStart()
2659 if( pTabItem->fg.jointype & JT_LTORJ ) continue; in sqlite3WhereCodeOneLoopStart()
2713 if( (pTabItem->fg.jointype & JT_LTORJ)==0 ){ in sqlite3WhereRightJoinLoop()
[all …]
H A Dtreeview.c200 if( (pItem->fg.jointype & (JT_LEFT|JT_RIGHT))==(JT_LEFT|JT_RIGHT) ){ in sqlite3TreeViewSrcList()
202 }else if( pItem->fg.jointype & JT_LEFT ){ in sqlite3TreeViewSrcList()
204 }else if( pItem->fg.jointype & JT_RIGHT ){ in sqlite3TreeViewSrcList()
206 }else if( pItem->fg.jointype & JT_CROSS ){ in sqlite3TreeViewSrcList()
209 if( pItem->fg.jointype & JT_LTORJ ){ in sqlite3TreeViewSrcList()
H A Dresolve.c199 assert( (pMatch->fg.jointype & (JT_LEFT|JT_LTORJ))!=0 ); in extendFJMatch()
332 if( (pItem->fg.jointype & JT_RIGHT)==0 ){ in lookupName()
336 if( (pItem->fg.jointype & JT_LEFT)==0 ){ in lookupName()
388 if( (pItem->fg.jointype & JT_RIGHT)==0 ){ in lookupName()
392 if( (pItem->fg.jointype & JT_LEFT)==0 ){ in lookupName()
421 if( (pMatch->fg.jointype & (JT_LEFT|JT_LTORJ))!=0 ){ in lookupName()
H A Dbuild.c5040 p1->a[0].fg.jointype |= (JT_LTORJ & p1->a[1].fg.jointype); in sqlite3SrcListAppendList()
5091 allFlags |= p->a[i].fg.jointype = p->a[i-1].fg.jointype; in sqlite3SrcListShiftJoinType()
5093 p->a[0].fg.jointype = 0; in sqlite3SrcListShiftJoinType()
5098 for(i=p->nSrc-1; ALWAYS(i>0) && (p->a[i].fg.jointype&JT_RIGHT)==0; i--){} in sqlite3SrcListShiftJoinType()
5102 p->a[i].fg.jointype |= JT_LTORJ; in sqlite3SrcListShiftJoinType()
H A Dwhereexpr.c1128 if( ALWAYS(pSrc->nSrc>0) && (pSrc->a[0].fg.jointype & JT_LTORJ)!=0 ){ in exprAnalyze()
1842 if( pItem->fg.jointype & (JT_LEFT|JT_LTORJ) ){ in sqlite3WhereTabFuncArgs()
H A Dexpr.c2327 if( pSrc->fg.jointype & JT_LTORJ ){ in sqlite3ExprIsTableConstraint()
2330 if( pSrc->fg.jointype & JT_LEFT ){ in sqlite3ExprIsTableConstraint()
H A DsqliteInt.h3123 u8 jointype; /* Type of join between this table and the previous */ member
H A Dparse.y695 if( ALWAYS(A && A->nSrc>0) ) A->a[A->nSrc-1].fg.jointype = (u8)Y;
/sqlite-3.40.0/test/
H A Dautoindex4.test110 unset -nocomplain id data1 data2 jointype onclause whereclause answer
111 foreach {id data1 data2 jointype onclause whereclause answer} {
186 set sql "SELECT * FROM t1 $jointype t2 ON $onclause WHERE $whereclause"