Lines Matching refs:iColumn
7895 ** aConstraint[].iColumn.)^ ^(aConstraint[].usable is TRUE if the
7982 int iColumn; /* Column constrained. -1 for ROWID */
7989 int iColumn; /* Column number */
15294 ** TK_COLUMN node in the expression tree refers to the Expr.iColumn-th
18071 i16 iColumn; /* Column number within the source table */
18133 ** Expr.iColumn is the column number for the specific column. If the
18142 ** If the expression is a subquery then Expr.iColumn holds an integer
18210 ynVar iColumn; /* TK_COLUMN: column index. -1 for rowid.
30182 pExpr->iTable, pExpr->iColumn, zFlgs);
30195 pExpr->iColumn, zFlgs, zOp2);
30198 pExpr->iTable, pExpr->iColumn,
30241 pExpr->u.zToken, pExpr->iColumn);
30414 ** new.* pseudo-table, or 0 for the old.* pseudo-table. Expr.iColumn
30419 pExpr->iTable ? "NEW" : "OLD", pExpr->iColumn);
30443 pExpr->iTable, pExpr->iColumn, zFlgs);
30454 sqlite3TreeViewLine(pView, "SELECT-COLUMN %d", pExpr->iColumn);
78154 int iBindVar = pExpr->iColumn;
79955 if( pExpr->iColumn<0 ){
79958 sqlite3_str_appendf(p, "c%d", (int)pExpr->iColumn);
97882 if( p->op==SQLITE_INDEX_CONSTRAINT_EQ && p->iColumn==iBaseCol+1 ){
97887 if( p->op==SQLITE_INDEX_CONSTRAINT_ISNULL && p->iColumn==iBaseCol ){
98818 n = pExpr->iColumn;
98847 ** pExpr->iColumn Set to the column number within the table.
98941 pExpr->iColumn = j;
98977 pExpr->iColumn = j==pTab->iPKey ? -1 : (i16)j;
99056 pExpr->iColumn = iCol;
99073 pExpr->iColumn = (i16)iCol;
99106 pExpr->iColumn = -1;
99260 if( pExpr->iColumn>=0 && pMatch!=0 ){
99309 p->iColumn = -1;
99311 p->iColumn = (ynVar)iCol;
99423 pExpr->iColumn--;
100461 ** Expr.iColumn The column index in X.Y. -1 for the rowid.
100611 ** nodes of the expression is set to -1 and the Expr.iColumn value is
100722 return sqlite3TableColumnAffinity(pExpr->y.pTab, pExpr->iColumn);
100727 pExpr->pLeft->x.pSelect->pEList->a[pExpr->iColumn].pExpr
100835 int j = p->iColumn;
101156 ** iColumn: Index of a column in pVector
101170 pRet->iColumn = iField;
101759 pExpr->iColumn = x;
102046 assert( p->iColumn==0 || p->pRight==0 );
102159 assert( pNewExpr->iColumn==0 || i>0 );
102160 if( pNewExpr->iColumn==0 ){
102166 assert( pNewExpr->iColumn==pItem[-1].pExpr->iColumn+1 );
102982 (p->iColumn>=0
102984 && p->y.pTab->aCol[p->iColumn].notNull==0);
103025 return aff>=SQLITE_AFF_NUMERIC && p->iColumn<0;
103261 if( nExpr==1 && pEList->a[0].pExpr->iColumn<0 ){
103282 int iCol = pEList->a[i].pExpr->iColumn;
103329 assert( pReq!=0 || pRhs->iColumn==XN_ROWID || pParse->nErr );
103331 if( pIdx->aiColumn[j]!=pRhs->iColumn ) continue;
104270 ** Generate code that will extract the iColumn-th column from
104274 ** is called. If iColumn<0 then code is generated that extracts the rowid.
104279 int iColumn, /* Index of the table column */
104285 sqlite3ExprCodeGetColumnOfTable(pParse->pVdbe, pTab, iTable, iColumn, iReg);
104514 if( pCol->iColumn<0 ){
104517 VdbeComment((v,"%s.%s",pTab->zName,pTab->aCol[pCol->iColumn].zName));
104518 if( pTab->aCol[pCol->iColumn].affinity==SQLITE_AFF_REAL ){
104540 aff = sqlite3TableColumnAffinity(pExpr->y.pTab, pExpr->iColumn);
104564 int iCol = pExpr->iColumn;
104603 pExpr->iColumn, iTab, target,
104659 sqlite3VdbeAddOp2(v, OP_Variable, pExpr->iColumn, target);
104661 const char *z = sqlite3VListNumToName(pParse->pVList, pExpr->iColumn);
104933 sqlite3VdbeAddOp3(v, OP_Offset, pArg->iTable, pArg->iColumn, target);
104979 return pExpr->pLeft->iTable + pExpr->iColumn;
105021 ** new.* pseudo-table, or 0 for the old.* pseudo-table. Expr.iColumn
105044 int iCol = pExpr->iColumn;
105056 (pExpr->iColumn<0 ? "rowid" : pExpr->y.pTab->aCol[iCol].zName)
105875 iVar = pVar->iColumn;
105978 if( pA->iColumn!=pB->iColumn ) return 2;
106305 && sqlite3TableColumnToIndex(pWalker->u.pIdxCover->pIdx, pExpr->iColumn)<0
106548 pCol->iColumn==pExpr->iColumn ){
106558 pCol->iColumn = pExpr->iColumn;
106570 pE->iColumn==pExpr->iColumn ){
107702 && pExpr->iColumn==p->iCol
107707 && pExpr->iColumn==p->iCol
111481 iCol = pExpr->iColumn;
115471 j = pCExpr->iColumn;
121226 pExpr->iColumn = iCol;
122377 if( pExpr->op==TK_COLUMN && pExpr->iColumn>=0 ){
122378 assert( pExpr->iColumn < pWalker->u.pTab->nCol );
122379 pWalker->eCode |= pWalker->u.pTab->aCol[pExpr->iColumn].colFlags;
123533 assert( pExpr->iColumn>=0 || pExpr->iColumn==-1 );
123534 if( pExpr->iColumn>=0 ){
123535 if( pWalker->u.aiCol[pExpr->iColumn]>=0 ){
129941 if( pConstraint->iColumn < pTab->iHidden ) continue;
129942 j = pConstraint->iColumn - pTab->iHidden;
131968 if( pExpr->op==TK_COLUMN && pExpr->iColumn>=0 && pTab && !IsVirtual(pTab)
131969 && (pTab->aCol[pExpr->iColumn].colFlags & COLFLAG_SORTERREF)
131991 pNew->iColumn = pPk ? pPk->aiColumn[k] : -1;
132853 int iCol = pExpr->iColumn; /* Index of column in pTab */
133078 int iCol = p->iColumn;
133169 int iCol = pColExpr->iColumn;
134653 ** a column in table number iTable with a copy of the iColumn-th
134678 if( pExpr->iColumn<0 ){
134682 Expr *pCopy = pSubst->pEList->a[pExpr->iColumn].pExpr;
134684 assert( pSubst->pEList!=0 && pExpr->iColumn<pSubst->pEList->nExpr );
134794 if( pExpr->iColumn<0 ) return WRC_Continue;
135512 && pE2->iColumn==pColumn->iColumn
135577 if( pColumn->iColumn!=pExpr->iColumn ) continue;
138003 pCol->pTab, pCol->iTable, pCol->iColumn, r1);
140060 ** Expr.iColumn set to value (iCol+1). The resolver will modify the
140066 if( pRet ) pRet->iColumn = iCol+1;
141380 && pTerm->iColumn==XN_ROWID
141425 sCol[1].iColumn = pIdx->aiColumn[ii];
143817 int iColumn, /* Column number of LHS */
144744 && sqlite3TableColumnToIndex(pHint->pIdx, pExpr->iColumn)<0
144812 pExpr->iColumn = sqlite3TableColumnToIndex(pHint->pIdx, pExpr->iColumn);
144813 assert( pExpr->iColumn>=0 );
145063 pExpr->iColumn = pX->iIdxCol;
145081 if( pExpr->iTable==pX->iTabCur && pExpr->iColumn==pX->iTabCol ){
145084 pExpr->affExpr = sqlite3TableColumnAffinity(pExpr->y.pTab,pExpr->iColumn);
145086 pExpr->iColumn = pX->iIdxCol;
146609 int iCol = pRight->iColumn;
146697 sqlite3VdbeSetVarmask(v, pRight->iColumn);
147173 int iColumn = -1; /* Column index on lhs of IN operator */
147179 ** will be recorded in iCursor and iColumn. There might not be any
147206 iColumn = pOrTerm->u.x.leftColumn;
147228 }else if( pOrTerm->u.x.leftColumn!=iColumn || (iColumn==XN_EXPR
147263 assert( pOrTerm->u.x.leftColumn==iColumn );
147407 aiCurCol[1] = pExpr->iColumn;
147894 && pExpr->pLeft->iColumn>=0
147912 pNewTerm->u.x.leftColumn = pLeft->iColumn;
148100 pNewTerm->u.x.leftColumn = pLeft->iColumn;
148295 pColRef->iColumn = k++;
148583 i16 iColumn; /* The column on the LHS of the term. -1 for IPK */
148592 iColumn = pScan->aiColumn[pScan->iEquiv-1];
148598 && pTerm->u.x.leftColumn==iColumn
148599 && (iColumn!=XN_EXPR
148611 && pScan->aiColumn[j]==pX->iColumn ){
148617 pScan->aiColumn[j] = pX->iColumn;
148640 && pX->iColumn==pScan->aiColumn[0]
148678 ** for terms of the form "X <op> <expr>" where X is column iColumn of table
148679 ** iCur. Or if pIdx!=0 then X is column iColumn of index pIdx. pIdx
148696 int iColumn, /* Column to scan for */
148711 int j = iColumn;
148712 iColumn = pIdx->aiColumn[j];
148713 if( iColumn==XN_EXPR ){
148718 }else if( iColumn==pIdx->pTable->iPKey ){
148719 iColumn = XN_ROWID;
148720 }else if( iColumn>=0 ){
148721 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
148724 }else if( iColumn==XN_EXPR ){
148727 pScan->aiColumn[0] = iColumn;
148733 ** where X is a reference to the iColumn of table iCur or of index pIdx
148738 ** Search for terms matching the iColumn-th column of pIdx
148739 ** rather than the iColumn-th column of table iCur.
148759 int iColumn, /* Column number of LHS */
148768 p = whereScanInit(&scan, pWC, iCur, iColumn, op, pIdx);
148804 && p->iColumn==pIdx->aiColumn[iCol]
148868 if( p->op==TK_COLUMN && p->iTable==iBase && p->iColumn<0 ) return 1;
148965 p->aConstraint[i].iColumn,
148973 p->aOrderBy[i].iColumn,
149335 pIdxCons[j].iColumn = pTerm->u.x.leftColumn;
149374 pIdxOrderBy[i].iColumn = pExpr->iColumn;
150714 || pLhs->iColumn!=pIdx->aiColumn[i+nEq]
150720 testcase( pLhs->iColumn==XN_ROWID );
150722 idxaff = sqlite3TableColumnAffinity(pIdx->pTable, pLhs->iColumn);
151155 if( pExpr->iColumn<0 ) return 1;
151157 if( pExpr->iColumn==pIndex->aiColumn[jj] ) return 1;
152050 u8 isMatch; /* iColumn matches a term of the ORDER BY clause */
152058 int iColumn; /* A column number within table iCur */
152135 pTerm = sqlite3WhereFindTerm(&pWInfo->sWC, iCur, pOBExpr->iColumn,
152147 if( (pTerm->eOperator&(WO_EQ|WO_IS))!=0 && pOBExpr->iColumn>=0 ){
152227 /* Get the column number in the table (iColumn) and sort order
152231 iColumn = pIndex->aiColumn[j];
152233 if( iColumn==pIndex->pTable->iPKey ) iColumn = XN_ROWID;
152235 iColumn = XN_ROWID;
152243 && iColumn>=0
152245 && pIndex->pTable->aCol[iColumn].notNull==0
152261 if( iColumn>=XN_ROWID ){
152264 if( pOBExpr->iColumn!=iColumn ) continue;
152271 if( iColumn!=XN_ROWID ){
152302 if( iColumn==XN_ROWID ){
154751 pExpr->iColumn = (iCol<0 ? p->pSub->nExpr-1: iCol);
157163 p->iColumn = 0;
170071 int iColumn; /* Index of column this phrase must match */
171652 bDocid = (pCons->iColumn<0 || pCons->iColumn==p->nColumn+1);
171671 && pCons->iColumn>=0 && pCons->iColumn<=p->nColumn
171673 pInfo->idxNum = FTS3_FULLTEXT_SEARCH + pCons->iColumn;
171680 && pCons->iColumn==p->nColumn + 2
171726 if( pOrder->iColumn<0 || pOrder->iColumn==p->nColumn+1 ){
173169 int iColumn, /* Column to query (or -ve for all columns) */
173184 | (iColumn<p->nColumn ? FTS3_SEGMENT_COLUMN_FILTER : 0);
173185 filter.iCol = iColumn;
174274 rc = fts3TermSelect(pTab, pToken, p->iColumn, &nThis, &pThis);
174437 int iCol = (p->iColumn >= pTab->nColumn ? -1 : p->iColumn);
174886 pTC->iCol = pPhrase->iColumn;
175944 if( (pPhrase->iColumn<pTab->nColumn && pPhrase->iColumn!=iCol) ){
176269 && pInfo->aOrderBy[0].iColumn==0
176280 int iCol = pInfo->aConstraint[i].iColumn;
176837 int iCol, /* Value for Fts3Phrase.iColumn */
176872 pRet->pPhrase->iColumn = iCol;
177013 p->pPhrase->iColumn = pParse->iDefaultCol;
177790 "%zPHRASE %d 0", zBuf, pPhrase->iColumn);
180009 && pInfo->aConstraint[i].iColumn==0
186906 if( (pPhrase->iColumn>=pTab->nColumn || pPhrase->iColumn==iCol) ){
190921 if( pConstraint->iColumn < JEACH_JSON ) continue;
190922 iCol = pConstraint->iColumn - JEACH_JSON;
193188 && p->iColumn==0 && p->op==SQLITE_INDEX_CONSTRAINT_EQ
193213 && ((p->iColumn>0 && p->iColumn<=pRtree->nDim2)
193228 zIdxStr[iIdx++] = (char)(p->iColumn - 1 + '0');
197045 if( p->iColumn<0 && p->op==SQLITE_INDEX_CONSTRAINT_EQ ){
197049 if( p->iColumn==0 && p->op>=SQLITE_INDEX_CONSTRAINT_FUNCTION ){
204521 switch( pIdxInfo->aConstraint[i].iColumn ){
204557 && pIdxInfo->aOrderBy[0].iColumn==0
204561 && pIdxInfo->aOrderBy[0].iColumn==0
204563 && pIdxInfo->aOrderBy[1].iColumn==1
205274 if( p->iColumn!=DBPAGE_COLUMN_SCHEMA ) continue;
205295 if( p->usable && p->iColumn<=0 && p->op==SQLITE_INDEX_CONSTRAINT_EQ ){
205308 && pIdxInfo->aOrderBy[0].iColumn<=0
227101 int iCol = p->iColumn;
227147 if( p->iColumn<0 && p->usable ){
227168 int iSort = pInfo->aOrderBy[0].iColumn;
233421 if( p->iColumn==0 ){ /* term column */
233454 && pInfo->aOrderBy[0].iColumn==0