Lines Matching refs:pCol
35013 SQLITE_PRIVATE char *sqlite3ColumnType(Column *pCol, char *zDflt){ in sqlite3ColumnType() argument
35014 if( pCol->colFlags & COLFLAG_HASTYPE ){ in sqlite3ColumnType()
35015 return pCol->zCnName + strlen(pCol->zCnName) + 1; in sqlite3ColumnType()
35016 }else if( pCol->eCType ){ in sqlite3ColumnType()
35017 assert( pCol->eCType<=SQLITE_N_STDTYPE ); in sqlite3ColumnType()
35018 return (char*)sqlite3StdType[pCol->eCType-1]; in sqlite3ColumnType()
107021 Column *pCol; /* A column of pTab */
107157 for(j=0, pCol=pTab->aCol; j<pTab->nCol; j++, pCol++){
107158 if( pCol->hName==hCol
107159 && sqlite3StrICmp(pCol->zCnName, zCol)==0
107285 for(iCol=0, pCol=pTab->aCol; iCol<pTab->nCol; iCol++, pCol++){
107286 if( pCol->hName==hCol
107287 && sqlite3StrICmp(pCol->zCnName, zCol)==0
113142 Column *pCol, /* The generated column */
113155 sqlite3ExprCodeCopy(pParse, sqlite3ColumnExpr(pTab,pCol), regOut);
113156 if( pCol->affinity>=SQLITE_AFF_TEXT ){
113157 sqlite3VdbeAddOp4(v, OP_Affinity, regOut, 1, 0, &pCol->affinity, 1);
113174 Column *pCol;
113188 }else if( (pCol = &pTab->aCol[iCol])->colFlags & COLFLAG_VIRTUAL ){
113190 if( pCol->colFlags & COLFLAG_BUSY ){
113192 pCol->zCnName);
113195 pCol->colFlags |= COLFLAG_BUSY;
113197 sqlite3ExprCodeGeneratedColumn(pParse, pTab, pCol, regOut);
113199 pCol->colFlags &= ~COLFLAG_BUSY;
113567 struct AggInfo_col *pCol;
113582 pCol = &pAggInfo->aCol[pExpr->iAgg];
113586 Table *pTab = pCol->pTab;
113588 pCol->iSorterColumn, target);
113591 }else if( pCol->iColumn<0 ){
113595 pTab->zName, pTab->aCol[pCol->iColumn].zCnName));
113596 if( pTab->aCol[pCol->iColumn].affinity==SQLITE_AFF_REAL ){
113642 Column *pCol;
113654 pCol = pTab->aCol + iCol;
113658 if( pCol->colFlags & COLFLAG_GENERATED ){
113659 if( pCol->colFlags & COLFLAG_BUSY ){
113661 pCol->zCnName);
113664 pCol->colFlags |= COLFLAG_BUSY;
113665 if( pCol->colFlags & COLFLAG_NOTAVAIL ){
113666 sqlite3ExprCodeGeneratedColumn(pParse, pTab, pCol, iSrc);
113668 pCol->colFlags &= ~(COLFLAG_BUSY|COLFLAG_NOTAVAIL);
113672 if( pCol->affinity==SQLITE_AFF_REAL ){
115769 struct AggInfo_col *pCol;
115773 pCol = pAggInfo->aCol;
115774 for(k=0; k<pAggInfo->nColumn; k++, pCol++){
115775 if( pCol->pCExpr==pExpr ) return;
115776 if( pCol->iTable==pExpr->iTable
115777 && pCol->iColumn==pExpr->iColumn
115789 pCol = &pAggInfo->aCol[k];
115791 pCol->pTab = pExpr->y.pTab;
115792 pCol->iTable = pExpr->iTable;
115793 pCol->iColumn = pExpr->iColumn;
115794 pCol->iSorterColumn = -1;
115795 pCol->pCExpr = pExpr;
115807 pCol->iSorterColumn = j;
115812 if( pCol->iSorterColumn<0 ){
115813 pCol->iSorterColumn = pAggInfo->nSortingColumn++;
116462 Column *pCol; /* The new column */
116479 pCol = &pNew->aCol[pNew->nCol-1];
116480 pDflt = sqlite3ColumnExpr(pNew, pCol);
116496 if( pCol->colFlags & COLFLAG_PRIMKEY ){
116505 if( (pCol->colFlags & COLFLAG_GENERATED)==0 ){
116519 if( pCol->notNull && !pDflt ){
116543 }else if( pCol->colFlags & COLFLAG_STORED ){
116590 || (pCol->notNull && (pCol->colFlags & COLFLAG_GENERATED)!=0)
116684 Column *pCol = &pNew->aCol[i];
116685 pCol->zCnName = sqlite3DbStrDup(db, pCol->zCnName);
116686 pCol->hName = sqlite3StrIHash(pCol->zCnName);
118243 RenameToken *pCol;
118263 pCol = renameTokenFind(&sParse, 0, (void*)pTab->aCol[iCol].zCnName);
118271 while( ALWAYS(pCol->t.z[0]!=0) && pCol->t.z[0]!=',' ) pCol->t.z--;
118274 zNew = sqlite3MPrintf(db, "%.*s%s", pCol->t.z-zSql, zSql, zEnd);
122065 Column *pCol, /* The column to receive the new DEFAULT expression */
122071 if( pCol->iDflt==0
122073 || NEVER(pList->nExpr<pCol->iDflt)
122075 pCol->iDflt = pList==0 ? 1 : pList->nExpr+1;
122078 sqlite3ExprDelete(pParse->db, pList->a[pCol->iDflt-1].pExpr);
122079 pList->a[pCol->iDflt-1].pExpr = pExpr;
122088 SQLITE_PRIVATE Expr *sqlite3ColumnExpr(Table *pTab, Column *pCol){
122089 if( pCol->iDflt==0 ) return 0;
122092 if( NEVER(pTab->u.tab.pDfltList->nExpr<pCol->iDflt) ) return 0;
122093 return pTab->u.tab.pDfltList->a[pCol->iDflt-1].pExpr;
122101 Column *pCol,
122108 n = sqlite3Strlen30(pCol->zCnName) + 1;
122109 if( pCol->colFlags & COLFLAG_HASTYPE ){
122110 n += sqlite3Strlen30(pCol->zCnName+n) + 1;
122113 zNew = sqlite3DbRealloc(db, pCol->zCnName, nColl+n);
122115 pCol->zCnName = zNew;
122116 memcpy(pCol->zCnName + n, zColl, nColl);
122117 pCol->colFlags |= COLFLAG_HASCOLL;
122124 SQLITE_PRIVATE const char *sqlite3ColumnColl(Column *pCol){
122126 if( (pCol->colFlags & COLFLAG_HASCOLL)==0 ) return 0;
122127 z = pCol->zCnName;
122129 if( pCol->colFlags & COLFLAG_HASTYPE ){
122141 Column *pCol;
122144 if( (pCol = pTable->aCol)!=0 ){
122145 for(i=0; i<pTable->nCol; i++, pCol++){
122146 assert( pCol->zCnName==0 || pCol->hName==sqlite3StrIHash(pCol->zCnName) );
122147 sqlite3DbFree(db, pCol->zCnName);
122770 SQLITE_PRIVATE void sqlite3ColumnPropertiesFromName(Table *pTab, Column *pCol){
122771 if( sqlite3_strnicmp(pCol->zCnName, "__hidden__", 10)==0 ){
122772 pCol->colFlags |= COLFLAG_HIDDEN;
122774 }else if( pTab && pCol!=pTab->aCol && (pCol[-1].colFlags & COLFLAG_HIDDEN) ){
122863 Column *pCol;
122933 pCol = &p->aCol[p->nCol];
122934 memset(pCol, 0, sizeof(p->aCol[0]));
122935 pCol->zCnName = z;
122936 pCol->hName = hName;
122937 sqlite3ColumnPropertiesFromName(p, pCol);
122942 pCol->affinity = affinity;
122943 pCol->eCType = eType;
122944 pCol->szEst = szEst;
122948 pCol->colFlags |= COLFLAG_SORTERREF;
122957 pCol->affinity = sqlite3AffinityType(zType, pCol);
122958 pCol->colFlags |= COLFLAG_HASTYPE;
122973 Column *pCol;
122976 pCol = &p->aCol[p->nCol-1];
122977 pCol->notNull = (u8)onError;
122982 if( pCol->colFlags & COLFLAG_UNIQUE ){
123018 SQLITE_PRIVATE char sqlite3AffinityType(const char *zIn, Column *pCol){
123058 if( pCol ){
123076 pCol->colFlags |= COLFLAG_SORTERREF;
123081 pCol->szEst = v;
123103 Column *pCol;
123108 pCol = &(p->aCol[p->nCol-1]);
123111 pCol->zCnName);
123113 }else if( pCol->colFlags & COLFLAG_GENERATED ){
123114 testcase( pCol->colFlags & COLFLAG_VIRTUAL );
123115 testcase( pCol->colFlags & COLFLAG_STORED );
123130 sqlite3ColumnSetExpr(pParse, p, pCol, pDfltExpr);
123166 static void makeColumnPartOfPrimaryKey(Parse *pParse, Column *pCol){
123167 pCol->colFlags |= COLFLAG_PRIMKEY;
123169 if( pCol->colFlags & COLFLAG_GENERATED ){
123170 testcase( pCol->colFlags & COLFLAG_VIRTUAL );
123171 testcase( pCol->colFlags & COLFLAG_STORED );
123204 Column *pCol = 0;
123216 pCol = &pTab->aCol[iCol];
123217 makeColumnPartOfPrimaryKey(pParse, pCol);
123231 pCol = &pTab->aCol[iCol];
123232 makeColumnPartOfPrimaryKey(pParse, pCol);
123240 && pCol
123241 && pCol->eCType==COLTYPE_INTEGER
123344 Column *pCol;
123349 pCol = &(pTab->aCol[pTab->nCol-1]);
123354 if( pCol->iDflt>0 ) goto generated_error;
123365 pCol->colFlags |= eType;
123369 if( pCol->colFlags & COLFLAG_PRIMKEY ){
123370 makeColumnPartOfPrimaryKey(pParse, pCol); /* For the error message */
123379 if( pExpr && pExpr->op!=TK_RAISE ) pExpr->affExpr = pCol->affinity;
123380 sqlite3ColumnSetExpr(pParse, pTab, pCol, pExpr);
123386 pCol->zCnName);
123485 Column *pCol;
123487 for(pCol = p->aCol, i=0; i<p->nCol; i++, pCol++){
123488 n += identLength(pCol->zCnName) + 5;
123510 for(pCol=p->aCol, i=0; i<p->nCol; i++, pCol++){
123525 identPut(zStmt, &k, pCol->zCnName);
123526 assert( pCol->affinity-SQLITE_AFF_BLOB >= 0 );
123527 assert( pCol->affinity-SQLITE_AFF_BLOB < ArraySize(azType) );
123528 testcase( pCol->affinity==SQLITE_AFF_BLOB );
123529 testcase( pCol->affinity==SQLITE_AFF_TEXT );
123530 testcase( pCol->affinity==SQLITE_AFF_NUMERIC );
123531 testcase( pCol->affinity==SQLITE_AFF_INTEGER );
123532 testcase( pCol->affinity==SQLITE_AFF_REAL );
123533 testcase( pCol->affinity==SQLITE_AFF_FLEXNUM );
123535 zType = azType[pCol->affinity - SQLITE_AFF_BLOB];
123537 assert( pCol->affinity==SQLITE_AFF_BLOB
123538 || pCol->affinity==SQLITE_AFF_FLEXNUM
123539 || pCol->affinity==sqlite3AffinityType(zType, 0) );
124045 Column *pCol = &p->aCol[ii];
124046 if( pCol->eCType==COLTYPE_CUSTOM ){
124047 if( pCol->colFlags & COLFLAG_HASTYPE ){
124050 p->zName, pCol->zCnName, sqlite3ColumnType(pCol, "")
124054 p->zName, pCol->zCnName);
124057 }else if( pCol->eCType==COLTYPE_ANY ){
124058 pCol->affinity = SQLITE_AFF_BLOB;
124060 if( (pCol->colFlags & COLFLAG_PRIMKEY)!=0
124062 && pCol->notNull == OE_None
124064 pCol->notNull = OE_Abort;
125486 Column *pCol = &pTab->aCol[pTab->nCol-1];
125487 pCol->colFlags |= COLFLAG_UNIQUE;
125488 sqlite3TokenInit(&prevCol, pCol->zCnName);
131886 Column *pCol;
131893 pCol = &pTab->aCol[iCol];
131895 pExpr->affExpr = pCol->affinity;
131896 zColl = sqlite3ColumnColl(pCol);
132245 Column *pCol = &pTab->aCol[iKey];
132247 if( 0==sqlite3StrICmp(pCol->zCnName, zKey) ) return 1;
132248 }else if( pCol->colFlags & COLFLAG_PRIMKEY ){
132708 Column *pCol = pFKey->pFrom->aCol + iFromCol;
132710 if( pCol->colFlags & COLFLAG_GENERATED ){
132711 testcase( pCol->colFlags & COLFLAG_VIRTUAL );
132712 testcase( pCol->colFlags & COLFLAG_STORED );
132715 pDflt = sqlite3ColumnExpr(pFKey->pFrom, pCol);
133248 Column *pCol = pTab->aCol + i;
133249 if( (pCol->colFlags & COLFLAG_NOTAVAIL)!=0 ){
133251 pCol->colFlags |= COLFLAG_BUSY;
133253 sqlite3WalkExpr(&w, sqlite3ColumnExpr(pTab, pCol));
133254 pCol->colFlags &= ~COLFLAG_BUSY;
133256 pRedo = pCol;
133260 assert( pCol->colFlags & COLFLAG_GENERATED );
133262 sqlite3ExprCodeGeneratedColumn(pParse, pTab, pCol, x);
133263 pCol->colFlags &= ~COLFLAG_NOTAVAIL;
134841 Column *pCol = &pTab->aCol[i]; /* The column to check for NOT NULL */
134843 onError = pCol->notNull;
134848 isGenerated = pCol->colFlags & COLFLAG_GENERATED;
134864 || pCol->iDflt==0 /* REPLACE is ABORT if no DEFAULT value */
134866 testcase( pCol->colFlags & COLFLAG_VIRTUAL );
134867 testcase( pCol->colFlags & COLFLAG_STORED );
134868 testcase( pCol->colFlags & COLFLAG_GENERATED );
134884 assert( (pCol->colFlags & COLFLAG_GENERATED)==0 );
134887 sqlite3ColumnExpr(pTab, pCol), iReg);
134897 pCol->zCnName);
139929 Column *pCol;
139933 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
139936 if( pCol->colFlags & COLFLAG_NOINSERT ){
139941 if( pCol->colFlags & COLFLAG_VIRTUAL ){
139943 }else if( pCol->colFlags & COLFLAG_STORED ){
139945 }else{ assert( pCol->colFlags & COLFLAG_HIDDEN );
139949 if( (pCol->colFlags & COLFLAG_PRIMKEY)==0 ){
139956 pColExpr = sqlite3ColumnExpr(pTab,pCol);
139962 pCol->zCnName,
139963 sqlite3ColumnType(pCol,""),
139964 pCol->notNull ? 1 : 0,
140623 Column *pCol = pTab->aCol + j; /* The column to be checked */
140631 doTypeCheck = pCol->eCType>COLTYPE_ANY;
140633 doTypeCheck = pCol->affinity>SQLITE_AFF_BLOB;
140635 if( pCol->notNull==0 && !doTypeCheck ) continue;
140639 if( pCol->colFlags & COLFLAG_VIRTUAL ){
140644 if( pCol->iDflt ){
140646 sqlite3ValueFromExpr(db, sqlite3ColumnExpr(pTab,pCol), ENC(db),
140647 pCol->affinity, &pDfltValue);
140665 if( pCol->notNull ){
140685 pCol->zCnName);
140706 assert( pCol->eCType>=1 && pCol->eCType<=sizeof(aStdTypeMask) );
140707 sqlite3VdbeChangeP5(v, aStdTypeMask[pCol->eCType-1]);
140710 sqlite3StdType[pCol->eCType-1],
140713 }else if( !bStrict && pCol->affinity==SQLITE_AFF_TEXT ){
140722 }else if( !bStrict && pCol->affinity>=SQLITE_AFF_NUMERIC ){
143214 Column *pCol;
143215 for(pCol=pTab->aCol, i=0; i<pTab->nCol; pCol++, i++){
143216 if( pCol->hName==h && sqlite3StrICmp(pCol->zCnName, zCol)==0 ) return i;
145093 Column *aCol, *pCol; /* For looping over result columns */
145114 for(i=0, pCol=aCol; i<nCol && !pParse->nErr; i++, pCol++){
145156 pCol->colFlags |= COLFLAG_NOEXPAND;
145169 pCol->zCnName = zName;
145170 pCol->hName = sqlite3StrIHash(zName);
145172 pCol->colFlags |= COLFLAG_NOEXPAND;
145174 sqlite3ColumnPropertiesFromName(0, pCol);
145210 Column *pCol;
145226 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){
145231 pTab->tabFlags |= (pCol->colFlags & COLFLAG_NOINSERT);
145234 pCol->affinity = sqlite3ExprAffinity(p);
145235 while( pCol->affinity<=SQLITE_AFF_NONE && pS2->pNext!=0 ){
145238 pCol->affinity = sqlite3ExprAffinity(pS2->pEList->a[i].pExpr);
145240 if( pCol->affinity<=SQLITE_AFF_NONE ){
145241 pCol->affinity = aff;
145243 if( pCol->affinity>=SQLITE_AFF_TEXT && (pS2->pNext || pS2!=pSelect) ){
145247 if( pCol->affinity==SQLITE_AFF_TEXT && (m&0x01)!=0 ){
145248 pCol->affinity = SQLITE_AFF_BLOB;
145250 if( pCol->affinity>=SQLITE_AFF_NUMERIC && (m&0x02)!=0 ){
145251 pCol->affinity = SQLITE_AFF_BLOB;
145253 if( pCol->affinity>=SQLITE_AFF_NUMERIC && p->op==TK_CAST ){
145254 pCol->affinity = SQLITE_AFF_FLEXNUM;
145258 if( zType==0 || pCol->affinity!=sqlite3AffinityType(zType, 0) ){
145259 if( pCol->affinity==SQLITE_AFF_NUMERIC
145260 || pCol->affinity==SQLITE_AFF_FLEXNUM
145266 if( sqlite3StdTypeAffinity[j]==pCol->affinity ){
145275 n = sqlite3Strlen30(pCol->zCnName);
145276 pCol->zCnName = sqlite3DbReallocOrFree(db, pCol->zCnName, n+k+2);
145277 pCol->colFlags &= ~(COLFLAG_HASTYPE|COLFLAG_HASCOLL);
145278 if( pCol->zCnName ){
145279 memcpy(&pCol->zCnName[n+1], zType, k+1);
145280 pCol->colFlags |= COLFLAG_HASTYPE;
145286 sqlite3ColumnSetColl(db, pCol, pColl->zName);
149378 struct AggInfo_col *pCol = &pAggInfo->aCol[ii];
149382 ii, pCol->pTab ? pCol->pTab->zName : "NULL",
149383 pCol->iTable, pCol->iColumn, pAggInfo->iFirstReg+ii,
149384 pCol->iSorterColumn,
149492 struct AggInfo_col *pCol;
149501 pCol = &pAggInfo->aCol[pExpr->iAgg];
149503 pExpr->iTable = pCol->iTable;
149504 pExpr->iColumn = pCol->iColumn;
151140 struct AggInfo_col *pCol = &pAggInfo->aCol[i];
151141 if( pCol->iSorterColumn>=j ){
151142 sqlite3ExprCode(pParse, pCol->pCExpr, j + regBase);
152799 Expr *pCol = pNew->a[i].pExpr;
152800 assert( pCol!=0 ); /* Due to !db->mallocFailed ~9 lines above */
152801 sqlite3ExprCodeFactorable(pParse, pCol, reg+i);
152802 if( sqlite3ExprAffinity(pCol)==SQLITE_AFF_REAL ){
153335 Column *pCol;
153338 pCol = &pTab->aCol[i];
153339 if( pCol->iDflt ){
153343 VdbeComment((v, "%s.%s", pTab->zName, pCol->zCnName));
153346 sqlite3ColumnExpr(pTab,pCol), enc,
153347 pCol->affinity, &pValue);
153353 if( pCol->affinity==SQLITE_AFF_REAL && !IsVirtual(pTab) ){
160610 Expr *pCol; /* Column reference */
160626 pCol = pList->a[1].pExpr;
160627 assert( pCol->op!=TK_COLUMN || (ExprUseYTab(pCol) && pCol->y.pTab!=0) );
160628 if( ExprIsVtab(pCol) ){
160634 *ppLeft = pCol;
160650 pCol = pList->a[0].pExpr;
160651 assert( pCol->op!=TK_COLUMN || ExprUseYTab(pCol) );
160652 assert( pCol->op!=TK_COLUMN || (ExprUseYTab(pCol) && pCol->y.pTab!=0) );
160653 if( ExprIsVtab(pCol) ){
160658 pVtab = sqlite3GetVTable(db, pCol->y.pTab)->pVtab;
160668 *ppLeft = pCol;
183696 Column *pCol = 0;
183731 pCol = &pTab->aCol[iCol];
183732 if( 0==sqlite3StrICmp(pCol->zCnName, zColumnName) ){
183739 pCol = iCol>=0 ? &pTab->aCol[iCol] : 0;
183757 if( pCol ){
183758 zDataType = sqlite3ColumnType(pCol,0);
183759 zCollSeq = sqlite3ColumnColl(pCol);
183760 notnull = pCol->notNull!=0;
183761 primarykey = (pCol->colFlags & COLFLAG_PRIMKEY)!=0;