Lines Matching refs:aCol
18797 Column *aCol; /* Information about each column */ member
18967 } aCol[FLEXARRAY]; /* One entry for each of nCol columns */ member
18972 #define SZ_FKEY(N) (offsetof(FKey,aCol)+(N)*sizeof(struct sColMap))
19269 } *aCol; member
33247 const Column *aCol, in sqlite3TreeViewColumnList() argument
33255 u16 flg = aCol[i].colFlags; in sqlite3TreeViewColumnList()
33259 printf(" %s", aCol[i].zCnName); in sqlite3TreeViewColumnList()
33260 switch( aCol[i].eCType ){ in sqlite3TreeViewColumnList()
33269 const char *z = aCol[i].zCnName; in sqlite3TreeViewColumnList()
33402 sqlite3TreeViewColumnList(pView, pTab->aCol, pTab->nCol, 1); in sqlite3TreeViewSrcList()
93693 Column *pCol = &p->pTab->aCol[iIdx];
93717 }else if( p->pTab->aCol[iIdx].affinity==SQLITE_AFF_REAL ){
97602 Column *aCol;
97609 aCol = pTab->aCol;
97612 if( aCol[i].colFlags & COLFLAG_GENERATED ){
97613 if( aCol[i].colFlags & COLFLAG_VIRTUAL ) continue;
97617 applyAffinity(pIn1, aCol[i].affinity, encoding);
97619 switch( aCol[i].eCType ){
97672 vdbeMemTypeName(pIn1), sqlite3StdType[aCol[i].eCType-1],
97673 pTab->zName, aCol[i].zCnName);
100075 if( db->xUpdateCallback==0 || pTab->aCol==0 ){
100111 assert( pTab->aCol!=0 );
103802 if( pFKey->aCol[j].iFrom==iCol ){
108223 && (pExTab->aCol[n].colFlags & COLFLAG_GENERATED)!=0
108907 && (pTab->aCol[iCol].colFlags & COLFLAG_GENERATED)!=0
110371 return pTab->aCol[iCol].affinity;
110607 const char *zColl = sqlite3ColumnColl(&p->y.pTab->aCol[j]);
113243 && p->y.pTab->aCol!=0 /* Possible due to prior error */
113245 && p->y.pTab->aCol[p->iColumn].notNull==0);
114649 }else if( (pCol = &pTab->aCol[iCol])->colFlags & COLFLAG_VIRTUAL ){
115111 pCol = &pAggInfo->aCol[pExpr->iAgg];
115124 pTab->zName, pTab->aCol[pCol->iColumn].zCnName));
115125 if( pTab->aCol[pCol->iColumn].affinity==SQLITE_AFF_REAL ){
115183 pCol = pTab->aCol + iCol;
115693 (pExpr->iColumn<0 ? "rowid" : pExpr->y.pTab->aCol[iCol].zCnName)
115702 if( iCol>=0 && pTab->aCol[iCol].affinity==SQLITE_AFF_REAL ){
115732 pAggInfo->aCol[pExpr->iAgg].iSorterColumn,
117304 && pAggInfo->aCol[iAgg].pCExpr==pExpr
117308 pAggInfo->aCol[iAgg].pCExpr = pExpr;
117343 pInfo->aCol = sqlite3ArrayAllocate(
117345 pInfo->aCol,
117346 sizeof(pInfo->aCol[0]),
117387 pCol = pAggInfo->aCol;
117407 pCol = &pAggInfo->aCol[k];
117489 assert( pAggInfo->aCol!=0 );
117491 pAggInfo->aCol[tmp.iAgg].pCExpr = pExpr;
118105 pCol = &pNew->aCol[pNew->nCol-1];
118302 pNew->aCol = (Column*)sqlite3DbMallocZero(db, sizeof(Column)*(u32)nAlloc);
118304 if( !pNew->aCol || !pNew->zName ){
118308 memcpy(pNew->aCol, pTab->aCol, sizeof(Column)*(size_t)pNew->nCol);
118310 Column *pCol = &pNew->aCol[i];
119312 zOld = pTab->aCol[iCol].zCnName;
119349 &sParse, &sCtx, (void*)sParse.pNewTable->aCol[iCol].zCnName
119365 &sParse.pNewTable->aCol[i]);
119374 if( bFKOnly==0 && pFKey->aCol[i].iFrom==iCol ){
119375 renameTokenFind(&sParse, &sCtx, (void*)&pFKey->aCol[i]);
119378 && 0==sqlite3_stricmp(pFKey->aCol[i].zCol, zOld)
119380 renameTokenFind(&sParse, &sCtx, (void*)pFKey->aCol[i].zCol);
119738 &sParse.pNewTable->aCol[i]));
119907 pCol = renameTokenFind(&sParse, 0, (void*)pTab->aCol[iCol].zCnName);
119910 pEnd = renameTokenFind(&sParse, 0, (void*)pTab->aCol[iCol+1].zCnName);
119974 if( pTab->aCol[iCol].colFlags & (COLFLAG_PRIMKEY|COLFLAG_UNIQUE) ){
119976 (pTab->aCol[iCol].colFlags&COLFLAG_PRIMKEY) ? "PRIMARY KEY" : "UNIQUE",
120012 if( pParse->nErr==0 && (pTab->aCol[iCol].colFlags & COLFLAG_VIRTUAL)==0 ){
120038 if( i!=iCol && (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ){
120051 char aff = pTab->aCol[i].affinity;
120053 pTab->aCol[i].affinity = SQLITE_AFF_NUMERIC;
120056 pTab->aCol[i].affinity = aff;
121066 VdbeComment((v,"%s.%s", pIdx->zName, pIdx->pTable->aCol[i].zCnName));
122914 zCol = pTab->aCol[iCol].zCnName;
122917 zCol = pTab->aCol[pTab->iPKey].zCnName;
123757 if( (pCol = pTable->aCol)!=0 ){
123762 sqlite3DbNNFreeNN(db, pTable->aCol);
123767 pTable->aCol = 0;
124103 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ) iCol++;
124153 if( (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ) n++;
124155 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ){
124394 }else if( pTab && pCol!=pTab->aCol && (pCol[-1].colFlags & COLFLAG_HIDDEN) ){
124544 aNew = sqlite3DbRealloc(db,p->aCol,((i64)p->nCol+1)*sizeof(p->aCol[0]));
124549 p->aCol = aNew;
124550 pCol = &p->aCol[p->nCol];
124551 memset(pCol, 0, sizeof(p->aCol[0]));
124598 pCol = &p->aCol[p->nCol-1];
124730 pCol = &(p->aCol[p->nCol-1]);
124838 pCol = &pTab->aCol[iCol];
124851 pCol = &pTab->aCol[iCol];
124941 sqlite3ColumnSetColl(db, &p->aCol[i], zColl);
124950 pIdx->azColl[0] = sqlite3ColumnColl(&p->aCol[i]);
124969 pCol = &(pTab->aCol[pTab->nCol-1]);
125108 for(pCol = p->aCol, i=0; i<p->nCol; i++, pCol++){
125132 for(pCol=p->aCol, i=0; i<p->nCol; i++, pCol++){
125215 for(i=pTab->nCol, pTabCol=pTab->aCol; i>0; i--, pTabCol++){
125228 const Column *aCol = pIdx->pTable->aCol;
125232 wIndex += x<0 ? 1 : aCol[x].szEst;
125309 if( x>=0 && (pTab->aCol[x].colFlags & COLFLAG_VIRTUAL)==0 ){
125356 if( (pTab->aCol[i].colFlags & COLFLAG_PRIMKEY)!=0
125357 && (pTab->aCol[i].notNull==OE_None)
125359 pTab->aCol[i].notNull = OE_Abort;
125380 sqlite3TokenInit(&ipkToken, pTab->aCol[pTab->iPKey].zCnName);
125479 && (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ) nExtra++;
125484 && (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0
125677 Column *pCol = &p->aCol[ii];
125744 u32 colFlags = p->aCol[ii].colFlags;
125746 Expr *pX = sqlite3ColumnExpr(p, &p->aCol[ii]);
125756 sqlite3ColumnSetExpr(pParse, p, &p->aCol[ii],
125850 assert( p->aCol==0 );
125852 p->aCol = pSelTab->aCol;
125854 pSelTab->aCol = 0;
126161 &pTable->nCol, &pTable->aCol);
126172 assert( pTable->aCol==0 );
126174 pTable->aCol = pSelTab->aCol;
126177 pSelTab->aCol = 0;
126627 p->aCol[iCol].zCnName, pTo);
126652 z = (char*)&pFKey->aCol[nCol];
126663 pFKey->aCol[0].iFrom = p->nCol-1;
126668 if( sqlite3StrICmp(p->aCol[j].zCnName, pFromCol->a[i].zEName)==0 ){
126669 pFKey->aCol[i].iFrom = j;
126680 sqlite3RenameTokenRemap(pParse, &pFKey->aCol[i], pFromCol->a[i].zEName);
126687 pFKey->aCol[i].zCol = z;
127121 Column *pCol = &pTab->aCol[pTab->nCol-1];
127226 if( pTab->aCol[j].notNull==0 ){
127229 if( pTab->aCol[j].colFlags & COLFLAG_VIRTUAL ){
127248 zColl = sqlite3ColumnColl(&pTab->aCol[j]);
128466 zCol = pTab->aCol[pIdx->aiColumn[j]].zCnName;
128493 pTab->aCol[pTab->iPKey].zCnName);
129582 zName = pTab->aCol[pPk->aiColumn[0]].zCnName;
129590 p = sqlite3Expr(db, TK_ID, pTab->aCol[pPk->aiColumn[i]].zCnName);
133520 char *zKey = pFKey->aCol[0].zCol; /* Name of left-most parent key column */
133545 if( !sqlite3StrICmp(pParent->aCol[pParent->iPKey].zCnName, zKey) ){
133569 for(i=0; i<nCol; i++) aiCol[i] = pFKey->aCol[i].iFrom;
133589 zDfltColl = sqlite3ColumnColl(&pParent->aCol[iCol]);
133593 zIdxCol = pParent->aCol[iCol].zCnName;
133595 if( sqlite3StrICmp(pFKey->aCol[j].zCol, zIdxCol)==0 ){
133596 if( aiCol ) aiCol[i] = pFKey->aCol[j].iFrom;
133812 pCol = &pTab->aCol[iCol];
133919 iCol = aiCol ? aiCol[i] : pFKey->aCol[0].iFrom;
133921 zCol = pFKey->pFrom->aCol[iCol].zCnName;
133956 pRight = sqlite3Expr(db, TK_ID, pTab->aCol[iCol].zCnName);
134133 int iChildKey = p->aCol[i].iFrom;
134160 char *zKey = p->aCol[i].zCol;
134164 Column *pCol = &pTab->aCol[iKey];
134281 iFromCol = pFKey->aCol[i].iFrom;
134294 iCol = pFKey->aCol[0].iFrom;
134308 char *zCol = pTo->aCol[pIdx ? pIdx->aiColumn[i] : pTo->iPKey].zCnName;
134429 for(i=0; i<p->nCol; i++) mask |= COLUMN_MASK(p->aCol[i].iFrom);
134583 iFromCol = aiCol ? aiCol[i] : pFKey->aCol[0].iFrom;
134588 pTab->aCol[pIdx ? pIdx->aiColumn[i] : pTab->iPKey].zCnName);
134589 sqlite3TokenInit(&tFromCol, pFKey->pFrom->aCol[iFromCol].zCnName);
134627 Column *pCol = pFKey->pFrom->aCol + iFromCol;
134909 aff = pTab->aCol[x].affinity;
134942 if( (pTab->aCol[i].colFlags & COLFLAG_VIRTUAL)==0 ){
134943 zColAff[j++] = pTab->aCol[i].affinity;
135083 pWalker->eCode |= pWalker->u.pTab->aCol[pExpr->iColumn].colFlags;
135126 if( pTab->aCol[ii].colFlags & COLFLAG_VIRTUAL ){
135129 if( pTab->aCol[ii].colFlags & COLFLAG_STORED ){
135147 if( pTab->aCol[i].colFlags & COLFLAG_GENERATED ){
135148 testcase( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL );
135149 testcase( pTab->aCol[i].colFlags & COLFLAG_STORED );
135150 pTab->aCol[i].colFlags |= COLFLAG_NOTAVAIL;
135169 Column *pCol = pTab->aCol + i;
135900 if( pTab->aCol[j].colFlags & (COLFLAG_STORED|COLFLAG_VIRTUAL) ){
135903 pTab->aCol[j].zCnName);
136040 if( pTab->aCol[i].colFlags & COLFLAG_GENERATED ){
136041 testcase( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL );
136042 testcase( pTab->aCol[i].colFlags & COLFLAG_STORED );
136057 if( pTab->aCol[i].colFlags & COLFLAG_NOINSERT ) nHidden++;
136186 if( ((colFlags = pTab->aCol[i].colFlags) & COLFLAG_NOINSERT)!=0 ){
136207 sqlite3ColumnExpr(pTab, &pTab->aCol[i]),
136219 sqlite3ColumnExpr(pTab, &pTab->aCol[i]),
136227 sqlite3ColumnExpr(pTab, &pTab->aCol[i]),
136779 Column *pCol = &pTab->aCol[i]; /* The column to check for NOT NULL */
137255 VdbeComment((v, "%s", pTab->aCol[iField].zCnName));
137350 pTab->aCol[pPk->aiColumn[i]].zCnName));
137551 if( pTab->aCol[i].iDflt!=0 ) break;
137552 if( pTab->aCol[i].colFlags & COLFLAG_PRIMKEY ) break;
137928 Column *pDestCol = &pDest->aCol[i];
137929 Column *pSrcCol = &pSrc->aCol[i];
141874 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
142053 cnum<0 ? 0 : pTab->aCol[cnum].zCnName);
142176 pTab->aCol[pFK->aCol[j].iFrom].zCnName,
142177 pFK->aCol[j].zCol,
142268 int iCol = aiCols ? aiCols[j] : pFK->aCol[j].iFrom;
142520 if( (pTab->aCol[j].colFlags & COLFLAG_VIRTUAL)==0 ) mxCol++;
142566 Column *pCol = pTab->aCol + j; /* The column to be checked */
142654 pTab->zName, pTab->aCol[j].zCnName);
142663 pTab->zName, pTab->aCol[j].zCnName);
142679 pTab->zName, pTab->aCol[j].zCnName);
142778 if( iCol>=0 && pTab->aCol[iCol].notNull ) continue;
145162 const Column *aCol;
145166 aCol = pTab->aCol;
145172 if( aCol[i].hName==h
145173 && sqlite3StrICmp(aCol[i].zCnName, zCol)==0
145181 if( aCol[i].hName==h
145182 && sqlite3StrICmp(aCol[i].zCnName, zCol)==0
145239 && (bIgnoreHidden==0 || IsHiddenColumn(&pSrc->a[i].pSTab->aCol[iCol])==0)
145387 if( IsHiddenColumn(&pRightTab->aCol[j]) ) continue;
145388 zName = pRightTab->aCol[j].zCnName;
145925 && (pTab->aCol[pExpr->iColumn].colFlags & COLFLAG_SORTERREF)!=0
146867 zOrigCol = pTab->aCol[iCol].zCnName;
146868 zType = sqlite3ColumnType(&pTab->aCol[iCol],0);
146880 zType = sqlite3ColumnType(&pTab->aCol[iCol],0);
147035 zCol = pTab->aCol[iCol].zCnName;
147084 Column *aCol, *pCol; /* For looping over result columns */
147094 aCol = sqlite3DbMallocZero(db, sizeof(aCol[0])*nCol);
147095 testcase( aCol==0 );
147099 aCol = 0;
147103 *paCol = aCol;
147105 for(i=0, pCol=aCol; i<nCol && !pParse->nErr; i++, pCol++){
147126 zName = iCol>=0 ? pTab->aCol[iCol].zCnName : "rowid";
147173 sqlite3DbFree(db, aCol[j].zCnName);
147175 sqlite3DbFree(db, aCol);
147217 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
147306 sqlite3ColumnsFromExprList(pParse, pSelect->pEList, &pTab->nCol, &pTab->aCol);
150762 sqlite3ColumnsFromExprList(pParse, pEList, &pTab->nCol, &pTab->aCol);
150824 sqlite3ColumnsFromExprList(pParse, pSel->pEList,&pTab->nCol,&pTab->aCol);
151148 zName = pTab->aCol[j].zCnName;
151168 && IsHiddenColumn(&pTab->aCol[j])
151172 if( (pTab->aCol[j].colFlags & COLFLAG_NOEXPAND)!=0
151234 || (j<pTab->nCol && (pTab->aCol[j].colFlags & COLFLAG_NOEXPAND))
151410 struct AggInfo_col *pCol = &pAggInfo->aCol[ii];
151418 sqlite3TreeViewExpr(0, pAggInfo->aCol[ii].pCExpr, 0);
151494 k = pAggInfo->aCol[j].iSorterColumn;
151533 pCol = &pAggInfo->aCol[pExpr->iAgg];
151879 for(i=0, pC=pAggInfo->aCol; i<pAggInfo->nAccumulator; i++, pC++){
152033 sqlite3DbFree(db, p->aCol);
153258 if( pAggInfo->aCol[i].iSorterColumn>=j ){
153268 struct AggInfo_col *pCol = &pAggInfo->aCol[i];
153637 Expr *pExpr = pAggInfo->aCol[i].pCExpr;
154801 if( IsHiddenColumn(pTab->aCol+jj) ) continue;
154802 pNewExpr = sqlite3Expr(db, TK_ID, pTab->aCol[jj].zCnName);
154806 pItem->zEName = sqlite3DbStrDup(db, pTab->aCol[jj].zCnName);
155500 pCol = &pTab->aCol[i];
155914 }else if( pPk && (pTab->aCol[j].colFlags & COLFLAG_PRIMKEY)!=0 ){
155918 else if( pTab->aCol[j].colFlags & COLFLAG_GENERATED ){
155919 testcase( pTab->aCol[j].colFlags & COLFLAG_VIRTUAL );
155920 testcase( pTab->aCol[j].colFlags & COLFLAG_STORED );
155923 pTab->aCol[j].zCnName);
155944 j<0 ? "ROWID" : pTab->aCol[j].zCnName,
155975 if( (pTab->aCol[i].colFlags & COLFLAG_GENERATED)==0 ) continue;
155977 sqlite3ColumnExpr(pTab, &pTab->aCol[i]),
156340 u32 colFlags = pTab->aCol[i].colFlags;
156379 }else if( (pTab->aCol[i].colFlags & COLFLAG_GENERATED)!=0 ){
156380 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ) k--;
156447 if( pTab->aCol[i].colFlags & COLFLAG_GENERATED ){
156448 if( pTab->aCol[i].colFlags & COLFLAG_VIRTUAL ) k--;
156715 assert( (pTab->aCol[i].colFlags & COLFLAG_GENERATED)==0 );
157104 pTab->aCol[pPk->aiColumn[i]].zCnName));
157120 if( pTab->aCol[i].affinity==SQLITE_AFF_REAL ){
158207 char *zType = sqlite3ColumnType(&pTab->aCol[iCol], "");
158229 pTab->aCol[iCol].colFlags |= COLFLAG_HIDDEN;
158422 if( !pTab->aCol ){
158425 pTab->aCol = pNew->aCol;
158431 pNew->aCol = 0;
159633 return pIdx->pTable->aCol[i].zCnName;
159783 const char *zRowid = pTab->iPKey>=0 ? pTab->aCol[pTab->iPKey].zCnName:
159901 sqlite3_str_appendf(&str, "%s=?", pTab->aCol[pTab->iPKey].zCnName);
161533 if( (j>=0 && pIdx->pTable->aCol[j].notNull==0) || j==XN_EXPR ){
164438 while( k<pTab->nCol && (pTab->aCol[k].colFlags & COLFLAG_HIDDEN)==0 ){k++;}
164977 pScan->idxaff = pIdx->pTable->aCol[iColumn].affinity;
165087 return pIdx->pTable->aCol[j].notNull;
165389 aff = pSrc->pSTab->aCol[leftCol].affinity;
165430 zName = pTab->aCol[iCol].zCnName;
165526 pTable->aCol[iCol].zCnName);
165560 if( (pTable->aCol[i].colFlags & COLFLAG_PRIMKEY)==0 ) continue;
165971 zColl = sqlite3ColumnColl(&pTab->aCol[pE2->iColumn]);
168305 aff = pIdx->pTable->aCol[pLeft->iColumn].affinity;
169707 && pIndex->pTable->aCol[iColumn].notNull==0
170986 }else if( j>=0 && (pTab->aCol[j].colFlags & COLFLAG_VIRTUAL)!=0 ){
170987 pExpr = sqlite3ColumnExpr(pTab, &pTab->aCol[j]);
186644 pCol = &pTab->aCol[iCol];
186648 pCol = iCol>=0 ? &pTab->aCol[iCol] : 0;
190269 const char **aCol; /* Array of column names */
190295 aCol = (const char **)sqlite3_malloc64(nByte);
190296 if( aCol ){
190297 memset((void*)aCol, 0, nByte);
190303 if( !aCol || !azNotindexed ){
190427 aCol[nCol++] = z;
190444 sqlite3_free((void*)aCol);
190445 aCol = 0;
190446 rc = fts3ContentColumns(db, argv[1], zContent,&aCol,&nCol,&nString,pzErr);
190453 if( sqlite3_stricmp(zLanguageid, aCol[j])==0 ){
190455 for(k=j; k<nCol; k++) aCol[k] = aCol[k+1];
190467 aCol[0] = "content";
190538 z = (char *)sqlite3Fts3NextToken(aCol[iCol], &n);
190613 sqlite3_free((void *)aCol);
236302 static int sqlite3Fts5StorageDocsize(Fts5Storage *p, i64 iRowid, int *aCol);
258981 int *aCol, int nCol, /* Array to populate */
258988 iOff += fts5GetVarint32(&aBlob[iOff], aCol[i]);
259001 static int sqlite3Fts5StorageDocsize(Fts5Storage *p, i64 iRowid, int *aCol){
259015 if( 0==fts5StorageDecodeSizeArray(aCol, nCol, aBlob, nBlob) ){
262585 int aCol[STMT_NUM_INTEGER_COLUMN+1]; /* all other column values */
262729 sqlite3_result_int(ctx, pRow->aCol[i]);
262786 pNew->aCol[STMT_COLUMN_NCOL] = sqlite3_column_count(p);
262787 pNew->aCol[STMT_COLUMN_RO] = sqlite3_stmt_readonly(p);
262788 pNew->aCol[STMT_COLUMN_BUSY] = sqlite3_stmt_busy(p);
262789 pNew->aCol[STMT_COLUMN_NSCAN] = sqlite3_stmt_status(
262792 pNew->aCol[STMT_COLUMN_NSORT] = sqlite3_stmt_status(
262795 pNew->aCol[STMT_COLUMN_NAIDX] = sqlite3_stmt_status(
262798 pNew->aCol[STMT_COLUMN_NSTEP] = sqlite3_stmt_status(
262801 pNew->aCol[STMT_COLUMN_REPREP] = sqlite3_stmt_status(
262804 pNew->aCol[STMT_COLUMN_RUN] = sqlite3_stmt_status(
262807 pNew->aCol[STMT_COLUMN_MEM] = sqlite3_stmt_status(