Lines Matching refs:i
97 int i, j; in sqliteJoinType() local
101 for(i=0; i<3 && apAll[i]; i++){ in sqliteJoinType()
102 p = apAll[i]; in sqliteJoinType()
140 int i; in columnIndex() local
141 for(i=0; i<pTab->nCol; i++){ in columnIndex()
142 if( sqliteStrICmp(pTab->aCol[i].zName, zCol)==0 ) return i; in columnIndex()
211 int i, j; in sqliteProcessJoin() local
213 for(i=0; i<pSrc->nSrc-1; i++){ in sqliteProcessJoin()
214 struct SrcList_item *pTerm = &pSrc->a[i]; in sqliteProcessJoin()
215 struct SrcList_item *pOther = &pSrc->a[i+1]; in sqliteProcessJoin()
268 assert( i<pSrc->nSrc-1 ); in sqliteProcessJoin()
316 int i; in pushOntoSorter() local
319 for(i=0; i<pOrderBy->nExpr; i++){ in pushOntoSorter()
320 int order = pOrderBy->a[i].sortOrder; in pushOntoSorter()
328 type = sqliteExprType(pOrderBy->a[i].pExpr); in pushOntoSorter()
337 zSortOrder[i] = c; in pushOntoSorter()
338 sqliteExprCode(pParse, pOrderBy->a[i].pExpr); in pushOntoSorter()
358 int i; in sqliteAddKeyType() local
360 for(i=0; i<nColumn; i++){ in sqliteAddKeyType()
361 zType[i] = sqliteExprType(pEList->a[i].pExpr)==SQLITE_SO_NUM ? 'n' : 't'; in sqliteAddKeyType()
363 zType[i] = 0; in sqliteAddKeyType()
414 int i; in selectInnerLoop() local
431 for(i=0; i<nColumn; i++){ in selectInnerLoop()
432 sqliteVdbeAddOp(v, OP_Column, srcTab, i); in selectInnerLoop()
436 for(i=0; i<pEList->nExpr; i++){ in selectInnerLoop()
437 sqliteExprCode(pParse, pEList->a[i].pExpr); in selectInnerLoop()
624 int i; in generateSortTail() local
625 for(i=0; i<nColumn; i++){ in generateSortTail()
626 sqliteVdbeAddOp(v, OP_Column, -1-i, i); in generateSortTail()
665 int i, j; in generateColumnTypes() local
666 for(i=0; i<pEList->nExpr; i++){ in generateColumnTypes()
667 Expr *p = pEList->a[i].pExpr; in generateColumnTypes()
690 sqliteVdbeOp3(v, OP_ColumnName, i + pEList->nExpr, 0, zType, 0); in generateColumnTypes()
705 int i, j; in generateColumnNames() local
714 for(i=0; i<pEList->nExpr; i++){ in generateColumnNames()
716 int p2 = i==pEList->nExpr-1; in generateColumnNames()
717 p = pEList->a[i].pExpr; in generateColumnNames()
719 if( pEList->a[i].zName ){ in generateColumnNames()
720 char *zName = pEList->a[i].zName; in generateColumnNames()
721 sqliteVdbeOp3(v, OP_ColumnName, i, p2, zName, 0); in generateColumnNames()
739 int addr = sqliteVdbeOp3(v,OP_ColumnName, i, p2, p->span.z, p->span.n); in generateColumnNames()
748 sqliteVdbeOp3(v, OP_ColumnName, i, p2, zName, P3_DYNAMIC); in generateColumnNames()
750 sqliteVdbeOp3(v, OP_ColumnName, i, p2, zCol, 0); in generateColumnNames()
753 int addr = sqliteVdbeOp3(v,OP_ColumnName, i, p2, p->span.z, p->span.n); in generateColumnNames()
758 sprintf(zName, "column%d", i+1); in generateColumnNames()
759 sqliteVdbeOp3(v, OP_ColumnName, i, p2, zName, 0); in generateColumnNames()
789 int i, j; in sqliteResultSetOfSelect() local
805 for(i=0; i<pTab->nCol; i++){ in sqliteResultSetOfSelect()
807 if( pEList->a[i].zName ){ in sqliteResultSetOfSelect()
808 aCol[i].zName = sqliteStrDup(pEList->a[i].zName); in sqliteResultSetOfSelect()
809 }else if( (p=pEList->a[i].pExpr)->op==TK_DOT in sqliteResultSetOfSelect()
812 sqliteSetNString(&aCol[i].zName, pR->token.z, pR->token.n, 0); in sqliteResultSetOfSelect()
813 for(j=cnt=0; j<i; j++){ in sqliteResultSetOfSelect()
814 if( sqliteStrICmp(aCol[j].zName, aCol[i].zName)==0 ){ in sqliteResultSetOfSelect()
819 sqliteSetNString(&aCol[i].zName, pR->token.z, pR->token.n, zBuf, n,0); in sqliteResultSetOfSelect()
824 sqliteSetNString(&pTab->aCol[i].zName, p->span.z, p->span.n, 0); in sqliteResultSetOfSelect()
827 sprintf(zBuf, "column%d", i+1); in sqliteResultSetOfSelect()
828 aCol[i].zName = sqliteStrDup(zBuf); in sqliteResultSetOfSelect()
830 sqliteDequote(aCol[i].zName); in sqliteResultSetOfSelect()
859 int i, j, k, rc; in fillInColumnList() local
870 for(i=0; i<pTabList->nSrc; i++){ in fillInColumnList()
871 if( pTabList->a[i].pTab ){ in fillInColumnList()
875 if( pTabList->a[i].zName==0 ){ in fillInColumnList()
877 assert( pTabList->a[i].pSelect!=0 ); in fillInColumnList()
878 if( pTabList->a[i].zAlias==0 ){ in fillInColumnList()
881 (void*)pTabList->a[i].pSelect); in fillInColumnList()
882 sqliteSetString(&pTabList->a[i].zAlias, zFakeName, 0); in fillInColumnList()
884 pTabList->a[i].pTab = pTab = in fillInColumnList()
885 sqliteResultSetOfSelect(pParse, pTabList->a[i].zAlias, in fillInColumnList()
886 pTabList->a[i].pSelect); in fillInColumnList()
897 pTabList->a[i].pTab = pTab = in fillInColumnList()
898 sqliteLocateTable(pParse,pTabList->a[i].zName,pTabList->a[i].zDatabase); in fillInColumnList()
912 if( pTabList->a[i].pSelect==0 ){ in fillInColumnList()
913 pTabList->a[i].pSelect = sqliteSelectDup(pTab->pSelect); in fillInColumnList()
968 for(i=0; i<pTabList->nSrc; i++){ in fillInColumnList()
969 Table *pTab = pTabList->a[i].pTab; in fillInColumnList()
970 char *zTabName = pTabList->a[i].zAlias; in fillInColumnList()
983 if( i>0 && (pTabList->a[i-1].jointype & JT_NATURAL)!=0 && in fillInColumnList()
984 columnIndex(pTabList->a[i-1].pTab, zName)>=0 ){ in fillInColumnList()
989 if( i>0 && sqliteIdListIndex(pTabList->a[i-1].pUsing, zName)>=0 ){ in fillInColumnList()
1050 int i; in sqliteSelectUnbind() local
1054 for(i=0; i<pSrc->nSrc; i++){ in sqliteSelectUnbind()
1055 if( (pTab = pSrc->a[i].pTab)!=0 ){ in sqliteSelectUnbind()
1059 pSrc->a[i].pTab = 0; in sqliteSelectUnbind()
1060 if( pSrc->a[i].pSelect ){ in sqliteSelectUnbind()
1061 sqliteSelectUnbind(pSrc->a[i].pSelect); in sqliteSelectUnbind()
1095 int i, j; in matchOrderbyToColumn() local
1100 for(i=0; i<pOrderBy->nExpr; i++){ pOrderBy->a[i].done = 0; } in matchOrderbyToColumn()
1111 for(i=0; i<pOrderBy->nExpr; i++){ in matchOrderbyToColumn()
1112 Expr *pE = pOrderBy->a[i].pExpr; in matchOrderbyToColumn()
1114 if( pOrderBy->a[i].done ) continue; in matchOrderbyToColumn()
1146 pOrderBy->a[i].done = 1; in matchOrderbyToColumn()
1150 "ORDER BY term number %d does not match any result column", i+1); in matchOrderbyToColumn()
1198 int i; in multiSelectSortOrder() local
1202 for(i=0; i<pOrderBy->nExpr; i++){ in multiSelectSortOrder()
1203 pOrderBy->a[i].pExpr->dataType = SQLITE_SO_TEXT; in multiSelectSortOrder()
1209 for(i=0; i<pOrderBy->nExpr; i++){ in multiSelectSortOrder()
1210 Expr *pE = pOrderBy->a[i].pExpr; in multiSelectSortOrder()
1559 int i; in substExprList() local
1561 for(i=0; i<pList->nExpr; i++){ in substExprList()
1562 substExpr(pList->a[i].pExpr, iTable, pEList); in substExprList()
1647 int i; in flattenSubquery() local
1727 for(i=1; i<nSubSrc; i++){ in flattenSubquery()
1731 for(i=pSrc->nSrc-1; i-extra>=iFrom; i--){ in flattenSubquery()
1732 pSrc->a[i] = pSrc->a[i-extra]; in flattenSubquery()
1735 for(i=0; i<nSubSrc; i++){ in flattenSubquery()
1736 pSrc->a[i+iFrom] = pSubSrc->a[i]; in flattenSubquery()
1737 memset(&pSubSrc->a[i], 0, sizeof(pSubSrc->a[i])); in flattenSubquery()
1756 for(i=0; i<pList->nExpr; i++){ in flattenSubquery()
1758 if( pList->a[i].zName==0 && (pExpr = pList->a[i].pExpr)->span.z!=0 ){ in flattenSubquery()
1759 pList->a[i].zName = sqliteStrNDup(pExpr->span.z, pExpr->span.n); in flattenSubquery()
2018 int i; in sqliteSelect() local
2097 for(i=0; i<pEList->nExpr; i++){ in sqliteSelect()
2098 if( sqliteExprResolveIds(pParse, pTabList, 0, pEList->a[i].pExpr) ){ in sqliteSelect()
2101 if( sqliteExprCheck(pParse, pEList->a[i].pExpr, 1, &isAgg) ){ in sqliteSelect()
2126 for(i=0; i<pOrderBy->nExpr; i++){ in sqliteSelect()
2128 Expr *pE = pOrderBy->a[i].pExpr; in sqliteSelect()
2131 pE = pOrderBy->a[i].pExpr = sqliteExprDup(pEList->a[iCol-1].pExpr); in sqliteSelect()
2154 for(i=0; i<pGroupBy->nExpr; i++){ in sqliteSelect()
2156 Expr *pE = pGroupBy->a[i].pExpr; in sqliteSelect()
2159 pE = pGroupBy->a[i].pExpr = sqliteExprDup(pEList->a[iCol-1].pExpr); in sqliteSelect()
2196 for(i=0; i<pTabList->nSrc; i++){ in sqliteSelect()
2200 if( pTabList->a[i].pSelect==0 ) continue; in sqliteSelect()
2201 if( pTabList->a[i].zName!=0 ){ in sqliteSelect()
2203 pParse->zAuthContext = pTabList->a[i].zName; in sqliteSelect()
2208 sqliteSelect(pParse, pTabList->a[i].pSelect, SRT_TempTable, in sqliteSelect()
2209 pTabList->a[i].iCursor, p, i, &isAgg); in sqliteSelect()
2269 for(i=0; i<pEList->nExpr; i++){ in sqliteSelect()
2270 if( sqliteExprAnalyzeAggregates(pParse, pEList->a[i].pExpr) ){ in sqliteSelect()
2275 for(i=0; i<pGroupBy->nExpr; i++){ in sqliteSelect()
2276 if( sqliteExprAnalyzeAggregates(pParse, pGroupBy->a[i].pExpr) ){ in sqliteSelect()
2285 for(i=0; i<pOrderBy->nExpr; i++){ in sqliteSelect()
2286 if( sqliteExprAnalyzeAggregates(pParse, pOrderBy->a[i].pExpr) ){ in sqliteSelect()
2297 for(i=0; i<pParse->nAgg; i++){ in sqliteSelect()
2299 if( (pFunc = pParse->aAgg[i].pFunc)!=0 && pFunc->xFinalize!=0 ){ in sqliteSelect()
2300 sqliteVdbeOp3(v, OP_AggInit, 0, i, (char*)pFunc, P3_POINTER); in sqliteSelect()
2348 for(i=0; i<pGroupBy->nExpr; i++){ in sqliteSelect()
2349 sqliteExprCode(pParse, pGroupBy->a[i].pExpr); in sqliteSelect()
2355 for(i=0, pAgg=pParse->aAgg; i<pParse->nAgg; i++, pAgg++){ in sqliteSelect()
2358 sqliteVdbeAddOp(v, OP_AggSet, 0, i); in sqliteSelect()
2362 for(i=0, pAgg=pParse->aAgg; i<pParse->nAgg; i++, pAgg++){ in sqliteSelect()
2374 sqliteVdbeAddOp(v, OP_Integer, i, 0); in sqliteSelect()
