Lines Matching refs:pCol
32117 SQLITE_PRIVATE char *sqlite3ColumnType(Column *pCol, char *zDflt){
32118 if( pCol->colFlags & COLFLAG_HASTYPE ){
32119 return pCol->zCnName + strlen(pCol->zCnName) + 1;
32120 }else if( pCol->eCType ){
32121 assert( pCol->eCType<=SQLITE_N_STDTYPE );
32122 return (char*)sqlite3StdType[pCol->eCType-1];
99844 Column *pCol; /* A column of pTab */
99925 for(j=0, pCol=pTab->aCol; j<pTab->nCol; j++, pCol++){
99926 if( pCol->hName==hCol
99927 && sqlite3StrICmp(pCol->zCnName, zCol)==0
100005 for(iCol=0, pCol=pTab->aCol; iCol<pTab->nCol; iCol++, pCol++){
100006 if( pCol->hName==hCol
100007 && sqlite3StrICmp(pCol->zCnName, zCol)==0
105332 Column *pCol, /* The generated column */
105344 sqlite3ExprCodeCopy(pParse, sqlite3ColumnExpr(pTab,pCol), regOut);
105345 if( pCol->affinity>=SQLITE_AFF_TEXT ){
105346 sqlite3VdbeAddOp4(v, OP_Affinity, regOut, 1, 0, &pCol->affinity, 1);
105362 Column *pCol;
105377 }else if( (pCol = &pTab->aCol[iCol])->colFlags & COLFLAG_VIRTUAL ){
105379 if( pCol->colFlags & COLFLAG_BUSY ){
105381 pCol->zCnName);
105384 pCol->colFlags |= COLFLAG_BUSY;
105386 sqlite3ExprCodeGeneratedColumn(pParse, pTab, pCol, regOut);
105388 pCol->colFlags &= ~COLFLAG_BUSY;
105641 struct AggInfo_col *pCol;
105644 pCol = &pAggInfo->aCol[pExpr->iAgg];
105646 assert( pCol->iMem>0 );
105647 return pCol->iMem;
105649 Table *pTab = pCol->pTab;
105651 pCol->iSorterColumn, target);
105652 if( pCol->iColumn<0 ){
105656 pTab->zName, pTab->aCol[pCol->iColumn].zCnName));
105657 if( pTab->aCol[pCol->iColumn].affinity==SQLITE_AFF_REAL ){
105701 Column *pCol;
105713 pCol = pTab->aCol + iCol;
105717 if( pCol->colFlags & COLFLAG_GENERATED ){
105718 if( pCol->colFlags & COLFLAG_BUSY ){
105720 pCol->zCnName);
105723 pCol->colFlags |= COLFLAG_BUSY;
105724 if( pCol->colFlags & COLFLAG_NOTAVAIL ){
105725 sqlite3ExprCodeGeneratedColumn(pParse, pTab, pCol, iSrc);
105727 pCol->colFlags &= ~(COLFLAG_BUSY|COLFLAG_NOTAVAIL);
105731 if( pCol->affinity==SQLITE_AFF_REAL ){
107755 struct AggInfo_col *pCol;
107765 pCol = pAggInfo->aCol;
107766 for(k=0; k<pAggInfo->nColumn; k++, pCol++){
107767 if( pCol->iTable==pExpr->iTable &&
107768 pCol->iColumn==pExpr->iColumn ){
107775 pCol = &pAggInfo->aCol[k];
107777 pCol->pTab = pExpr->y.pTab;
107778 pCol->iTable = pExpr->iTable;
107779 pCol->iColumn = pExpr->iColumn;
107780 pCol->iMem = ++pParse->nMem;
107781 pCol->iSorterColumn = -1;
107782 pCol->pCExpr = pExpr;
107792 pCol->iSorterColumn = j;
107797 if( pCol->iSorterColumn<0 ){
107798 pCol->iSorterColumn = pAggInfo->nSortingColumn++;
108312 Column *pCol; /* The new column */
108327 pCol = &pNew->aCol[pNew->nCol-1];
108328 pDflt = sqlite3ColumnExpr(pNew, pCol);
108344 if( pCol->colFlags & COLFLAG_PRIMKEY ){
108353 if( (pCol->colFlags & COLFLAG_GENERATED)==0 ){
108367 if( pCol->notNull && !pDflt ){
108391 }else if( pCol->colFlags & COLFLAG_STORED ){
108438 || (pCol->notNull && (pCol->colFlags & COLFLAG_GENERATED)!=0)
108527 Column *pCol = &pNew->aCol[i];
108528 pCol->zCnName = sqlite3DbStrDup(db, pCol->zCnName);
108529 pCol->hName = sqlite3StrIHash(pCol->zCnName);
110025 RenameToken *pCol;
110045 pCol = renameTokenFind(&sParse, 0, (void*)pTab->aCol[iCol].zCnName);
110053 while( ALWAYS(pCol->t.z[0]!=0) && pCol->t.z[0]!=',' ) pCol->t.z--;
110056 zNew = sqlite3MPrintf(db, "%.*s%s", pCol->t.z-zSql, zSql, zEnd);
113738 Column *pCol, /* The column to receive the new DEFAULT expression */
113744 if( pCol->iDflt==0
113746 || NEVER(pList->nExpr<pCol->iDflt)
113748 pCol->iDflt = pList==0 ? 1 : pList->nExpr+1;
113751 sqlite3ExprDelete(pParse->db, pList->a[pCol->iDflt-1].pExpr);
113752 pList->a[pCol->iDflt-1].pExpr = pExpr;
113761 SQLITE_PRIVATE Expr *sqlite3ColumnExpr(Table *pTab, Column *pCol){
113762 if( pCol->iDflt==0 ) return 0;
113765 if( NEVER(pTab->u.tab.pDfltList->nExpr<pCol->iDflt) ) return 0;
113766 return pTab->u.tab.pDfltList->a[pCol->iDflt-1].pExpr;
113774 Column *pCol,
113781 n = sqlite3Strlen30(pCol->zCnName) + 1;
113782 if( pCol->colFlags & COLFLAG_HASTYPE ){
113783 n += sqlite3Strlen30(pCol->zCnName+n) + 1;
113786 zNew = sqlite3DbRealloc(db, pCol->zCnName, nColl+n);
113788 pCol->zCnName = zNew;
113789 memcpy(pCol->zCnName + n, zColl, nColl);
113790 pCol->colFlags |= COLFLAG_HASCOLL;
113797 SQLITE_PRIVATE const char *sqlite3ColumnColl(Column *pCol){
113799 if( (pCol->colFlags & COLFLAG_HASCOLL)==0 ) return 0;
113800 z = pCol->zCnName;
113802 if( pCol->colFlags & COLFLAG_HASTYPE ){
113814 Column *pCol;
113816 if( (pCol = pTable->aCol)!=0 ){
113817 for(i=0; i<pTable->nCol; i++, pCol++){
113818 assert( pCol->zCnName==0 || pCol->hName==sqlite3StrIHash(pCol->zCnName) );
113819 sqlite3DbFree(db, pCol->zCnName);
114436 SQLITE_PRIVATE void sqlite3ColumnPropertiesFromName(Table *pTab, Column *pCol){
114437 if( sqlite3_strnicmp(pCol->zCnName, "__hidden__", 10)==0 ){
114438 pCol->colFlags |= COLFLAG_HIDDEN;
114440 }else if( pTab && pCol!=pTab->aCol && (pCol[-1].colFlags & COLFLAG_HIDDEN) ){
114533 Column *pCol;
114603 pCol = &p->aCol[p->nCol];
114604 memset(pCol, 0, sizeof(p->aCol[0]));
114605 pCol->zCnName = z;
114606 pCol->hName = hName;
114607 sqlite3ColumnPropertiesFromName(p, pCol);
114612 pCol->affinity = affinity;
114613 pCol->eCType = eType;
114614 pCol->szEst = szEst;
114618 pCol->colFlags |= COLFLAG_SORTERREF;
114627 pCol->affinity = sqlite3AffinityType(zType, pCol);
114628 pCol->colFlags |= COLFLAG_HASTYPE;
114643 Column *pCol;
114646 pCol = &p->aCol[p->nCol-1];
114647 pCol->notNull = (u8)onError;
114652 if( pCol->colFlags & COLFLAG_UNIQUE ){
114688 SQLITE_PRIVATE char sqlite3AffinityType(const char *zIn, Column *pCol){
114727 if( pCol ){
114745 pCol->colFlags |= COLFLAG_SORTERREF;
114750 pCol->szEst = v;
114772 Column *pCol;
114777 pCol = &(p->aCol[p->nCol-1]);
114780 pCol->zCnName);
114782 }else if( pCol->colFlags & COLFLAG_GENERATED ){
114783 testcase( pCol->colFlags & COLFLAG_VIRTUAL );
114784 testcase( pCol->colFlags & COLFLAG_STORED );
114799 sqlite3ColumnSetExpr(pParse, p, pCol, pDfltExpr);
114835 static void makeColumnPartOfPrimaryKey(Parse *pParse, Column *pCol){
114836 pCol->colFlags |= COLFLAG_PRIMKEY;
114838 if( pCol->colFlags & COLFLAG_GENERATED ){
114839 testcase( pCol->colFlags & COLFLAG_VIRTUAL );
114840 testcase( pCol->colFlags & COLFLAG_STORED );
114873 Column *pCol = 0;
114885 pCol = &pTab->aCol[iCol];
114886 makeColumnPartOfPrimaryKey(pParse, pCol);
114900 pCol = &pTab->aCol[iCol];
114901 makeColumnPartOfPrimaryKey(pParse, pCol);
114909 && pCol
114910 && pCol->eCType==COLTYPE_INTEGER
115013 Column *pCol;
115018 pCol = &(pTab->aCol[pTab->nCol-1]);
115023 if( pCol->iDflt>0 ) goto generated_error;
115034 pCol->colFlags |= eType;
115038 if( pCol->colFlags & COLFLAG_PRIMKEY ){
115039 makeColumnPartOfPrimaryKey(pParse, pCol); /* For the error message */
115041 sqlite3ColumnSetExpr(pParse, pTab, pCol, pExpr);
115047 pCol->zCnName);
115146 Column *pCol;
115148 for(pCol = p->aCol, i=0; i<p->nCol; i++, pCol++){
115149 n += identLength(pCol->zCnName) + 5;
115171 for(pCol=p->aCol, i=0; i<p->nCol; i++, pCol++){
115185 identPut(zStmt, &k, pCol->zCnName);
115186 assert( pCol->affinity-SQLITE_AFF_BLOB >= 0 );
115187 assert( pCol->affinity-SQLITE_AFF_BLOB < ArraySize(azType) );
115188 testcase( pCol->affinity==SQLITE_AFF_BLOB );
115189 testcase( pCol->affinity==SQLITE_AFF_TEXT );
115190 testcase( pCol->affinity==SQLITE_AFF_NUMERIC );
115191 testcase( pCol->affinity==SQLITE_AFF_INTEGER );
115192 testcase( pCol->affinity==SQLITE_AFF_REAL );
115194 zType = azType[pCol->affinity - SQLITE_AFF_BLOB];
115196 assert( pCol->affinity==SQLITE_AFF_BLOB
115197 || pCol->affinity==sqlite3AffinityType(zType, 0) );
115700 Column *pCol = &p->aCol[ii];
115701 if( pCol->eCType==COLTYPE_CUSTOM ){
115702 if( pCol->colFlags & COLFLAG_HASTYPE ){
115705 p->zName, pCol->zCnName, sqlite3ColumnType(pCol, "")
115709 p->zName, pCol->zCnName);
115712 }else if( pCol->eCType==COLTYPE_ANY ){
115713 pCol->affinity = SQLITE_AFF_BLOB;
115715 if( (pCol->colFlags & COLFLAG_PRIMKEY)!=0
115717 && pCol->notNull == OE_None
115719 pCol->notNull = OE_Abort;
117117 Column *pCol = &pTab->aCol[pTab->nCol-1];
117118 pCol->colFlags |= COLFLAG_UNIQUE;
117119 sqlite3TokenInit(&prevCol, pCol->zCnName);
123022 Column *pCol;
123029 pCol = &pTab->aCol[iCol];
123031 pExpr->affExpr = pCol->affinity;
123032 zColl = sqlite3ColumnColl(pCol);
123385 Column *pCol = &pTab->aCol[iKey];
123387 if( 0==sqlite3StrICmp(pCol->zCnName, zKey) ) return 1;
123388 }else if( pCol->colFlags & COLFLAG_PRIMKEY ){
123840 Column *pCol = pFKey->pFrom->aCol + iFromCol;
123842 if( pCol->colFlags & COLFLAG_GENERATED ){
123843 testcase( pCol->colFlags & COLFLAG_VIRTUAL );
123844 testcase( pCol->colFlags & COLFLAG_STORED );
123847 pDflt = sqlite3ColumnExpr(pFKey->pFrom, pCol);
124359 Column *pCol = pTab->aCol + i;
124360 if( (pCol->colFlags & COLFLAG_NOTAVAIL)!=0 ){
124362 pCol->colFlags |= COLFLAG_BUSY;
124364 sqlite3WalkExpr(&w, sqlite3ColumnExpr(pTab, pCol));
124365 pCol->colFlags &= ~COLFLAG_BUSY;
124367 pRedo = pCol;
124371 assert( pCol->colFlags & COLFLAG_GENERATED );
124373 sqlite3ExprCodeGeneratedColumn(pParse, pTab, pCol, x);
124374 pCol->colFlags &= ~COLFLAG_NOTAVAIL;
125723 Column *pCol = &pTab->aCol[i]; /* The column to check for NOT NULL */
125725 onError = pCol->notNull;
125730 isGenerated = pCol->colFlags & COLFLAG_GENERATED;
125746 || pCol->iDflt==0 /* REPLACE is ABORT if no DEFAULT value */
125748 testcase( pCol->colFlags & COLFLAG_VIRTUAL );
125749 testcase( pCol->colFlags & COLFLAG_STORED );
125750 testcase( pCol->colFlags & COLFLAG_GENERATED );
125766 assert( (pCol->colFlags & COLFLAG_GENERATED)==0 );
125769 sqlite3ColumnExpr(pTab, pCol), iReg);
125779 pCol->zCnName);
130675 Column *pCol;
130679 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
130682 if( pCol->colFlags & COLFLAG_NOINSERT ){
130687 if( pCol->colFlags & COLFLAG_VIRTUAL ){
130689 }else if( pCol->colFlags & COLFLAG_STORED ){
130691 }else{ assert( pCol->colFlags & COLFLAG_HIDDEN );
130695 if( (pCol->colFlags & COLFLAG_PRIMKEY)==0 ){
130702 pColExpr = sqlite3ColumnExpr(pTab,pCol);
130708 pCol->zCnName,
130709 sqlite3ColumnType(pCol,""),
130710 pCol->notNull ? 1 : 0,
131284 Column *pCol = pTab->aCol + j;
131287 if( pCol->notNull==0 && !bStrict ) continue;
131293 if( pCol->notNull ){
131296 pCol->zCnName);
131298 if( bStrict && pCol->eCType!=COLTYPE_ANY ){
131306 && pCol->eCType!=COLTYPE_ANY
131309 sqlite3StdTypeMap[pCol->eCType-1]);
131312 sqlite3StdType[pCol->eCType-1],
133528 Column *pCol;
133529 for(pCol=pTab->aCol, i=0; i<pTab->nCol; pCol++, i++){
133530 if( pCol->hName==h && sqlite3StrICmp(pCol->zCnName, zCol)==0 ) return i;
135334 Column *aCol, *pCol; /* For looping over result columns */
135355 for(i=0, pCol=aCol; i<nCol && !db->mallocFailed; i++, pCol++){
135401 pCol->zCnName = zName;
135402 pCol->hName = sqlite3StrIHash(zName);
135403 sqlite3ColumnPropertiesFromName(0, pCol);
135404 if( zName && sqlite3HashInsert(&ht, zName, pCol)==pCol ){
135440 Column *pCol;
135453 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
135456 pTab->tabFlags |= (pCol->colFlags & COLFLAG_NOINSERT);
135460 pCol->affinity = sqlite3ExprAffinity(p);
135463 n = sqlite3Strlen30(pCol->zCnName);
135464 pCol->zCnName = sqlite3DbReallocOrFree(db, pCol->zCnName, n+m+2);
135465 if( pCol->zCnName ){
135466 memcpy(&pCol->zCnName[n+1], zType, m+1);
135467 pCol->colFlags |= COLFLAG_HASTYPE;
135469 testcase( pCol->colFlags & COLFLAG_HASTYPE );
135470 pCol->colFlags &= ~(COLFLAG_HASTYPE|COLFLAG_HASCOLL);
135473 if( pCol->affinity<=SQLITE_AFF_NONE ) pCol->affinity = aff;
135477 sqlite3ColumnSetColl(db, pCol, pColl->zName);
140441 struct AggInfo_col *pCol = &pAggInfo->aCol[i];
140442 if( pCol->iSorterColumn>=j ){
140445 pCol->pTab, pCol->iTable, pCol->iColumn, r1);
141941 Expr *pCol = pNew->a[i].pExpr;
141942 assert( pCol!=0 ); /* Due to !db->mallocFailed ~9 lines above */
141943 sqlite3ExprCodeFactorable(pParse, pCol, reg+i);
142475 Column *pCol = &pTab->aCol[i];
142476 VdbeComment((v, "%s.%s", pTab->zName, pCol->zCnName));
142479 sqlite3ColumnExpr(pTab,pCol), enc,
142480 pCol->affinity, &pValue);
149347 Expr *pCol; /* Column reference */
149363 pCol = pList->a[1].pExpr;
149364 assert( pCol->op!=TK_COLUMN || ExprUseYTab(pCol) );
149365 testcase( pCol->op==TK_COLUMN && pCol->y.pTab==0 );
149366 if( ExprIsVtab(pCol) ){
149372 *ppLeft = pCol;
149388 pCol = pList->a[0].pExpr;
149389 assert( pCol->op!=TK_COLUMN || ExprUseYTab(pCol) );
149390 testcase( pCol->op==TK_COLUMN && pCol->y.pTab==0 );
149391 if( ExprIsVtab(pCol) ){
149396 pVtab = sqlite3GetVTable(db, pCol->y.pTab)->pVtab;
149406 *ppLeft = pCol;
170340 Column *pCol = 0;
170375 pCol = &pTab->aCol[iCol];
170376 if( 0==sqlite3StrICmp(pCol->zCnName, zColumnName) ){
170383 pCol = iCol>=0 ? &pTab->aCol[iCol] : 0;
170401 if( pCol ){
170402 zDataType = sqlite3ColumnType(pCol,0);
170403 zCollSeq = sqlite3ColumnColl(pCol);
170404 notnull = pCol->notNull!=0;
170405 primarykey = (pCol->colFlags & COLFLAG_PRIMKEY)!=0;