Lines Matching refs:aCol
18393 Column *aCol; /* Information about each column */ member
18562 } aCol[1]; /* One entry for each of nCol columns */ member
18858 } *aCol; member
32678 const Column *aCol, in sqlite3TreeViewColumnList() argument
32686 u16 flg = aCol[i].colFlags; in sqlite3TreeViewColumnList()
32690 printf(" %s", aCol[i].zCnName); in sqlite3TreeViewColumnList()
32691 switch( aCol[i].eCType ){ in sqlite3TreeViewColumnList()
32700 const char *z = aCol[i].zCnName; in sqlite3TreeViewColumnList()
32827 sqlite3TreeViewColumnList(pView, pTab->aCol, pTab->nCol, 1); in sqlite3TreeViewSrcList()
92585 }else if( p->pTab->aCol[iIdx].affinity==SQLITE_AFF_REAL ){
96345 Column *aCol;
96352 aCol = pTab->aCol;
96355 if( aCol[i].colFlags & COLFLAG_GENERATED ){
96356 if( aCol[i].colFlags & COLFLAG_VIRTUAL ) continue;
96360 applyAffinity(pIn1, aCol[i].affinity, encoding);
96362 switch( aCol[i].eCType ){
96415 vdbeMemTypeName(pIn1), sqlite3StdType[aCol[i].eCType-1],
96416 pTab->zName, aCol[i].zCnName);
98811 if( db->xUpdateCallback==0 || pTab->aCol==0 ){
98847 assert( pTab->aCol!=0 );
102474 if( sqlite3StrICmp(pTab->aCol[iCol].zCnName, zColumn)==0 ){
102503 if( pFKey->aCol[j].iFrom==iCol ){
106913 && (pExTab->aCol[n].colFlags & COLFLAG_GENERATED)!=0
107157 for(j=0, pCol=pTab->aCol; j<pTab->nCol; j++, pCol++){
107285 for(iCol=0, pCol=pTab->aCol; iCol<pTab->nCol; iCol++, pCol++){
107605 && (pTab->aCol[iCol].colFlags & COLFLAG_GENERATED)!=0
109037 return pTab->aCol[iCol].affinity;
109269 const char *zColl = sqlite3ColumnColl(&p->y.pTab->aCol[j]);
111873 && p->y.pTab->aCol!=0 /* Possible due to prior error */
111875 && p->y.pTab->aCol[p->iColumn].notNull==0);
111946 if( sqlite3_stricmp(azOpt[ii], pTab->aCol[iCol].zCnName)==0 ) break;
113188 }else if( (pCol = &pTab->aCol[iCol])->colFlags & COLFLAG_VIRTUAL ){
113582 pCol = &pAggInfo->aCol[pExpr->iAgg];
113595 pTab->zName, pTab->aCol[pCol->iColumn].zCnName));
113596 if( pTab->aCol[pCol->iColumn].affinity==SQLITE_AFF_REAL ){
113654 pCol = pTab->aCol + iCol;
114158 (pExpr->iColumn<0 ? "rowid" : pExpr->y.pTab->aCol[iCol].zCnName)
114167 if( iCol>=0 && pTab->aCol[iCol].affinity==SQLITE_AFF_REAL ){
114197 pAggInfo->aCol[pExpr->iAgg].iSorterColumn,
115692 && pAggInfo->aCol[iAgg].pCExpr==pExpr
115696 pAggInfo->aCol[iAgg].pCExpr = pExpr;
115731 pInfo->aCol = sqlite3ArrayAllocate(
115733 pInfo->aCol,
115734 sizeof(pInfo->aCol[0]),
115773 pCol = pAggInfo->aCol;
115789 pCol = &pAggInfo->aCol[k];
115870 assert( pAggInfo->aCol!=0 );
115872 pAggInfo->aCol[tmp.iAgg].pCExpr = pExpr;
116479 pCol = &pNew->aCol[pNew->nCol-1];
116676 pNew->aCol = (Column*)sqlite3DbMallocZero(db, sizeof(Column)*nAlloc);
116678 if( !pNew->aCol || !pNew->zName ){
116682 memcpy(pNew->aCol, pTab->aCol, sizeof(Column)*pNew->nCol);
116684 Column *pCol = &pNew->aCol[i];
116778 if( 0==sqlite3StrICmp(pTab->aCol[iCol].zCnName, zOld) ) break;
117668 zOld = pTab->aCol[iCol].zCnName;
117705 &sParse, &sCtx, (void*)sParse.pNewTable->aCol[iCol].zCnName
117721 &sParse.pNewTable->aCol[i]);
117730 if( bFKOnly==0 && pFKey->aCol[i].iFrom==iCol ){
117731 renameTokenFind(&sParse, &sCtx, (void*)&pFKey->aCol[i]);
117734 && 0==sqlite3_stricmp(pFKey->aCol[i].zCol, zOld)
117736 renameTokenFind(&sParse, &sCtx, (void*)pFKey->aCol[i].zCol);
118094 &sParse.pNewTable->aCol[i]));
118263 pCol = renameTokenFind(&sParse, 0, (void*)pTab->aCol[iCol].zCnName);
118266 pEnd = renameTokenFind(&sParse, 0, (void*)pTab->aCol[iCol+1].zCnName);
118330 if( pTab->aCol[iCol].colFlags & (COLFLAG_PRIMKEY|COLFLAG_UNIQUE) ){
118332 (pTab->aCol[iCol].colFlags&COLFLAG_PRIMKEY) ? "PRIMARY KEY" : "UNIQUE",
118368 if( pParse->nErr==0 && (pTab->aCol[iCol].colFlags & COLFLAG_VIRTUAL)==0 ){
118394 if( i!=iCol && (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ){
118407 char aff = pTab->aCol[i].affinity;
118409 pTab->aCol[i].affinity = SQLITE_AFF_NUMERIC;
118412 pTab->aCol[i].affinity = aff;
119421 VdbeComment((v,"%s.%s", pIdx->zName, pIdx->pTable->aCol[i].zCnName));
121274 zCol = pTab->aCol[iCol].zCnName;
121277 zCol = pTab->aCol[pTab->iPKey].zCnName;
122144 if( (pCol = pTable->aCol)!=0 ){
122149 sqlite3DbNNFreeNN(db, pTable->aCol);
122154 pTable->aCol = 0;
122484 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ) iCol++;
122534 if( (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ) n++;
122536 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ){
122774 }else if( pTab && pCol!=pTab->aCol && (pCol[-1].colFlags & COLFLAG_HIDDEN) ){
122921 if( p->aCol[i].hName==hName && sqlite3StrICmp(z, p->aCol[i].zCnName)==0 ){
122927 aNew = sqlite3DbRealloc(db,p->aCol,((i64)p->nCol+1)*sizeof(p->aCol[0]));
122932 p->aCol = aNew;
122933 pCol = &p->aCol[p->nCol];
122934 memset(pCol, 0, sizeof(p->aCol[0]));
122976 pCol = &p->aCol[p->nCol-1];
123108 pCol = &(p->aCol[p->nCol-1]);
123216 pCol = &pTab->aCol[iCol];
123230 if( sqlite3StrICmp(zCName, pTab->aCol[iCol].zCnName)==0 ){
123231 pCol = &pTab->aCol[iCol];
123321 sqlite3ColumnSetColl(db, &p->aCol[i], zColl);
123330 pIdx->azColl[0] = sqlite3ColumnColl(&p->aCol[i]);
123349 pCol = &(pTab->aCol[pTab->nCol-1]);
123487 for(pCol = p->aCol, i=0; i<p->nCol; i++, pCol++){
123510 for(pCol=p->aCol, i=0; i<p->nCol; i++, pCol++){
123583 for(i=pTab->nCol, pTabCol=pTab->aCol; i>0; i--, pTabCol++){
123596 const Column *aCol = pIdx->pTable->aCol;
123600 wIndex += x<0 ? 1 : aCol[x].szEst;
123677 if( x>=0 && (pTab->aCol[x].colFlags & COLFLAG_VIRTUAL)==0 ){
123724 if( (pTab->aCol[i].colFlags & COLFLAG_PRIMKEY)!=0
123725 && (pTab->aCol[i].notNull==OE_None)
123727 pTab->aCol[i].notNull = OE_Abort;
123748 sqlite3TokenInit(&ipkToken, pTab->aCol[pTab->iPKey].zCnName);
123847 && (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ) nExtra++;
123852 && (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0
124045 Column *pCol = &p->aCol[ii];
124112 u32 colFlags = p->aCol[ii].colFlags;
124114 Expr *pX = sqlite3ColumnExpr(p, &p->aCol[ii]);
124124 sqlite3ColumnSetExpr(pParse, p, &p->aCol[ii],
124217 assert( p->aCol==0 );
124219 p->aCol = pSelTab->aCol;
124221 pSelTab->aCol = 0;
124527 &pTable->nCol, &pTable->aCol);
124538 assert( pTable->aCol==0 );
124540 pTable->aCol = pSelTab->aCol;
124543 pSelTab->aCol = 0;
124991 p->aCol[iCol].zCnName, pTo);
125003 nByte = sizeof(*pFKey) + (nCol-1)*sizeof(pFKey->aCol[0]) + pTo->n + 1;
125016 z = (char*)&pFKey->aCol[nCol];
125027 pFKey->aCol[0].iFrom = p->nCol-1;
125032 if( sqlite3StrICmp(p->aCol[j].zCnName, pFromCol->a[i].zEName)==0 ){
125033 pFKey->aCol[i].iFrom = j;
125044 sqlite3RenameTokenRemap(pParse, &pFKey->aCol[i], pFromCol->a[i].zEName);
125051 pFKey->aCol[i].zCol = z;
125486 Column *pCol = &pTab->aCol[pTab->nCol-1];
125591 if( pTab->aCol[j].notNull==0 ){
125594 if( pTab->aCol[j].colFlags & COLFLAG_VIRTUAL ){
125613 zColl = sqlite3ColumnColl(&pTab->aCol[j]);
126742 zCol = pTab->aCol[pIdx->aiColumn[j]].zCnName;
126769 pTab->aCol[pTab->iPKey].zCnName);
127851 zName = pTab->aCol[pPk->aiColumn[0]].zCnName;
127859 p = sqlite3Expr(db, TK_ID, pTab->aCol[pPk->aiColumn[i]].zCnName);
131601 char *zKey = pFKey->aCol[0].zCol; /* Name of left-most parent key column */
131626 if( !sqlite3StrICmp(pParent->aCol[pParent->iPKey].zCnName, zKey) ){
131650 for(i=0; i<nCol; i++) aiCol[i] = pFKey->aCol[i].iFrom;
131670 zDfltColl = sqlite3ColumnColl(&pParent->aCol[iCol]);
131674 zIdxCol = pParent->aCol[iCol].zCnName;
131676 if( sqlite3StrICmp(pFKey->aCol[j].zCol, zIdxCol)==0 ){
131677 if( aiCol ) aiCol[i] = pFKey->aCol[j].iFrom;
131893 pCol = &pTab->aCol[iCol];
132000 iCol = aiCol ? aiCol[i] : pFKey->aCol[0].iFrom;
132002 zCol = pFKey->pFrom->aCol[iCol].zCnName;
132037 pRight = sqlite3Expr(db, TK_ID, pTab->aCol[iCol].zCnName);
132214 int iChildKey = p->aCol[i].iFrom;
132241 char *zKey = p->aCol[i].zCol;
132245 Column *pCol = &pTab->aCol[iKey];
132362 iFromCol = pFKey->aCol[i].iFrom;
132375 iCol = pFKey->aCol[0].iFrom;
132389 char *zCol = pTo->aCol[pIdx ? pIdx->aiColumn[i] : pTo->iPKey].zCnName;
132510 for(i=0; i<p->nCol; i++) mask |= COLUMN_MASK(p->aCol[i].iFrom);
132664 iFromCol = aiCol ? aiCol[i] : pFKey->aCol[0].iFrom;
132669 pTab->aCol[pIdx ? pIdx->aiColumn[i] : pTab->iPKey].zCnName);
132670 sqlite3TokenInit(&tFromCol, pFKey->pFrom->aCol[iFromCol].zCnName);
132708 Column *pCol = pFKey->pFrom->aCol + iFromCol;
132988 aff = pTab->aCol[x].affinity;
133021 if( (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ){
133022 zColAff[j++] = pTab->aCol[i].affinity;
133162 pWalker->eCode |= pWalker->u.pTab->aCol[pExpr->iColumn].colFlags;
133205 if( pTab->aCol[ii].colFlags & COLFLAG_VIRTUAL ){
133208 if( pTab->aCol[ii].colFlags & COLFLAG_STORED ){
133226 if( pTab->aCol[i].colFlags & COLFLAG_GENERATED ){
133227 testcase( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL );
133228 testcase( pTab->aCol[i].colFlags & COLFLAG_STORED );
133229 pTab->aCol[i].colFlags |= COLFLAG_NOTAVAIL;
133248 Column *pCol = pTab->aCol + i;
133960 if( sqlite3StrICmp(pColumn->a[i].zName, pTab->aCol[j].zCnName)==0 ){
133967 if( pTab->aCol[j].colFlags & (COLFLAG_STORED|COLFLAG_VIRTUAL) ){
133970 pTab->aCol[j].zCnName);
134105 if( pTab->aCol[i].colFlags & COLFLAG_GENERATED ){
134106 testcase( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL );
134107 testcase( pTab->aCol[i].colFlags & COLFLAG_STORED );
134122 if( pTab->aCol[i].colFlags & COLFLAG_NOINSERT ) nHidden++;
134251 if( ((colFlags = pTab->aCol[i].colFlags) & COLFLAG_NOINSERT)!=0 ){
134272 sqlite3ColumnExpr(pTab, &pTab->aCol[i]),
134284 sqlite3ColumnExpr(pTab, &pTab->aCol[i]),
134292 sqlite3ColumnExpr(pTab, &pTab->aCol[i]),
134841 Column *pCol = &pTab->aCol[i]; /* The column to check for NOT NULL */
135317 VdbeComment((v, "%s", pTab->aCol[iField].zCnName));
135412 pTab->aCol[pPk->aiColumn[i]].zCnName));
135613 if( pTab->aCol[i].iDflt!=0 ) break;
135614 if( pTab->aCol[i].colFlags & COLFLAG_PRIMKEY ) break;
135990 Column *pDestCol = &pDest->aCol[i];
135991 Column *pSrcCol = &pSrc->aCol[i];
139933 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
140111 cnum<0 ? 0 : pTab->aCol[cnum].zCnName);
140234 pTab->aCol[pFK->aCol[j].iFrom].zCnName,
140235 pFK->aCol[j].zCol,
140326 int iCol = aiCols ? aiCols[j] : pFK->aCol[j].iFrom;
140577 if( (pTab->aCol[j].colFlags & COLFLAG_VIRTUAL)==0 ) mxCol++;
140623 Column *pCol = pTab->aCol + j; /* The column to be checked */
140711 pTab->zName, pTab->aCol[j].zCnName);
140720 pTab->zName, pTab->aCol[j].zCnName);
140736 pTab->zName, pTab->aCol[j].zCnName);
140835 if( iCol>=0 && pTab->aCol[iCol].notNull ) continue;
143215 for(pCol=pTab->aCol, i=0; i<pTab->nCol; pCol++, i++){
143266 && (bIgnoreHidden==0 || IsHiddenColumn(&pSrc->a[i].pTab->aCol[iCol])==0)
143414 if( IsHiddenColumn(&pRightTab->aCol[j]) ) continue;
143415 zName = pRightTab->aCol[j].zCnName;
143944 && (pTab->aCol[pExpr->iColumn].colFlags & COLFLAG_SORTERREF)!=0
144876 zOrigCol = pTab->aCol[iCol].zCnName;
144877 zType = sqlite3ColumnType(&pTab->aCol[iCol],0);
144889 zType = sqlite3ColumnType(&pTab->aCol[iCol],0);
145044 zCol = pTab->aCol[iCol].zCnName;
145093 Column *aCol, *pCol; /* For looping over result columns */
145103 aCol = sqlite3DbMallocZero(db, sizeof(aCol[0])*nCol);
145104 testcase( aCol==0 );
145108 aCol = 0;
145112 *paCol = aCol;
145114 for(i=0, pCol=aCol; i<nCol && !pParse->nErr; i++, pCol++){
145135 zName = iCol>=0 ? pTab->aCol[iCol].zCnName : "rowid";
145182 sqlite3DbFree(db, aCol[j].zCnName);
145184 sqlite3DbFree(db, aCol);
145226 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
145315 sqlite3ColumnsFromExprList(pParse, pSelect->pEList, &pTab->nCol, &pTab->aCol);
148736 sqlite3ColumnsFromExprList(pParse, pEList, &pTab->nCol, &pTab->aCol);
148795 sqlite3ColumnsFromExprList(pParse, pSel->pEList,&pTab->nCol,&pTab->aCol);
149114 zName = pTab->aCol[j].zCnName;
149134 && IsHiddenColumn(&pTab->aCol[j])
149138 if( (pTab->aCol[j].colFlags & COLFLAG_NOEXPAND)!=0
149200 || (j<pTab->nCol && (pTab->aCol[j].colFlags & COLFLAG_NOEXPAND))
149378 struct AggInfo_col *pCol = &pAggInfo->aCol[ii];
149386 sqlite3TreeViewExpr(0, pAggInfo->aCol[ii].pCExpr, 0);
149462 k = pAggInfo->aCol[j].iSorterColumn;
149501 pCol = &pAggInfo->aCol[pExpr->iAgg];
149845 for(i=0, pC=pAggInfo->aCol; i<pAggInfo->nAccumulator; i++, pC++){
149995 sqlite3DbFree(db, p->aCol);
151130 if( pAggInfo->aCol[i].iSorterColumn>=j ){
151140 struct AggInfo_col *pCol = &pAggInfo->aCol[i];
151486 Expr *pExpr = pAggInfo->aCol[i].pCExpr;
152644 if( IsHiddenColumn(pTab->aCol+jj) ) continue;
152645 pNewExpr = sqlite3Expr(db, TK_ID, pTab->aCol[jj].zCnName);
152649 pItem->zEName = sqlite3DbStrDup(db, pTab->aCol[jj].zCnName);
153338 pCol = &pTab->aCol[i];
153748 if( pTab->aCol[j].hName==hCol
153749 && sqlite3StrICmp(pTab->aCol[j].zCnName, pChanges->a[i].zEName)==0
153755 }else if( pPk && (pTab->aCol[j].colFlags & COLFLAG_PRIMKEY)!=0 ){
153759 else if( pTab->aCol[j].colFlags & COLFLAG_GENERATED ){
153760 testcase( pTab->aCol[j].colFlags & COLFLAG_VIRTUAL );
153761 testcase( pTab->aCol[j].colFlags & COLFLAG_STORED );
153764 pTab->aCol[j].zCnName);
153788 j<0 ? "ROWID" : pTab->aCol[j].zCnName,
153819 if( (pTab->aCol[i].colFlags & COLFLAG_GENERATED)==0 ) continue;
153821 sqlite3ColumnExpr(pTab, &pTab->aCol[i]),
154184 u32 colFlags = pTab->aCol[i].colFlags;
154223 }else if( (pTab->aCol[i].colFlags & COLFLAG_GENERATED)!=0 ){
154224 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ) k--;
154291 if( pTab->aCol[i].colFlags & COLFLAG_GENERATED ){
154292 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ) k--;
154559 assert( (pTab->aCol[i].colFlags & COLFLAG_GENERATED)==0 );
154948 pTab->aCol[pPk->aiColumn[i]].zCnName));
154964 if( pTab->aCol[i].affinity==SQLITE_AFF_REAL ){
156045 char *zType = sqlite3ColumnType(&pTab->aCol[iCol], "");
156067 pTab->aCol[iCol].colFlags |= COLFLAG_HIDDEN;
156258 if( !pTab->aCol ){
156261 pTab->aCol = pNew->aCol;
156266 pNew->aCol = 0;
157443 return pIdx->pTable->aCol[i].zCnName;
157593 const char *zRowid = pTab->iPKey>=0 ? pTab->aCol[pTab->iPKey].zCnName:
157669 sqlite3_str_appendf(&str, "%s=?", pTab->aCol[pTab->iPKey].zCnName);
159237 if( (j>=0 && pIdx->pTable->aCol[j].notNull==0) || j==XN_EXPR ){
162087 while( k<pTab->nCol && (pTab->aCol[k].colFlags & COLFLAG_HIDDEN)==0 ){k++;}
162621 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
162731 return pIdx->pTable->aCol[j].notNull;
162985 aff = pSrc->pTab->aCol[pTerm->u.x.leftColumn].affinity;
163026 zName = pTab->aCol[iCol].zCnName;
163122 pTable->aCol[iCol].zCnName);
163526 zColl = sqlite3ColumnColl(&pTab->aCol[pE2->iColumn]);
165809 aff = pIdx->pTable->aCol[pLeft->iColumn].affinity;
167112 && pIndex->pTable->aCol[iColumn].notNull==0
168194 }else if( j>=0 && (pTab->aCol[j].colFlags & COLFLAG_VIRTUAL)!=0 ){
168195 pExpr = sqlite3ColumnExpr(pTab, &pTab->aCol[j]);
183731 pCol = &pTab->aCol[iCol];
183739 pCol = iCol>=0 ? &pTab->aCol[iCol] : 0;
187344 const char **aCol; /* Array of column names */
187370 aCol = (const char **)sqlite3_malloc64(nByte);
187371 if( aCol ){
187372 memset((void*)aCol, 0, nByte);
187378 if( !aCol || !azNotindexed ){
187502 aCol[nCol++] = z;
187519 sqlite3_free((void*)aCol);
187520 aCol = 0;
187521 rc = fts3ContentColumns(db, argv[1], zContent,&aCol,&nCol,&nString,pzErr);
187528 if( sqlite3_stricmp(zLanguageid, aCol[j])==0 ){
187530 for(k=j; k<nCol; k++) aCol[k] = aCol[k+1];
187542 aCol[0] = "content";
187613 z = (char *)sqlite3Fts3NextToken(aCol[iCol], &n);
187688 sqlite3_free((void *)aCol);
232746 static int sqlite3Fts5StorageDocsize(Fts5Storage *p, i64 iRowid, int *aCol);
253810 int *aCol, int nCol, /* Array to populate */
253817 iOff += fts5GetVarint32(&aBlob[iOff], aCol[i]);
253830 static int sqlite3Fts5StorageDocsize(Fts5Storage *p, i64 iRowid, int *aCol){
253844 if( 0==fts5StorageDecodeSizeArray(aCol, nCol, aBlob, nBlob) ){
257366 int aCol[STMT_NUM_INTEGER_COLUMN+1]; /* all other column values */
257510 sqlite3_result_int(ctx, pRow->aCol[i]);
257567 pNew->aCol[STMT_COLUMN_NCOL] = sqlite3_column_count(p);
257568 pNew->aCol[STMT_COLUMN_RO] = sqlite3_stmt_readonly(p);
257569 pNew->aCol[STMT_COLUMN_BUSY] = sqlite3_stmt_busy(p);
257570 pNew->aCol[STMT_COLUMN_NSCAN] = sqlite3_stmt_status(
257573 pNew->aCol[STMT_COLUMN_NSORT] = sqlite3_stmt_status(
257576 pNew->aCol[STMT_COLUMN_NAIDX] = sqlite3_stmt_status(
257579 pNew->aCol[STMT_COLUMN_NSTEP] = sqlite3_stmt_status(
257582 pNew->aCol[STMT_COLUMN_REPREP] = sqlite3_stmt_status(
257585 pNew->aCol[STMT_COLUMN_RUN] = sqlite3_stmt_status(
257588 pNew->aCol[STMT_COLUMN_MEM] = sqlite3_stmt_status(