Home
last modified time | relevance | path

Searched refs:tx (Results 1 – 25 of 36) sorted by relevance

12

/sqlite-3.40.0/ext/fts5/test/
H A Dfts5delete.test97 CREATE VIRTUAL TABLE tx USING fts5(a, b, c, d, content=);
98 INSERT INTO tx(rowid, a, c) VALUES(1, 'abc def', 'a b c');
99 INSERT INTO tx(rowid, a, c) VALUES(5, 'a b c', 'a b d def');
102 INSERT INTO tx(tx, rowid, a, b, c, d)
106 INSERT INTO tx(tx) VALUES('integrity-check');
109 INSERT INTO tx(tx, rowid, a, b, c, d)
113 INSERT INTO tx(tx) VALUES('integrity-check');
H A Dfts5vocab.test260 CREATE VIRTUAL TABLE tx USING fts5(one, two, detail=%DETAIL%);
261 INSERT INTO tx VALUES('g a ggg g a b eee', 'cc d aa ff g ee');
262 INSERT INTO tx VALUES('dd fff i a i jjj', 'f fff hh jj e f');
263 INSERT INTO tx VALUES('ggg a f f fff dd aa', 'd ggg f f j gg ddd');
264 INSERT INTO tx VALUES('e bb h jjj ii gg', 'e aa e f c fff');
265 INSERT INTO tx VALUES('j ff aa a h', 'h a j bbb bb');
268 INSERT INTO tx VALUES('hhh hhh hhh bb fff f', 'fff gg aa ii h a');
274 INSERT INTO tx VALUES('c jjj hh ddd dd h', 'e aaa h jjj gg');
276 CREATE VIRTUAL TABLE txr USING fts5vocab(tx, row);
277 CREATE VIRTUAL TABLE txc USING fts5vocab(tx, col);
[all …]
H A Dfts5doclist.test49 CREATE VIRTUAL TABLE tx USING fts5(x);
55 INSERT INTO tx(rowid, x) VALUES(-9000000000000000000, $doc);
56 INSERT INTO tx(rowid, x) VALUES(9000000000000000000, $doc);
61 SELECT rowid FROM tx('abc');
/sqlite-3.40.0/tool/
H A Dvdbe_profile.tcl55 foreach {cx tx detail} $stat($stmt,$addr) break
57 incr tx $t
58 set stat($stmt,$addr) [list $cx $tx $detail]
70 foreach {cx tx detail} $stat($stmt,$i) break
76 puts [format {%8d %12d %12d %4d %s} $cx $tx $ax $i $detail]
83 set tx $opcycle($op)
89 puts [format {%8d %12d %12d %s} $cx $tx $ax $op]
/sqlite-3.40.0/test/
H A Dattach.test273 CREATE TABLE tx(x1,x2,y1,y2);
277 SELECT * FROM tx;
283 SELECT * FROM tx;
289 SELECT * FROM tx;
300 SELECT * FROM db2.tx;
305 SELECT * FROM main.tx;
312 } {table t2 t2 table tx tx trigger r1 t2}
335 } {table t2 t2 table tx tx trigger r1 t2 index i2 t2}
361 } {table t1 t1 table tx tx}
366 } {table t2 t2 table tx tx trigger r1 t2 index i2 t2}
[all …]
H A Dwhere2.test560 SELECT w FROM tx
568 SELECT w FROM tx
576 SELECT w FROM tx
584 SELECT w FROM tx
592 SELECT w FROM tx
600 SELECT w FROM tx
608 SELECT w FROM tx
616 SELECT w FROM tx
624 SELECT w FROM tx
632 SELECT w FROM tx
[all …]
H A Dnulls1.test126 CREATE TABLE tx(a INTEGER PRIMARY KEY, b, c);
127 CREATE INDEX i1 ON tx(b);
128 INSERT INTO tx VALUES(1, 1, 1);
129 INSERT INTO tx VALUES(2, NULL, 2);
130 INSERT INTO tx VALUES(3, 3, 3);
131 INSERT INTO tx VALUES(4, NULL, 4);
132 INSERT INTO tx VALUES(5, 5, 5);
133 CREATE VIRTUAL TABLE te USING echo(tx);
137 SELECT * FROM tx ORDER BY b NULLS FIRST;
144 SELECT * FROM tx ORDER BY b NULLS LAST;
H A Dtemptable2.test295 CREATE TABLE tx(a, b);
296 CREATE INDEX i1 ON tx(a);
297 CREATE INDEX i2 ON tx(b);
299 INSERT INTO tx SELECT randomblob(100), randomblob(100) FROM x;
303 do_execsql_test 9.$tn.$i.1 { DELETE FROM tx WHERE (random()%3)==0 }
309 INSERT INTO tx SELECT randomblob(100), randomblob(100) FROM x;
316 DELETE FROM tx WHERE (random()%3)==0;
318 INSERT INTO tx SELECT randomblob(100), randomblob(100) FROM x;
H A Dvacuum6.test88 CREATE TABLE tx(a, b);
89 CREATE INDEX i1 ON tx(b);
93 INSERT INTO tx SELECT i, randomblob(i) FROM s;
95 SELECT sum(length(b)) FROM tx;
H A Dselect7.test48 CREATE VIEW tv1 AS SELECT x.id, tx.id FROM x JOIN tempx tx ON tx.id=x.id;
49 CREATE VIEW tv1b AS SELECT x.id, tx.id FROM x JOIN tempx tx on tx.id=x.id;
H A Djoin6.test151 CREATE TABLE tx(a, b, c, d, e, f, g, h, i, j, k, l, m, n, o PRIMARY KEY)
153 INSERT INTO tx VALUES(
158 SELECT o FROM tx NATURAL JOIN tx;
H A DcorruptM.test58 UPDATE sqlite_master SET tbl_name='tx' WHERE name='t1';
60 } {table t1 tx | index i1 t1 | view v2 v2 | trigger r1 t1 |}
109 UPDATE sqlite_master SET tbl_name='tx' WHERE name='i1';
111 } {table t1 t1 | index i1 tx | view v2 v2 | trigger r1 t1 |}
H A Daggnested.test262 DROP TABLE IF EXISTS tx;
264 CREATE TABLE tx(x INT);
265 INSERT INTO tx VALUES(1),(2),(3),(4),(5);
268 SELECT min((SELECT count(y) FROM ty)) FROM tx;
271 SELECT max((SELECT a FROM (SELECT count(*) AS a FROM ty) AS s)) FROM tx;
H A Djournal3.test31 do_test journal3-1.1 { execsql { CREATE TABLE tx(y, z) } } {}
56 INSERT INTO tx DEFAULT VALUES;
H A Dfts3fault2.test69 CREATE VIRTUAL TABLE tx USING fts4(a, b);
70 INSERT INTO tx VALUES('a b c', 'x y z');
71 CREATE VIRTUAL TABLE terms2 USING fts4aux(tx);
H A Dauth.test947 CREATE TABLE tx(id);
974 SELECT * FROM tx;
979 } {t2 tx r2}
1084 } {t2 tx r2}
1100 } {t2 tx r2}
1112 } {t2 tx r2}
1128 } {t2 tx r2}
1144 DROP TABLE tx;
2367 SELECT * FROM tx;
2378 DELETE FROM tx;
[all …]
H A Dwindow8.tcl425 CREATE TABLE tx(a INTEGER PRIMARY KEY);
426 INSERT INTO tx VALUES(1), (2), (3), (4), (5), (6);
444 SELECT sum(a) OVER win FROM tx
467 SELECT sum(a) OVER win FROM tx
H A Ddate3.test102 WITH tx(timeval,datetime) AS (
107 SELECT datetime(timeval,'auto') == datetime FROM tx;
H A Dselect4.test923 DROP TABLE IF EXISTS tx;
924 CREATE TABLE tx(id INTEGER PRIMARY KEY, a, b);
925 INSERT INTO tx(a,b) VALUES(33,456);
926 INSERT INTO tx(a,b) VALUES(33,789);
929 FROM tx AS t0, tx AS t1
933 FROM tx AS t0, tx AS t1
H A Dorderby6.test87 foreach {tx limit offset orderby} {
124 do_test $tn.21.$tx {db eval $::sql2} [db eval $sql1]
H A Dstat.test209 CREATE TABLE tx(y);
226 } {sqlite_schema NULL 1 NULL 1 34 878 34 | tx NULL 1 NULL 0 0 1016 0 |}
H A DtriggerB.test30 CREATE TEMP TRIGGER tx INSTEAD OF UPDATE OF y ON vx
/sqlite-3.40.0/ext/rbu/
H A Drbuvacuum.test311 CREATE TABLE tx(a PRIMARY KEY, b BLOB);
312 INSERT INTO tx VALUES(1, randomblob(900));
313 INSERT INTO tx SELECT a+1, randomblob(900) FROM tx;
314 INSERT INTO tx SELECT a+2, randomblob(900) FROM tx;
315 INSERT INTO tx SELECT a+4, randomblob(900) FROM tx;
316 INSERT INTO tx SELECT a+8, randomblob(900) FROM tx;
327 execsql { INSERT INTO tx VALUES(20, 20) }
/sqlite-3.40.0/src/
H A Ddate.c857 DateTime tx; in parseModifier() local
860 memset(&tx, 0, sizeof(tx)); in parseModifier()
861 if( parseHhMmSs(z2, &tx) ) break; in parseModifier()
862 computeJD(&tx); in parseModifier()
863 tx.iJD -= 43200000; in parseModifier()
864 day = tx.iJD/86400000; in parseModifier()
865 tx.iJD -= day*86400000; in parseModifier()
866 if( z[0]=='-' ) tx.iJD = -tx.iJD; in parseModifier()
869 p->iJD += tx.iJD; in parseModifier()
/sqlite-3.40.0/ext/wasm/
H A Dbatch-runner.js39 db.handle.transaction(function(tx){ argument
41 const callback = function(tx, result){ argument
53 tx.executeSql(sql2, [], ()=>{}, onErr);
62 tx.executeSql(sqlToDrop, [], callback, onErr);
169 const transaction = function(tx){ argument
180 tx.executeSql(s,[], ()=>{}, (t,e)=>{
486 d.handle.transaction(function(tx){ argument
487 tx.executeSql("PRAGMA cache_size="+cacheSize);

12