Lines Matching refs:pTab
1167 Table *pTab; in sqlite3Pragma() local
1169 pTab = sqlite3LocateTable(pParse, LOCATE_NOERR, zRight, zDb); in sqlite3Pragma()
1170 if( pTab ){ in sqlite3Pragma()
1174 Index *pPk = sqlite3PrimaryKeyIndex(pTab); in sqlite3Pragma()
1176 sqlite3ViewGetColumnNames(pParse, pTab); in sqlite3Pragma()
1177 for(i=0, pCol=pTab->aCol; i<pTab->nCol; i++, pCol++){ in sqlite3Pragma()
1198 for(k=1; k<=pTab->nCol && pPk->aiColumn[k-1]!=i; k++){} in sqlite3Pragma()
1200 pColExpr = sqlite3ColumnExpr(pTab,pCol); in sqlite3Pragma()
1249 Table *pTab; in sqlite3Pragma() local
1251 pTab = sqliteHashData(k); in sqlite3Pragma()
1252 if( pTab->nCol==0 ){ in sqlite3Pragma()
1253 char *zSql = sqlite3MPrintf(db, "SELECT*FROM\"%w\"", pTab->zName); in sqlite3Pragma()
1271 Table *pTab = sqliteHashData(k); in sqlite3Pragma() local
1273 if( zRight && sqlite3_stricmp(zRight, pTab->zName)!=0 ) continue; in sqlite3Pragma()
1274 if( IsView(pTab) ){ in sqlite3Pragma()
1276 }else if( IsVirtual(pTab) ){ in sqlite3Pragma()
1278 }else if( pTab->tabFlags & TF_Shadow ){ in sqlite3Pragma()
1285 sqlite3PreferredTableName(pTab->zName), in sqlite3Pragma()
1287 pTab->nCol, in sqlite3Pragma()
1288 (pTab->tabFlags & TF_WithoutRowid)!=0, in sqlite3Pragma()
1289 (pTab->tabFlags & TF_Strict)!=0 in sqlite3Pragma()
1303 Table *pTab = sqliteHashData(i); in sqlite3Pragma() local
1305 sqlite3PreferredTableName(pTab->zName), in sqlite3Pragma()
1307 pTab->szTabRow, in sqlite3Pragma()
1308 pTab->nRowLogEst, in sqlite3Pragma()
1309 pTab->tabFlags); in sqlite3Pragma()
1310 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3Pragma()
1325 Table *pTab; in sqlite3Pragma() local
1331 pTab = sqlite3LocateTable(pParse, LOCATE_NOERR, zRight, zDb); in sqlite3Pragma()
1332 if( pTab && !HasRowid(pTab) ){ in sqlite3Pragma()
1333 pIdx = sqlite3PrimaryKeyIndex(pTab); in sqlite3Pragma()
1349 pTab = pIdx->pTable; in sqlite3Pragma()
1355 cnum<0 ? 0 : pTab->aCol[cnum].zCnName); in sqlite3Pragma()
1370 Table *pTab; in sqlite3Pragma() local
1372 pTab = sqlite3FindTable(db, zRight, zDb); in sqlite3Pragma()
1373 if( pTab ){ in sqlite3Pragma()
1374 int iTabDb = sqlite3SchemaToIndex(db, pTab->pSchema); in sqlite3Pragma()
1377 for(pIdx=pTab->pIndex, i=0; pIdx; pIdx=pIdx->pNext, i++){ in sqlite3Pragma()
1462 Table *pTab; in sqlite3Pragma() local
1463 pTab = sqlite3FindTable(db, zRight, zDb); in sqlite3Pragma()
1464 if( pTab && IsOrdinaryTable(pTab) ){ in sqlite3Pragma()
1465 pFK = pTab->u.tab.pFKey; in sqlite3Pragma()
1467 int iTabDb = sqlite3SchemaToIndex(db, pTab->pSchema); in sqlite3Pragma()
1478 pTab->aCol[pFK->aCol[j].iFrom].zCnName, in sqlite3Pragma()
1497 Table *pTab; /* Child table contain "REFERENCES" keyword */ in sqlite3Pragma() local
1516 pTab = sqlite3LocateTable(pParse, 0, zRight, zDb); in sqlite3Pragma()
1519 pTab = (Table*)sqliteHashData(k); in sqlite3Pragma()
1522 if( pTab==0 || !IsOrdinaryTable(pTab) || pTab->u.tab.pFKey==0 ) continue; in sqlite3Pragma()
1523 iDb = sqlite3SchemaToIndex(db, pTab->pSchema); in sqlite3Pragma()
1526 sqlite3TableLock(pParse, iDb, pTab->tnum, 0, pTab->zName); in sqlite3Pragma()
1527 if( pTab->nCol+regRow>pParse->nMem ) pParse->nMem = pTab->nCol + regRow; in sqlite3Pragma()
1528 sqlite3OpenTable(pParse, 0, iDb, pTab, OP_OpenRead); in sqlite3Pragma()
1529 sqlite3VdbeLoadString(v, regResult, pTab->zName); in sqlite3Pragma()
1530 assert( IsOrdinaryTable(pTab) ); in sqlite3Pragma()
1531 for(i=1, pFK=pTab->u.tab.pFKey; pFK; i++, pFK=pFK->pNextFrom){ in sqlite3Pragma()
1553 assert( IsOrdinaryTable(pTab) ); in sqlite3Pragma()
1554 for(i=1, pFK=pTab->u.tab.pFKey; pFK; i++, pFK=pFK->pNextFrom){ in sqlite3Pragma()
1571 sqlite3ExprCodeGetColumnOfTable(v, pTab, 0, iCol, regRow+j); in sqlite3Pragma()
1590 if( HasRowid(pTab) ){ in sqlite3Pragma()
1706 Table *pTab = sqliteHashData(x); /* Current table */ in sqlite3Pragma() local
1709 if( pObjTab && pObjTab!=pTab ) continue; in sqlite3Pragma()
1710 if( HasRowid(pTab) ) cnt++; in sqlite3Pragma()
1711 for(nIdx=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, nIdx++){ cnt++; } in sqlite3Pragma()
1721 Table *pTab = sqliteHashData(x); in sqlite3Pragma() local
1723 if( pObjTab && pObjTab!=pTab ) continue; in sqlite3Pragma()
1724 if( HasRowid(pTab) ) aRoot[++cnt] = pTab->tnum; in sqlite3Pragma()
1725 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3Pragma()
1749 Table *pTab = sqliteHashData(x); in sqlite3Pragma() local
1759 if( !IsOrdinaryTable(pTab) ) continue; in sqlite3Pragma()
1760 if( pObjTab && pObjTab!=pTab ) continue; in sqlite3Pragma()
1761 if( isQuick || HasRowid(pTab) ){ in sqlite3Pragma()
1765 pPk = sqlite3PrimaryKeyIndex(pTab); in sqlite3Pragma()
1769 sqlite3OpenTableAndIndices(pParse, pTab, OP_OpenRead, 0, in sqlite3Pragma()
1775 for(j=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, j++){ in sqlite3Pragma()
1788 mxCol = pTab->nCol-1; in sqlite3Pragma()
1790 && ((pTab->aCol[mxCol].colFlags & COLFLAG_VIRTUAL)!=0 in sqlite3Pragma()
1791 || pTab->iPKey==mxCol) ) mxCol--; in sqlite3Pragma()
1793 sqlite3ExprCodeGetColumnOfTable(v, pTab, iDataCur, mxCol, 3); in sqlite3Pragma()
1807 pTab->zName); in sqlite3Pragma()
1826 bStrict = (pTab->tabFlags & TF_Strict)!=0; in sqlite3Pragma()
1827 for(j=0; j<pTab->nCol; j++){ in sqlite3Pragma()
1829 Column *pCol = pTab->aCol + j; /* The column to be checked */ in sqlite3Pragma()
1835 if( j==pTab->iPKey ) continue; in sqlite3Pragma()
1846 sqlite3ExprCodeGetColumnOfTable(v, pTab, iDataCur, j, 3); in sqlite3Pragma()
1852 sqlite3ValueFromExpr(db, sqlite3ColumnExpr(pTab,pCol), ENC(db), in sqlite3Pragma()
1860 if( !HasRowid(pTab) ){ in sqlite3Pragma()
1861 testcase( j!=sqlite3TableColumnToStorage(pTab, j) ); in sqlite3Pragma()
1862 p3 = sqlite3TableColumnToIndex(sqlite3PrimaryKeyIndex(pTab), j); in sqlite3Pragma()
1864 p3 = sqlite3TableColumnToStorage(pTab,j); in sqlite3Pragma()
1876 zErr = sqlite3MPrintf(db, "NULL value in %s.%s", pTab->zName, in sqlite3Pragma()
1902 pTab->zName, pTab->aCol[j].zCnName); in sqlite3Pragma()
1911 pTab->zName, pTab->aCol[j].zCnName); in sqlite3Pragma()
1920 sqlite3ExprCodeGetColumnOfTable(v, pTab, iDataCur, j, 3); in sqlite3Pragma()
1927 pTab->zName, pTab->aCol[j].zCnName); in sqlite3Pragma()
1935 if( pTab->pCheck && (db->flags & SQLITE_IgnoreChecks)==0 ){ in sqlite3Pragma()
1936 ExprList *pCheck = sqlite3ExprListDup(db, pTab->pCheck, 0); in sqlite3Pragma()
1951 pTab->zName); in sqlite3Pragma()
1960 for(j=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, j++){ in sqlite3Pragma()
1988 assert( iCol!=XN_ROWID && iCol<pTab->nCol ); in sqlite3Pragma()
1989 if( iCol>=0 && pTab->aCol[iCol].notNull ) continue; in sqlite3Pragma()
2010 for(j=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, j++){ in sqlite3Pragma()
2332 Table *pTab; /* A table in the schema */ in sqlite3Pragma() local
2350 pTab = (Table*)sqliteHashData(k); in sqlite3Pragma()
2355 if( (pTab->tabFlags & TF_StatsUsed)==0 ) continue; in sqlite3Pragma()
2358 szThreshold = pTab->nRowLogEst + 46; assert( sqlite3LogEst(25)==46 ); in sqlite3Pragma()
2359 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in sqlite3Pragma()
2366 sqlite3OpenTable(pParse, iTabCur, iDb, pTab, OP_OpenRead); in sqlite3Pragma()
2372 db->aDb[iDb].zDbSName, pTab->zName); in sqlite3Pragma()
2567 PragmaVtab *pTab = 0; in pragmaVtabConnect() local
2600 pTab = (PragmaVtab*)sqlite3_malloc(sizeof(PragmaVtab)); in pragmaVtabConnect()
2601 if( pTab==0 ){ in pragmaVtabConnect()
2604 memset(pTab, 0, sizeof(PragmaVtab)); in pragmaVtabConnect()
2605 pTab->pName = pPragma; in pragmaVtabConnect()
2606 pTab->db = db; in pragmaVtabConnect()
2607 pTab->iHidden = i; in pragmaVtabConnect()
2608 pTab->nHidden = j; in pragmaVtabConnect()
2614 *ppVtab = (sqlite3_vtab*)pTab; in pragmaVtabConnect()
2622 PragmaVtab *pTab = (PragmaVtab*)pVtab; in pragmaVtabDisconnect() local
2623 sqlite3_free(pTab); in pragmaVtabDisconnect()
2635 PragmaVtab *pTab = (PragmaVtab*)tab; in pragmaVtabBestIndex() local
2641 if( pTab->nHidden==0 ){ return SQLITE_OK; } in pragmaVtabBestIndex()
2648 if( pConstraint->iColumn < pTab->iHidden ) continue; in pragmaVtabBestIndex()
2649 j = pConstraint->iColumn - pTab->iHidden; in pragmaVtabBestIndex()
2725 PragmaVtab *pTab = (PragmaVtab*)(pVtabCursor->pVtab); in pragmaVtabFilter() local
2734 j = (pTab->pName->mPragFlg & PragFlg_Result1)!=0 ? 0 : 1; in pragmaVtabFilter()
2746 sqlite3StrAccumInit(&acc, 0, 0, 0, pTab->db->aLimit[SQLITE_LIMIT_SQL_LENGTH]); in pragmaVtabFilter()
2751 sqlite3_str_appendall(&acc, pTab->pName->zName); in pragmaVtabFilter()
2757 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pCsr->pPragma, 0); in pragmaVtabFilter()
2760 pTab->base.zErrMsg = sqlite3_mprintf("%s", sqlite3_errmsg(pTab->db)); in pragmaVtabFilter()
2783 PragmaVtab *pTab = (PragmaVtab*)(pVtabCursor->pVtab); in pragmaVtabColumn() local
2784 if( i<pTab->iHidden ){ in pragmaVtabColumn()
2787 sqlite3_result_text(ctx, pCsr->azArg[i-pTab->iHidden],-1,SQLITE_TRANSIENT); in pragmaVtabColumn()