Lines Matching defs:iColumn
7188 ** aConstraint[].iColumn.)^ ^(aConstraint[].usable is TRUE if the
7269 int iColumn; /* Column constrained. -1 for ROWID */
7276 int iColumn; /* Column number */
13456 ** TK_COLUMN node in the expression tree refers to the Expr.iColumn-th
16121 ** pointer to this structure. The Expr.iColumn field is the index in
16142 int iColumn; /* Column number within the source table */
16205 ** Expr.iColumn is the column number for the specific column. If the
16214 ** If the expression is a subquery then Expr.iColumn holds an integer
16273 ynVar iColumn; /* TK_COLUMN: column index. -1 for rowid.
16903 i16 iColumn; /* Table column number */
27238 pExpr->iTable, pExpr->iColumn, zFlgs);
27244 sqlite3TreeViewLine(pView, "COLUMN(%d)%s", pExpr->iColumn, zFlgs);
27247 pExpr->iTable, pExpr->iColumn, zFlgs);
27281 pExpr->u.zToken, pExpr->iColumn);
27408 ** new.* pseudo-table, or 0 for the old.* pseudo-table. Expr.iColumn
27413 pExpr->iTable ? "NEW" : "OLD", pExpr->iColumn);
27437 pExpr->iTable, pExpr->iColumn, zFlgs);
27446 sqlite3TreeViewLine(pView, "SELECT-COLUMN %d", pExpr->iColumn);
72753 int iBindVar = pExpr->iColumn;
73176 printf(" r[%d]={%d:%d}", x->iReg, x->iTable, x->iColumn);
74236 if( pExpr->iColumn<0 ){
74239 sqlite3XPrintf(p, "c%d", (int)pExpr->iColumn);
91331 ** pExpr->iColumn Set to the column number within the table.
91419 pExpr->iColumn = j;
91451 pExpr->iColumn = j==pTab->iPKey ? -1 : (i16)j;
91514 pExpr->iColumn = (i16)iCol;
91533 pExpr->iColumn = -1;
91633 if( pExpr->iColumn>=0 && pMatch!=0 ){
91634 int n = pExpr->iColumn;
91682 p->iColumn = -1;
91684 p->iColumn = (ynVar)iCol;
91773 pExpr->iColumn = -1;
92562 ** Expr.iColumn The column index in X.Y. -1 for the rowid.
92674 ** is set to -1 and the Expr.iColumn value is set to the column number.
92765 return sqlite3TableColumnAffinity(pExpr->pTab, pExpr->iColumn);
92770 pExpr->pLeft->x.pSelect->pEList->a[pExpr->iColumn].pExpr
92861 int j = p->iColumn;
93150 ** iColumn: Index of a column in pVector
93164 pRet->iColumn = iField;
93738 pExpr->iColumn = x;
93972 assert( p->iColumn==0 || p->pRight==0 );
94052 assert( pNewExpr->iColumn==0 || i>0 );
94053 if( pNewExpr->iColumn==0 ){
94059 assert( pNewExpr->iColumn==pItem[-1].pExpr->iColumn+1 );
94721 (p->iColumn>=0 && p->pTab->aCol[p->iColumn].notNull==0);
94758 return p->iColumn<0
94993 if( nExpr==1 && pEList->a[0].pExpr->iColumn<0 ){
95013 int iCol = pEList->a[i].pExpr->iColumn;
95059 assert( pReq!=0 || pRhs->iColumn==XN_ROWID || pParse->nErr );
95061 if( pIdx->aiColumn[j]!=pRhs->iColumn ) continue;
95132 if( pX->pLeft->iColumn<0 && !ExprHasProperty(pX, EP_xIsSelect) ){
95875 assert( p->iTable!=iTab || p->iColumn!=iCol );
95897 p->iColumn = iCol;
96025 ** Generate code that will extract the iColumn-th column from
96034 ** is called. If iColumn<0 then code is generated that extracts the rowid.
96039 int iColumn, /* Index of the table column */
96049 if( p->iTable==iTable && p->iColumn==iColumn ){
96056 sqlite3ExprCodeGetColumnOfTable(v, pTab, iTable, iColumn, iReg);
96060 sqlite3ExprCacheStore(pParse, iTable, iColumn, iReg);
96067 int iColumn, /* Index of the table column */
96071 int r1 = sqlite3ExprCodeGetColumn(pParse, pTab, iColumn, iTable, iReg, 0);
96234 return pExpr->iColumn - pParse->iSelfTab;
96242 pExpr->iColumn, iTab, target,
96285 sqlite3VdbeAddOp2(v, OP_Variable, pExpr->iColumn, target);
96287 const char *z = sqlite3VListNumToName(pParse->pVList, pExpr->iColumn);
96579 sqlite3VdbeAddOp3(v, OP_Offset, pArg->iTable, pArg->iColumn, target);
96620 return pExpr->pLeft->iTable + pExpr->iColumn;
96661 ** new.* pseudo-table, or 0 for the old.* pseudo-table. Expr.iColumn
96684 int p1 = pExpr->iTable * (pTab->nCol+1) + 1 + pExpr->iColumn;
96687 assert( pExpr->iColumn>=-1 && pExpr->iColumn<pTab->nCol );
96688 assert( pTab->iPKey<0 || pExpr->iColumn!=pTab->iPKey );
96694 (pExpr->iColumn<0 ? "rowid" : pExpr->pTab->aCol[pExpr->iColumn].zName),
96704 if( pExpr->iColumn>=0
96705 && pTab->aCol[pExpr->iColumn].affinity==SQLITE_AFF_REAL
97446 iVar = pVar->iColumn;
97529 if( pA->iColumn!=pB->iColumn ) return 2;
97640 && sqlite3ColumnOfIndex(pWalker->u.pIdxCover->pIdx, pExpr->iColumn)<0
97800 pCol->iColumn==pExpr->iColumn ){
97810 pCol->iColumn = pExpr->iColumn;
97822 pE->iColumn==pExpr->iColumn ){
101533 iCol = pExpr->iColumn;
104815 j = pCExpr->iColumn;
109930 pExpr->iColumn = iCol;
111953 assert( pExpr->iColumn>=0 || pExpr->iColumn==-1 );
111954 if( pExpr->iColumn>=0 ){
111955 if( pWalker->u.aiCol[pExpr->iColumn]>=0 ){
117600 if( pConstraint->iColumn < pTab->iHidden ) continue;
117601 j = pConstraint->iColumn - pTab->iHidden;
120096 int iCol = pExpr->iColumn; /* Index of column in pTab */
120321 int iCol = p->iColumn;
120412 int iCol = pColExpr->iColumn;
121857 ** a column in table number iTable with a copy of the iColumn-th
121879 if( pExpr->iColumn<0 ){
121883 Expr *pCopy = pSubst->pEList->a[pExpr->iColumn].pExpr;
121885 assert( pSubst->pEList!=0 && pExpr->iColumn<pSubst->pEList->nExpr );
124481 pCol->pTab, pCol->iColumn, pCol->iTable, r1);
129101 int iColumn, /* Column number of LHS */
130003 && sqlite3ColumnOfIndex(pHint->pIdx, pExpr->iColumn)<0
130068 v, pExpr->pTab, pExpr->iTable, pExpr->iColumn, reg
130074 pExpr->iColumn = sqlite3ColumnOfIndex(pHint->pIdx, pExpr->iColumn);
130075 assert( pExpr->iColumn>=0 );
130300 pExpr->iColumn = pX->iIdxCol;
131613 int iCol = pRight->iColumn;
131679 sqlite3VdbeSetVarmask(v, pRight->iColumn);
132106 int iColumn = -1; /* Column index on lhs of IN operator */
132112 ** will be recorded in iCursor and iColumn. There might not be any
132138 iColumn = pOrTerm->u.leftColumn;
132159 }else if( pOrTerm->u.leftColumn!=iColumn ){
132192 assert( pOrTerm->u.leftColumn==iColumn );
132334 aiCurCol[1] = pExpr->iColumn;
132643 pNewTerm->u.leftColumn = pLeft->iColumn;
132719 && pExpr->pLeft->iColumn>=0
132737 pNewTerm->u.leftColumn = pLeft->iColumn;
132915 pColRef->iColumn = k++;
133134 i16 iColumn; /* The column on the LHS of the term. -1 for IPK */
133143 iColumn = pScan->aiColumn[pScan->iEquiv-1];
133149 && pTerm->u.leftColumn==iColumn
133150 && (iColumn!=XN_EXPR
133162 && pScan->aiColumn[j]==pX->iColumn ){
133168 pScan->aiColumn[j] = pX->iColumn;
133192 && pX->iColumn==pScan->aiColumn[0]
133219 ** for terms of the form "X <op> <expr>" where X is column iColumn of table
133220 ** iCur. Or if pIdx!=0 then X is column iColumn of index pIdx. pIdx
133237 int iColumn, /* Column to scan for */
133247 int j = iColumn;
133248 iColumn = pIdx->aiColumn[j];
133249 if( iColumn==XN_EXPR ){
133252 }else if( iColumn==pIdx->pTable->iPKey ){
133253 iColumn = XN_ROWID;
133254 }else if( iColumn>=0 ){
133255 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
133258 }else if( iColumn==XN_EXPR ){
133264 pScan->aiColumn[0] = iColumn;
133272 ** where X is a reference to the iColumn of table iCur or of index pIdx
133277 ** Search for terms matching the iColumn-th column of pIdx
133278 ** rather than the iColumn-th column of table iCur.
133298 int iColumn, /* Column number of LHS */
133307 p = whereScanInit(&scan, pWC, iCur, iColumn, op, pIdx);
133342 && p->iColumn==pIdx->aiColumn[iCol]
133405 if( p->op==TK_COLUMN && p->iTable==iBase && p->iColumn<0 ) return 1;
133504 p->aConstraint[i].iColumn,
133512 p->aOrderBy[i].iColumn,
133873 pIdxCons[j].iColumn = pTerm->u.leftColumn;
133910 pIdxOrderBy[i].iColumn = pExpr->iColumn;
135232 || pLhs->iColumn!=pIdx->aiColumn[i+nEq]
135238 testcase( pLhs->iColumn==XN_ROWID );
135240 idxaff = sqlite3TableColumnAffinity(pIdx->pTable, pLhs->iColumn);
135612 if( pExpr->iColumn<0 ) return 1;
135614 if( pExpr->iColumn==pIndex->aiColumn[jj] ) return 1;
136457 u8 isMatch; /* iColumn matches a term of the ORDER BY clause */
136465 int iColumn; /* A column number within table iCur */
136537 pTerm = sqlite3WhereFindTerm(&pWInfo->sWC, iCur, pOBExpr->iColumn,
136548 if( (pTerm->eOperator&(WO_EQ|WO_IS))!=0 && pOBExpr->iColumn>=0 ){
136618 /* Get the column number in the table (iColumn) and sort order
136622 iColumn = pIndex->aiColumn[j];
136624 if( iColumn==pIndex->pTable->iPKey ) iColumn = XN_ROWID;
136626 iColumn = XN_ROWID;
136634 && iColumn>=0
136636 && pIndex->pTable->aCol[iColumn].notNull==0
136651 if( iColumn>=XN_ROWID ){
136654 if( pOBExpr->iColumn!=iColumn ) continue;
136661 if( iColumn!=XN_ROWID ){
136681 if( iColumn==XN_ROWID ){
148883 int iColumn; /* Index of column this phrase must match */
150395 bDocid = (pCons->iColumn<0 || pCons->iColumn==p->nColumn+1);
150414 && pCons->iColumn>=0 && pCons->iColumn<=p->nColumn
150416 pInfo->idxNum = FTS3_FULLTEXT_SEARCH + pCons->iColumn;
150423 && pCons->iColumn==p->nColumn + 2
150469 if( pOrder->iColumn<0 || pOrder->iColumn==p->nColumn+1 ){
151868 int iColumn, /* Column to query (or -ve for all columns) */
151883 | (iColumn<p->nColumn ? FTS3_SEGMENT_COLUMN_FILTER : 0);
151884 filter.iCol = iColumn;
152967 rc = fts3TermSelect(pTab, pToken, p->iColumn, &nThis, &pThis);
153128 int iCol = (p->iColumn >= pTab->nColumn ? -1 : p->iColumn);
153575 pTC->iCol = pPhrase->iColumn;
154626 if( (pPhrase->iColumn<pTab->nColumn && pPhrase->iColumn!=iCol) ){
154951 && pInfo->aOrderBy[0].iColumn==0
154962 int iCol = pInfo->aConstraint[i].iColumn;
155518 int iCol, /* Value for Fts3Phrase.iColumn */
155553 pRet->pPhrase->iColumn = iCol;
155694 p->pPhrase->iColumn = pParse->iDefaultCol;
156498 "%zPHRASE %d 0", zBuf, pPhrase->iColumn);
158701 && pInfo->aConstraint[i].iColumn==0
165484 if( (pPhrase->iColumn>=pTab->nColumn || pPhrase->iColumn==iCol) ){
168917 && p->iColumn==0 && p->op==SQLITE_INDEX_CONSTRAINT_EQ
168940 if( p->usable && (p->iColumn>0 || p->op==SQLITE_INDEX_CONSTRAINT_MATCH) ){
168954 zIdxStr[iIdx++] = (char)(p->iColumn - 1 + '0');
177880 if( pIdxInfo->aConstraint[i].iColumn!=10 ) continue;
177894 && pIdxInfo->aOrderBy[0].iColumn==0
177898 && pIdxInfo->aOrderBy[0].iColumn==0
177900 && pIdxInfo->aOrderBy[1].iColumn==1
178500 if( p->iColumn!=DBPAGE_COLUMN_SCHEMA ) continue;
178522 if( p->usable && p->iColumn<=0 && p->op==SQLITE_INDEX_CONSTRAINT_EQ ){
178535 && pIdxInfo->aOrderBy[0].iColumn<=0
185791 switch( pConstraint->iColumn ){
201330 int iCol = p->iColumn;
201359 int iSort = pInfo->aOrderBy[0].iColumn;
206896 if( p->iColumn==0 ){ /* term column */
206929 && pInfo->aOrderBy[0].iColumn==0
