Lines Matching refs:aCol
9375 ** Table.nCol is the number of columns in this table. Table.aCol is a
9399 int iPKey; /* If not negative, use aCol[iPKey] as the primary key */
9401 Column *aCol; /* Information about each column */
9435 #define TF_NeedMetadata 0x20 /* aCol[].zType and aCol[].pColl missing */
9485 } aCol[1]; /* One entry for each of nCol column s */
9588 ** first column to be indexed (c3) has an index of 2 in Ex1.aCol[].
9590 ** Ex1.aCol[], hence Ex2.aiColumn[1]==0.
9648 ** AggInfo.aCol[] or AggInfo.aFunc[] of information needed to generate
9670 } *aCol;
9671 int nColumn; /* Number of used entries in aCol[] */
9672 int nColumnAlloc; /* Number of slots allocated for aCol[] */
9797 i16 iAgg; /* Which entry in pAggInfo->aCol[] or ->aFunc[] */
9922 int idx; /* Index in some Table.aCol[] of a column named zName */
66699 if( sqlite3StrICmp(pTab->aCol[iCol].zName, zColumn)==0 ){
66728 if( pFKey->aCol[j].iFrom==iCol ){
67791 for(j=0, pCol=pTab->aCol; j<pTab->nCol; j++, pCol++){
67848 Column *pCol = &pTab->aCol[iCol];
68860 return pExpr->pTab->aCol[j].affinity;
68916 zColl = p->pTab->aCol[j].zColl;
70293 int affinity_ok = (pTab->aCol[iCol].affinity==aff||aff==SQLITE_AFF_NONE);
70314 if( prNotFound && !pTab->aCol[iCol].notNull ){
71092 struct AggInfo_col *pCol = &pAggInfo->aCol[pExpr->iAgg];
71530 (pExpr->iColumn<0 ? "rowid" : pExpr->pTab->aCol[pExpr->iColumn].zName),
71538 && pTab->aCol[pExpr->iColumn].affinity==SQLITE_AFF_REAL
72297 ** Add a new element to the pAggInfo->aCol[] array. Return the index of
72302 pInfo->aCol = sqlite3ArrayAllocate(
72304 pInfo->aCol,
72305 sizeof(pInfo->aCol[0]),
72360 ** Make an entry for the column in pAggInfo->aCol[] if there
72364 pCol = pAggInfo->aCol;
72374 pCol = &pAggInfo->aCol[k];
72399 /* There is now an entry for pExpr in pAggInfo->aCol[] (either
72402 ** pAggInfo->aCol[] entry.
73192 pCol = &pNew->aCol[pNew->nCol-1];
73343 pNew->aCol = (Column*)sqlite3DbMallocZero(db, sizeof(Column)*nAlloc);
73345 if( !pNew->aCol || !pNew->zName ){
73349 memcpy(pNew->aCol, pTab->aCol, sizeof(Column)*pNew->nCol);
73351 Column *pCol = &pNew->aCol[i];
74778 zCol = pTab->aCol[iCol].zName;
74781 zCol = pTab->aCol[pTab->iPKey].zName;
75311 ** Table.aCol[] array).
75317 if( (pCol = pTable->aCol)!=0 ){
75325 sqlite3DbFree(db, pTable->aCol);
75786 if( STRICMP(z, p->aCol[i].zName) ){
75794 aNew = sqlite3DbRealloc(db,p->aCol,(p->nCol+8)*sizeof(p->aCol[0]));
75799 p->aCol = aNew;
75801 pCol = &p->aCol[p->nCol];
75802 memset(pCol, 0, sizeof(p->aCol[0]));
75823 p->aCol[p->nCol-1].notNull = (u8)onError;
75902 pCol = &p->aCol[p->nCol-1];
75924 pCol = &(p->aCol[p->nCol-1]);
75980 pTab->aCol[iCol].isPrimKey = 1;
75984 if( sqlite3StrICmp(pList->a[i].zName, pTab->aCol[iCol].zName)==0 ){
75989 pTab->aCol[iCol].isPrimKey = 1;
75995 zType = pTab->aCol[iCol].zType;
76059 p->aCol[i].zColl = zColl;
76068 pIdx->azColl[0] = p->aCol[i].zColl;
76202 for(pCol = p->aCol, i=0; i<p->nCol; i++, pCol++){
76225 for(pCol=p->aCol, i=0; i<p->nCol; i++, pCol++){
76392 assert( p->aCol==0 );
76394 p->aCol = pSelTab->aCol;
76396 pSelTab->aCol = 0;
76634 assert( pTable->aCol==0 );
76636 pTable->aCol = pSelTab->aCol;
76638 pSelTab->aCol = 0;
76665 pTab->aCol = 0;
77007 p->aCol[iCol].zName, pTo);
77019 nByte = sizeof(*pFKey) + (nCol-1)*sizeof(pFKey->aCol[0]) + pTo->n + 1;
77031 z = (char*)&pFKey->aCol[nCol];
77039 pFKey->aCol[0].iFrom = p->nCol-1;
77044 if( sqlite3StrICmp(p->aCol[j].zName, pFromCol->a[i].zName)==0 ){
77045 pFKey->aCol[i].iFrom = j;
77060 pFKey->aCol[i].zCol = z;
77373 nullId.z = pTab->aCol[pTab->nCol-1].zName;
77450 for(j=0, pTabCol=pTab->aCol; j<pTab->nCol; j++, pTabCol++){
77475 zColl = pTab->aCol[j].zColl;
81427 char *zKey = pFKey->aCol[0].zCol; /* Name of left-most parent key column */
81452 if( !sqlite3StrICmp(pParent->aCol[pParent->iPKey].zName, zKey) ) return 0;
81474 for(i=0; i<nCol; i++) aiCol[i] = pFKey->aCol[i].iFrom;
81492 zDfltColl = pParent->aCol[iCol].zColl;
81498 zIdxCol = pParent->aCol[iCol].zName;
81500 if( sqlite3StrICmp(pFKey->aCol[j].zCol, zIdxCol)==0 ){
81501 if( aiCol ) aiCol[i] = pFKey->aCol[j].iFrom;
81739 pCol = &pTab->aCol[iCol];
81749 iCol = aiCol ? aiCol[i] : pFKey->aCol[0].iFrom;
81751 zCol = pFKey->pFrom->aCol[iCol].zName;
81971 iCol = pFKey->aCol[0].iFrom;
81984 char *zCol = pTo->aCol[pIdx ? pIdx->aiColumn[i] : pTo->iPKey].zName;
82076 for(i=0; i<p->nCol; i++) mask |= COLUMN_MASK(p->aCol[i].iFrom);
82124 int iChildKey = p->aCol[i].iFrom;
82133 char *zKey = p->aCol[i].zCol;
82136 Column *pCol = &pTab->aCol[iKey];
82216 iFromCol = aiCol ? aiCol[i] : pFKey->aCol[0].iFrom;
82218 tToCol.z = pIdx ? pTab->aCol[pIdx->aiColumn[i]].zName : "oid";
82219 tFromCol.z = pFKey->pFrom->aCol[iFromCol].zName;
82264 Expr *pDflt = pFKey->pFrom->aCol[iFromCol].pDflt;
82504 pIdx->zColAff[n] = pTab->aCol[pIdx->aiColumn[n]].affinity;
82547 zColAff[i] = pTab->aCol[i].affinity;
83113 nHidden += (IsHiddenColumn(&pTab->aCol[i]) ? 1 : 0);
83144 if( sqlite3StrICmp(pColumn->a[i].zName, pTab->aCol[j].zName)==0 ){
83278 sqlite3ExprCode(pParse, pTab->aCol[i].pDflt, regCols+i+1);
83369 if( IsHiddenColumn(&pTab->aCol[i]) ){
83382 sqlite3ExprCode(pParse, pTab->aCol[i].pDflt, iRegStore);
83601 onError = pTab->aCol[i].notNull;
83608 if( onError==OE_Replace && pTab->aCol[i].pDflt==0 ){
83622 pTab->zName, pTab->aCol[i].zName);
83633 sqlite3ExprCode(pParse, pTab->aCol[i].pDflt, regData+i);
83802 char *zCol = pTab->aCol[pIdx->aiColumn[j]].zName;
84139 if( pDest->aCol[i].affinity!=pSrc->aCol[i].affinity ){
84142 if( !xferCompatibleCollation(pDest->aCol[i].zColl, pSrc->aCol[i].zColl) ){
84145 if( pDest->aCol[i].notNull && !pSrc->aCol[i].notNull ){
86356 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
86395 sqlite3VdbeAddOp4(v, OP_String8, 0, 3, 0, pTab->aCol[cnum].zName, 0);
86487 char *zCol = pFK->aCol[j].zCol;
86494 pTab->aCol[pFK->aCol[j].iFrom].zName, 0);
88034 if( sqlite3StrICmp(pTab->aCol[i].zName, zCol)==0 ) return i;
88053 int *piCol /* Write index of pSrc->a[*piTab].pTab->aCol[] here */
88198 zName = pRightTab->aCol[j].zName;
88904 zType = pTab->aCol[iCol].zType;
88905 zOriginCol = pTab->aCol[iCol].zName;
89030 zCol = pTab->aCol[iCol].zName;
89072 Column *aCol, *pCol; /* For looping over result columns */
89079 aCol = *paCol = sqlite3DbMallocZero(db, sizeof(aCol[0])*nCol);
89080 if( aCol==0 ) return SQLITE_NOMEM;
89081 for(i=0, pCol=aCol; i<nCol; i++, pCol++){
89100 iCol>=0 ? pTab->aCol[iCol].zName : "rowid");
89119 if( sqlite3StrICmp(aCol[j].zName, zName)==0 ){
89133 sqlite3DbFree(db, aCol[j].zName);
89135 sqlite3DbFree(db, aCol);
89157 Column *aCol, /* List of columns */
89175 for(i=0, pCol=aCol; i<nCol; i++, pCol++){
89213 selectColumnsFromExprList(pParse, pSelect->pEList, &pTab->nCol, &pTab->aCol);
89214 selectAddColumnTypeAndCollation(pParse, pTab->nCol, pTab->aCol, pSelect);
91043 selectColumnsFromExprList(pParse, pSel->pEList, &pTab->nCol, &pTab->aCol);
91146 char *zName = pTab->aCol[j].zName;
91155 if( IsHiddenColumn(&pTab->aCol[j]) ){
91283 selectAddColumnTypeAndCollation(pParse, pTab->nCol, pTab->aCol, pSel);
91353 sqlite3VdbeAddOp2(v, OP_Null, 0, pAggInfo->aCol[i].iMem);
91455 for(i=0, pC=pAggInfo->aCol; i<pAggInfo->nAccumulator; i++, pC++){
91887 if( sAggInfo.aCol[i].iSorterColumn>=j ){
91898 struct AggInfo_col *pCol = &sAggInfo.aCol[i];
92176 sqlite3DbFree(db, sAggInfo.aCol);
93636 Column *pCol = &pTab->aCol[i];
93645 if( iReg>=0 && pTab->aCol[i].affinity==SQLITE_AFF_REAL ){
93771 if( sqlite3StrICmp(pTab->aCol[j].zName, pChanges->a[i].zName)==0 ){
93794 pTab->aCol[j].zName, db->aDb[iDb].zName);
94200 pExpr = sqlite3Expr(db, TK_ID, pTab->aCol[i].zName);
95076 char *zType = pTab->aCol[iCol].zType;
95101 pTab->aCol[iCol].isHidden = 1;
95250 if( !pTab->aCol ){
95251 pTab->aCol = pParse->pNewTable->aCol;
95254 pParse->pNewTable->aCol = 0;
96109 idxaff = pIdx->pTable->aCol[iColumn].affinity;
97193 aff = pSrc->pTab->aCol[pTerm->u.leftColumn].affinity;
97899 int nEq, /* index into p->aCol[] of the range-compared column */
97914 u8 aff = p->pTable->aCol[p->aiColumn[0]].affinity;
98703 Column *aCol = pTab->aCol;
98714 explainAppendTerm(&txt, i, aCol[aiColumn[i]].zName, "=");
98719 explainAppendTerm(&txt, i++, aCol[aiColumn[j]].zName, ">");
98722 explainAppendTerm(&txt, i, aCol[aiColumn[j]].zName, "<");
107078 pCol = &pTab->aCol[iCol];
107082 pCol = &pTab->aCol[iCol];
109089 const char **aCol; /* Array of column names */
109100 aCol = (const char **)sqlite3_malloc(sizeof(const char *) * (argc-2) );
109101 if( !aCol ) return SQLITE_NOMEM;
109102 memset((void *)aCol, 0, sizeof(const char *) * (argc-2));
109152 aCol[nCol++] = z;
109159 aCol[0] = "content";
109207 z = (char *)sqlite3Fts3NextToken(aCol[iCol], &n);
109234 sqlite3_free((void *)aCol);
