lib/sqlite/sqlite3.c

71964         Column *pCol;
71990         for(j=0, pCol=pTab->aCol; j<pTab->nCol; j++, pCol++){
71991           if( sqlite3StrICmp(pCol->zName, zCol)==0 ){
72047           Column *pCol = &pTab->aCol[iCol];
72048           if( sqlite3StrICmp(pCol->zName, zCol)==0 ){
75301       struct AggInfo_col *pCol = &pAggInfo->aCol[pExpr->iAgg];
75303         assert( pCol->iMem>0 );
75304         inReg = pCol->iMem;
75308                               pCol->iSorterColumn, target);
76569           struct AggInfo_col *pCol;
76579             pCol = pAggInfo->aCol;
76580             for(k=0; k<pAggInfo->nColumn; k++, pCol++){
76581               if( pCol->iTable==pExpr->iTable &&
76582                   pCol->iColumn==pExpr->iColumn ){
76589               pCol = &pAggInfo->aCol[k];
76590               pCol->pTab = pExpr->pTab;
76591               pCol->iTable = pExpr->iTable;
76592               pCol->iColumn = pExpr->iColumn;
76593               pCol->iMem = ++pParse->nMem;
76594               pCol->iSorterColumn = -1;
76595               pCol->pExpr = pExpr;
76605                     pCol->iSorterColumn = j;
76610               if( pCol->iSorterColumn<0 ){
76611                 pCol->iSorterColumn = pAggInfo->nSortingColumn++;
77407   Column *pCol;             /* The new column */
77420   pCol = &pNew->aCol[pNew->nCol-1];
77421   pDflt = pCol->pDflt;
77444   if( pCol->isPrimKey ){
77457   if( pCol->notNull && !pDflt ){
77582     Column *pCol = &pNew->aCol[i];
77583     pCol->zName = sqlite3DbStrDup(db, pCol->zName);
77584     pCol->zColl = 0;
77585     pCol->zType = 0;
77586     pCol->pDflt = 0;
77587     pCol->zDflt = 0;
79619   Column *pCol;
79621   if( (pCol = pTable->aCol)!=0 ){
79622     for(i=0; i<pTable->nCol; i++, pCol++){
79623       sqlite3DbFree(db, pCol->zName);
79624       sqlite3ExprDelete(db, pCol->pDflt);
79625       sqlite3DbFree(db, pCol->zDflt);
79626       sqlite3DbFree(db, pCol->zType);
79627       sqlite3DbFree(db, pCol->zColl);
80084   Column *pCol;
80111   pCol = &p->aCol[p->nCol];
80112   memset(pCol, 0, sizeof(p->aCol[0]));
80113   pCol->zName = z;
80117   ** be called next to set pCol->affinity correctly.
80119   pCol->affinity = SQLITE_AFF_NONE;
80208   Column *pCol;
80212   pCol = &p->aCol[p->nCol-1];
80213   assert( pCol->zType==0 );
80214   pCol->zType = sqlite3NameFromToken(pParse->db, pType);
80215   pCol->affinity = sqlite3AffinityType(pCol->zType);
80230   Column *pCol;
80234     pCol = &(p->aCol[p->nCol-1]);
80237           pCol->zName);
80243       sqlite3ExprDelete(db, pCol->pDflt);
80244       pCol->pDflt = sqlite3ExprDup(db, pSpan->pExpr, EXPRDUP_REDUCE);
80245       sqlite3DbFree(db, pCol->zDflt);
80246       pCol->zDflt = sqlite3DbStrNDup(db, (char*)pSpan->zStart,
80511   Column *pCol;
80513   for(pCol = p->aCol, i=0; i<p->nCol; i++, pCol++){
80514     n += identLength(pCol->zName) + 5;
80536   for(pCol=p->aCol, i=0; i<p->nCol; i++, pCol++){
80550     identPut(zStmt, &k, pCol->zName);
80551     assert( pCol->affinity-SQLITE_AFF_TEXT >= 0 );
80552     assert( pCol->affinity-SQLITE_AFF_TEXT < ArraySize(azType) );
80553     testcase( pCol->affinity==SQLITE_AFF_TEXT );
80554     testcase( pCol->affinity==SQLITE_AFF_NONE );
80555     testcase( pCol->affinity==SQLITE_AFF_NUMERIC );
80556     testcase( pCol->affinity==SQLITE_AFF_INTEGER );
80557     testcase( pCol->affinity==SQLITE_AFF_REAL );
80559     zType = azType[pCol->affinity - SQLITE_AFF_TEXT];
80561     assert( pCol->affinity==SQLITE_AFF_NONE
80562             || pCol->affinity==sqlite3AffinityType(zType) );
86173         Column *pCol;
86175         pCol = &pTab->aCol[iCol];
86178         pLeft->affinity = pCol->affinity;
86179         pLeft->pColl = sqlite3LocateCollSeq(pParse, pCol->zColl);
86587             Column *pCol = &pTab->aCol[iKey];
86588             if( (zKey ? !sqlite3StrICmp(pCol->zName, zKey) : pCol->isPrimKey) ){
90831       Column *pCol;
90841       for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
90842         if( IsHiddenColumn(pCol) ){
90847         sqlite3VdbeAddOp4(v, OP_String8, 0, 2, 0, pCol->zName, 0);
90849            pCol->zType ? pCol->zType : "", 0);
90850         sqlite3VdbeAddOp2(v, OP_Integer, (pCol->notNull ? 1 : 0), 4);
90851         if( pCol->zDflt ){
90852           sqlite3VdbeAddOp4(v, OP_String8, 0, 5, 0, (char*)pCol->zDflt, 0);
90856         sqlite3VdbeAddOp2(v, OP_Integer, pCol->isPrimKey, 6);
93599   Column *aCol, *pCol;        /* For looping over result columns */
93608   for(i=0, pCol=aCol; i<nCol; i++, pCol++){
93656     pCol->zName = zName;
93689   Column *pCol;
93702   for(i=0, pCol=aCol; i<nCol; i++, pCol++){
93704     pCol->zType = sqlite3DbStrDup(db, columnType(&sNC, p, 0, 0, 0));
93705     pCol->affinity = sqlite3ExprAffinity(p);
93706     if( pCol->affinity==0 ) pCol->affinity = SQLITE_AFF_NONE;
93709       pCol->zColl = sqlite3DbStrDup(db, pColl->zName);
96546           struct AggInfo_col *pCol = &sAggInfo.aCol[i];
96547           if( pCol->iSorterColumn>=j ){
96552                                pCol->pTab, pCol->iColumn, pCol->iTable, r1);
98325     Column *pCol = &pTab->aCol[i];
98326     VdbeComment((v, "%s.%s", pTab->zName, pCol->zName));
98328     sqlite3ValueFromExpr(sqlite3VdbeDb(v), pCol->pDflt, enc,
98329                          pCol->affinity, &pValue);
112684   Column *pCol = 0;
112712       pCol = &pTab->aCol[iCol];
112716       pCol = &pTab->aCol[iCol];
112717       if( 0==sqlite3StrICmp(pCol->zName, zColumnName) ){
112735   **        explicitly declared column. Copy meta information from *pCol.
112737   if( pCol ){
112738     zDataType = pCol->zType;
112739     zCollSeq = pCol->zColl;
112740     notnull = pCol->notNull!=0;
112741     primarykey  = pCol->isPrimKey!=0;