Home
last modified time | relevance | path

Searched refs:zz (Results 1 – 15 of 15) sorted by relevance

/sqlite-3.40.0/ext/fts5/test/
H A Dfts5integrity.test44 INSERT INTO zz(zz, rank) VALUES('pgsz', 32);
46 INSERT INTO zz SELECT z FROM zz;
47 INSERT INTO zz SELECT z FROM zz;
48 INSERT INTO zz SELECT z FROM zz;
49 INSERT INTO zz SELECT z FROM zz;
50 INSERT INTO zz SELECT z FROM zz;
51 INSERT INTO zz SELECT z FROM zz;
52 INSERT INTO zz(zz) VALUES('optimize');
55 do_execsql_test 3.1 { INSERT INTO zz(zz) VALUES('integrity-check'); }
66 INSERT INTO aa(zz) VALUES('a b');
[all …]
H A Dfts5simple3.test99 SELECT * FROM t1('"xy zz" OR "ab cd" *');
102 SELECT * FROM t1('"xy zz" OR "xy zz" *');
105 SELECT * FROM t1('"ab cd" OR "xy zz" *');
H A Dfts5alter.test63 CREATE VIRTUAL TABLE zz USING fts5(a);
64 INSERT INTO zz(rowid, a) VALUES(-56, 'a b c');
66 INSERT INTO zz(rowid, a) VALUES(-22, 'a b c');
67 ALTER TABLE zz RENAME TO yy;
/sqlite-3.40.0/test/
H A Dzipfile.test169 PRAGMA table_info(zz);
193 INSERT INTO zz(name, data, method)
247 SELECT name FROM zz;
251 SELECT name FROM zz;
254 SELECT data FROM zz WHERE name='i.txt';
258 DELETE FROM zz WHERE name='g.txt';
259 SELECT name FROM zz;
348 FROM zz AS a, zz AS b
364 DELETE FROM zz;
365 SELECT * FROM zz;
[all …]
H A DwhereL.test79 zz INTEGER
82 CREATE UNIQUE INDEX x4 ON C(yy, zz);
85 INSERT INTO C(id,xx,yy,zz) VALUES(99,50,1,2);
88 (SELECT id,xx,yy,zz FROM C) subq,
92 AND B.id=subq.zz;
97 (SELECT id,xx,yy,zz FROM C) subq,
101 AND B.id=subq.zz;
106 (SELECT id,yy,zz FROM C) subq,
110 AND B.id=subq.zz;
H A Dsnapshot.test347 INSERT INTO x1 VALUES('z', 'zz', 'zzz');
350 } {wal z zz zzz}
387 INSERT INTO x1 VALUES('z', 'zz', 'zzz');
403 } {z zz zzz}
411 } {z zz zzz}
H A Dupfrom3.test111 CREATE TABLE x2(o, n, zz);
114 UPDATE OR IGNORE t1 SET x=n, z=zz FROM x2 WHERE x=o;
124 UPDATE OR REPLACE t1 SET x=n, z=zz FROM x2 WHERE x=o;
H A Dlike.test567 INSERT INTO t2 VALUES('zz-lower-lower');
570 SELECT x FROM t2 WHERE x LIKE 'zz%';
572 } {zz-lower-lower zZ-lower-upper Zz-upper-lower ZZ-upper-upper nosort {} i2}
577 } {zz-lower-lower zZ-lower-upper Zz-upper-lower ZZ-upper-upper nosort {} i2}
582 } {zz-lower-lower zZ-lower-upper Zz-upper-lower ZZ-upper-upper nosort {} i2}
587 } {zz-lower-lower zZ-lower-upper Zz-upper-lower ZZ-upper-upper nosort {} i2}
596 INSERT INTO t3 VALUES('zz-lower-lower');
599 SELECT x FROM t3 WHERE x LIKE 'zz%';
601 } {zz-lower-lower nosort {} i3}
H A Dupsert4.test293 CREATE UNIQUE INDEX zz ON t1(z);
297 CREATE UNIQUE INDEX zz ON t1(z);
335 CREATE UNIQUE INDEX zz ON excluded(z);
340 CREATE UNIQUE INDEX zz ON excluded(z);
H A Dpager1.test1586 CREATE TABLE zz(top PRIMARY KEY);
1587 INSERT INTO zz VALUES(a_string(222));
1588 INSERT INTO zz SELECT a_string((SELECT 222+max(rowid) FROM zz)) FROM zz;
1589 INSERT INTO zz SELECT a_string((SELECT 222+max(rowid) FROM zz)) FROM zz;
1590 INSERT INTO zz SELECT a_string((SELECT 222+max(rowid) FROM zz)) FROM zz;
1591 INSERT INTO zz SELECT a_string((SELECT 222+max(rowid) FROM zz)) FROM zz;
1592 INSERT INTO zz SELECT a_string((SELECT 222+max(rowid) FROM zz)) FROM zz;
1595 UPDATE zz SET top = a_string(345);
1615 do_execsql_test pager1-11.5 { SELECT count(*) FROM zz } {32}
H A Daltercol.test594 ON CONFLICT (x) DO UPDATE SET z=zz+1;
596 } {no such column: zz}
806 ALTER TABLE t1 RENAME cc TO zz;
808 } {{CREATE TABLE t1(xx UNIQUE,yy UNIQUE,zz UNIQUE,UNIQUE(xx),PRIMARY KEY(yy),UNIQUE(zz))}}
H A Dwalfault.test338 CREATE TABLE z(zz INTEGER PRIMARY KEY, zzz BLOB);
358 set ::stmt [sqlite3_prepare db "SELECT zzz FROM z WHERE zz IN (1, 2, 3)" -1]
H A Dfuzzcheck.c1976 const char *zz; in main() local
1978 for(ii=0; (zz = sqlite3_compileoption_get(ii))!=0; ii++){ in main()
1979 printf("%s\n", zz); in main()
H A Dfuzzer1.test1790 INSERT INTO x4_rules VALUES(0, 'bx', 'zz', 20);
1792 INSERT INTO x4_rules VALUES(0, 'zz', '!!', 50);
1798 } {ax 0 bx 10 cx 11 yy 26 zz 30 !! 80}
/sqlite-3.40.0/tool/
H A Dmkautoconfamal.sh38 zz=0
40 zz=`echo $VERSION|sed 's/3\.[^.]*\.[^.]*\.\([0-9]*\).*/\1/'|grep -v '\.'`
42 TARBALLNAME=`printf "sqlite-autoconf-3%.2d%.2d%.2d" $xx $yy $zz`