Lines Matching refs:iColumn
5552 ** aConstraint[].iColumn.)^ ^(aConstraint[].usable is TRUE if the
5590 int iColumn; /* Column on left-hand side of constraint */
5597 int iColumn; /* Column number */
10429 ** pointer to this structure. The Expr.iColumn field is the index in
10449 int iColumn; /* Column number within the source table */
10512 ** Expr.iColumn is the column number for the specific column. If the
10521 ** If the expression is a subquery then Expr.iColumn holds an integer
10576 ynVar iColumn; /* TK_COLUMN: column index. -1 for rowid.
11110 int iColumn; /* Table column number */
73333 ** pExpr->iColumn Set to the column number within the table.
73426 pExpr->iColumn = j==pTab->iPKey ? -1 : (i16)j;
73478 pExpr->iColumn = (i16)iCol;
73491 pExpr->iColumn = -1; /* IMP: R-44911-55124 */
73577 if( pExpr->iColumn>=0 && pMatch!=0 ){
73578 int n = pExpr->iColumn;
73623 p->iColumn = -1;
73625 p->iColumn = (ynVar)iCol;
73681 pExpr->iColumn = -1;
74334 ** Expr.iColumn The column index in X.Y. -1 for the rowid.
74477 int j = pExpr->iColumn;
74533 int j = p->iColumn;
74985 pExpr->iColumn = (ynVar)(++pParse->nVar);
74994 pExpr->iColumn = x = (ynVar)i;
75015 pExpr->iColumn = x = (ynVar)i+1;
75019 if( x==0 ) x = pExpr->iColumn = (ynVar)(++pParse->nVar);
75745 return p->iColumn<0
75898 iCol = pExpr->iColumn;
75973 if( pX->pLeft->iColumn<0 && !ExprHasAnyProperty(pX, EP_xIsSelect) ){
76176 ** of the memory cell in iColumn. If this is an EXISTS, write
76178 ** and record that memory cell in iColumn.
76463 if( p->iReg && p->iTable==iTab && p->iColumn==iCol ){
76471 assert( p->iReg==0 || p->iTable!=iTab || p->iColumn!=iCol );
76480 p->iColumn = iCol;
76501 p->iColumn = iCol;
76592 ** Generate code that will extract the iColumn-th column from
76598 ** is called. If iColumn<0 then code is generated that extracts the rowid.
76603 int iColumn, /* Index of the table column */
76612 if( p->iReg>0 && p->iTable==iTable && p->iColumn==iColumn ){
76619 sqlite3ExprCodeGetColumnOfTable(v, pTab, iTable, iColumn, iReg);
76620 sqlite3ExprCacheStore(pParse, iTable, iColumn, iReg);
76745 inReg = pExpr->iColumn + pParse->ckBase;
76748 pExpr->iColumn, pExpr->iTable, target);
76792 sqlite3VdbeAddOp2(v, OP_Variable, pExpr->iColumn, target);
76795 || strcmp(pExpr->u.zToken, pParse->azVar[pExpr->iColumn-1])==0 );
76796 sqlite3VdbeChangeP4(v, -1, pParse->azVar[pExpr->iColumn-1], P4_STATIC);
77136 ** new.* pseudo-table, or 0 for the old.* pseudo-table. Expr.iColumn
77159 int p1 = pExpr->iTable * (pTab->nCol+1) + 1 + pExpr->iColumn;
77162 assert( pExpr->iColumn>=-1 && pExpr->iColumn<pTab->nCol );
77163 assert( pTab->iPKey<0 || pExpr->iColumn!=pTab->iPKey );
77169 (pExpr->iColumn<0 ? "rowid" : pExpr->pTab->aCol[pExpr->iColumn].zName),
77176 if( pExpr->iColumn>=0
77177 && pTab->aCol[pExpr->iColumn].affinity==SQLITE_AFF_REAL
77397 pExpr->iTable, pExpr->iColumn);
77403 sqlite3ExplainPrintf(pOut, "COLUMN(%d)", pExpr->iColumn);
77406 pExpr->iTable, pExpr->iColumn);
77440 pExpr->u.zToken, pExpr->iColumn);
77569 ** new.* pseudo-table, or 0 for the old.* pseudo-table. Expr.iColumn
77574 pExpr->iTable ? "NEW" : "OLD", pExpr->iColumn);
78155 if( pA->iTable!=pB->iTable || pA->iColumn!=pB->iColumn ) return 2;
78264 pCol->iColumn==pExpr->iColumn ){
78274 pCol->iColumn = pExpr->iColumn;
78286 pE->iColumn==pExpr->iColumn ){
81148 iCol = pExpr->iColumn;
88324 pRight->iColumn = -1;
95562 int iCol = pExpr->iColumn; /* Index of column in pTab */
95739 int iCol = p->iColumn;
95819 int iCol = pColExpr->iColumn;
97050 ** a column in table number iTable with a copy of the iColumn-th
97069 if( pExpr->iColumn<0 ){
97073 assert( pEList!=0 && pExpr->iColumn<pEList->nExpr );
97075 pNew = sqlite3ExprDup(db, pEList->a[pExpr->iColumn].pExpr, 0);
98768 pCol->pTab, pCol->iColumn, pCol->iTable, r1);
103152 ** where X is a reference to the iColumn of table iCur and <op> is one of
103159 int iColumn, /* Column number of LHS */
103172 && pTerm->u.leftColumn==iColumn
103175 if( iColumn>=0 && pIdx && pTerm->eOperator!=WO_ISNULL ){
103182 idxaff = pIdx->pTable->aCol[iColumn].affinity;
103193 for(j=0; pIdx->aiColumn[j]!=iColumn; j++){
103262 assert( pLeft->iColumn!=(-1) ); /* Because IPK never has AFF_TEXT */
103271 int iCol = pRight->iColumn;
103294 sqlite3VdbeSetVarmask(v, pRight->iColumn);
103554 int iColumn = -1; /* Column index on lhs of IN operator */
103560 ** will be recorded in iCursor and iColumn. There might not be any
103585 iColumn = pOrTerm->u.leftColumn;
103606 }else if( pOrTerm->u.leftColumn!=iColumn ){
103641 assert( pOrTerm->u.leftColumn==iColumn );
103742 pTerm->u.leftColumn = pLeft->iColumn;
103769 pNew->u.leftColumn = pLeft->iColumn;
103916 pNewTerm->u.leftColumn = pLeft->iColumn;
103940 && pExpr->pLeft->iColumn>=0
103957 pNewTerm->u.leftColumn = pLeft->iColumn;
104016 && p->iColumn==pIdx->aiColumn[iCol]
104067 pTerm = findTerm(pWC, p->iTable, p->iColumn, ~(Bitmask)0, WO_EQ, 0);
104118 if( p->op==TK_COLUMN && p->iTable==iBase && p->iColumn<0 ) return 1;
104209 int iColumn; /* The i-th column of the index. -1 for rowid */
104224 iColumn = pIdx->aiColumn[i];
104225 if( iColumn==pIdx->pTable->iPKey ){
104226 iColumn = -1;
104231 iColumn = -1;
104235 if( pExpr->iColumn!=iColumn || sqlite3StrICmp(pColl->zName, zColl) ){
104252 assert( pIdx->aSortOrder!=0 || iColumn==-1 );
104267 if( iColumn<0 && !referencesOtherTables(pOrderBy, pMaskSet, j, base) ){
104328 p->aConstraint[i].iColumn,
104336 p->aOrderBy[i].iColumn,
104791 pIdxCons[j].iColumn = pTerm->u.leftColumn;
104808 pIdxOrderBy[i].iColumn = pExpr->iColumn;
105205 int iVar = pExpr->iColumn;
106646 /* assert( pOrderBy->a[0].pExpr->iColumn==pIdx->aiColumn[nEq] ); */
116773 int iColumn; /* Index of column this phrase must match */
118083 && (pCons->iColumn<0 || pCons->iColumn==p->nColumn+1 )
118100 && pCons->iColumn>=0 && pCons->iColumn<=p->nColumn
118102 pInfo->idxNum = FTS3_FULLTEXT_SEARCH + pCons->iColumn;
118109 && pCons->iColumn==p->nColumn + 2
118128 if( pOrder->iColumn<0 || pOrder->iColumn==p->nColumn+1 ){
119474 int iColumn, /* Column to query (or -ve for all columns) */
119489 | (iColumn<p->nColumn ? FTS3_SEGMENT_COLUMN_FILTER : 0);
119490 filter.iCol = iColumn;
120404 rc = fts3TermSelect(pTab, pToken, p->iColumn, &nThis, &pThis);
120544 int iCol = (p->iColumn >= pTab->nColumn ? -1 : p->iColumn);
120781 pTC->iCol = pPhrase->iColumn;
121791 || (pPhrase->iColumn<pTab->nColumn && pPhrase->iColumn!=iCol)
122005 && pInfo->aOrderBy[0].iColumn==0
122013 if( pInfo->aConstraint[i].usable && pInfo->aConstraint[i].iColumn==0 ){
122507 int iCol, /* Value for Fts3Phrase.iColumn */
122535 pRet->pPhrase->iColumn = iCol;
122675 p->pPhrase->iColumn = pParse->iDefaultCol;
123213 "%zPHRASE %d 0", zBuf, pPhrase->iColumn);
131529 if( p->usable && p->iColumn==0 && p->op==SQLITE_INDEX_CONSTRAINT_EQ ){
131549 if( p->usable && (p->iColumn>0 || p->op==SQLITE_INDEX_CONSTRAINT_MATCH) ){
131563 zIdxStr[iIdx++] = p->iColumn - 1 + 'a';
