Lines Matching defs:iColumn
5473 ** aConstraint[].iColumn.)^ ^(aConstraint[].usable is TRUE if the
5523 int iColumn; /* Column on left-hand side of constraint */
5530 int iColumn; /* Column number */
11231 ** pointer to this structure. The Expr.iColumn field is the index in
11252 int iColumn; /* Column number within the source table */
11315 ** Expr.iColumn is the column number for the specific column. If the
11324 ** If the expression is a subquery then Expr.iColumn holds an integer
11382 ynVar iColumn; /* TK_COLUMN: column index. -1 for rowid.
11938 i16 iColumn; /* Table column number */
62035 int iBindVar = pExpr->iColumn;
62416 printf(" r[%d]={%d:%d}", x->iReg, x->iTable, x->iColumn);
76984 ** pExpr->iColumn Set to the column number within the table.
77070 pExpr->iColumn = j;
77102 pExpr->iColumn = j==pTab->iPKey ? -1 : (i16)j;
77161 pExpr->iColumn = (i16)iCol;
77175 pExpr->iColumn = -1; /* IMP: R-44911-55124 */
77271 if( pExpr->iColumn>=0 && pMatch!=0 ){
77272 int n = pExpr->iColumn;
77319 p->iColumn = -1;
77321 p->iColumn = (ynVar)iCol;
77423 pExpr->iColumn = -1;
78109 ** Expr.iColumn The column index in X.Y. -1 for the rowid.
78211 ** is set to -1 and the Expr.iColumn value is set to the column number.
78299 int j = pExpr->iColumn;
78387 int j = p->iColumn;
78875 pExpr->iColumn = (ynVar)(++pParse->nVar);
78884 pExpr->iColumn = x = (ynVar)i;
78905 pExpr->iColumn = x = (ynVar)i+1;
78909 if( x==0 ) x = pExpr->iColumn = (ynVar)(++pParse->nVar);
79619 return p->iColumn>=0 && p->pTab->aCol[p->iColumn].notNull==0;
79656 return p->iColumn<0
79860 iCol = (i16)pExpr->iColumn;
79941 if( pX->pLeft->iColumn<0 && !ExprHasProperty(pX, EP_xIsSelect) ){
80145 ** of the memory cell in iColumn. If this is an EXISTS, write
80147 ** and record that memory cell in iColumn.
80476 assert( p->iReg==0 || p->iTable!=iTab || p->iColumn!=iCol );
80485 p->iColumn = iCol;
80506 p->iColumn = iCol;
80610 ** Generate code that will extract the iColumn-th column from
80616 ** is called. If iColumn<0 then code is generated that extracts the rowid.
80621 int iColumn, /* Index of the table column */
80631 if( p->iReg>0 && p->iTable==iTable && p->iColumn==iColumn ){
80638 sqlite3ExprCodeGetColumnOfTable(v, pTab, iTable, iColumn, iReg);
80642 sqlite3ExprCacheStore(pParse, iTable, iColumn, iReg);
80773 inReg = pExpr->iColumn + pParse->ckBase;
80781 pExpr->iColumn, iTab, target,
80825 sqlite3VdbeAddOp2(v, OP_Variable, pExpr->iColumn, target);
80828 || strcmp(pExpr->u.zToken, pParse->azVar[pExpr->iColumn-1])==0 );
80829 sqlite3VdbeChangeP4(v, -1, pParse->azVar[pExpr->iColumn-1], P4_STATIC);
81189 ** new.* pseudo-table, or 0 for the old.* pseudo-table. Expr.iColumn
81212 int p1 = pExpr->iTable * (pTab->nCol+1) + 1 + pExpr->iColumn;
81215 assert( pExpr->iColumn>=-1 && pExpr->iColumn<pTab->nCol );
81216 assert( pTab->iPKey<0 || pExpr->iColumn!=pTab->iPKey );
81222 (pExpr->iColumn<0 ? "rowid" : pExpr->pTab->aCol[pExpr->iColumn].zName),
81229 if( pExpr->iColumn>=0
81230 && pTab->aCol[pExpr->iColumn].affinity==SQLITE_AFF_REAL
81497 pExpr->iTable, pExpr->iColumn);
81503 sqlite3ExplainPrintf(pOut, "COLUMN(%d)", pExpr->iColumn);
81506 pExpr->iTable, pExpr->iColumn);
81540 pExpr->u.zToken, pExpr->iColumn);
81677 ** new.* pseudo-table, or 0 for the old.* pseudo-table. Expr.iColumn
81682 pExpr->iTable ? "NEW" : "OLD", pExpr->iColumn);
82199 if( pA->iColumn!=pB->iColumn ) return 2;
82399 pCol->iColumn==pExpr->iColumn ){
82409 pCol->iColumn = pExpr->iColumn;
82421 pE->iColumn==pExpr->iColumn ){
86027 iCol = pExpr->iColumn;
93940 pExpr->iColumn = iCol;
102758 int iCol = pExpr->iColumn; /* Index of column in pTab */
102948 int iCol = p->iColumn;
103035 int iCol = pColExpr->iColumn;
104438 ** a column in table number iTable with a copy of the iColumn-th
104457 if( pExpr->iColumn<0 ){
104461 assert( pEList!=0 && pExpr->iColumn<pEList->nExpr );
104463 pNew = sqlite3ExprDup(db, pEList->a[pExpr->iColumn].pExpr, 0);
106472 pCol->pTab, pCol->iColumn, pCol->iTable, r1, 0);
111357 int iColumn; /* The column on the LHS of the term. -1 for IPK */
111365 iColumn = pScan->aEquiv[pScan->iEquiv-1];
111369 && pTerm->u.leftColumn==iColumn
111380 && pScan->aEquiv[j+1]==pX->iColumn ){
111386 pScan->aEquiv[j+1] = pX->iColumn;
111410 && pX->iColumn==pScan->aEquiv[1]
111434 ** for terms of the form "X <op> <expr>" where X is column iColumn of table
111449 int iColumn, /* Column to scan for */
111458 if( pIdx && iColumn>=0 ){
111459 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
111460 for(j=0; pIdx->aiColumn[j]!=iColumn; j++){
111471 pScan->aEquiv[1] = iColumn;
111479 ** where X is a reference to the iColumn of table iCur and <op> is one of
111503 int iColumn, /* Column number of LHS */
111512 p = whereScanInit(&scan, pWC, iCur, iColumn, op, pIdx);
111583 assert( pLeft->iColumn!=(-1) ); /* Because IPK never has AFF_TEXT */
111589 int iCol = pRight->iColumn;
111612 sqlite3VdbeSetVarmask(v, pRight->iColumn);
111873 int iColumn = -1; /* Column index on lhs of IN operator */
111879 ** will be recorded in iCursor and iColumn. There might not be any
111904 iColumn = pOrTerm->u.leftColumn;
111925 }else if( pOrTerm->u.leftColumn!=iColumn ){
111958 assert( pOrTerm->u.leftColumn==iColumn );
112061 pTerm->u.leftColumn = pLeft->iColumn;
112096 pNew->u.leftColumn = pLeft->iColumn;
112247 pNewTerm->u.leftColumn = pLeft->iColumn;
112271 && pExpr->pLeft->iColumn>=0
112289 pNewTerm->u.leftColumn = pLeft->iColumn;
112326 && p->iColumn==pIdx->aiColumn[iCol]
112370 if( p->op==TK_COLUMN && p->iTable==iBase && p->iColumn<0 ) return 1;
112427 p->aConstraint[i].iColumn,
112435 p->aOrderBy[i].iColumn,
112724 pIdxCons[j].iColumn = pTerm->u.leftColumn;
112743 pIdxOrderBy[i].iColumn = pExpr->iColumn;
115441 if( pExpr->iColumn==pIndex->aiColumn[jj] ) return 1;
116050 u8 isMatch; /* iColumn matches a term of the ORDER BY clause */
116057 int iColumn; /* A column number within table iCur */
116120 pTerm = findTerm(&pWInfo->sWC, iCur, pOBExpr->iColumn,
116123 if( (pTerm->eOperator&WO_EQ)!=0 && pOBExpr->iColumn>=0 ){
116171 /* Get the column number in the table (iColumn) and sort order
116175 iColumn = pIndex->aiColumn[j];
116177 if( iColumn==pIndex->pTable->iPKey ) iColumn = -1;
116179 iColumn = -1;
116187 && iColumn>=0
116189 && pIndex->pTable->aCol[iColumn].notNull==0
116207 if( pOBExpr->iColumn!=iColumn ) continue;
116208 if( iColumn>=0 ){
116228 if( iColumn<0 ){
126930 int iColumn; /* Index of column this phrase must match */
128382 bDocid = (pCons->iColumn<0 || pCons->iColumn==p->nColumn+1);
128401 && pCons->iColumn>=0 && pCons->iColumn<=p->nColumn
128403 pInfo->idxNum = FTS3_FULLTEXT_SEARCH + pCons->iColumn;
128410 && pCons->iColumn==p->nColumn + 2
128453 if( pOrder->iColumn<0 || pOrder->iColumn==p->nColumn+1 ){
129794 int iColumn, /* Column to query (or -ve for all columns) */
129809 | (iColumn<p->nColumn ? FTS3_SEGMENT_COLUMN_FILTER : 0);
129810 filter.iCol = iColumn;
130856 rc = fts3TermSelect(pTab, pToken, p->iColumn, &nThis, &pThis);
131018 int iCol = (p->iColumn >= pTab->nColumn ? -1 : p->iColumn);
131462 pTC->iCol = pPhrase->iColumn;
132497 if( (pPhrase->iColumn<pTab->nColumn && pPhrase->iColumn!=iCol) ){
132830 && pInfo->aOrderBy[0].iColumn==0
132841 int iCol = pInfo->aConstraint[i].iColumn;
133396 int iCol, /* Value for Fts3Phrase.iColumn */
133431 pRet->pPhrase->iColumn = iCol;
133572 p->pPhrase->iColumn = pParse->iDefaultCol;
134350 "%zPHRASE %d 0", zBuf, pPhrase->iColumn);
136517 && pInfo->aConstraint[i].iColumn==0
146361 if( p->usable && p->iColumn==0 && p->op==SQLITE_INDEX_CONSTRAINT_EQ ){
146383 if( p->usable && (p->iColumn>0 || p->op==SQLITE_INDEX_CONSTRAINT_MATCH) ){
146397 zIdxStr[iIdx++] = p->iColumn - 1 + '0';
