Lines Matching refs:aCol
17187 Column *aCol; /* Information about each column */ member
17348 } aCol[1]; /* One entry for each of nCol columns */ member
17624 } *aCol; member
86312 }else if( p->pTab->aCol[iIdx].affinity==SQLITE_AFF_REAL ){
89637 Column *aCol;
89644 aCol = pTab->aCol;
89647 if( aCol[i].colFlags & COLFLAG_GENERATED ){
89648 if( aCol[i].colFlags & COLFLAG_VIRTUAL ) continue;
89652 applyAffinity(pIn1, aCol[i].affinity, encoding);
89654 switch( aCol[i].eCType ){
89705 vdbeMemTypeName(pIn1), sqlite3StdType[aCol[i].eCType-1],
89706 pTab->zName, aCol[i].zCnName);
91993 if( db->xUpdateCallback==0 || pTab->aCol==0 ){
92024 assert( pTab->aCol!=0 );
95368 if( sqlite3StrICmp(pTab->aCol[iCol].zCnName, zColumn)==0 ){
95397 if( pFKey->aCol[j].iFrom==iCol ){
99785 && (pExTab->aCol[n].colFlags & COLFLAG_GENERATED)!=0
99925 for(j=0, pCol=pTab->aCol; j<pTab->nCol; j++, pCol++){
100005 for(iCol=0, pCol=pTab->aCol; iCol<pTab->nCol; iCol++, pCol++){
100281 && (pTab->aCol[iCol].colFlags & COLFLAG_GENERATED)!=0
101664 return pTab->aCol[iCol].affinity;
101822 const char *zColl = sqlite3ColumnColl(&p->y.pTab->aCol[j]);
104098 && p->y.pTab->aCol!=0 /* Possible due to prior error */
104099 && p->y.pTab->aCol[p->iColumn].notNull==0);
105377 }else if( (pCol = &pTab->aCol[iCol])->colFlags & COLFLAG_VIRTUAL ){
105644 pCol = &pAggInfo->aCol[pExpr->iAgg];
105656 pTab->zName, pTab->aCol[pCol->iColumn].zCnName));
105657 if( pTab->aCol[pCol->iColumn].affinity==SQLITE_AFF_REAL ){
105713 pCol = pTab->aCol + iCol;
106213 (pExpr->iColumn<0 ? "rowid" : pExpr->y.pTab->aCol[iCol].zCnName)
106222 if( iCol>=0 && pTab->aCol[iCol].affinity==SQLITE_AFF_REAL ){
107668 if( pAggInfo->aCol[iAgg].pCExpr==pExpr ){
107671 pAggInfo->aCol[iAgg].pCExpr = pExpr;
107706 pInfo->aCol = sqlite3ArrayAllocate(
107708 pInfo->aCol,
107709 sizeof(pInfo->aCol[0]),
107765 pCol = pAggInfo->aCol;
107775 pCol = &pAggInfo->aCol[k];
108327 pCol = &pNew->aCol[pNew->nCol-1];
108519 pNew->aCol = (Column*)sqlite3DbMallocZero(db, sizeof(Column)*nAlloc);
108521 if( !pNew->aCol || !pNew->zName ){
108525 memcpy(pNew->aCol, pTab->aCol, sizeof(Column)*pNew->nCol);
108527 Column *pCol = &pNew->aCol[i];
108621 if( 0==sqlite3StrICmp(pTab->aCol[iCol].zCnName, zOld) ) break;
109478 zOld = pTab->aCol[iCol].zCnName;
109515 &sParse, &sCtx, (void*)sParse.pNewTable->aCol[iCol].zCnName
109531 &sParse.pNewTable->aCol[i]);
109540 if( bFKOnly==0 && pFKey->aCol[i].iFrom==iCol ){
109541 renameTokenFind(&sParse, &sCtx, (void*)&pFKey->aCol[i]);
109544 && 0==sqlite3_stricmp(pFKey->aCol[i].zCol, zOld)
109546 renameTokenFind(&sParse, &sCtx, (void*)pFKey->aCol[i].zCol);
109887 &sParse.pNewTable->aCol[i]));
110045 pCol = renameTokenFind(&sParse, 0, (void*)pTab->aCol[iCol].zCnName);
110048 pEnd = renameTokenFind(&sParse, 0, (void*)pTab->aCol[iCol+1].zCnName);
110112 if( pTab->aCol[iCol].colFlags & (COLFLAG_PRIMKEY|COLFLAG_UNIQUE) ){
110114 (pTab->aCol[iCol].colFlags&COLFLAG_PRIMKEY) ? "PRIMARY KEY" : "UNIQUE",
110144 if( pParse->nErr==0 && (pTab->aCol[iCol].colFlags & COLFLAG_VIRTUAL)==0 ){
110170 if( i!=iCol && (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ){
111179 VdbeComment((v,"%s.%s", pIdx->zName, pIdx->pTable->aCol[i].zCnName));
112939 zCol = pTab->aCol[iCol].zCnName;
112942 zCol = pTab->aCol[pTab->iPKey].zCnName;
113816 if( (pCol = pTable->aCol)!=0 ){
113821 sqlite3DbFree(db, pTable->aCol);
113826 pTable->aCol = 0;
114151 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ) iCol++;
114201 if( (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ) n++;
114203 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ){
114440 }else if( pTab && pCol!=pTab->aCol && (pCol[-1].colFlags & COLFLAG_HIDDEN) ){
114591 if( p->aCol[i].hName==hName && sqlite3StrICmp(z, p->aCol[i].zCnName)==0 ){
114597 aNew = sqlite3DbRealloc(db,p->aCol,((i64)p->nCol+1)*sizeof(p->aCol[0]));
114602 p->aCol = aNew;
114603 pCol = &p->aCol[p->nCol];
114604 memset(pCol, 0, sizeof(p->aCol[0]));
114646 pCol = &p->aCol[p->nCol-1];
114777 pCol = &(p->aCol[p->nCol-1]);
114885 pCol = &pTab->aCol[iCol];
114899 if( sqlite3StrICmp(zCName, pTab->aCol[iCol].zCnName)==0 ){
114900 pCol = &pTab->aCol[iCol];
114990 sqlite3ColumnSetColl(db, &p->aCol[i], zColl);
114999 pIdx->azColl[0] = sqlite3ColumnColl(&p->aCol[i]);
115018 pCol = &(pTab->aCol[pTab->nCol-1]);
115148 for(pCol = p->aCol, i=0; i<p->nCol; i++, pCol++){
115171 for(pCol=p->aCol, i=0; i<p->nCol; i++, pCol++){
115241 for(i=pTab->nCol, pTabCol=pTab->aCol; i>0; i--, pTabCol++){
115254 const Column *aCol = pIdx->pTable->aCol;
115258 wIndex += x<0 ? 1 : aCol[pIdx->aiColumn[i]].szEst;
115334 if( x>=0 && (pTab->aCol[x].colFlags & COLFLAG_VIRTUAL)==0 ){
115381 if( (pTab->aCol[i].colFlags & COLFLAG_PRIMKEY)!=0
115382 && (pTab->aCol[i].notNull==OE_None)
115384 pTab->aCol[i].notNull = OE_Abort;
115405 sqlite3TokenInit(&ipkToken, pTab->aCol[pTab->iPKey].zCnName);
115503 && (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ) nExtra++;
115508 && (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0
115700 Column *pCol = &p->aCol[ii];
115767 u32 colFlags = p->aCol[ii].colFlags;
115769 Expr *pX = sqlite3ColumnExpr(p, &p->aCol[ii]);
115779 sqlite3ColumnSetExpr(pParse, p, &p->aCol[ii],
115867 assert( p->aCol==0 );
115869 p->aCol = pSelTab->aCol;
115871 pSelTab->aCol = 0;
116163 &pTable->nCol, &pTable->aCol);
116175 assert( pTable->aCol==0 );
116177 pTable->aCol = pSelTab->aCol;
116180 pSelTab->aCol = 0;
116623 p->aCol[iCol].zCnName, pTo);
116635 nByte = sizeof(*pFKey) + (nCol-1)*sizeof(pFKey->aCol[0]) + pTo->n + 1;
116648 z = (char*)&pFKey->aCol[nCol];
116659 pFKey->aCol[0].iFrom = p->nCol-1;
116664 if( sqlite3StrICmp(p->aCol[j].zCnName, pFromCol->a[i].zEName)==0 ){
116665 pFKey->aCol[i].iFrom = j;
116676 sqlite3RenameTokenRemap(pParse, &pFKey->aCol[i], pFromCol->a[i].zEName);
116683 pFKey->aCol[i].zCol = z;
117117 Column *pCol = &pTab->aCol[pTab->nCol-1];
117221 if( pTab->aCol[j].notNull==0 ){
117224 if( pTab->aCol[j].colFlags & COLFLAG_VIRTUAL ){
117242 zColl = sqlite3ColumnColl(&pTab->aCol[j]);
118335 zCol = pTab->aCol[pIdx->aiColumn[j]].zCnName;
118362 pTab->aCol[pTab->iPKey].zCnName);
119395 const char *zName = pTab->aCol[pPk->aiColumn[0]].zCnName;
119401 Expr *p = sqlite3Expr(db, TK_ID, pTab->aCol[pPk->aiColumn[i]].zCnName);
122735 char *zKey = pFKey->aCol[0].zCol; /* Name of left-most parent key column */
122760 if( !sqlite3StrICmp(pParent->aCol[pParent->iPKey].zCnName, zKey) ){
122784 for(i=0; i<nCol; i++) aiCol[i] = pFKey->aCol[i].iFrom;
122804 zDfltColl = sqlite3ColumnColl(&pParent->aCol[iCol]);
122808 zIdxCol = pParent->aCol[iCol].zCnName;
122810 if( sqlite3StrICmp(pFKey->aCol[j].zCol, zIdxCol)==0 ){
122811 if( aiCol ) aiCol[i] = pFKey->aCol[j].iFrom;
123029 pCol = &pTab->aCol[iCol];
123140 iCol = aiCol ? aiCol[i] : pFKey->aCol[0].iFrom;
123142 zCol = pFKey->pFrom->aCol[iCol].zCnName;
123177 pRight = sqlite3Expr(db, TK_ID, pTab->aCol[iCol].zCnName);
123354 int iChildKey = p->aCol[i].iFrom;
123381 char *zKey = p->aCol[i].zCol;
123385 Column *pCol = &pTab->aCol[iKey];
123501 iFromCol = pFKey->aCol[i].iFrom;
123514 iCol = pFKey->aCol[0].iFrom;
123528 char *zCol = pTo->aCol[pIdx ? pIdx->aiColumn[i] : pTo->iPKey].zCnName;
123647 for(i=0; i<p->nCol; i++) mask |= COLUMN_MASK(p->aCol[i].iFrom);
123796 iFromCol = aiCol ? aiCol[i] : pFKey->aCol[0].iFrom;
123801 pTab->aCol[pIdx ? pIdx->aiColumn[i] : pTab->iPKey].zCnName);
123802 sqlite3TokenInit(&tFromCol, pFKey->pFrom->aCol[iFromCol].zCnName);
123840 Column *pCol = pFKey->pFrom->aCol + iFromCol;
124114 aff = pTab->aCol[x].affinity;
124204 assert( pTab->aCol[i].affinity!=0 );
124205 if( (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ){
124206 zColAff[j++] = pTab->aCol[i].affinity;
124273 pWalker->eCode |= pWalker->u.pTab->aCol[pExpr->iColumn].colFlags;
124316 if( pTab->aCol[ii].colFlags & COLFLAG_VIRTUAL ){
124319 if( pTab->aCol[ii].colFlags & COLFLAG_STORED ){
124337 if( pTab->aCol[i].colFlags & COLFLAG_GENERATED ){
124338 testcase( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL );
124339 testcase( pTab->aCol[i].colFlags & COLFLAG_STORED );
124340 pTab->aCol[i].colFlags |= COLFLAG_NOTAVAIL;
124359 Column *pCol = pTab->aCol + i;
124865 if( sqlite3StrICmp(pColumn->a[i].zName, pTab->aCol[j].zCnName)==0 ){
124872 if( pTab->aCol[j].colFlags & (COLFLAG_STORED|COLFLAG_VIRTUAL) ){
124875 pTab->aCol[j].zCnName);
124993 if( pTab->aCol[i].colFlags & COLFLAG_GENERATED ){
124994 testcase( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL );
124995 testcase( pTab->aCol[i].colFlags & COLFLAG_STORED );
125010 if( pTab->aCol[i].colFlags & COLFLAG_NOINSERT ) nHidden++;
125139 if( ((colFlags = pTab->aCol[i].colFlags) & COLFLAG_NOINSERT)!=0 ){
125160 sqlite3ColumnExpr(pTab, &pTab->aCol[i]),
125171 sqlite3ColumnExpr(pTab, &pTab->aCol[i]),
125179 sqlite3ColumnExpr(pTab, &pTab->aCol[i]),
125723 Column *pCol = &pTab->aCol[i]; /* The column to check for NOT NULL */
126198 VdbeComment((v, "%s", pTab->aCol[iField].zCnName));
126293 pTab->aCol[pPk->aiColumn[i]].zCnName));
126494 if( pTab->aCol[i].iDflt!=0 ) break;
126495 if( pTab->aCol[i].colFlags & COLFLAG_PRIMKEY ) break;
126874 Column *pDestCol = &pDest->aCol[i];
126875 Column *pSrcCol = &pSrc->aCol[i];
130679 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
130853 cnum<0 ? 0 : pTab->aCol[cnum].zCnName);
130976 pTab->aCol[pFK->aCol[j].iFrom].zCnName,
130977 pFK->aCol[j].zCol,
131070 int iCol = aiCols ? aiCols[j] : pFK->aCol[j].iFrom;
131284 Column *pCol = pTab->aCol + j;
131313 pTab->zName, pTab->aCol[j].zCnName);
131375 if( iCol>=0 && pTab->aCol[iCol].notNull ) continue;
133529 for(pCol=pTab->aCol, i=0; i<pTab->nCol; pCol++, i++){
133559 && (bIgnoreHidden==0 || IsHiddenColumn(&pSrc->a[i].pTab->aCol[iCol])==0)
133737 if( IsHiddenColumn(&pRightTab->aCol[j]) ) continue;
133738 zName = pRightTab->aCol[j].zCnName;
134206 && (pTab->aCol[pExpr->iColumn].colFlags & COLFLAG_SORTERREF)!=0
135110 zOrigCol = pTab->aCol[iCol].zCnName;
135111 zType = sqlite3ColumnType(&pTab->aCol[iCol],0);
135123 zType = sqlite3ColumnType(&pTab->aCol[iCol],0);
135285 zCol = pTab->aCol[iCol].zCnName;
135334 Column *aCol, *pCol; /* For looping over result columns */
135344 aCol = sqlite3DbMallocZero(db, sizeof(aCol[0])*nCol);
135345 testcase( aCol==0 );
135349 aCol = 0;
135353 *paCol = aCol;
135355 for(i=0, pCol=aCol; i<nCol && !db->mallocFailed; i++, pCol++){
135373 zName = iCol>=0 ? pTab->aCol[iCol].zCnName : "rowid";
135411 sqlite3DbFree(db, aCol[j].zCnName);
135413 sqlite3DbFree(db, aCol);
135453 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
135506 sqlite3ColumnsFromExprList(pParse, pSelect->pEList, &pTab->nCol, &pTab->aCol);
138610 sqlite3ColumnsFromExprList(pParse, pEList, &pTab->nCol, &pTab->aCol);
138669 sqlite3ColumnsFromExprList(pParse, pSel->pEList,&pTab->nCol,&pTab->aCol);
138912 char *zName = pTab->aCol[j].zCnName;
138929 && IsHiddenColumn(&pTab->aCol[j])
139157 assert( pAggInfo->aCol[i].iMem>=pAggInfo->mnReg
139158 && pAggInfo->aCol[i].iMem<=pAggInfo->mxReg );
139299 for(i=0, pC=pAggInfo->aCol; i<pAggInfo->nAccumulator; i++, pC++){
139443 sqlite3DbFree(db, p->aCol);
140320 ii, pAggInfo->aCol[ii].iMem);
140321 sqlite3TreeViewExpr(0, pAggInfo->aCol[ii].pCExpr, 0);
140432 if( pAggInfo->aCol[i].iSorterColumn>=j ){
140441 struct AggInfo_col *pCol = &pAggInfo->aCol[i];
140758 Expr *pExpr = pAggInfo->aCol[i].pCExpr;
141863 if( IsHiddenColumn(pTab->aCol+jj) ) continue;
141864 pNewExpr = sqlite3Expr(db, TK_ID, pTab->aCol[jj].zCnName);
141868 pItem->zEName = sqlite3DbStrDup(db, pTab->aCol[jj].zCnName);
142475 Column *pCol = &pTab->aCol[i];
142486 if( pTab->aCol[i].affinity==SQLITE_AFF_REAL && !IsVirtual(pTab) ){
142870 if( pTab->aCol[j].hName==hCol
142871 && sqlite3StrICmp(pTab->aCol[j].zCnName, pChanges->a[i].zEName)==0
142877 }else if( pPk && (pTab->aCol[j].colFlags & COLFLAG_PRIMKEY)!=0 ){
142881 else if( pTab->aCol[j].colFlags & COLFLAG_GENERATED ){
142882 testcase( pTab->aCol[j].colFlags & COLFLAG_VIRTUAL );
142883 testcase( pTab->aCol[j].colFlags & COLFLAG_STORED );
142886 pTab->aCol[j].zCnName);
142910 j<0 ? "ROWID" : pTab->aCol[j].zCnName,
142941 if( (pTab->aCol[i].colFlags & COLFLAG_GENERATED)==0 ) continue;
142943 sqlite3ColumnExpr(pTab, &pTab->aCol[i]),
143294 u32 colFlags = pTab->aCol[i].colFlags;
143330 }else if( (pTab->aCol[i].colFlags & COLFLAG_GENERATED)!=0 ){
143331 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ) k--;
143398 if( pTab->aCol[i].colFlags & COLFLAG_GENERATED ){
143399 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ) k--;
143662 assert( (pTab->aCol[i].colFlags & COLFLAG_GENERATED)==0 );
144037 pTab->aCol[pPk->aiColumn[i]].zCnName));
144053 if( pTab->aCol[i].affinity==SQLITE_AFF_REAL ){
145123 char *zType = sqlite3ColumnType(&pTab->aCol[iCol], "");
145145 pTab->aCol[iCol].colFlags |= COLFLAG_HIDDEN;
145318 if( !pTab->aCol ){
145321 pTab->aCol = pNew->aCol;
145326 pNew->aCol = 0;
146464 return pIdx->pTable->aCol[i].zCnName;
147684 && (pTab->aCol[iRef].colFlags & COLFLAG_VIRTUAL)!=0
147685 && ((pTab->aCol[iRef].colFlags & COLFLAG_HASCOLL)==0
147686 || sqlite3StrICmp(sqlite3ColumnColl(&pTab->aCol[iRef]),
148163 if( (j>=0 && pIdx->pTable->aCol[j].notNull==0) || j==XN_EXPR ){
150614 while( k<pTab->nCol && (pTab->aCol[k].colFlags & COLFLAG_HIDDEN)==0 ){k++;}
151067 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
151172 return pIdx->pTable->aCol[j].notNull;
151371 aff = pSrc->pTab->aCol[pTerm->u.x.leftColumn].affinity;
151452 pTable->aCol[iCol].zCnName);
154642 && pIndex->pTable->aCol[iColumn].notNull==0
170375 pCol = &pTab->aCol[iCol];
170383 pCol = iCol>=0 ? &pTab->aCol[iCol] : 0;
173827 const char **aCol; /* Array of column names */
173853 aCol = (const char **)sqlite3_malloc64(nByte);
173854 if( aCol ){
173855 memset((void*)aCol, 0, nByte);
173861 if( !aCol || !azNotindexed ){
173985 aCol[nCol++] = z;
174002 sqlite3_free((void*)aCol);
174003 aCol = 0;
174004 rc = fts3ContentColumns(db, argv[1], zContent,&aCol,&nCol,&nString,pzErr);
174011 if( sqlite3_stricmp(zLanguageid, aCol[j])==0 ){
174013 for(k=j; k<nCol; k++) aCol[k] = aCol[k+1];
174025 aCol[0] = "content";
174096 z = (char *)sqlite3Fts3NextToken(aCol[iCol], &n);
174171 sqlite3_free((void *)aCol);
215511 static int sqlite3Fts5StorageDocsize(Fts5Storage *p, i64 iRowid, int *aCol);
233705 int *aCol, int nCol, /* Array to populate */
233712 iOff += fts5GetVarint32(&aBlob[iOff], aCol[i]);
233725 static int sqlite3Fts5StorageDocsize(Fts5Storage *p, i64 iRowid, int *aCol){
233739 if( 0==fts5StorageDecodeSizeArray(aCol, nCol, aBlob, nBlob) ){