Home
last modified time | relevance | path

Searched refs:z1 (Results 1 – 25 of 35) sorted by relevance

12

/sqlite-3.40.0/tool/
H A Dindex_usage.c183 const char *z1, *z2; in main() local
186 z1 = strstr(zExplain, " USING INDEX "); in main()
187 if( z1==0 ) continue; in main()
188 z1 += 13; in main()
189 for(z2=z1+1; z2[0] && z2[1]!='('; z2++){} in main()
190 n = z2 - z1; in main()
191 if( zUsing && sqlite3_strnicmp(zUsing, z1, n)==0 ){ in main()
195 sqlite3_bind_text(pIncrCnt,1,z1,n,SQLITE_STATIC); in main()
/sqlite-3.40.0/ext/fts3/
H A Dfts3_tokenizer.c129 const char *z1; in sqlite3Fts3NextToken() local
133 z1 = zStr; in sqlite3Fts3NextToken()
135 char c = *z1; in sqlite3Fts3NextToken()
141 z2 = z1; in sqlite3Fts3NextToken()
146 z2 = &z1[1]; in sqlite3Fts3NextToken()
152 if( sqlite3Fts3IsIdChar(*z1) ){ in sqlite3Fts3NextToken()
153 z2 = &z1[1]; in sqlite3Fts3NextToken()
156 z1++; in sqlite3Fts3NextToken()
161 *pn = (int)(z2-z1); in sqlite3Fts3NextToken()
162 return z1; in sqlite3Fts3NextToken()
/sqlite-3.40.0/test/
H A Drowvalue3.test48 CREATE TABLE z1(x, y, z);
51 INSERT INTO z1 VALUES('a', 'b', 'c');
52 INSERT INTO z1 VALUES('d', 'e', 'f');
53 INSERT INTO z1 VALUES('g', 'h', 'i');
63 2 { CREATE INDEX z1idx ON z1(x, y) }
64 3 { CREATE UNIQUE INDEX z1idx ON z1(x, y) }
71 SELECT * FROM z1 WHERE x IN (SELECT a FROM kk)
75 SELECT * FROM z1 WHERE (x,y) IN (SELECT a, b FROM kk)
79 SELECT * FROM z1 WHERE (x, +y) IN (SELECT a, b FROM kk)
83 SELECT * FROM z1 WHERE (x, +y) IN (SELECT a, b||'x' FROM kk)
[all …]
H A Dshow_speedtest1_rtree.tcl35 foreach {id x0 x1 y0 y1 z0 z1} $::data {
43 foreach {id x0 x1 y0 y1 z0 z1} $::data {
44 .c create rectangle $x0 $z0 $x1 $z1
51 foreach {id x0 x1 y0 y1 z0 z1} $::data {
52 .c create rectangle $y0 $z0 $y1 $z1
H A Dfuzzinvariants.c335 const char *z1 = (const char*)sqlite3_column_text(pS1,i1); in sameValue() local
337 x = ((z1==0 && z2==0) || (z1!=0 && z2!=0 && strcmp(z1,z1)==0)); in sameValue()
H A Dinterrupt2.test78 CREATE TEMP TABLE z1(a, b);
79 INSERT INTO z1 SELECT * FROM t1;
86 db eval {SELECT * FROM z1} {
102 SELECT count(*) FROM z1
H A De_select.test769 CREATE TABLE z1(a, b, c);
774 INSERT INTO z1 VALUES(-5, NULL, 75);
798 3 "SELECT z1.* FROM z1,z2 LIMIT 1" {51.65 -59.58 belfries}
800 5 "SELECT z2.*, z1.* FROM z1,z2 LIMIT 1" {{} 21 51.65 -59.58 belfries}
809 10 "SELECT z1.*,z1.* FROM z2,z1 LIMIT 1" {
841 1 "SELECT * FROM z1" 3
843 3 "SELECT z1.* FROM z1 NATURAL JOIN z3" 3
845 5 "SELECT z1.*, z3.* FROM z1 NATURAL JOIN z3" 5
846 6 "SELECT 1, 2, z1.* FROM z1" 5
876 1 "SELECT a, b FROM z1"
[all …]
H A Dthreadtest1.c227 char z1[30], z2[30]; in worker_bee() local
229 sprintf(z1, "%d", i*2); in worker_bee()
231 db_check(zFilename, "readback", az, z1, z2, 0); in worker_bee()
H A Dfts3aa.test254 CREATE VIRTUAL TABLE z1 USING fts3;
255 INSERT INTO z1 VALUES('one two three'),('four one five'),('six two five');
257 DELETE FROM z1;
261 DELETE FROM z1;
H A Dthreadtest3.c994 char *z1, *z2, *z3; in walthread1_thread() local
998 z1 = execsql_text(&err, &db, 1, azSql[0]); in walthread1_thread()
1003 if( strcmp(z1, z2) || strcmp(z1, z3) ){ in walthread1_thread()
1004 test_error(&err, "Failed read: %s %s %s", z1, z2, z3); in walthread1_thread()
H A Dspeedtest1.c1484 unsigned x0, x1, y0, y1, z0, z1; in testset_rtree() local
1499 twoCoords(p1, p2, mxCoord, &z0, &z1); in testset_rtree()
1506 sqlite3_bind_int(g.pStmt, 7, z1); in testset_rtree()
H A Dselect4.test1024 SELECT * FROM t1 AS z1 JOIN t1 AS z2 USING(aa)
1025 WHERE abs(z1.aa)=z2.aa AND z1.aa=123;
/sqlite-3.40.0/ext/misc/
H A Dshowauth.c30 const char *z1, in authCallback() argument
80 if( z1==0 ) z1 = "NULL"; in authCallback()
84 printf("AUTH: %s,%s,%s,%s,%s\n", zOp, z1, z2, z3, z4); in authCallback()
H A Dvfslog.c216 char z1[40], z2[40], z3[2000]; in vlogLogPrint() local
219 sqlite3_snprintf(sizeof(z1), z1, "%lld", iArg1); in vlogLogPrint()
221 z1[0] = 0; in vlogLogPrint()
234 tStart, tElapse, zOp, pLog->zFilename==0, z1, z2, z3, iRes); in vlogLogPrint()
/sqlite-3.40.0/src/
H A Dtest_tclvar.c253 const char *z1; in tclvarColumn() local
260 z1 = Tcl_GetString(p1); in tclvarColumn()
266 sqlite3_result_text(ctx, z1, -1, SQLITE_TRANSIENT); in tclvarColumn()
274 Tcl_Obj *pVal = Tcl_GetVar2Ex(interp, z1, *z2?z2:0, TCL_GLOBAL_ONLY); in tclvarColumn()
281 z3 = sqlite3_mprintf("%s(%s)", z1, z2); in tclvarColumn()
284 sqlite3_result_text(ctx, z1, -1, SQLITE_TRANSIENT); in tclvarColumn()
H A Dfunc.c469 char *z1; in upperFunc() local
478 z1 = contextMalloc(context, ((i64)n)+1); in upperFunc()
479 if( z1 ){ in upperFunc()
481 z1[i] = (char)sqlite3Toupper(z2[i]); in upperFunc()
483 sqlite3_result_text(context, z1, n, sqlite3_free); in upperFunc()
488 char *z1; in lowerFunc() local
497 z1 = contextMalloc(context, ((i64)n)+1); in lowerFunc()
498 if( z1 ){ in lowerFunc()
500 z1[i] = sqlite3Tolower(z2[i]); in lowerFunc()
502 sqlite3_result_text(context, z1, n, sqlite3_free); in lowerFunc()
/sqlite-3.40.0/ext/repair/
H A Dcheckindex.c406 const char *z1; in cidxParseSQL() local
415 z1 = z+1; in cidxParseSQL()
434 while( cidx_isspace(z1[0]) ) z1++; in cidxParseSQL()
437 pCol->zExpr = cidxMprintf(&rc, "%.*s", z-z1, z1); in cidxParseSQL()
439 z = z1 = z2+1; in cidxParseSQL()
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5rank.test133 CREATE VIRTUAL TABLE z1 USING fts5(a, detail=%DETAIL%);
134 INSERT INTO z1 VALUES('wrinkle in time');
135 SELECT * FROM z1 WHERE z1 MATCH 'wrinkle in time OR a wrinkle in time';
/sqlite-3.40.0/ext/lsm1/lsm-test/
H A Dlsmtest2.c102 void testCompareStr(const char *z1, const char *z2, int *pRc){ in testCompareStr() argument
104 if( strcmp(z1, z2) ){ in testCompareStr()
105 testPrintError("testCompareStr: \"%s\" != \"%s\"\n", z1, z2); in testCompareStr()
H A Dlsmtest.h287 void testCompareStr(const char *z1, const char *z2, int *pRc);
/sqlite-3.40.0/ext/session/
H A Dtest_session.c785 const char *z1 = Tcl_GetString(objv[1]); in testSqlite3changesetApply() local
786 int n = strlen(z1); in testSqlite3changesetApply()
787 if( n>1 && n<=12 && 0==sqlite3_strnicmp("-nosavepoint", z1, n) ){ in testSqlite3changesetApply()
794 const char *z1 = Tcl_GetString(objv[1]); in testSqlite3changesetApply() local
795 int n = strlen(z1); in testSqlite3changesetApply()
796 if( n>1 && n<=7 && 0==sqlite3_strnicmp("-invert", z1, n) ){ in testSqlite3changesetApply()
/sqlite-3.40.0/ext/rtree/
H A Drtree9.test26 CREATE VIRTUAL TABLE rt USING rtree(id, x1, x2, y1, y2, z1, z2);
56 CREATE VIRTUAL TABLE rt32 USING rtree_i32(id, x1, x2, y1, y2, z1, z2);
H A Drtreedoc.test61 CREATE VIRTUAL TABLE rt3 USING rtree(id, x1,x2, y1,y2, z1,z2)
67 CREATE VIRTUAL TABLE rt4 USING rtree(id, x1,x2, y1,y2, z1,z2, v1,v2)
73 CREATE VIRTUAL TABLE rt5 USING rtree(id, x1,x2, y1,y2, z1,z2, v1,v2, w1,w2)
84 id, x1,x2, y1,y2, z1,z2, v1,v2, w1,w2, a1,a2
89 id, x1,x2, y1,y2, z1,z2, v1,v2, w1,w2, a1,a2, b1, b2
178 CREATE VIRTUAL TABLE rtI USING rtree_i32(id, x1,x2, y1,y2, z1,z2);
190 foreach {tn x1 x2 y1 y2 z1 z2 ok} {
249 typeof(x1), typeof(x2), typeof(y1), typeof(y2), typeof(z1), typeof(z2)
281 2 t2 "id x1 x2 y1 y2 z1 z2"
1220 # USING rtree_i32(id,x0,x1,y0,y1,z0,z1);
[all …]
H A Drtree3.test226 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2, z1, z2);
/sqlite-3.40.0/ext/wasm/
H A Dtester1.js532 const [z1, z2, z3] = w.scopedAllocPtr(3);
533 T.assert('number'===typeof z1).assert(z2>z1).assert(z3>z2)
534 .assert(0===w.getMemValue(z1,'i32'), 'allocPtr() must zero the targets')

12