Home
last modified time | relevance | path

Searched refs:tab (Results 1 – 25 of 69) sorted by relevance

123

/sqlite-3.40.0/test/
H A Dtkt2141.test30 INSERT INTO tab1 VALUES(1,'rec 1 tab 1');
32 INSERT INTO tab2 VALUES(1,1,'rec 1 tab 2');
41 } {1 {rec 1 tab 1} 1 1 {rec 1 tab 2}}
50 } {1 {rec 1 tab 1} 1 1 {rec 1 tab 2}}
59 } {1 {rec 1 tab 1} 1 1 {rec 1 tab 2}}
H A Dbetween.test62 $x all ss as tab idx]} {
63 lappend data $tab $idx
64 } elseif {[regexp {(SCAN|SEARCH) (\w+ AS )?(\w+)\y} $x all ss as tab]} {
65 lappend data $tab *
H A DtriggerD.test19 # CREATE TRIGGER attached.trig AFTER INSERT ON attached.tab ...
186 # CREATE TRIGGER xyz.trig BEFORE UPDATE ON xyz.tab BEGIN ...
188 # But a long-standing bug does allow it. And the "xyz.tab" slips into
190 # "xyz.tab" since that could break legacy applications. We have to
191 # fix the system so that the "xyz." on "xyz.tab" is ignored.
H A DwhereJ.test337 CREATE TABLE tab(
345 FROM tab AS t0, tab AS t1, tab AS t2, tab AS t3, tab AS t4
356 FROM tab AS t0a, tab AS t0b,
357 tab AS t1a, tab AS t1b,
358 tab AS t2a, tab AS t2b,
359 tab AS t3a, tab AS t3b,
360 tab AS t4
H A Dgencol1.test567 CREATE TEMPORARY TABLE tab (
575 INSERT INTO tab (prim, a, b) VALUES ('2001-01-01', 0, 0);
577 SELECT * FROM tab;
581 INSERT INTO tab (prim, b)
585 SELECT * FROM tab;
H A Dinsert3.test170 foreach tab [db eval {SELECT name FROM sqlite_master WHERE type = 'table'}] {
171 db eval "DROP TABLE $tab"
H A Dwhere3.test117 $x all ss as tab idx]} {
118 lappend data $tab $idx
119 } elseif {[regexp {(SCAN|SEARCH) (\w+ AS )?(\w+)\y} $x all ss as tab]} {
120 lappend data $tab *
H A Dmultiplex.test472 db eval {CREATE TABLE t2(x); INSERT INTO t2 VALUES('tab-t2');}
479 } {tab-t2}
488 db2 eval { DELETE FROM t2 WHERE x = 'tab-t2' }
/sqlite-3.40.0/src/
H A Dtest8.c810 echo_vtab *pVtab = (echo_vtab *)tab; in echoBestIndex()
970 sqlite3_vtab *tab, in echoUpdate() argument
975 echo_vtab *pVtab = (echo_vtab *)tab; in echoUpdate()
1104 echo_vtab *pVtab = (echo_vtab *)tab; in echoTransactionCall()
1112 static int echoBegin(sqlite3_vtab *tab){ in echoBegin() argument
1114 echo_vtab *pVtab = (echo_vtab *)tab; in echoBegin()
1143 static int echoSync(sqlite3_vtab *tab){ in echoSync() argument
1145 echo_vtab *pVtab = (echo_vtab *)tab; in echoSync()
1157 rc = echoTransactionCall(tab, "xSync"); in echoSync()
1172 echo_vtab *pVtab = (echo_vtab*)tab; in echoCommit()
[all …]
H A Dtest_tclvar.c351 static int tclvarBestIndex(sqlite3_vtab *tab, sqlite3_index_info *pIdxInfo){ in tclvarBestIndex() argument
352 tclvar_vtab *pTab = (tclvar_vtab*)tab; in tclvarBestIndex()
417 sqlite3_vtab *tab, in tclvarUpdate() argument
422 tclvar_vtab *pTab = (tclvar_vtab*)tab; in tclvarUpdate()
434 tab->zErrMsg = sqlite3_mprintf("the 'fullname' column must be TEXT"); in tclvarUpdate()
461 tab->zErrMsg = sqlite3_mprintf("prohibited TCL variable change"); in tclvarUpdate()
H A Dfkey.c711 for(pFKey=pTab->u.tab.pFKey; pFKey; pFKey=pFKey->pNextFrom){ in sqlite3FkClearTriggerCache()
750 for(p=pTab->u.tab.pFKey; p; p=p->pNextFrom){ in sqlite3FkDropTable()
913 for(pFKey=pTab->u.tab.pFKey; pFKey; pFKey=pFKey->pNextFrom){ in sqlite3FkCheck()
1098 for(p=pTab->u.tab.pFKey; p; p=p->pNextFrom){ in sqlite3FkOldmask()
1153 bHaveFK = (sqlite3FkReferences(pTab) || pTab->u.tab.pFKey); in sqlite3FkRequired()
1160 for(p=pTab->u.tab.pFKey; p; p=p->pNextFrom){ in sqlite3FkRequired()
1443 for(pFKey=pTab->u.tab.pFKey; pFKey; pFKey=pNext){ in sqlite3FkDelete()
H A Dalter.c373 if( (db->flags&SQLITE_ForeignKeys) && pNew->u.tab.pFKey && pDflt ){ in sqlite3AlterFinishAddColumn()
422 zDb, pNew->u.tab.addColOffset, zCol, pNew->u.tab.addColOffset, in sqlite3AlterFinishAddColumn()
511 assert( pTab->u.tab.addColOffset>0 ); in sqlite3AlterBeginAddColumn()
542 pNew->u.tab.pDfltList = sqlite3ExprListDup(db, pTab->u.tab.pDfltList, 0); in sqlite3AlterBeginAddColumn()
544 pNew->u.tab.addColOffset = pTab->u.tab.addColOffset; in sqlite3AlterBeginAddColumn()
1557 for(pFKey=sParse.pNewTable->u.tab.pFKey; pFKey; pFKey=pFKey->pNextFrom){ in renameColumnFunc()
1752 for(pFKey=pTab->u.tab.pFKey; pFKey; pFKey=pFKey->pNextFrom){ in renameTableFunc()
2099 zEnd = (const char*)&zSql[pTab->u.tab.addColOffset]; in dropColumnFunc()
H A Dtest_fs.c183 static int fsdirBestIndex(sqlite3_vtab *tab, sqlite3_index_info *pIdxInfo){ in fsdirBestIndex() argument
390 static int fstreeBestIndex(sqlite3_vtab *tab, sqlite3_index_info *pIdxInfo){ in fstreeBestIndex() argument
774 static int fsBestIndex(sqlite3_vtab *tab, sqlite3_index_info *pIdxInfo){ in fsBestIndex() argument
H A Dvdbevtab.c356 sqlite3_vtab *tab, in bytecodevtabBestIndex() argument
362 bytecodevtab *pVTab = (bytecodevtab*)tab; in bytecodevtabBestIndex()
H A Dpragma.c1465 pFK = pTab->u.tab.pFKey; in sqlite3Pragma()
1522 if( pTab==0 || !IsOrdinaryTable(pTab) || pTab->u.tab.pFKey==0 ) continue; in sqlite3Pragma()
1531 for(i=1, pFK=pTab->u.tab.pFKey; pFK; i++, pFK=pFK->pNextFrom){ in sqlite3Pragma()
1554 for(i=1, pFK=pTab->u.tab.pFKey; pFK; i++, pFK=pFK->pNextFrom){ in sqlite3Pragma()
2634 static int pragmaVtabBestIndex(sqlite3_vtab *tab, sqlite3_index_info *pIdxInfo){ in pragmaVtabBestIndex() argument
2635 PragmaVtab *pTab = (PragmaVtab*)tab; in pragmaVtabBestIndex()
H A Dbuild.c705 pList = pTab->u.tab.pDfltList; in sqlite3ColumnSetExpr()
711 pTab->u.tab.pDfltList = sqlite3ExprListAppend(pParse, pList, pExpr); in sqlite3ColumnSetExpr()
726 if( NEVER(pTab->u.tab.pDfltList==0) ) return 0; in sqlite3ColumnExpr()
727 if( NEVER(pTab->u.tab.pDfltList->nExpr<pCol->iDflt) ) return 0; in sqlite3ColumnExpr()
728 return pTab->u.tab.pDfltList->a[pCol->iDflt-1].pExpr; in sqlite3ColumnExpr()
786 sqlite3ExprListDelete(db, pTable->u.tab.pDfltList); in sqlite3DeleteColumnNames()
792 pTable->u.tab.pDfltList = 0; in sqlite3DeleteColumnNames()
2948 p->u.tab.addColOffset = 13 + (int)(pCons->z - pParse->sNameToken.z); in sqlite3EndTable()
3627 pFKey->pNextFrom = p->u.tab.pFKey; in sqlite3CreateForeignKey()
3693 p->u.tab.pFKey = pFKey; in sqlite3CreateForeignKey()
[all …]
H A Dtest_bestindex.c596 static int tclBestIndex(sqlite3_vtab *tab, sqlite3_index_info *pIdxInfo){ in tclBestIndex() argument
597 tcl_vtab *pTab = (tcl_vtab*)tab; in tclBestIndex()
/sqlite-3.40.0/ext/misc/
H A Dvtablog.c432 sqlite3_vtab *tab, in vtablogBestIndex() argument
435 vtablog_vtab *pTab = (vtablog_vtab*)tab; in vtablogBestIndex()
450 sqlite3_vtab *tab, in vtablogUpdate() argument
455 vtablog_vtab *pTab = (vtablog_vtab*)tab; in vtablogUpdate()
H A Dcompletion.c405 sqlite3_vtab *tab, in completionBestIndex() argument
415 (void)(tab); /* Unused parameter */ in completionBestIndex()
H A Dtemplatevtab.c216 sqlite3_vtab *tab, in templatevtabBestIndex() argument
H A Dvfsstat.c726 sqlite3_vtab *tab, in vstattabBestIndex() argument
738 sqlite3_vtab *tab, in vstattabUpdate() argument
/sqlite-3.40.0/ext/session/
H A Dsession8.test36 foreach tab $alltab {
37 append txt [lsort [$db eval "SELECT * FROM $dbname.$tab"]]\n
H A DsessionD.test33 foreach tab $alltab {
35 db eval "PRAGMA $dbname.table_info = $tab" x {
39 append txt [db eval "SELECT $cols FROM $tab ORDER BY $cols"]
H A DsessionB.test346 foreach tab $alltab {
347 $db eval "SELECT * FROM $tab LIMIT 1" res { }
352 set sql "SELECT [join $slist ,] FROM $tab"
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5corrupt5.test91 | 2528: 01 05 01 03 74 61 62 03 02 03 04 0a 19 8c 80 80 ....tab.........
161 | 3648: 03 74 61 62 01 06 01 01 05 04 08 1a 84 80 80 80 .tab............
305 | 2528: 01 05 01 03 74 61 62 03 02 03 04 0a 19 8c 80 80 ....tab.........
375 | 3648: 03 74 61 62 01 06 01 01 05 04 08 1a 84 80 80 80 .tab............
636 | 2528: 01 05 01 03 74 61 62 03 02 03 04 0a 19 8c 80 80 ....tab.........
706 | 3648: 03 74 61 62 01 06 01 01 05 04 08 1a 84 80 80 80 .tab............
725 | 3952: 80 80 80 04 03 00 2e 00 00 00 10 06 30 74 61 62 ............0tab

123