Home
last modified time | relevance | path

Searched refs:u1 (Results 1 – 25 of 27) sorted by relevance

12

/sqlite-3.40.0/test/
H A Dtrans2.test46 # Compute hashes on the u1 and u2 fields of the sample data.
84 u1 TEXT UNIQUE,
90 foreach {id u1 z u2} $rec break
91 db eval {INSERT INTO t1 VALUES($id,$u1,zeroblob($z),$u2)}
93 db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
117 db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
145 foreach {id u1 z u2} $rec break
160 UPDATE t1 SET u1=u1||'x',
184 UPDATE t1 SET u1=u1||'x',
214 UPDATE t1 SET u1=u1||'x',
[all …]
H A Dupfrom3.test135 CREATE TABLE u1(a, b, c, PRIMARY KEY(b, c)) WITHOUT ROWID;
136 INSERT INTO u1 VALUES(0, 0, 0);
137 INSERT INTO u1 VALUES(1, 0, 1);
138 INSERT INTO u1 VALUES(2, 1, 0);
139 INSERT INTO u1 VALUES(3, 1, 1);
146 UPDATE u1 SET c=t FROM map WHERE c=f;
147 SELECT * FROM u1 ORDER BY a;
156 UPDATE u1 SET b=t FROM map WHERE b=f;
157 SELECT * FROM u1 ORDER BY a;
170 UPDATE u1 SET b=n1, c=n2 FROM map2 WHERE b=o1 AND c=o2;
[all …]
H A Dunionvtab.test119 CREATE VIRTUAL TABLE u1 USING unionvtab("VALUES(NULL, 't1', 1, 100)");
122 CREATE VIRTUAL TABLE main.u1 USING unionvtab("VALUES('', 't1', 1, 100)");
125 CREATE VIRTUAL TABLE aux.u1 USING unionvtab("VALUES('', 't1', 1, 100)");
129 CREATE VIRTUAL TABLE temp.u1 USING unionvtab("VALUES(NULL, 't555', 1, 100)");
132 CREATE VIRTUAL TABLE temp.u1 USING unionvtab("VALUES('aux', 't555', 1, 100)");
135 CREATE VIRTUAL TABLE temp.u1 USING unionvtab("VALUES('xua', 't555', 1, 100)");
147 CREATE VIRTUAL TABLE temp.u1 USING unionvtab("VALUES('main', 'wr1', 1, 2)");
150 CREATE VIRTUAL TABLE temp.u1 USING unionvtab("VALUES(NULL, 'v1', 1, 2)");
153 CREATE VIRTUAL TABLE temp.u1 USING unionvtab("VALUES(NULL, 'v2', 1, 2)");
156 CREATE VIRTUAL TABLE temp.u1 USING unionvtab("VALUES(NULL, 'wr2', 1, 2)");
[all …]
H A Dpushdown.test62 CREATE TABLE u1(a, b, c);
65 INSERT INTO u1 VALUES('a1', 'b1', 'c1');
72 SELECT * FROM u1 WHERE f('one')=123 AND 123=(
82 SELECT * FROM u1 WHERE 123=(
H A Djoin2.test276 CREATE TABLE u1(a INTEGER PRIMARY KEY, b, c);
278 CREATE INDEX u1ab ON u1(b, c);
281 SELECT u2.* FROM u2 LEFT JOIN u1 ON( u1.a=u2.a AND u1.b=u2.b AND u1.c=u2.c );
H A Dtransitive1.test324 CREATE TABLE u1(x TEXT, y INTEGER, z TEXT);
325 CREATE INDEX i1 ON u1(x);
326 INSERT INTO u1 VALUES('00013', 13, '013');
327 SELECT * FROM u1 WHERE x=y AND y=z AND z='013';
/sqlite-3.40.0/ext/recover/
H A Drecover1.test194 CREATE TABLE u1(u, v);
195 INSERT INTO u1 VALUES('edvin marton', 'bond');
196 INSERT INTO u1 VALUES(1, 4.0);
228 CREATE TABLE u1(u, v);
229 CREATE UNIQUE INDEX i1 ON u1(u, v);
230 INSERT INTO u1 VALUES(1, 2), (3, 4);
233 CREATE UNIQUE INDEX i2 ON u1(u, v);
252 CREATE TABLE u1(u, v);
253 CREATE UNIQUE INDEX i1 ON u1(u, v);
254 INSERT INTO u1 VALUES(1, 2), (3, 4);
[all …]
/sqlite-3.40.0/src/
H A Dtokenize.c584 AtomicStore(&db->u1.isInterrupted, 0);
629 if( AtomicLoad(&db->u1.isInterrupted) ){
H A Dbuild.c171 Returning *pReturning = pParse->u1.pReturning; in sqlite3FinishCoding()
264 Returning *pRet = pParse->u1.pReturning; in sqlite3FinishCoding()
1377 pParse->u1.addrCrTab = in sqlite3StartTable()
1461 pParse->u1.pReturning = pRet; in sqlite3AddReturning()
2361 if( pParse->u1.addrCrTab ){ in convertToWithoutRowidTable()
2363 sqlite3VdbeChangeP3(v, pParse->u1.addrCrTab, BTREE_BLOBKEY); in convertToWithoutRowidTable()
4913 if( pItem->fg.isIndexedBy ) sqlite3DbFree(db, pItem->u1.zIndexedBy); in sqlite3SrcListDelete()
4914 if( pItem->fg.isTabFunc ) sqlite3ExprListDelete(db, pItem->u1.pFuncArg); in sqlite3SrcListDelete()
5018 pItem->u1.zIndexedBy = sqlite3NameFromToken(pParse->db, pIndexedBy); in sqlite3SrcListIndexedBy()
5056 pItem->u1.pFuncArg = pList; in sqlite3SrcListFuncArgs()
H A Dwalker.c176 && sqlite3WalkExprList(pWalker, pItem->u1.pFuncArg) in sqlite3WalkSelectFrom()
H A Dmalloc.c828 AtomicStore(&db->u1.isInterrupted, 1); in sqlite3OomFault()
854 AtomicStore(&db->u1.isInterrupted, 0); in sqlite3OomClear()
H A Dtrigger.c73 assert( &(pParse->u1.pReturning->retTrig) == pTrig ); in sqlite3TriggerList()
970 pReturning = pParse->u1.pReturning; in codeReturningTrigger()
H A Dwhereexpr.c953 mask |= sqlite3WhereExprListUsage(pMaskSet, pSrc->a[i].u1.pFuncArg); in exprSelectUsage()
1821 pArgs = pItem->u1.pFuncArg; in sqlite3WhereTabFuncArgs()
H A Ddelete.c252 sqlite3DbFree(db, pSrc->a[0].u1.zIndexedBy); in sqlite3LimitWhere()
H A DsqliteInt.h1628 } u1; member
3148 } u1; member
3679 } u1; member
H A Dparse.y728 pNew->u1.pFuncArg = pOld->u1.pFuncArg;
729 pOld->u1.pFuncArg = 0;
H A Dexpr.c1676 pNewItem->u1.zIndexedBy = sqlite3DbStrDup(db, pOldItem->u1.zIndexedBy); in sqlite3SrcListDup()
1683 pNewItem->u1.pFuncArg = in sqlite3SrcListDup()
1684 sqlite3ExprListDup(db, pOldItem->u1.pFuncArg, flags); in sqlite3SrcListDup()
H A Dmain.c1803 AtomicStore(&db->u1.isInterrupted, 1); in sqlite3_interrupt()
2469 AtomicStore(&db->u1.isInterrupted, 0); in sqlite3_wal_checkpoint_v2()
H A Dtreeview.c239 sqlite3TreeViewExprList(pView, pItem->u1.pFuncArg, 0, "func-args:"); in sqlite3TreeViewSrcList()
H A Dresolve.c1827 && sqlite3ResolveExprListNames(&sNC, pItem->u1.pFuncArg) in resolveSelectStep()
H A Dvdbeapi.c674 AtomicStore(&db->u1.isInterrupted, 0); in sqlite3Step()
H A Dvdbe.c769 if( AtomicLoad(&db->u1.isInterrupted) ) goto abort_due_to_interrupt; in sqlite3VdbeExec()
953 if( AtomicLoad(&db->u1.isInterrupted) ) goto abort_due_to_interrupt; in sqlite3VdbeExec()
8857 assert( AtomicLoad(&db->u1.isInterrupted) ); in sqlite3VdbeExec()
H A Dselect.c3905 substExprList(pSubst, pItem->u1.pFuncArg); in substSelect()
5250 char *zIndexedBy = pFrom->u1.zIndexedBy; in sqlite3IndexedByLookup()
5523 sqlite3ErrorMsg(pParse, "no such index: \"%s\"", pFrom->u1.zIndexedBy); in resolveFromTermToCte()
H A Dwal.c2131 if( AtomicLoad(&db->u1.isInterrupted) ){ in walCheckpoint()
/sqlite-3.40.0/ext/rtree/
H A Drtreedoc.test977 id, u1,u2, v1,v2, +aux
1015 CREATE VIRTUAL TABLE r1 USING rtree(intid, u1,u2,
1030 CREATE VIRTUAL TABLE r1 USING rtree(intid, u1,u2,
1044 CREATE VIRTUAL TABLE r1 USING rtree(intid, u1,u2, v1,v2,
1059 CREATE VIRTUAL TABLE r1 USING rtree(intid, u1,u2, v1,v2,

12