Lines Matching refs:aCol
17492 Column *aCol; /* Information about each column */ member
17632 } aCol[1]; /* One entry for each of nCol columns */ member
17902 } *aCol; member
84852 }else if( p->pTab->aCol[iIdx].affinity==SQLITE_AFF_REAL ){
90265 if( db->xUpdateCallback==0 || pTab->aCol==0 ){
90295 assert( pTab->aCol!=0 );
93563 if( sqlite3StrICmp(pTab->aCol[iCol].zName, zColumn)==0 ){
93591 if( pFKey->aCol[j].iFrom==iCol ){
97952 && (pExTab->aCol[n].colFlags & COLFLAG_GENERATED)!=0
98094 for(j=0, pCol=pTab->aCol; j<pTab->nCol; j++, pCol++){
98159 for(iCol=0, pCol=pTab->aCol; iCol<pTab->nCol; iCol++, pCol++){
98417 && (pTab->aCol[iCol].colFlags & COLFLAG_GENERATED)!=0
99740 return iCol>=0 ? pTab->aCol[iCol].affinity : SQLITE_AFF_INTEGER;
99886 const char *zColl = p->y.pTab->aCol[j].zColl;
102012 && ALWAYS(p->y.pTab->aCol!=0) /* Defense against OOM problems */
102013 && p->y.pTab->aCol[p->iColumn].notNull==0);
103270 }else if( (pCol = &pTab->aCol[iCol])->colFlags & COLFLAG_VIRTUAL ){
103534 pCol = &pAggInfo->aCol[pExpr->iAgg];
103545 VdbeComment((v,"%s.%s",pTab->zName,pTab->aCol[pCol->iColumn].zName));
103546 if( pTab->aCol[pCol->iColumn].affinity==SQLITE_AFF_REAL ){
103599 pCol = pTab->aCol + iCol;
104084 (pExpr->iColumn<0 ? "rowid" : pExpr->y.pTab->aCol[iCol].zName)
104093 if( iCol>=0 && pTab->aCol[iCol].affinity==SQLITE_AFF_REAL ){
105475 if( pAggInfo->aCol[iAgg].pCExpr==pExpr ){
105478 pAggInfo->aCol[iAgg].pCExpr = pExpr;
105515 pInfo->aCol = sqlite3ArrayAllocate(
105517 pInfo->aCol,
105518 sizeof(pInfo->aCol[0]),
105574 pCol = pAggInfo->aCol;
105584 pCol = &pAggInfo->aCol[k];
106106 pCol = &pNew->aCol[pNew->nCol-1];
106279 pNew->aCol = (Column*)sqlite3DbMallocZero(db, sizeof(Column)*nAlloc);
106281 if( !pNew->aCol || !pNew->zName ){
106285 memcpy(pNew->aCol, pTab->aCol, sizeof(Column)*pNew->nCol);
106287 Column *pCol = &pNew->aCol[i];
106380 if( 0==sqlite3StrICmp(pTab->aCol[iCol].zName, zOld) ) break;
107149 zOld = pTab->aCol[iCol].zName;
107186 &sParse, &sCtx, (void*)sParse.pNewTable->aCol[iCol].zName
107201 sqlite3WalkExpr(&sWalker, sParse.pNewTable->aCol[i].pDflt);
107207 if( bFKOnly==0 && pFKey->aCol[i].iFrom==iCol ){
107208 renameTokenFind(&sParse, &sCtx, (void*)&pFKey->aCol[i]);
107211 && 0==sqlite3_stricmp(pFKey->aCol[i].zCol, zOld)
107213 renameTokenFind(&sParse, &sCtx, (void*)pFKey->aCol[i].zCol);
108520 VdbeComment((v,"%s.%s", pIdx->zName, pIdx->pTable->aCol[i].zName));
110297 zCol = pTab->aCol[iCol].zName;
110300 zCol = pTab->aCol[pTab->iPKey].zName;
111031 if( (pCol = pTable->aCol)!=0 ){
111038 sqlite3DbFree(db, pTable->aCol);
111352 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ) iCol++;
111402 if( (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ) n++;
111404 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ){
111631 }else if( pTab && pCol!=pTab->aCol && (pCol[-1].colFlags & COLFLAG_HIDDEN) ){
111665 if( sqlite3_stricmp(z, p->aCol[i].zName)==0 ){
111673 aNew = sqlite3DbRealloc(db,p->aCol,(p->nCol+8)*sizeof(p->aCol[0]));
111678 p->aCol = aNew;
111680 pCol = &p->aCol[p->nCol];
111681 memset(pCol, 0, sizeof(p->aCol[0]));
111720 pCol = &p->aCol[p->nCol-1];
111851 pCol = &(p->aCol[p->nCol-1]);
111959 pCol = &pTab->aCol[iCol];
111971 if( sqlite3StrICmp(zCName, pTab->aCol[iCol].zName)==0 ){
111972 pCol = &pTab->aCol[iCol];
112053 sqlite3DbFree(db, p->aCol[i].zColl);
112054 p->aCol[i].zColl = zColl;
112063 pIdx->azColl[0] = p->aCol[i].zColl;
112083 pCol = &(pTab->aCol[pTab->nCol-1]);
112213 for(pCol = p->aCol, i=0; i<p->nCol; i++, pCol++){
112236 for(pCol=p->aCol, i=0; i<p->nCol; i++, pCol++){
112303 for(i=pTab->nCol, pTabCol=pTab->aCol; i>0; i--, pTabCol++){
112316 const Column *aCol = pIdx->pTable->aCol;
112320 wIndex += x<0 ? 1 : aCol[pIdx->aiColumn[i]].szEst;
112397 if( x>=0 && (pTab->aCol[x].colFlags & COLFLAG_VIRTUAL)==0 ){
112444 if( (pTab->aCol[i].colFlags & COLFLAG_PRIMKEY)!=0 ){
112445 pTab->aCol[i].notNull = OE_Abort;
112465 sqlite3TokenInit(&ipkToken, pTab->aCol[pTab->iPKey].zName);
112557 && (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ) nExtra++;
112562 && (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0
112749 u32 colFlags = p->aCol[ii].colFlags;
112751 Expr *pX = p->aCol[ii].pDflt;
112762 p->aCol[ii].pDflt = sqlite3ExprAlloc(db, TK_NULL, 0, 0);
112849 assert( p->aCol==0 );
112851 p->aCol = pSelTab->aCol;
112853 pSelTab->aCol = 0;
113126 &pTable->nCol, &pTable->aCol);
113138 assert( pTable->aCol==0 );
113140 pTable->aCol = pSelTab->aCol;
113142 pSelTab->aCol = 0;
113156 pTable->aCol = 0;
113176 pTab->aCol = 0;
113582 p->aCol[iCol].zName, pTo);
113594 nByte = sizeof(*pFKey) + (nCol-1)*sizeof(pFKey->aCol[0]) + pTo->n + 1;
113606 z = (char*)&pFKey->aCol[nCol];
113617 pFKey->aCol[0].iFrom = p->nCol-1;
113622 if( sqlite3StrICmp(p->aCol[j].zName, pFromCol->a[i].zEName)==0 ){
113623 pFKey->aCol[i].iFrom = j;
113634 sqlite3RenameTokenRemap(pParse, &pFKey->aCol[i], pFromCol->a[i].zEName);
113641 pFKey->aCol[i].zCol = z;
114071 Column *pCol = &pTab->aCol[pTab->nCol-1];
114174 if( pTab->aCol[j].notNull==0 ){
114177 if( pTab->aCol[j].colFlags & COLFLAG_VIRTUAL ){
114194 zColl = pTab->aCol[j].zColl;
115258 zCol = pTab->aCol[pIdx->aiColumn[j]].zName;
115285 pTab->aCol[pTab->iPKey].zName);
116272 const char *zName = pTab->aCol[pPk->aiColumn[0]].zName;
116278 Expr *p = sqlite3Expr(db, TK_ID, pTab->aCol[pPk->aiColumn[i]].zName);
119294 char *zKey = pFKey->aCol[0].zCol; /* Name of left-most parent key column */
119319 if( !sqlite3StrICmp(pParent->aCol[pParent->iPKey].zName, zKey) ) return 0;
119341 for(i=0; i<nCol; i++) aiCol[i] = pFKey->aCol[i].iFrom;
119361 zDfltColl = pParent->aCol[iCol].zColl;
119365 zIdxCol = pParent->aCol[iCol].zName;
119367 if( sqlite3StrICmp(pFKey->aCol[j].zCol, zIdxCol)==0 ){
119368 if( aiCol ) aiCol[i] = pFKey->aCol[j].iFrom;
119586 pCol = &pTab->aCol[iCol];
119696 iCol = aiCol ? aiCol[i] : pFKey->aCol[0].iFrom;
119698 zCol = pFKey->pFrom->aCol[iCol].zName;
119733 pRight = sqlite3Expr(db, TK_ID, pTab->aCol[iCol].zName);
119891 int iChildKey = p->aCol[i].iFrom;
119918 char *zKey = p->aCol[i].zCol;
119922 Column *pCol = &pTab->aCol[iKey];
120037 iFromCol = pFKey->aCol[i].iFrom;
120050 iCol = pFKey->aCol[0].iFrom;
120064 char *zCol = pTo->aCol[pIdx ? pIdx->aiColumn[i] : pTo->iPKey].zName;
120183 for(i=0; i<p->nCol; i++) mask |= COLUMN_MASK(p->aCol[i].iFrom);
120329 iFromCol = aiCol ? aiCol[i] : pFKey->aCol[0].iFrom;
120334 pTab->aCol[pIdx ? pIdx->aiColumn[i] : pTab->iPKey].zName);
120335 sqlite3TokenInit(&tFromCol, pFKey->pFrom->aCol[iFromCol].zName);
120373 Column *pCol = pFKey->pFrom->aCol + iFromCol;
120646 aff = pTab->aCol[x].affinity;
120696 assert( pTab->aCol[i].affinity!=0 );
120697 if( (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ){
120698 zColAff[j++] = pTab->aCol[i].affinity;
120763 pWalker->eCode |= pWalker->u.pTab->aCol[pExpr->iColumn].colFlags;
120806 if( pTab->aCol[ii].colFlags & COLFLAG_VIRTUAL ){
120809 if( pTab->aCol[ii].colFlags & COLFLAG_STORED ){
120821 if( pTab->aCol[i].colFlags & COLFLAG_GENERATED ){
120822 testcase( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL );
120823 testcase( pTab->aCol[i].colFlags & COLFLAG_STORED );
120824 pTab->aCol[i].colFlags |= COLFLAG_NOTAVAIL;
120843 Column *pCol = pTab->aCol + i;
121347 if( sqlite3StrICmp(pColumn->a[i].zName, pTab->aCol[j].zName)==0 ){
121354 if( pTab->aCol[j].colFlags & (COLFLAG_STORED|COLFLAG_VIRTUAL) ){
121357 pTab->aCol[j].zName);
121475 if( pTab->aCol[i].colFlags & COLFLAG_GENERATED ){
121476 testcase( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL );
121477 testcase( pTab->aCol[i].colFlags & COLFLAG_STORED );
121489 if( pTab->aCol[i].colFlags & COLFLAG_NOINSERT ) nHidden++;
121608 if( ((colFlags = pTab->aCol[i].colFlags) & COLFLAG_NOINSERT)!=0 ){
121628 sqlite3ExprCodeFactorable(pParse, pTab->aCol[i].pDflt, iRegStore);
121637 sqlite3ExprCodeFactorable(pParse, pTab->aCol[i].pDflt, iRegStore);
121643 sqlite3ExprCodeFactorable(pParse, pTab->aCol[i].pDflt, iRegStore);
122117 Column *pCol = &pTab->aCol[i]; /* The column to check for NOT NULL */
122533 VdbeComment((v, "%s", pTab->aCol[iField].zName));
122627 pTab->aCol[pPk->aiColumn[i]].zName));
122823 if( pTab->aCol[i].pDflt!=0 ) break;
122824 if( pTab->aCol[i].colFlags & COLFLAG_PRIMKEY ) break;
123187 Column *pDestCol = &pDest->aCol[i];
123188 Column *pSrcCol = &pSrc->aCol[i];
126901 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
126996 cnum<0 ? 0 : pTab->aCol[cnum].zName);
127117 pTab->aCol[pFK->aCol[j].iFrom].zName,
127118 pFK->aCol[j].zCol,
127208 int iCol = aiCols ? aiCols[j] : pFK->aCol[j].iFrom;
127420 if( pTab->aCol[j].notNull==0 ) continue;
127427 pTab->aCol[j].zName);
127487 if( iCol>=0 && pTab->aCol[iCol].notNull ) continue;
128889 sqlite3DbFree(db, p->aCol);
129568 for(pCol=pTab->aCol, i=0; i<pTab->nCol; pCol++, i++){
129598 && (bIgnoreHidden==0 || IsHiddenColumn(&pSrc->a[i].pTab->aCol[iCol])==0)
129764 if( IsHiddenColumn(&pRightTab->aCol[j]) ) continue;
129765 zName = pRightTab->aCol[j].zName;
130103 && (pTab->aCol[pExpr->iColumn].colFlags & COLFLAG_SORTERREF)
131048 zOrigCol = pTab->aCol[iCol].zName;
131049 zType = sqlite3ColumnType(&pTab->aCol[iCol],0);
131061 zType = sqlite3ColumnType(&pTab->aCol[iCol],0);
131220 zCol = pTab->aCol[iCol].zName;
131269 Column *aCol, *pCol; /* For looping over result columns */
131278 aCol = sqlite3DbMallocZero(db, sizeof(aCol[0])*nCol);
131279 testcase( aCol==0 );
131283 aCol = 0;
131287 *paCol = aCol;
131289 for(i=0, pCol=aCol; i<nCol && !db->mallocFailed; i++, pCol++){
131306 zName = iCol>=0 ? pTab->aCol[iCol].zName : "rowid";
131344 sqlite3DbFree(db, aCol[j].zName);
131346 sqlite3DbFree(db, aCol);
131386 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
131434 sqlite3ColumnsFromExprList(pParse, pSelect->pEList, &pTab->nCol, &pTab->aCol);
134179 sqlite3ColumnsFromExprList(pParse, pEList, &pTab->nCol, &pTab->aCol);
134240 sqlite3ColumnsFromExprList(pParse, pSel->pEList,&pTab->nCol,&pTab->aCol);
134461 char *zName = pTab->aCol[j].zName;
134478 && IsHiddenColumn(&pTab->aCol[j])
134706 assert( pAggInfo->aCol[i].iMem>=pAggInfo->mnReg
134707 && pAggInfo->aCol[i].iMem<=pAggInfo->mxReg );
134840 for(i=0, pC=pAggInfo->aCol; i<pAggInfo->nAccumulator; i++, pC++){
135767 ii, pAggInfo->aCol[ii].iMem);
135768 sqlite3TreeViewExpr(0, pAggInfo->aCol[ii].pCExpr, 0);
135858 if( pAggInfo->aCol[i].iSorterColumn>=j ){
135867 struct AggInfo_col *pCol = &pAggInfo->aCol[i];
136162 Expr *pExpr = pAggInfo->aCol[i].pCExpr;
137667 Column *pCol = &pTab->aCol[i];
137677 if( pTab->aCol[i].affinity==SQLITE_AFF_REAL && !IsVirtual(pTab) ){
138057 if( sqlite3StrICmp(pTab->aCol[j].zName, pChanges->a[i].zEName)==0 ){
138062 }else if( pPk && (pTab->aCol[j].colFlags & COLFLAG_PRIMKEY)!=0 ){
138066 else if( pTab->aCol[j].colFlags & COLFLAG_GENERATED ){
138067 testcase( pTab->aCol[j].colFlags & COLFLAG_VIRTUAL );
138068 testcase( pTab->aCol[j].colFlags & COLFLAG_STORED );
138071 pTab->aCol[j].zName);
138095 j<0 ? "ROWID" : pTab->aCol[j].zName,
138126 if( (pTab->aCol[i].colFlags & COLFLAG_GENERATED)==0 ) continue;
138127 if( sqlite3ExprReferencesUpdatedColumn(pTab->aCol[i].pDflt,
138467 u32 colFlags = pTab->aCol[i].colFlags;
138503 }else if( (pTab->aCol[i].colFlags & COLFLAG_GENERATED)!=0 ){
138504 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ) k--;
138571 if( pTab->aCol[i].colFlags & COLFLAG_GENERATED ){
138572 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ) k--;
138823 assert( (pTab->aCol[i].colFlags & COLFLAG_GENERATED)==0 );
139140 pTab->aCol[pPk->aiColumn[i]].zName));
139156 if( pTab->aCol[i].affinity==SQLITE_AFF_REAL ){
140217 char *zType = sqlite3ColumnType(&pTab->aCol[iCol], "");
140239 pTab->aCol[iCol].colFlags |= COLFLAG_HIDDEN;
140404 if( !pTab->aCol ){
140407 pTab->aCol = pNew->aCol;
140411 pNew->aCol = 0;
141554 return pIdx->pTable->aCol[i].zName;
142741 && (pTab->aCol[iRef].colFlags & COLFLAG_VIRTUAL)!=0
142742 && (pTab->aCol[iRef].zColl==0
142743 || sqlite3StrICmp(pTab->aCol[iRef].zColl, sqlite3StrBINARY)==0)
143213 if( (j>=0 && pIdx->pTable->aCol[j].notNull==0) || j==XN_EXPR ){
145589 while( k<pTab->nCol && (pTab->aCol[k].colFlags & COLFLAG_HIDDEN)==0 ){k++;}
145995 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
146099 return pIdx->pTable->aCol[j].notNull;
146294 aff = pSrc->pTab->aCol[pTerm->u.leftColumn].affinity;
146372 pTable->aCol[iCol].zName);
149499 && pIndex->pTable->aCol[iColumn].notNull==0
164689 pCol = &pTab->aCol[iCol];
164697 pCol = iCol>=0 ? &pTab->aCol[iCol] : 0;
168068 const char **aCol; /* Array of column names */
168094 aCol = (const char **)sqlite3_malloc64(nByte);
168095 if( aCol ){
168096 memset((void*)aCol, 0, nByte);
168102 if( !aCol || !azNotindexed ){
168226 aCol[nCol++] = z;
168243 sqlite3_free((void*)aCol);
168244 aCol = 0;
168245 rc = fts3ContentColumns(db, argv[1], zContent,&aCol,&nCol,&nString,pzErr);
168252 if( sqlite3_stricmp(zLanguageid, aCol[j])==0 ){
168254 for(k=j; k<nCol; k++) aCol[k] = aCol[k+1];
168266 aCol[0] = "content";
168337 z = (char *)sqlite3Fts3NextToken(aCol[iCol], &n);
168412 sqlite3_free((void *)aCol);
209150 static int sqlite3Fts5StorageDocsize(Fts5Storage *p, i64 iRowid, int *aCol);
226880 int *aCol, int nCol, /* Array to populate */
226887 iOff += fts5GetVarint32(&aBlob[iOff], aCol[i]);
226900 static int sqlite3Fts5StorageDocsize(Fts5Storage *p, i64 iRowid, int *aCol){
226913 if( 0==fts5StorageDecodeSizeArray(aCol, nCol, aBlob, nBlob) ){