Home
last modified time | relevance | path

Searched refs:pTab (Results 1 – 14 of 14) sorted by relevance

/illumos-gate/usr/src/lib/libsqlite/src/
H A Ddelete.c25 Table *pTab = 0; in sqliteSrcListLookup() local
30 pTab = sqliteLocateTable(pParse, zTab, zDb); in sqliteSrcListLookup()
31 pSrc->a[i].pTab = pTab; in sqliteSrcListLookup()
33 return pTab; in sqliteSrcListLookup()
41 int sqliteIsReadOnly(Parse *pParse, Table *pTab, int viewOk){ in sqliteIsReadOnly() argument
42 if( pTab->readOnly ){ in sqliteIsReadOnly()
43 sqliteErrorMsg(pParse, "table %s may not be modified", pTab->zName); in sqliteIsReadOnly()
46 if( !viewOk && pTab->pSelect ){ in sqliteIsReadOnly()
47 sqliteErrorMsg(pParse, "cannot modify %s because it is a view",pTab->zName); in sqliteIsReadOnly()
62 Table *pTab; /* The table from which records will be deleted */ in sqliteDeleteFrom() local
[all …]
H A Dupdate.c34 Table *pTab; /* The table to be updated */ in sqliteUpdate() local
71 pTab = sqliteSrcListLookup(pParse, pTabList); in sqliteUpdate()
72 if( pTab==0 ) goto update_cleanup; in sqliteUpdate()
73 before_triggers = sqliteTriggersExist(pParse, pTab->pTrigger, in sqliteUpdate()
75 after_triggers = sqliteTriggersExist(pParse, pTab->pTrigger, in sqliteUpdate()
78 isView = pTab->pSelect!=0; in sqliteUpdate()
79 if( sqliteIsReadOnly(pParse, pTab, before_triggers) ){ in sqliteUpdate()
83 if( sqliteViewGetColumnNames(pParse, pTab) ){ in sqliteUpdate()
87 aXRef = sqliteMalloc( sizeof(int) * pTab->nCol ); in sqliteUpdate()
89 for(i=0; i<pTab->nCol; i++) aXRef[i] = -1; in sqliteUpdate()
[all …]
H A Dcopy.c36 Table *pTab; in sqliteCopy() local
47 pTab = sqliteSrcListLookup(pParse, pTableName); in sqliteCopy()
48 if( pTab==0 || sqliteIsReadOnly(pParse, pTab, 0) ) goto copy_cleanup; in sqliteCopy()
51 assert( pTab->iDb<db->nDb ); in sqliteCopy()
52 zDb = db->aDb[pTab->iDb].zName; in sqliteCopy()
53 if( sqliteAuthCheck(pParse, SQLITE_INSERT, pTab->zName, 0, zDb) in sqliteCopy()
54 || sqliteAuthCheck(pParse, SQLITE_COPY, pTab->zName, zFile, zDb) ){ in sqliteCopy()
59 sqliteBeginWriteOperation(pParse, 1, pTab->iDb); in sqliteCopy()
62 sqliteOpenTableAndIndices(pParse, pTab, 0); in sqliteCopy()
67 addr = sqliteVdbeAddOp(v, OP_FileRead, pTab->nCol, end); in sqliteCopy()
[all …]
H A Dinsert.c94 Table *pTab; /* The table to insert into */ in sqliteInsert() local
127 pTab = sqliteSrcListLookup(pParse, pTabList); in sqliteInsert()
128 if( pTab==0 ){ in sqliteInsert()
131 assert( pTab->iDb<db->nDb ); in sqliteInsert()
132 zDb = db->aDb[pTab->iDb].zName; in sqliteInsert()
133 if( sqliteAuthCheck(pParse, SQLITE_INSERT, pTab->zName, 0, zDb) ){ in sqliteInsert()
141 before_triggers = sqliteTriggersExist(pParse, pTab->pTrigger, TK_INSERT, in sqliteInsert()
143 after_triggers = sqliteTriggersExist(pParse, pTab->pTrigger, TK_INSERT, in sqliteInsert()
146 isView = pTab->pSelect!=0; in sqliteInsert()
147 if( sqliteIsReadOnly(pParse, pTab, before_triggers) ){ in sqliteInsert()
[all …]
H A Dauth.c110 Table *pTab; /* The table being read */ in sqliteAuthRead() local
121 pTab = pTabList->a[iSrc].pTab; in sqliteAuthRead()
130 pTab = pStack->pTab; in sqliteAuthRead()
132 if( pTab==0 ) return; in sqliteAuthRead()
134 assert( pExpr->iColumn<pTab->nCol ); in sqliteAuthRead()
135 zCol = pTab->aCol[pExpr->iColumn].zName; in sqliteAuthRead()
136 }else if( pTab->iPKey>=0 ){ in sqliteAuthRead()
137 assert( pTab->iPKey<pTab->nCol ); in sqliteAuthRead()
138 zCol = pTab->aCol[pTab->iPKey].zName; in sqliteAuthRead()
144 rc = db->xAuth(db->pAuthArg, SQLITE_READ, pTab->zName, zCol, zDBase, in sqliteAuthRead()
[all …]
H A Dpragma.c367 Table *pTab; in sqlitePragma() local
368 pTab = sqliteFindTable(db, zRight, 0); in sqlitePragma()
369 if( pTab ){ in sqlitePragma()
380 sqliteViewGetColumnNames(pParse, pTab); in sqlitePragma()
381 for(i=0; i<pTab->nCol; i++){ in sqlitePragma()
383 sqliteVdbeOp3(v, OP_String, 0, 0, pTab->aCol[i].zName, 0); in sqlitePragma()
385 pTab->aCol[i].zType ? pTab->aCol[i].zType : "numeric", 0); in sqlitePragma()
386 sqliteVdbeAddOp(v, OP_Integer, pTab->aCol[i].notNull, 0); in sqlitePragma()
388 pTab->aCol[i].zDflt, P3_STATIC); in sqlitePragma()
389 sqliteVdbeAddOp(v, OP_Integer, pTab->aCol[i].isPrimKey, 0); in sqlitePragma()
[all …]
H A Dselect.c138 static int columnIndex(Table *pTab, const char *zCol){ in columnIndex() argument
140 for(i=0; i<pTab->nCol; i++){ in columnIndex()
141 if( sqliteStrICmp(pTab->aCol[i].zName, zCol)==0 ) return i; in columnIndex()
216 if( pTerm->pTab==0 || pOther->pTab==0 ) continue; in sqliteProcessJoin()
222 Table *pTab; in sqliteProcessJoin() local
228 pTab = pTerm->pTab; in sqliteProcessJoin()
229 for(j=0; j<pTab->nCol; j++){ in sqliteProcessJoin()
230 if( columnIndex(pOther->pTab, pTab->aCol[j].zName)>=0 ){ in sqliteProcessJoin()
231 addWhereTerm(pTab->aCol[j].zName, pTab, pOther->pTab, &p->pWhere); in sqliteProcessJoin()
270 if( columnIndex(pTerm->pTab, pList->a[j].zName)<0 || in sqliteProcessJoin()
[all …]
H A Dbuild.c240 Table *pTab = sqliteHashData(pElem); in sqliteResetInternalSchema() local
241 sqliteDeleteTable(db, pTab); in sqliteResetInternalSchema()
681 Table *pTab = pParse->pNewTable; in sqliteAddPrimaryKey() local
684 if( pTab==0 ) goto primary_key_exit; in sqliteAddPrimaryKey()
685 if( pTab->hasPrimKey ){ in sqliteAddPrimaryKey()
687 "table \"%s\" has more than one primary key", pTab->zName); in sqliteAddPrimaryKey()
690 pTab->hasPrimKey = 1; in sqliteAddPrimaryKey()
692 iCol = pTab->nCol - 1; in sqliteAddPrimaryKey()
693 pTab->aCol[iCol].isPrimKey = 1; in sqliteAddPrimaryKey()
696 for(iCol=0; iCol<pTab->nCol; iCol++){ in sqliteAddPrimaryKey()
[all …]
H A Dwhere.c213 Table *pTab, /* The table to be sorted */ in findSortingIndex() argument
252 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in findSortingIndex()
486 Table *pTab = pTabList->a[i].pTab; in sqliteWhereBegin() local
557 for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){ in sqliteWhereBegin()
667 Table *pTab; in sqliteWhereBegin() local
670 pTab = pTabList->a[0].pTab; in sqliteWhereBegin()
685 pSortIdx = findSortingIndex(pTab, pTabList->a[0].iCursor, in sqliteWhereBegin()
702 Table *pTab; in sqliteWhereBegin() local
705 pTab = pTabList->a[i].pTab; in sqliteWhereBegin()
706 if( pTab->isTransient || pTab->pSelect ) continue; in sqliteWhereBegin()
[all …]
H A Dmain.c142 Table *pTab; in upgrade_3_callback() local
146 pTab = sqliteFindTable(pData->db, argv[0], 0); in upgrade_3_callback()
147 assert( pTab!=0 ); in upgrade_3_callback()
148 assert( sqliteStrICmp(pTab->zName, argv[0])==0 ); in upgrade_3_callback()
149 if( pTab ){ in upgrade_3_callback()
150 pTrig = pTab->pTrigger; in upgrade_3_callback()
151 pTab->pTrigger = 0; /* Disable all triggers before rebuilding the table */ in upgrade_3_callback()
169 pTab = sqliteFindTable(pData->db, argv[0], 0); in upgrade_3_callback()
170 if( pTab ){ in upgrade_3_callback()
171 assert( sqliteStrICmp(pTab->zName, argv[0])==0 ); in upgrade_3_callback()
[all …]
H A Dexpr.c197 pNewItem->pTab = 0; in sqliteSrcListDup()
450 Table *pTab = pItem->pTab; in lookupName() local
453 if( pTab==0 ) continue; in lookupName()
454 assert( pTab->nCol>0 ); in lookupName()
460 char *zTabName = pTab->zName; in lookupName()
462 if( zDb!=0 && sqliteStrICmp(db->aDb[pTab->iDb].zName, zDb)!=0 ){ in lookupName()
469 pExpr->iDb = pTab->iDb; in lookupName()
471 for(j=0, pCol=pTab->aCol; j<pTab->nCol; j++, pCol++){ in lookupName()
475 pExpr->iDb = pTab->iDb; in lookupName()
477 pExpr->iColumn = j==pTab->iPKey ? -1 : j; in lookupName()
[all …]
H A Dtrigger.c215 Table *pTab; in sqliteFinishTrigger() local
218 pTab = sqliteLocateTable(pParse, nt->table, db->aDb[nt->iTabDb].zName); in sqliteFinishTrigger()
219 assert( pTab!=0 ); in sqliteFinishTrigger()
220 nt->pNext = pTab->pTrigger; in sqliteFinishTrigger()
221 pTab->pTrigger = nt; in sqliteFinishTrigger()
684 Table *pTab, /* The table to code triggers from */ in sqliteCodeRowTrigger() argument
698 pTrigger = pTab->pTrigger; in sqliteCodeRowTrigger()
731 pTriggerStack->pTab = pTab; in sqliteCodeRowTrigger()
H A DsqliteInt.h775 Table *pTab; /* An SQL table corresponding to zName */ member
1066 Table *pTab; /* Table that triggers are currently being coded on */ member
H A Dparse.y802 SrcList *pTab = sqliteSrcListAppend(0, &E, &DB);
803 sqliteBeginTrigger(pParse, &B, C, D.a, D.b, pTab, F, G, T);