Lines Matching defs:iCol
4236 SQLITE_API const void *sqlite3_column_blob(sqlite3_stmt*, int iCol);
4237 SQLITE_API int sqlite3_column_bytes(sqlite3_stmt*, int iCol);
4238 SQLITE_API int sqlite3_column_bytes16(sqlite3_stmt*, int iCol);
4239 SQLITE_API double sqlite3_column_double(sqlite3_stmt*, int iCol);
4240 SQLITE_API int sqlite3_column_int(sqlite3_stmt*, int iCol);
4241 SQLITE_API sqlite3_int64 sqlite3_column_int64(sqlite3_stmt*, int iCol);
4242 SQLITE_API const unsigned char *sqlite3_column_text(sqlite3_stmt*, int iCol);
4243 SQLITE_API const void *sqlite3_column_text16(sqlite3_stmt*, int iCol);
4244 SQLITE_API int sqlite3_column_type(sqlite3_stmt*, int iCol);
4245 SQLITE_API sqlite3_value *sqlite3_column_value(sqlite3_stmt*, int iCol);
63461 ** Check to see if column iCol of the given statement is valid. If
63463 ** If iCol is not valid, return a pointer to a Mem which has a value
71230 int iCol; /* Table column this handle is open on */
71268 u32 type = v->apCsr[0]->aType[p->iCol];
71277 p->iOffset = v->apCsr[0]->aOffset[p->iCol];
71319 int iCol; /* Index of zColumn in row-record */
71400 for(iCol=0; iCol<pTab->nCol; iCol++) {
71401 if( sqlite3StrICmp(pTab->aCol[iCol].zName, zColumn)==0 ){
71405 if( iCol==pTab->nCol ){
71430 if( pFKey->aCol[j].iFrom==iCol ){
71440 if( pIdx->aiColumn[j]==iCol ){
71509 pBlob->iCol = iCol;
73224 ** Turn the pExpr expression into an alias for the iCol-th column of the
73253 int iCol, /* A column in the result set. 0..pEList->nExpr-1 */
73257 Expr *pOrig; /* The iCol-th column of the result set */
73261 assert( iCol>=0 && iCol<pEList->nExpr );
73262 pOrig = pEList->a[iCol].pExpr;
73270 if( pEList->a[iCol].iAlias==0 ){
73271 pEList->a[iCol].iAlias = (u16)(++pParse->nAlias);
73273 pDup->iTable = pEList->a[iCol].iAlias;
73450 int iCol;
73453 for(iCol=0; iCol<pTab->nCol; iCol++){
73454 Column *pCol = &pTab->aCol[iCol];
73456 if( iCol==pTab->iPKey ){
73457 iCol = -1;
73462 if( iCol>=pTab->nCol && sqlite3IsRowid(zCol) ){
73463 iCol = -1; /* IMP: R-44911-55124 */
73465 if( iCol<pTab->nCol ){
73467 if( iCol<0 ){
73470 testcase( iCol==31 );
73471 testcase( iCol==32 );
73472 pParse->oldmask |= (iCol>=32 ? 0xffffffff : (((u32)1)<<iCol));
73474 testcase( iCol==31 );
73475 testcase( iCol==32 );
73476 pParse->newmask |= (iCol>=32 ? 0xffffffff : (((u32)1)<<iCol));
73478 pExpr->iColumn = (i16)iCol;
73613 ** Allocate and return a pointer to an expression to load the column iCol
73616 SQLITE_PRIVATE Expr *sqlite3CreateColumnExpr(sqlite3 *db, SrcList *pSrc, int iSrc, int iCol){
73622 if( p->pTab->iPKey==iCol ){
73625 p->iColumn = (ynVar)iCol;
73626 testcase( iCol==BMS );
73627 testcase( iCol==BMS-1 );
73628 pItem->colUsed |= ((Bitmask)1)<<(iCol>=BMS ? BMS-1 : iCol);
73975 int iCol = -1;
73979 if( sqlite3ExprIsInteger(pE, &iCol) ){
73980 if( iCol<=0 || iCol>pEList->nExpr ){
73985 iCol = resolveAsName(pParse, pEList, pE);
73986 if( iCol==0 ){
73990 iCol = resolveOrderByTermToExprList(pParse, pSelect, pDup);
73995 if( iCol>0 ){
74003 pE->u.iValue = iCol;
74004 pItem->iOrderByCol = (u16)iCol;
74025 ** result set expression (as determined by the ExprList.a.iCol field)
74089 int iCol; /* Column number */
74099 iCol = resolveAsName(pParse, pSelect->pEList, pE);
74100 if( iCol>0 ){
74102 ** a copy of the iCol-th result-set column. The subsequent call to
74104 ** copy of the iCol-th result-set expression. */
74105 pItem->iOrderByCol = (u16)iCol;
74108 if( sqlite3ExprIsInteger(pE, &iCol) ){
74112 if( iCol<1 ){
74116 pItem->iOrderByCol = (u16)iCol;
75889 int iCol; /* Index of column <column> */
75898 iCol = pExpr->iColumn;
75910 if( iCol<0 ){
75932 int affinity_ok = (pTab->aCol[iCol].affinity==aff||aff==SQLITE_AFF_NONE);
75935 if( (pIdx->aiColumn[0]==iCol)
75951 if( prNotFound && !pTab->aCol[iCol].notNull ){
76440 SQLITE_PRIVATE void sqlite3ExprCacheStore(Parse *pParse, int iTab, int iCol, int iReg){
76447 assert( iCol>=-1 && iCol<32768 ); /* Finite column numbers */
76463 if( p->iReg && p->iTable==iTab && p->iColumn==iCol ){
76471 assert( p->iReg==0 || p->iTable!=iTab || p->iColumn!=iCol );
76480 p->iColumn = iCol;
76501 p->iColumn = iCol;
76571 ** Generate code to extract the value of the iCol-th column of a table.
76577 int iCol, /* Index of the column to extract */
76580 if( iCol<0 || iCol==pTab->iPKey ){
76584 sqlite3VdbeAddOp3(v, op, iTabCur, iCol, regOut);
76586 if( iCol>=0 ){
76587 sqlite3ColumnDefault(v, pTab, iCol, regOut);
81126 int iCol; /* Index of column in table */
81148 iCol = pExpr->iColumn;
81151 if( iCol>=0 ){
81152 assert( iCol<pTab->nCol );
81153 zCol = pTab->aCol[iCol].zName;
82376 int iCol = -1, i;
82385 iCol = pTab->nCol - 1;
82386 pTab->aCol[iCol].isPrimKey = 1;
82389 for(iCol=0; iCol<pTab->nCol; iCol++){
82390 if( sqlite3StrICmp(pList->a[i].zName, pTab->aCol[iCol].zName)==0 ){
82394 if( iCol<pTab->nCol ){
82395 pTab->aCol[iCol].isPrimKey = 1;
82398 iCol = -1;
82400 if( iCol>=0 && iCol<pTab->nCol ){
82401 zType = pTab->aCol[iCol].zType;
82405 pTab->iPKey = iCol;
83447 int iCol = p->nCol-1;
83448 if( NEVER(iCol<0) ) goto fk_end;
83452 p->aCol[iCol].zName, pTo);
86013 int iCol; /* Iterator used while populating OLD.* */
86027 for(iCol=0; iCol<pTab->nCol; iCol++){
86028 if( mask==0xffffffff || mask&(1<<iCol) ){
86029 sqlite3ExprCodeGetColumnOfTable(v, pTab, iCur, iCol, iOld+iCol+1);
88026 int iCol = pIdx->aiColumn[i]; /* Index of column in parent tbl */
88033 zDfltColl = pParent->aCol[iCol].zColl;
88039 zIdxCol = pParent->aCol[iCol].zName;
88282 int iCol; /* Index of column in child table */
88291 iCol = pIdx->aiColumn[i];
88292 pCol = &pTab->aCol[iCol];
88293 if( pTab->iPKey==iCol ) iCol = -1;
88294 pLeft->iTable = regData+iCol+1;
88302 iCol = aiCol ? aiCol[i] : pFKey->aCol[0].iFrom;
88303 assert( iCol>=0 );
88304 zCol = pFKey->pFrom->aCol[iCol].zName;
88500 int iCol;
88539 iCol = pFKey->aCol[0].iFrom;
88540 aiCol = &iCol;
91065 const void * (*column_blob)(sqlite3_stmt*,int iCol);
91066 int (*column_bytes)(sqlite3_stmt*,int iCol);
91067 int (*column_bytes16)(sqlite3_stmt*,int iCol);
91073 double (*column_double)(sqlite3_stmt*,int iCol);
91074 int (*column_int)(sqlite3_stmt*,int iCol);
91075 sqlite_int64 (*column_int64)(sqlite3_stmt*,int iCol);
91082 const unsigned char * (*column_text)(sqlite3_stmt*,int iCol);
91083 const void * (*column_text16)(sqlite3_stmt*,int iCol);
91084 int (*column_type)(sqlite3_stmt*,int iCol);
91085 sqlite3_value* (*column_value)(sqlite3_stmt*,int iCol);
94751 int iCol; /* Index of column matching zCol */
94755 iCol = columnIndex(pSrc->a[i].pTab, zCol);
94756 if( iCol>=0 ){
94759 *piCol = iCol;
95562 int iCol = pExpr->iColumn; /* Index of column in pTab */
95603 if( iCol>=0 && ALWAYS(iCol<pS->pEList->nExpr) ){
95604 /* If iCol is less than zero, then the expression requests the
95609 Expr *p = pS->pEList->a[iCol].pExpr;
95618 if( iCol<0 ) iCol = pTab->iPKey;
95619 assert( iCol==-1 || (iCol>=0 && iCol<pTab->nCol) );
95620 if( iCol<0 ){
95624 zType = pTab->aCol[iCol].zType;
95625 zOriginCol = pTab->aCol[iCol].zName;
95739 int iCol = p->iColumn;
95745 if( iCol<0 ) iCol = pTab->iPKey;
95746 assert( iCol==-1 || (iCol>=0 && iCol<pTab->nCol) );
95747 if( iCol<0 ){
95750 zCol = pTab->aCol[iCol].zName;
95819 int iCol = pColExpr->iColumn;
95821 if( iCol<0 ) iCol = pTab->iPKey;
95823 iCol>=0 ? pTab->aCol[iCol].zName : "rowid");
96035 ** Return the appropriate collating sequence for the iCol-th column of
96042 static CollSeq *multiSelectCollSeq(Parse *pParse, Select *p, int iCol){
96045 pRet = multiSelectCollSeq(pParse, p->pPrior, iCol);
96049 assert( iCol>=0 );
96050 if( pRet==0 && iCol<p->pEList->nExpr ){
96051 pRet = sqlite3ExprCollSeq(pParse, p->pEList->a[iCol].pExpr);
101998 int iCol;
102007 for(iCol=0; iCol<pTab->nCol; iCol++){
102008 char *zType = pTab->aCol[iCol].zType;
102033 pTab->aCol[iCol].isHidden = 1;
103271 int iCol = pRight->iColumn;
103272 pVal = sqlite3VdbeGetValue(pReprepare, iCol, SQLITE_AFF_NONE);
103276 sqlite3VdbeSetVarmask(pParse->pVdbe, iCol);
103996 ** uses the same collation sequence as the iCol'th column of index pIdx.
104008 int iCol /* Column of index to match */
104011 const char *zColl = pIdx->azColl[iCol];
104016 && p->iColumn==pIdx->aiColumn[iCol]
104134 int iCol = pIdx->aiColumn[i];
104135 if( 0==findTerm(pWC, iBase, iCol, ~(Bitmask)0, WO_EQ, pIdx)
104602 int iCol = pTerm->u.leftColumn;
104603 Bitmask cMask = iCol>=BMS ? ((Bitmask)1)<<(BMS-1) : ((Bitmask)1)<<iCol;
104604 testcase( iCol==BMS );
104605 testcase( iCol==BMS-1 );
104653 int iCol = pTerm->u.leftColumn;
104654 Bitmask cMask = iCol>=BMS ? ((Bitmask)1)<<(BMS-1) : ((Bitmask)1)<<iCol;
115055 int iCol;
115080 iCol = pTab->iPKey;
115081 if( iCol>=0 ){
115082 pCol = &pTab->aCol[iCol];
115085 for(iCol=0; iCol<pTab->nCol; iCol++){
115086 pCol = &pTab->aCol[iCol];
115091 if( iCol==pTab->nCol ){
115112 autoinc = pTab->iPKey==iCol && (pTab->tabFlags & TF_Autoincrement)!=0;
116347 int fts3_global_term_cnt(int iTerm, int iCol);
116348 int fts3_term_cnt(int iTerm, int iCol);
116791 ** aMI[iCol*3 + 0] = Undefined
116792 ** aMI[iCol*3 + 1] = Number of occurrences
116793 ** aMI[iCol*3 + 2] = Number of rows containing at least one instance
116879 int iCol;
116954 SQLITE_PRIVATE char *sqlite3Fts3EvalPhrasePoslist(Fts3Cursor *, Fts3Expr *, int iCol);
117724 int iCol; /* Column index */
117974 for(iCol=0; iCol<nCol; iCol++){
117977 z = (char *)sqlite3Fts3NextToken(aCol[iCol], &n);
117981 p->azColumn[iCol] = zCsr;
118552 ** If parameter iCol is not 0, write an POS_COLUMN (1) byte followed by
118553 ** the value of iCol encoded as a varint to *pp. This will start a new
118557 ** returning (do not modify it if iCol==0). Return the total number of bytes
118558 ** written (0 if iCol==0).
118560 static int fts3PutColNumber(char **pp, int iCol){
118562 if( iCol ){
118564 n = 1 + sqlite3Fts3PutVarint(&p[1], iCol);
119101 sqlite3_int64 iCol;
119103 p += sqlite3Fts3GetVarint(p, &iCol);
119110 nOut += sqlite3Fts3PutVarint(&pOut[nOut], iCol);
119490 filter.iCol = iColumn;
119622 int iCol = idxNum-FTS3_FULLTEXT_SEARCH;
119633 p->azColumn, p->bHasStat, p->nColumn, iCol, zQuery, -1, &pCsr->pExpr
119707 ** (iCol < p->nColumn) -> The value of the iCol'th user column.
119708 ** (iCol == p->nColumn) -> Magic column with the same name as the table.
119709 ** (iCol == p->nColumn+1) -> Docid column
119710 ** (iCol == p->nColumn+2) -> Langid column
119715 int iCol /* Index of column to read value from */
119722 assert( iCol>=0 && iCol<=p->nColumn+2 );
119724 if( iCol==p->nColumn+1 ){
119729 }else if( iCol==p->nColumn ){
119733 }else if( iCol==p->nColumn+2 && pCsr->pExpr ){
119741 if( iCol==p->nColumn+2 ){
119747 }else if( sqlite3_data_count(pCsr->pStmt)>(iCol+1) ){
119748 sqlite3_result_value(pCtx, sqlite3_column_value(pCsr->pStmt, iCol+1));
119885 int iCol = -1;
119902 case 5: iCol = sqlite3_value_int(apVal[4]);
119910 sqlite3Fts3Snippet(pContext, pCsr, zStart, zEnd, zEllipsis, iCol, nToken);
120542 int iCol = (p->iColumn >= pTab->nColumn ? -1 : p->iColumn);
120544 pTab, pFirst->pSegcsr, iCol, pFirst->z, pFirst->n);
120751 int iCol; /* The column the token must match */
120779 pTC->iCol = pPhrase->iColumn;
120959 rc = sqlite3Fts3DeferToken(pCsr, pToken, pTC->iCol);
120975 rc = fts3TermSelect(pTab, pToken, pTC->iCol, &nList, &pList);
121576 int iCol = 0;
121588 /* aMI[iCol*3 + 1] = Number of occurrences
121589 ** aMI[iCol*3 + 2] = Number of rows containing at least one instance
121591 pExpr->aMI[iCol*3 + 1] += iCnt;
121592 pExpr->aMI[iCol*3 + 2] += (iCnt>0);
121595 p += sqlite3Fts3GetVarint32(p, &iCol);
121710 ** aiOut[iCol*3 + 1] = Number of occurrences
121711 ** aiOut[iCol*3 + 2] = Number of rows containing at least one instance
121734 int iCol;
121738 for(iCol=0; iCol<pTab->nColumn; iCol++){
121739 aiOut[iCol*3 + 1] = (u32)pCsr->nDoc;
121740 aiOut[iCol*3 + 2] = (u32)pCsr->nDoc;
121746 for(iCol=0; iCol<pTab->nColumn; iCol++){
121747 aiOut[iCol*3 + 1] = pExpr->aMI[iCol*3 + 1];
121748 aiOut[iCol*3 + 2] = pExpr->aMI[iCol*3 + 2];
121761 ** a position-list indicating the occurrences of the phrase in column iCol
121778 int iCol /* Column to return position list for */
121785 assert( iCol>=0 && iCol<pTab->nColumn );
121789 || (pPhrase->iColumn<pTab->nColumn && pPhrase->iColumn!=iCol)
121801 while( iThis<iCol ){
121808 return ((iCol==iThis)?pIter:0);
121893 int iCol; /* Current value of 'col' column */
122102 for(pCsr->iCol++; pCsr->iCol<pCsr->nStat; pCsr->iCol++){
122103 if( pCsr->aStat[pCsr->iCol].nDoc>0 ) return SQLITE_OK;
122111 int iCol;
122126 iCol = 0;
122137 iCol = 0;
122149 assert( iCol==0 );
122162 pCsr->aStat[iCol+1].nOcc++;
122169 iCol = (int)v;
122170 if( fts3auxGrowStatArray(pCsr, iCol+2) ) return SQLITE_NOMEM;
122171 pCsr->aStat[iCol+1].nDoc++;
122177 pCsr->iCol = 0;
122260 int iCol /* Index of column to read value from */
122265 if( iCol==0 ){ /* Column "term" */
122267 }else if( iCol==1 ){ /* Column "col" */
122268 if( p->iCol ){
122269 sqlite3_result_int(pContext, p->iCol-1);
122273 }else if( iCol==2 ){ /* Column "documents" */
122274 sqlite3_result_int64(pContext, p->aStat[p->iCol].nDoc);
122276 sqlite3_result_int64(pContext, p->aStat[p->iCol].nOcc);
122505 int iCol, /* Value for Fts3Phrase.iColumn */
122533 pRet->pPhrase->iColumn = iCol;
122736 int iCol;
122853 iCol = pParse->iDefaultCol;
122861 iCol = ii;
122866 rc = getNextToken(pParse, iCol, &z[iColLen], n-iColLen, ppExpr, pnConsumed);
125192 int iCol; /* Column token must occur in */
125690 sqlite3_int64 iCol, /* Column for entry to add */
125713 if( iCol>0 && p->iLastCol!=iCol ){
125715 || SQLITE_OK!=(rc = fts3PendingListAppendVarint(&p, iCol))
125719 p->iLastCol = iCol;
125722 if( iCol>=0 ){
125751 int iCol,
125764 if( fts3PendingListAppend(&pList, p->iPrevDocid, iCol, iPos, &rc) ){
125783 ** p->iPrevDocid, and the column is specified by argument iCol.
125791 int iCol, /* Column into which text is being inserted */
125841 p, iCol, iPos, &p->aIndex[0].hPending, zToken, nToken
125850 p, iCol, iPos, &pIndex->hPending, zToken, pIndex->nPrefix
127465 ** identify the subset of the position list that corresponds to column iCol.
127467 ** If there are no entries in the input position list for column iCol, then
127471 int iCol, /* Column to filter on */
127481 assert( iCol>=0 );
127486 if( iCol==iCurrent ){
127640 int iCol, /* Column to match on. */
127674 assert( iCol<0 || iCol<p->nColumn );
127675 pCsr->iColFilter = iCol;
127828 fts3ColumnFilter(pFilter->iCol, &pList, &nList);
128238 int iCol;
128242 for(iCol=0; rc==SQLITE_OK && iCol<p->nColumn; iCol++){
128243 const char *z = (const char *) sqlite3_column_text(pStmt, iCol+1);
128244 rc = fts3PendingTermsAdd(p, iLangid, z, iCol, &aSz[iCol]);
128245 aSz[p->nColumn] += sqlite3_column_bytes(pStmt, iCol+1);
128255 for(iCol=0; iCol<=p->nColumn; iCol++){
128256 aSzIns[iCol] += aSz[iCol];
128373 if( (pDef->iCol>=p->nColumn || pDef->iCol==i)
128429 int iCol /* Column that token must appear in (or -1) */
128439 pDeferred->iCol = iCol;
128714 int iCol; /* Extract snippet from this column */
128731 int iCol; /* Column snippet is extracted from */
129022 pCsr = sqlite3Fts3EvalPhrasePoslist(p->pCsr, pExpr, p->iCol);
129041 ** from column iCol that represent the "best" snippet. The best snippet
129057 int iCol, /* Index of column to create snippet from */
129094 sIter.iCol = iCol;
129110 pFragment->iCol = iCol;
129273 int iCol = pFragment->iCol+1; /* Query column to extract text from */
129279 zDoc = (const char *)sqlite3_column_text(pCsr->pStmt, iCol);
129281 if( sqlite3_column_type(pCsr->pStmt, iCol)!=SQLITE_NULL ){
129286 nDoc = sqlite3_column_bytes(pCsr->pStmt, iCol);
129393 ** for(iCol=0; iCol<nCol; iCol++){
129394 ** aMatchinfo[3*iPhrase*nCol + 3*iCol + 1] = X;
129395 ** aMatchinfo[3*iPhrase*nCol + 3*iCol + 2] = Y;
129398 ** where X is the number of matches for phrase iPhrase is column iCol of all
129399 ** rows of the table. Y is the number of rows for which column iCol contains
129531 ** If LcsIterator.iCol is set to the following value, the iterator has
129582 int iCol;
129599 for(iCol=0; iCol<pInfo->nCol; iCol++){
129605 pIt->pRead = sqlite3Fts3EvalPhrasePoslist(pCsr, pIt->pExpr, iCol);
129637 pInfo->aMatchinfo[iCol] = nLcs;
129698 int iCol;
129699 for(iCol=0; iCol<pInfo->nCol; iCol++){
129704 pInfo->aMatchinfo[iCol] = iVal;
129714 int iCol;
129716 for(iCol=0; iCol<pInfo->nCol; iCol++){
129719 pInfo->aMatchinfo[iCol] = (u32)nToken;
129838 int iCol, /* Extract snippet from this column */
129883 ** If the iCol argument to this function was negative, this means all
129884 ** columns of the FTS3 table. Otherwise, only column iCol is considered.
129889 if( iCol>=0 && iRead!=iCol ) continue;
129942 int iCol; /* Column of table to populate aTerm for */
129959 pList = sqlite3Fts3EvalPhrasePoslist(p->pCsr, pExpr, p->iCol);
129989 int iCol; /* Column currently being processed */
130017 for(iCol=0; iCol<pTab->nColumn; iCol++){
130025 /* Initialize the contents of sCtx.aTerm[] for column iCol. There is
130029 sCtx.iCol = iCol;
130033 /* Retreive the text stored in column iCol. If an SQL NULL is stored
130034 ** in column iCol, jump immediately to the next iteration of the loop.
130039 zDoc = (const char *)sqlite3_column_text(pCsr->pStmt, iCol+1);
130040 nDoc = sqlite3_column_bytes(pCsr->pStmt, iCol+1);
130042 if( sqlite3_column_type(pCsr->pStmt, iCol+1)==SQLITE_NULL ){
130049 /* Initialize a tokenizer iterator to iterate through column iCol. */
130085 "%d %d %d %d ", iCol, pTerm-sCtx.aTerm, iStart, iEnd-iStart
