Lines Matching defs:iColumn
7687 ** aConstraint[].iColumn.)^ ^(aConstraint[].usable is TRUE if the
7774 int iColumn; /* Column constrained. -1 for ROWID */
7781 int iColumn; /* Column number */
7820 ** aConstraint[].iColumn field. ^An iColumn of -1 indicates the left-hand
7824 ** corresponding aConstraint[].iColumn is meaningless and should not be
16194 ** TK_COLUMN node in the expression tree refers to the Expr.iColumn-th
18856 i16 iColumn; /* Column number within the source table */
18936 ** Expr.iColumn is the column number for the specific column. If the
18945 ** If the expression is a subquery then Expr.iColumn holds an integer
19013 ynVar iColumn; /* TK_COLUMN: column index. -1 for rowid.
33113 pExpr->iTable, pExpr->iColumn, zFlgs);
33126 pExpr->iColumn, zFlgs, zOp2);
33130 pExpr->iTable, pExpr->iColumn,
33177 pExpr->u.zToken, pExpr->iColumn);
33382 ** new.* pseudo-table, or 0 for the old.* pseudo-table. Expr.iColumn
33387 pExpr->iTable ? "NEW" : "OLD", pExpr->iColumn);
33413 pExpr->iTable, pExpr->iColumn, zFlgs);
33426 pExpr->iColumn, pExpr->iTable-1,
33446 if( pExpr->iColumn<=0 ){
33450 pExpr->iColumn-1);
84611 int iBindVar = pExpr->iColumn;
86674 if( pExpr->iColumn<0 ){
86677 sqlite3_str_appendf(p, "c%d", (int)pExpr->iColumn);
105960 if( p->op==SQLITE_INDEX_CONSTRAINT_EQ && p->iColumn==iBaseCol+1 ){
105965 if( p->op==SQLITE_INDEX_CONSTRAINT_ISNULL && p->iColumn==iBaseCol ){
106907 n = pExpr->iColumn;
106928 ** iColumn. Append this new expression term to the FULL JOIN Match set
106936 i16 iColumn /* The column number */
106941 pNew->iColumn = iColumn;
106987 ** pExpr->iColumn Set to the column number within the table.
107116 extendFJMatch(pParse, &pFJMatch, pMatch, pExpr->iColumn);
107128 pExpr->iColumn = j;
107182 extendFJMatch(pParse, &pFJMatch, pMatch, pExpr->iColumn);
107188 pExpr->iColumn = j==pTab->iPKey ? -1 : (i16)j;
107307 pExpr->iColumn = iCol;
107323 pExpr->iColumn = iCol;
107327 pExpr->iColumn = (i16)iCol;
107365 if( pMatch->fg.isNestedFrom==0 ) pExpr->iColumn = -1;
107502 extendFJMatch(pParse, &pFJMatch, pMatch, pExpr->iColumn);
107556 if( pExpr->iColumn>=0 ){
107601 p->iColumn = -1;
107603 p->iColumn = (ynVar)iCol;
107719 pExpr->iColumn--;
108815 ** Expr.iColumn The column index in X.Y. -1 for the rowid.
108970 ** nodes of the expression is set to -1 and the Expr.iColumn value is
109063 return sqlite3TableColumnAffinity(pExpr->y.pTab, pExpr->iColumn);
109080 assert( pExpr->iColumn < pExpr->iTable );
109081 assert( pExpr->iColumn >= 0 );
109084 pExpr->pLeft->x.pSelect->pEList->a[pExpr->iColumn].pExpr
109268 if( (j = p->iColumn)>=0 ){
109592 ** iColumn: Index of a column in pVector
109608 pRet->iColumn = iField;
110369 pExpr->iColumn = x;
111870 || (p->iColumn==XN_ROWID && IsView(p->y.pTab))
111872 || (p->iColumn>=0
111874 && ALWAYS(p->iColumn<p->y.pTab->nCol)
111875 && p->y.pTab->aCol[p->iColumn].notNull==0);
111916 return aff>=SQLITE_AFF_NUMERIC && p->iColumn<0;
112177 if( nExpr==1 && pEList->a[0].pExpr->iColumn<0 ){
112198 int iCol = pEList->a[i].pExpr->iColumn;
112246 if( pIdx->aiColumn[j]!=pRhs->iColumn ) continue;
113218 ** Generate code that will extract the iColumn-th column from
113222 ** is called. If iColumn<0 then code is generated that extracts the rowid.
113227 int iColumn, /* Index of the table column */
113235 sqlite3ExprCodeGetColumnOfTable(pParse->pVdbe, pTab, iTable, iColumn, iReg);
113358 sqlite3VdbeAddOp3(v, OP_Offset, pArg->iTable, pArg->iColumn, target);
113505 if( pExpr->iColumn==p->iIdxCol && pExpr->iTable==p->iDataCur ){
113591 }else if( pCol->iColumn<0 ){
113595 pTab->zName, pTab->aCol[pCol->iColumn].zCnName));
113596 if( pTab->aCol[pCol->iColumn].affinity==SQLITE_AFF_REAL ){
113604 sqlite3VdbeAddOp3(v, OP_Column, pExpr->iTable, pExpr->iColumn, target);
113624 aff = sqlite3TableColumnAffinity(pExpr->y.pTab, pExpr->iColumn);
113645 int iCol = pExpr->iColumn;
113693 pExpr->iColumn, iTab, target,
113746 sqlite3VdbeAddOp2(v, OP_Variable, pExpr->iColumn, target);
114060 return pLeft->iTable + pExpr->iColumn;
114118 ** new.* pseudo-table, or 0 for the old.* pseudo-table. Expr.iColumn
114146 iCol = pExpr->iColumn;
114158 (pExpr->iColumn<0 ? "rowid" : pExpr->y.pTab->aCol[iCol].zCnName)
115008 iVar = pVar->iColumn;
115129 if( pA->iColumn!=pB->iColumn ) return 2;
115507 && sqlite3TableColumnToIndex(pWalker->u.pIdxCover->pIdx, pExpr->iColumn)<0
115758 ** Search the AggInfo object for an aCol[] entry that has iTable and iColumn.
115777 && pCol->iColumn==pExpr->iColumn
115793 pCol->iColumn = pExpr->iColumn;
115805 && pE->iColumn==pExpr->iColumn
115867 tmp.iColumn = pIEpr->iIdxCol;
117159 && pExpr->iColumn==p->iCol
117164 && pExpr->iColumn==p->iCol
121269 iCol = pExpr->iColumn;
125586 j = pCExpr->iColumn;
131922 pExpr->iColumn = iCol;
133160 if( pExpr->op==TK_COLUMN && pExpr->iColumn>=0 ){
133161 assert( pExpr->iColumn < pWalker->u.pTab->nCol );
133162 pWalker->eCode |= pWalker->u.pTab->aCol[pExpr->iColumn].colFlags;
134564 assert( pExpr->iColumn>=0 || pExpr->iColumn==-1 );
134565 if( pExpr->iColumn>=0 ){
134566 if( pWalker->u.aiCol[pExpr->iColumn]>=0 ){
141597 if( pConstraint->iColumn < pTab->iHidden ) continue;
141600 j = pConstraint->iColumn - pTab->iHidden;
143940 && pExpr->iColumn>=0
143944 && (pTab->aCol[pExpr->iColumn].colFlags & COLFLAG_SORTERREF)!=0
143967 pNew->iColumn = pPk ? pPk->aiColumn[k] : -1;
144813 int iCol = pExpr->iColumn; /* Index of column in pTab */
145036 int iCol = p->iColumn;
145132 int iCol = pColExpr->iColumn;
146723 ** a column in table number iTable with a copy of the iColumn-th
146750 if( pExpr->iColumn<0 ){
146756 int iColumn;
146759 iColumn = pExpr->iColumn;
146760 assert( iColumn>=0 );
146761 assert( pSubst->pEList!=0 && iColumn<pSubst->pEList->nExpr );
146763 pCopy = pSubst->pEList->a[iColumn].pExpr;
146775 ifNullRow.iColumn = -99;
146805 pSubst->pCList->a[iColumn].pExpr
146888 if( pExpr->iColumn<0 ) return WRC_Continue;
147690 && pE2->iColumn==pColumn->iColumn
147769 if( pColumn->iColumn!=pExpr->iColumn ) continue;
148163 && pLeft->iColumn < 0
149380 "agg-column[%d] pTab=%s iTable=%d iColumn=%d iMem=%d"
149383 pCol->iTable, pCol->iColumn, pAggInfo->iFirstReg+ii,
149504 pExpr->iColumn = pCol->iColumn;
153412 ** Expr.iColumn set to value (iCol+1). The resolver will modify the
153418 if( pRet ) pRet->iColumn = iCol+1;
154776 && pTerm->iColumn==XN_ROWID
154822 sCol[1].iColumn = pIdx->aiColumn[ii];
157300 int iColumn, /* Column number of LHS */
158369 && sqlite3TableColumnToIndex(pHint->pIdx, pExpr->iColumn)<0
158438 pExpr->iColumn = sqlite3TableColumnToIndex(pHint->pIdx, pExpr->iColumn);
158439 assert( pExpr->iColumn>=0 );
160445 int iCol = pRight->iColumn;
160538 sqlite3VdbeSetVarmask(v, pRight->iColumn);
161020 int iColumn = -1; /* Column index on lhs of IN operator */
161026 ** will be recorded in iCursor and iColumn. There might not be any
161054 iColumn = pOrTerm->u.x.leftColumn;
161077 }else if( pOrTerm->u.x.leftColumn!=iColumn || (iColumn==XN_EXPR
161113 assert( pOrTerm->u.x.leftColumn==iColumn );
161265 aiCurCol[1] = pExpr->iColumn;
161521 && pExpr->pLeft->iColumn>=0
161539 pNewTerm->u.x.leftColumn = pLeft->iColumn;
161735 pNewTerm->u.x.leftColumn = pLeft->iColumn;
162096 pColRef->iColumn = k++;
162465 i16 iColumn; /* The column on the LHS of the term. -1 for IPK */
162474 iColumn = pScan->aiColumn[pScan->iEquiv-1];
162482 && pTerm->u.x.leftColumn==iColumn
162483 && (iColumn!=XN_EXPR
162495 && pScan->aiColumn[j]==pX->iColumn ){
162501 pScan->aiColumn[j] = pX->iColumn;
162533 && pX->iColumn==pScan->aiColumn[0]
162583 ** for terms of the form "X <op> <expr>" where X is column iColumn of table
162584 ** iCur. Or if pIdx!=0 then X is column iColumn of index pIdx. pIdx
162601 int iColumn, /* Column to scan for */
162616 int j = iColumn;
162617 iColumn = pIdx->aiColumn[j];
162618 if( iColumn==pIdx->pTable->iPKey ){
162619 iColumn = XN_ROWID;
162620 }else if( iColumn>=0 ){
162621 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
162623 }else if( iColumn==XN_EXPR ){
162629 }else if( iColumn==XN_EXPR ){
162632 pScan->aiColumn[0] = iColumn;
162638 ** where X is a reference to the iColumn of table iCur or of index pIdx
162643 ** Search for terms matching the iColumn-th column of pIdx
162644 ** rather than the iColumn-th column of table iCur.
162664 int iColumn, /* Column number of LHS */
162673 p = whereScanInit(&scan, pWC, iCur, iColumn, op, pIdx);
162709 && p->iColumn==pIdx->aiColumn[iCol]
162774 if( p->iTable==iBase && p->iColumn<0 ) return 1;
162888 p->aConstraint[i].iColumn,
162897 p->aOrderBy[i].iColumn,
163510 assert( pExpr->iColumn>=XN_ROWID && pExpr->iColumn<pTab->nCol );
163523 assert( pE2->iColumn>=XN_ROWID && pE2->iColumn<pTab->nCol );
163524 pExpr->iColumn = pE2->iColumn;
163525 if( pE2->iColumn<0 ) continue; /* Collseq does not matter for rowid */
163526 zColl = sqlite3ColumnColl(&pTab->aCol[pE2->iColumn]);
163568 pIdxCons[j].iColumn = pTerm->u.x.leftColumn;
163616 && pExpr->iColumn==pExpr->pLeft->iColumn) );
163617 pIdxOrderBy[j].iColumn = pExpr->iColumn;
165062 || pLhs->iColumn!=pIdx->aiColumn[i+nEq]
165068 testcase( pLhs->iColumn==XN_ROWID );
165070 idxaff = sqlite3TableColumnAffinity(pIdx->pTable, pLhs->iColumn);
165550 if( pExpr->iColumn<0 ) return 1;
165552 if( pExpr->iColumn==pIndex->aiColumn[jj] ) return 1;
165658 /* if( pExpr->iColumn<(BMS-1) && pIdx->bHasExpr==0 ) return WRC_Continue;*/
165664 if( aiColumn[i]==pExpr->iColumn ) return WRC_Continue;
165808 if( pLeft->iColumn<0 ) return;
165809 aff = pIdx->pTable->aCol[pLeft->iColumn].affinity;
165819 p->iIdxCol = pLeft->iColumn;
165829 }else if( pLeft->iColumn<(BMS-1) ){
165830 *pMask &= ~((Bitmask)1 << pLeft->iColumn);
166911 u8 isMatch; /* iColumn matches a term of the ORDER BY clause */
166919 int iColumn; /* A column number within table iCur */
166998 pTerm = sqlite3WhereFindTerm(&pWInfo->sWC, iCur, pOBExpr->iColumn,
167010 if( (pTerm->eOperator&(WO_EQ|WO_IS))!=0 && pOBExpr->iColumn>=0 ){
167094 /* Get the column number in the table (iColumn) and sort order
167098 iColumn = pIndex->aiColumn[j];
167100 if( iColumn==pIndex->pTable->iPKey ) iColumn = XN_ROWID;
167102 iColumn = XN_ROWID;
167110 if( iColumn>=0
167112 && pIndex->pTable->aCol[iColumn].notNull==0
167116 if( iColumn==XN_EXPR ){
167132 if( iColumn>=XN_ROWID ){
167135 if( pOBExpr->iColumn!=iColumn ) continue;
167142 if( iColumn!=XN_ROWID ){
167175 if( iColumn==XN_ROWID ){
170163 pExpr->iColumn = (iCol<0 ? p->pSub->nExpr-1: iCol);
172631 p->iColumn = 0;
186212 int iColumn; /* Index of column this phrase must match */
187800 bDocid = (pCons->iColumn<0 || pCons->iColumn==p->nColumn+1);
187819 && pCons->iColumn>=0 && pCons->iColumn<=p->nColumn
187821 pInfo->idxNum = FTS3_FULLTEXT_SEARCH + pCons->iColumn;
187828 && pCons->iColumn==p->nColumn + 2
187874 if( pOrder->iColumn<0 || pOrder->iColumn==p->nColumn+1 ){
189317 int iColumn, /* Column to query (or -ve for all columns) */
189332 | (iColumn<p->nColumn ? FTS3_SEGMENT_COLUMN_FILTER : 0);
189333 filter.iCol = iColumn;
190491 rc = fts3TermSelect(pTab, pToken, p->iColumn, &nThis, &pThis);
190657 int iCol = (p->iColumn >= pTab->nColumn ? -1 : p->iColumn);
191106 pTC->iCol = pPhrase->iColumn;
192172 if( (pPhrase->iColumn<pTab->nColumn && pPhrase->iColumn!=iCol) ){
192506 && pInfo->aOrderBy[0].iColumn==0
192517 int iCol = pInfo->aConstraint[i].iColumn;
193080 int iCol, /* Value for Fts3Phrase.iColumn */
193115 pRet->pPhrase->iColumn = iCol;
193256 p->pPhrase->iColumn = pParse->iDefaultCol;
194033 "%zPHRASE %d 0", zBuf, pPhrase->iColumn);
196252 && pInfo->aConstraint[i].iColumn==0
203193 if( (pPhrase->iColumn>=pTab->nColumn || pPhrase->iColumn==iCol) ){
209897 int iColumn /* Which column to return */
209900 switch( iColumn ){
210021 if( pConstraint->iColumn < JEACH_JSON ) continue;
210022 iCol = pConstraint->iColumn - JEACH_JSON;
210034 && pIdxInfo->aOrderBy[0].iColumn<0
212355 && p->iColumn<=0 && p->op==SQLITE_INDEX_CONSTRAINT_EQ
212380 && ((p->iColumn>0 && p->iColumn<=pRtree->nDim2)
212396 zIdxStr[iIdx++] = (char)(p->iColumn - 1 + '0');
216106 if( p->iColumn<0 && p->op==SQLITE_INDEX_CONSTRAINT_EQ ){
216110 if( p->iColumn==0 && p->op>=SQLITE_INDEX_CONSTRAINT_FUNCTION ){
223772 switch( pIdxInfo->aConstraint[i].iColumn ){
223808 && pIdxInfo->aOrderBy[0].iColumn==0
223812 && pIdxInfo->aOrderBy[0].iColumn==0
223814 && pIdxInfo->aOrderBy[1].iColumn==1
224573 if( p->iColumn!=DBPAGE_COLUMN_SCHEMA ) continue;
224594 if( p->usable && p->iColumn<=0 && p->op==SQLITE_INDEX_CONSTRAINT_EQ ){
224607 && pIdxInfo->aOrderBy[0].iColumn<=0
249353 if( p->op==SQLITE_INDEX_CONSTRAINT_EQ && p->iColumn==11 ){
250188 int iCol = p->iColumn;
250234 if( p->iColumn<0 && p->usable ){
250258 int iSort = pInfo->aOrderBy[0].iColumn;
256808 if( p->iColumn==0 ){ /* term column */
256841 && pInfo->aOrderBy[0].iColumn==0