Lines Matching refs:iCol
4108 SQLITE_API const void *sqlite3_column_blob(sqlite3_stmt*, int iCol);
4109 SQLITE_API int sqlite3_column_bytes(sqlite3_stmt*, int iCol);
4110 SQLITE_API int sqlite3_column_bytes16(sqlite3_stmt*, int iCol);
4111 SQLITE_API double sqlite3_column_double(sqlite3_stmt*, int iCol);
4112 SQLITE_API int sqlite3_column_int(sqlite3_stmt*, int iCol);
4113 SQLITE_API sqlite3_int64 sqlite3_column_int64(sqlite3_stmt*, int iCol);
4114 SQLITE_API const unsigned char *sqlite3_column_text(sqlite3_stmt*, int iCol);
4115 SQLITE_API const void *sqlite3_column_text16(sqlite3_stmt*, int iCol);
4116 SQLITE_API int sqlite3_column_type(sqlite3_stmt*, int iCol);
4117 SQLITE_API sqlite3_value *sqlite3_column_value(sqlite3_stmt*, int iCol);
10413 u16 iCol; /* For ORDER BY, column number in result set */
62230 ** Check to see if column iCol of the given statement is valid. If
62232 ** If iCol is not valid, return a pointer to a Mem which has a value
69836 int iCol; /* Table column this handle is open on */
69874 u32 type = v->apCsr[0]->aType[p->iCol];
69883 p->iOffset = v->apCsr[0]->aOffset[p->iCol];
69925 int iCol; /* Index of zColumn in row-record */
70006 for(iCol=0; iCol<pTab->nCol; iCol++) {
70007 if( sqlite3StrICmp(pTab->aCol[iCol].zName, zColumn)==0 ){
70011 if( iCol==pTab->nCol ){
70036 if( pFKey->aCol[j].iFrom==iCol ){
70046 if( pIdx->aiColumn[j]==iCol ){
70115 pBlob->iCol = iCol;
71822 ** Turn the pExpr expression into an alias for the iCol-th column of the
71851 int iCol, /* A column in the result set. 0..pEList->nExpr-1 */
71855 Expr *pOrig; /* The iCol-th column of the result set */
71859 assert( iCol>=0 && iCol<pEList->nExpr );
71860 pOrig = pEList->a[iCol].pExpr;
71868 if( pEList->a[iCol].iAlias==0 ){
71869 pEList->a[iCol].iAlias = (u16)(++pParse->nAlias);
71871 pDup->iTable = pEList->a[iCol].iAlias;
72043 int iCol;
72046 for(iCol=0; iCol<pTab->nCol; iCol++){
72047 Column *pCol = &pTab->aCol[iCol];
72049 if( iCol==pTab->iPKey ){
72050 iCol = -1;
72055 if( iCol>=pTab->nCol && sqlite3IsRowid(zCol) ){
72056 iCol = -1; /* IMP: R-44911-55124 */
72058 if( iCol<pTab->nCol ){
72060 if( iCol<0 ){
72063 testcase( iCol==31 );
72064 testcase( iCol==32 );
72065 pParse->oldmask |= (iCol>=32 ? 0xffffffff : (((u32)1)<<iCol));
72067 testcase( iCol==31 );
72068 testcase( iCol==32 );
72069 pParse->newmask |= (iCol>=32 ? 0xffffffff : (((u32)1)<<iCol));
72071 pExpr->iColumn = (i16)iCol;
72206 ** Allocate and return a pointer to an expression to load the column iCol
72209 SQLITE_PRIVATE Expr *sqlite3CreateColumnExpr(sqlite3 *db, SrcList *pSrc, int iSrc, int iCol){
72215 if( p->pTab->iPKey==iCol ){
72218 p->iColumn = (ynVar)iCol;
72219 testcase( iCol==BMS );
72220 testcase( iCol==BMS-1 );
72221 pItem->colUsed |= ((Bitmask)1)<<(iCol>=BMS ? BMS-1 : iCol);
72568 int iCol = -1;
72572 if( sqlite3ExprIsInteger(pE, &iCol) ){
72573 if( iCol<=0 || iCol>pEList->nExpr ){
72578 iCol = resolveAsName(pParse, pEList, pE);
72579 if( iCol==0 ){
72583 iCol = resolveOrderByTermToExprList(pParse, pSelect, pDup);
72588 if( iCol>0 ){
72596 pE->u.iValue = iCol;
72597 pItem->iCol = (u16)iCol;
72618 ** result set expression (as determined by the ExprList.a.iCol field)
72646 if( pItem->iCol ){
72647 if( pItem->iCol>pEList->nExpr ){
72651 resolveAlias(pParse, pEList, pItem->iCol-1, pItem->pExpr, zType);
72682 int iCol; /* Column number */
72692 iCol = resolveAsName(pParse, pSelect->pEList, pE);
72693 if( iCol>0 ){
72695 ** a copy of the iCol-th result-set column. The subsequent call to
72697 ** copy of the iCol-th result-set expression. */
72698 pItem->iCol = (u16)iCol;
72701 if( sqlite3ExprIsInteger(pE, &iCol) ){
72705 if( iCol<1 ){
72709 pItem->iCol = (u16)iCol;
72714 pItem->iCol = 0;
73892 pItem->iCol = pOldItem->iCol;
74466 int iCol = pExpr->iColumn; /* Index of column <column> */
74481 if( iCol<0 ){
74504 int affinity_ok = (pTab->aCol[iCol].affinity==aff||aff==SQLITE_AFF_NONE);
74507 if( (pIdx->aiColumn[0]==iCol)
74524 if( prNotFound && !pTab->aCol[iCol].notNull ){
75012 SQLITE_PRIVATE void sqlite3ExprCacheStore(Parse *pParse, int iTab, int iCol, int iReg){
75019 assert( iCol>=-1 && iCol<32768 ); /* Finite column numbers */
75035 if( p->iReg && p->iTable==iTab && p->iColumn==iCol ){
75043 assert( p->iReg==0 || p->iTable!=iTab || p->iColumn!=iCol );
75052 p->iColumn = iCol;
75073 p->iColumn = iCol;
75143 ** Generate code to extract the value of the iCol-th column of a table.
75149 int iCol, /* Index of the column to extract */
75152 if( iCol<0 || iCol==pTab->iPKey ){
75156 sqlite3VdbeAddOp3(v, op, iTabCur, iCol, regOut);
75158 if( iCol>=0 ){
75159 sqlite3ColumnDefault(v, pTab, iCol, regOut);
79030 int iCol; /* Index of column in table */
79052 iCol = pExpr->iColumn;
79055 if( iCol>=0 ){
79056 assert( iCol<pTab->nCol );
79057 zCol = pTab->aCol[iCol].zName;
80280 int iCol = -1, i;
80289 iCol = pTab->nCol - 1;
80290 pTab->aCol[iCol].isPrimKey = 1;
80293 for(iCol=0; iCol<pTab->nCol; iCol++){
80294 if( sqlite3StrICmp(pList->a[i].zName, pTab->aCol[iCol].zName)==0 ){
80298 if( iCol<pTab->nCol ){
80299 pTab->aCol[iCol].isPrimKey = 1;
80302 if( pList->nExpr>1 ) iCol = -1;
80304 if( iCol>=0 && iCol<pTab->nCol ){
80305 zType = pTab->aCol[iCol].zType;
80309 pTab->iPKey = iCol;
81337 int iCol = p->nCol-1;
81338 if( NEVER(iCol<0) ) goto fk_end;
81342 p->aCol[iCol].zName, pTo);
83905 int iCol; /* Iterator used while populating OLD.* */
83919 for(iCol=0; iCol<pTab->nCol; iCol++){
83920 if( mask==0xffffffff || mask&(1<<iCol) ){
83921 sqlite3ExprCodeGetColumnOfTable(v, pTab, iCur, iCol, iOld+iCol+1);
85909 int iCol = pIdx->aiColumn[i]; /* Index of column in parent tbl */
85916 zDfltColl = pParent->aCol[iCol].zColl;
85922 zIdxCol = pParent->aCol[iCol].zName;
86165 int iCol; /* Index of column in child table */
86174 iCol = pIdx->aiColumn[i];
86175 pCol = &pTab->aCol[iCol];
86176 if( pTab->iPKey==iCol ) iCol = -1;
86177 pLeft->iTable = regData+iCol+1;
86185 iCol = aiCol ? aiCol[i] : pFKey->aCol[0].iFrom;
86186 assert( iCol>=0 );
86187 zCol = pFKey->pFrom->aCol[iCol].zName;
86383 int iCol;
86422 iCol = pFKey->aCol[0].iFrom;
86423 aiCol = &iCol;
88946 const void * (*column_blob)(sqlite3_stmt*,int iCol);
88947 int (*column_bytes)(sqlite3_stmt*,int iCol);
88948 int (*column_bytes16)(sqlite3_stmt*,int iCol);
88954 double (*column_double)(sqlite3_stmt*,int iCol);
88955 int (*column_int)(sqlite3_stmt*,int iCol);
88956 sqlite_int64 (*column_int64)(sqlite3_stmt*,int iCol);
88963 const unsigned char * (*column_text)(sqlite3_stmt*,int iCol);
88964 const void * (*column_text16)(sqlite3_stmt*,int iCol);
88965 int (*column_type)(sqlite3_stmt*,int iCol);
88966 sqlite3_value* (*column_value)(sqlite3_stmt*,int iCol);
92558 int iCol; /* Index of column matching zCol */
92562 iCol = columnIndex(pSrc->a[i].pTab, zCol);
92563 if( iCol>=0 ){
92566 *piCol = iCol;
93369 int iCol = pExpr->iColumn; /* Index of column in pTab */
93410 if( iCol>=0 && ALWAYS(iCol<pS->pEList->nExpr) ){
93411 /* If iCol is less than zero, then the expression requests the
93416 Expr *p = pS->pEList->a[iCol].pExpr;
93425 if( iCol<0 ) iCol = pTab->iPKey;
93426 assert( iCol==-1 || (iCol>=0 && iCol<pTab->nCol) );
93427 if( iCol<0 ){
93431 zType = pTab->aCol[iCol].zType;
93432 zOriginCol = pTab->aCol[iCol].zName;
93546 int iCol = p->iColumn;
93552 if( iCol<0 ) iCol = pTab->iPKey;
93553 assert( iCol==-1 || (iCol>=0 && iCol<pTab->nCol) );
93554 if( iCol<0 ){
93557 zCol = pTab->aCol[iCol].zName;
93623 int iCol = pColExpr->iColumn;
93625 if( iCol<0 ) iCol = pTab->iPKey;
93627 iCol>=0 ? pTab->aCol[iCol].zName : "rowid");
93839 ** Return the appropriate collating sequence for the iCol-th column of
93846 static CollSeq *multiSelectCollSeq(Parse *pParse, Select *p, int iCol){
93849 pRet = multiSelectCollSeq(pParse, p->pPrior, iCol);
93853 assert( iCol>=0 );
93854 if( pRet==0 && iCol<p->pEList->nExpr ){
93855 pRet = sqlite3ExprCollSeq(pParse, p->pEList->a[iCol].pExpr);
94564 assert( pItem->iCol>0 );
94565 if( pItem->iCol==i ) break;
94573 pOrderBy->a[nOrderBy++].iCol = (u16)i;
94589 assert( pItem->iCol>0 && pItem->iCol<=p->pEList->nExpr );
94590 aPermute[i] = pItem->iCol - 1;
95167 if( p->pOrderBy->a[ii].iCol==0 ) return 0;
99775 int iCol;
99784 for(iCol=0; iCol<pTab->nCol; iCol++){
99785 char *zType = pTab->aCol[iCol].zType;
99810 pTab->aCol[iCol].isHidden = 1;
101033 int iCol = pRight->iColumn;
101034 pVal = sqlite3VdbeGetValue(pReprepare, iCol, SQLITE_AFF_NONE);
101038 sqlite3VdbeSetVarmask(pParse->pVdbe, iCol); /* IMP: R-23257-02778 */
101757 ** uses the same collation sequence as the iCol'th column of index pIdx.
101769 int iCol /* Column of index to match */
101772 const char *zColl = pIdx->azColl[iCol];
101777 && p->iColumn==pIdx->aiColumn[iCol]
101895 int iCol = pIdx->aiColumn[i];
101896 if( 0==findTerm(pWC, iBase, iCol, ~(Bitmask)0, WO_EQ, pIdx)
102360 int iCol = pTerm->u.leftColumn;
102361 Bitmask cMask = iCol>=BMS ? ((Bitmask)1)<<(BMS-1) : ((Bitmask)1)<<iCol;
102362 testcase( iCol==BMS );
102363 testcase( iCol==BMS-1 );
102411 int iCol = pTerm->u.leftColumn;
102412 Bitmask cMask = iCol>=BMS ? ((Bitmask)1)<<(BMS-1) : ((Bitmask)1)<<iCol;
112685 int iCol;
112710 iCol = pTab->iPKey;
112711 if( iCol>=0 ){
112712 pCol = &pTab->aCol[iCol];
112715 for(iCol=0; iCol<pTab->nCol; iCol++){
112716 pCol = &pTab->aCol[iCol];
112721 if( iCol==pTab->nCol ){
112742 autoinc = pTab->iPKey==iCol && (pTab->tabFlags & TF_Autoincrement)!=0;
113914 int fts3_global_term_cnt(int iTerm, int iCol);
113915 int fts3_term_cnt(int iTerm, int iCol);
114346 ** aMI[iCol*3 + 0] = Undefined
114347 ** aMI[iCol*3 + 1] = Number of occurrences
114348 ** aMI[iCol*3 + 2] = Number of rows containing at least one instance
114433 int iCol;
114504 SQLITE_PRIVATE char *sqlite3Fts3EvalPhrasePoslist(Fts3Cursor *, Fts3Expr *, int iCol);
115151 int iCol; /* Column index */
115348 for(iCol=0; iCol<nCol; iCol++){
115351 z = (char *)sqlite3Fts3NextToken(aCol[iCol], &n);
115355 p->azColumn[iCol] = zCsr;
115883 ** If parameter iCol is not 0, write an POS_COLUMN (1) byte followed by
115884 ** the value of iCol encoded as a varint to *pp. This will start a new
115888 ** returning (do not modify it if iCol==0). Return the total number of bytes
115889 ** written (0 if iCol==0).
115891 static int fts3PutColNumber(char **pp, int iCol){
115893 if( iCol ){
115895 n = 1 + sqlite3Fts3PutVarint(&p[1], iCol);
116766 filter.iCol = iColumn;
116898 int iCol = idxNum-FTS3_FULLTEXT_SEARCH;
116906 iCol, zQuery, -1, &pCsr->pExpr
116980 int iCol /* Index of column to read value from */
116987 assert( iCol>=0 && iCol<=p->nColumn+1 );
116989 if( iCol==p->nColumn+1 ){
116994 }else if( iCol==p->nColumn ){
117002 sqlite3_result_value(pContext, sqlite3_column_value(pCsr->pStmt, iCol+1));
117138 int iCol = -1;
117155 case 5: iCol = sqlite3_value_int(apVal[4]);
117163 sqlite3Fts3Snippet(pContext, pCsr, zStart, zEnd, zEllipsis, iCol, nToken);
117778 int iCol = (p->iColumn >= pTab->nColumn ? -1 : p->iColumn);
117780 pTab, pFirst->pSegcsr, iCol, pFirst->z, pFirst->n);
117987 int iCol; /* The column the token must match */
118015 pTC->iCol = pPhrase->iColumn;
118181 rc = sqlite3Fts3DeferToken(pCsr, pToken, pTC->iCol);
118193 rc = fts3TermSelect(pTab, pToken, pTC->iCol, &nList, &pList);
118791 int iCol = 0;
118803 /* aMI[iCol*3 + 1] = Number of occurrences
118804 ** aMI[iCol*3 + 2] = Number of rows containing at least one instance
118806 pExpr->aMI[iCol*3 + 1] += iCnt;
118807 pExpr->aMI[iCol*3 + 2] += (iCnt>0);
118810 p += sqlite3Fts3GetVarint32(p, &iCol);
118925 ** aiOut[iCol*3 + 1] = Number of occurrences
118926 ** aiOut[iCol*3 + 2] = Number of rows containing at least one instance
118949 int iCol;
118953 for(iCol=0; iCol<pTab->nColumn; iCol++){
118954 aiOut[iCol*3 + 1] = (u32)pCsr->nDoc;
118955 aiOut[iCol*3 + 2] = (u32)pCsr->nDoc;
118961 for(iCol=0; iCol<pTab->nColumn; iCol++){
118962 aiOut[iCol*3 + 1] = pExpr->aMI[iCol*3 + 1];
118963 aiOut[iCol*3 + 2] = pExpr->aMI[iCol*3 + 2];
118976 ** a position-list indicating the occurrences of the phrase in column iCol
118993 int iCol /* Column to return position list for */
119000 assert( iCol>=0 && iCol<pTab->nColumn );
119004 || (pPhrase->iColumn<pTab->nColumn && pPhrase->iColumn!=iCol)
119016 while( iThis<iCol ){
119023 return ((iCol==iThis)?pIter:0);
119099 int iCol; /* Current value of 'col' column */
119308 for(pCsr->iCol++; pCsr->iCol<pCsr->nStat; pCsr->iCol++){
119309 if( pCsr->aStat[pCsr->iCol].nDoc>0 ) return SQLITE_OK;
119317 int iCol;
119332 iCol = 0;
119343 iCol = 0;
119355 assert( iCol==0 );
119368 pCsr->aStat[iCol+1].nOcc++;
119375 iCol = (int)v;
119376 if( fts3auxGrowStatArray(pCsr, iCol+2) ) return SQLITE_NOMEM;
119377 pCsr->aStat[iCol+1].nDoc++;
119383 pCsr->iCol = 0;
119466 int iCol /* Index of column to read value from */
119471 if( iCol==0 ){ /* Column "term" */
119473 }else if( iCol==1 ){ /* Column "col" */
119474 if( p->iCol ){
119475 sqlite3_result_int(pContext, p->iCol-1);
119479 }else if( iCol==2 ){ /* Column "documents" */
119480 sqlite3_result_int64(pContext, p->aStat[p->iCol].nDoc);
119482 sqlite3_result_int64(pContext, p->aStat[p->iCol].nOcc);
119682 int iCol, /* Value for Fts3Phrase.iColumn */
119712 pRet->pPhrase->iColumn = iCol;
119898 int iCol;
120015 iCol = pParse->iDefaultCol;
120023 iCol = ii;
120028 rc = getNextToken(pParse, iCol, &z[iColLen], n-iColLen, ppExpr, pnConsumed);
122348 int iCol; /* Column token must occur in */
122793 sqlite3_int64 iCol, /* Column for entry to add */
122816 if( iCol>0 && p->iLastCol!=iCol ){
122818 || SQLITE_OK!=(rc = fts3PendingListAppendVarint(&p, iCol))
122822 p->iLastCol = iCol;
122825 if( iCol>=0 ){
122854 int iCol,
122867 if( fts3PendingListAppend(&pList, p->iPrevDocid, iCol, iPos, &rc) ){
122886 ** p->iPrevDocid, and the column is specified by argument iCol.
122893 int iCol, /* Column into which text is being inserted */
122944 p, iCol, iPos, &p->aIndex[0].hPending, zToken, nToken
122953 p, iCol, iPos, &pIndex->hPending, zToken, pIndex->nPrefix
124491 ** identify the subset of the position list that corresponds to column iCol.
124493 ** If there are no entries in the input position list for column iCol, then
124497 int iCol, /* Column to filter on */
124507 assert( iCol>=0 );
124512 if( iCol==iCurrent ){
124661 int iCol, /* Column to match on. */
124695 assert( iCol<0 || iCol<p->nColumn );
124696 pCsr->iColFilter = iCol;
124842 fts3ColumnFilter(pFilter->iCol, &pList, &nList);
125269 if( (pDef->iCol>=p->nColumn || pDef->iCol==i)
125324 int iCol /* Column that token must appear in (or -1) */
125334 pDeferred->iCol = iCol;
125587 int iCol; /* Extract snippet from this column */
125604 int iCol; /* Column snippet is extracted from */
125895 pCsr = sqlite3Fts3EvalPhrasePoslist(p->pCsr, pExpr, p->iCol);
125913 ** from column iCol that represent the "best" snippet. The best snippet
125929 int iCol, /* Index of column to create snippet from */
125966 sIter.iCol = iCol;
125982 pFragment->iCol = iCol;
126145 int iCol = pFragment->iCol+1; /* Query column to extract text from */
126151 zDoc = (const char *)sqlite3_column_text(pCsr->pStmt, iCol);
126153 if( sqlite3_column_type(pCsr->pStmt, iCol)!=SQLITE_NULL ){
126158 nDoc = sqlite3_column_bytes(pCsr->pStmt, iCol);
126264 ** for(iCol=0; iCol<nCol; iCol++){
126265 ** aMatchinfo[3*iPhrase*nCol + 3*iCol + 1] = X;
126266 ** aMatchinfo[3*iPhrase*nCol + 3*iCol + 2] = Y;
126269 ** where X is the number of matches for phrase iPhrase is column iCol of all
126270 ** rows of the table. Y is the number of rows for which column iCol contains
126402 ** If LcsIterator.iCol is set to the following value, the iterator has
126453 int iCol;
126470 for(iCol=0; iCol<pInfo->nCol; iCol++){
126476 pIt->pRead = sqlite3Fts3EvalPhrasePoslist(pCsr, pIt->pExpr, iCol);
126508 pInfo->aMatchinfo[iCol] = nLcs;
126569 int iCol;
126570 for(iCol=0; iCol<pInfo->nCol; iCol++){
126575 pInfo->aMatchinfo[iCol] = iVal;
126585 int iCol;
126587 for(iCol=0; iCol<pInfo->nCol; iCol++){
126590 pInfo->aMatchinfo[iCol] = (u32)nToken;
126709 int iCol, /* Extract snippet from this column */
126754 ** If the iCol argument to this function was negative, this means all
126755 ** columns of the FTS3 table. Otherwise, only column iCol is considered.
126760 if( iCol>=0 && iRead!=iCol ) continue;
126813 int iCol; /* Column of table to populate aTerm for */
126830 pList = sqlite3Fts3EvalPhrasePoslist(p->pCsr, pExpr, p->iCol);
126860 int iCol; /* Column currently being processed */
126888 for(iCol=0; iCol<pTab->nColumn; iCol++){
126896 /* Initialize the contents of sCtx.aTerm[] for column iCol. There is
126900 sCtx.iCol = iCol;
126904 /* Retreive the text stored in column iCol. If an SQL NULL is stored
126905 ** in column iCol, jump immediately to the next iteration of the loop.
126910 zDoc = (const char *)sqlite3_column_text(pCsr->pStmt, iCol+1);
126911 nDoc = sqlite3_column_bytes(pCsr->pStmt, iCol+1);
126913 if( sqlite3_column_type(pCsr->pStmt, iCol+1)==SQLITE_NULL ){
126920 /* Initialize a tokenizer iterator to iterate through column iCol. */
126955 "%d %d %d %d ", iCol, pTerm-sCtx.aTerm, iStart, iEnd-iStart