Home
last modified time | relevance | path

Searched refs:u2 (Results 1 – 12 of 12) sorted by relevance

/sqlite-3.40.0/test/
H A Dtrans2.test46 # Compute hashes on the u1 and u2 fields of the sample data.
86 u2 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
151 db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
166 db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
176 db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
[all …]
H A Dpushdown.test63 CREATE TABLE u2(x, y, z);
66 INSERT INTO u2 VALUES('a1', 'b1', 'c1');
73 SELECT x FROM u2 WHERE x=a AND f('two')
83 SELECT x FROM u2 WHERE x=a AND f('two')
H A Djoin2.test277 CREATE TABLE u2(a INTEGER PRIMARY KEY, 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 );
282 } {SCAN u2}
H A Dtester.tcl1161 set u2 $units/s
1162 output2 [format {%12d uS %s %s} $tm $rate $u2]
1177 set u2 $units/s
1178 output2 [format {%12d uS %s %s} $tm $rate $u2]
/sqlite-3.40.0/ext/recover/
H A Drecover1.test232 CREATE TABLE u2(u, v);
234 INSERT INTO u2 VALUES(hex(randomblob(500)), hex(randomblob(1000)));
235 INSERT INTO u2 VALUES(hex(randomblob(500)), hex(randomblob(1000)));
236 INSERT INTO u2 VALUES(hex(randomblob(500)), hex(randomblob(1000)));
237 INSERT INTO u2 VALUES(hex(randomblob(50000)), hex(randomblob(20000)));
256 CREATE TABLE u2(u, v);
258 INSERT INTO u2 VALUES(hex(randomblob(500)), hex(randomblob(1000)));
259 INSERT INTO u2 VALUES(hex(randomblob(500)), hex(randomblob(1000)));
260 INSERT INTO u2 VALUES(hex(randomblob(500)), hex(randomblob(1000)));
261 INSERT INTO u2 VALUES(hex(randomblob(50000)), hex(randomblob(20000)));
/sqlite-3.40.0/src/
H A Ddelete.c250 pSrc->a[0].u2.pIBIndex = 0; in sqlite3LimitWhere()
254 pSrc->a[0].u2.pCteUse->nUse++; in sqlite3LimitWhere()
H A Dselect.c4323 if( pSubitem->fg.isCte && pSubitem->u2.pCteUse->eM10d==M10d_Yes ){ in flattenSubquery()
5265 pFrom->u2.pIBIndex = pIdx; in sqlite3IndexedByLookup()
5527 pFrom->u2.pCteUse = pCteUse; in resolveFromTermToCte()
7000 || (pItem->u2.pCteUse->eM10d!=M10d_Yes && pItem->u2.pCteUse->nUse<2)) in sqlite3Select()
7031 && (pItem->fg.isCte==0 || pItem->u2.pCteUse->eM10d!=M10d_Yes) /* (2) */ in sqlite3Select()
7052 }else if( pItem->fg.isCte && pItem->u2.pCteUse->addrM9e>0 ){ in sqlite3Select()
7057 CteUse *pCteUse = pItem->u2.pCteUse; in sqlite3Select()
7105 CteUse *pCteUse = pItem->u2.pCteUse; in sqlite3Select()
H A Dtreeview.c216 sqlite3_str_appendf(&x, " CteUse=0x%p", pItem->u2.pCteUse); in sqlite3TreeViewSrcList()
H A Dexpr.c1678 pNewItem->u2 = pOldItem->u2; in sqlite3SrcListDup()
1680 pNewItem->u2.pCteUse->nUse++; in sqlite3SrcListDup()
H A DsqliteInt.h3152 } u2; member
H A Dwhere.c3404 pProbe = pSrc->u2.pIBIndex; in whereLoopAddBtree()
/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,