Home
last modified time | relevance | path

Searched refs:test1 (Results 1 – 25 of 31) sorted by relevance

12

/sqlite-3.40.0/test/
H A Dupdate.test24 } {1 {no such table: test1}}
42 execsql {SELECT * FROM test1 ORDER BY f1}
63 execsql {UPDATE test1 SET f2=f2*3}
71 db eval {SELECT count(*) FROM test1}
97 execsql {UPDATE test1 SET F2=f1, F1=f2}
104 execsql {UPDATE test1 SET F2=f1, F1=f2}
115 DELETE FROM test1 WHERE f1<=5;
152 SELECT * FROM test1 ORDER BY f1,f2
214 SELECT * FROM test1 ORDER BY f1,f2
403 UPDATE test1 SET x=11 WHERE f1=1025
[all …]
H A Dselect1.test90 execsql {SELECT * FROM test1 AS a, test1 AS b}
424 } {0 {test1.f1 11 test1.f1 33}}
469 } {0 {test1.f1+F2 33 test1.f1+F2 77}}
475 } {0 {test1.f1+F2 33 test1.f1+F2 77}}
518 SELECT test1 . f1, test1 . f2 FROM test1 LIMIT 1
520 } {{test1 . f1} 11 {test1 . f2} 22}
527 SELECT test1 . f1, test1 . f2 FROM test1 LIMIT 1
529 } {test1.f1 11 test1.f2 22}
562 } {test1.f1 11 test1.f2 22}
576 } {test1.f1 11 test1.f2 22}
[all …]
H A Dindex.test25 } {index1 test1}
29 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
35 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
40 } {index1 test1}
45 execsql {DROP TABLE test1}
69 execsql {DROP TABLE test1}
101 execsql {DROP TABLE test1}
122 } {index9 indext test1}
190 } {index1 test1 test2}
200 } {index1 test1 test2}
[all …]
H A Dinsert.test23 } {1 {no such table: test1}}
57 } {1 {table test1 has no column named four}}
62 execsql {INSERT INTO test1 VALUES(1,2,3)}
63 execsql {SELECT * FROM test1}
66 execsql {INSERT INTO test1 VALUES(4,5,6)}
67 execsql {SELECT * FROM test1 ORDER BY one}
70 execsql {INSERT INTO test1 VALUES(7,8,9)}
71 execsql {SELECT * FROM test1 ORDER BY one}
75 execsql {DELETE FROM test1}
77 execsql {SELECT * FROM test1 ORDER BY one}
[all …]
H A Dtrigger4.test24 create table test1(id integer primary key,a);
27 select test1.id as id,a as a,b as b
28 from test1 join test2 on test2.id = test1.id;
31 insert into test1 (id,a) values (NEW.id,NEW.a);
35 select * from test1;
48 select * from test1;
61 update test1 set a=NEW.a where id=NEW.id;
65 select * from test1;
78 select * from test1;
107 select * from test1;
[all …]
H A DcrashM.test28 foreach f [glob -nocomplain test1.* test2.*] { forcedelete $f }
30 sqlite3 db file:test1.db?8_3_names=1
57 crashsql -delay 1 -file test1.db -opendb {
61 sqlite3 db file:test1.db?8_3_names=1
H A Dshared4.test32 forcedelete test1.db test1.db-journal
36 sqlite3 db1 test1.db
64 ATTACH DATABASE 'test1.db' AS one;
67 ATTACH DATABASE 'test1.db' AS one;
74 ATTACH DATABASE 'test1.db' AS one;
H A Dtable.test22 CREATE TABLE test1 (
30 } {{CREATE TABLE test1 (
40 } {test1 test1 table}
49 } {test1 test1 table}
54 execsql {DROP TABLE test1}
78 execsql {CREATE TABLE test1("f1 ho" int)}
80 } {test1}
299 execsql {EXPLAIN CREATE TABLE test1(f1 int)}
307 execsql {CREATE TABLE test1(f1 int)}
309 execsql {EXPLAIN DROP TABLE test1}
[all …]
H A Dzipfile2.test218 INSERT INTO temp.zip (name,data) VALUES ('test1','test');
222 UPDATE temp.zip SET name='test1' WHERE name='test2'
223 } {1 {duplicate name: "test1"}}
237 INSERT INTO temp.zip (name,data) VALUES ('test1','test');
239 UPDATE OR REPLACE zip SET name='test2' WHERE name='test1';
H A Dicu.test25 execsql {CREATE TABLE test1(i1 int, i2 int, r1 real, r2 real, t1 text, t2 text)}
26 execsql {INSERT INTO test1 VALUES(1,2,1.1,2.2,'hello','world')}
31 UPDATE test1 SET %s;
32 SELECT %s FROM test1;
H A Dshared.test426 foreach db [list test.db test1.db test2.db test3.db] {
433 ATTACH 'test1.db' AS test1;
440 ATTACH 'test1.db' AS test1;
445 CREATE TABLE test1.t1(a, b);
446 CREATE INDEX test1.i1 ON t1(a, b);
452 CREATE VIEW test1.v1 AS SELECT * FROM t1;
1130 forcedelete test1.db test2.db
1131 sqlite3 db1 file:test1.db?mode=memory -uri 1
1141 file exists test1.db
1151 sqlite3 db test1.db
[all …]
H A Dview.test336 CREATE TABLE test1(id integer primary key, a);
338 INSERT INTO test1 VALUES(1,2);
341 SELECT test1.id, a, b
342 FROM test1 JOIN test2 ON test2.id=test1.id;
357 SELECT test1.id, a, b
358 FROM test1 JOIN test2 USING(id);
373 SELECT test1.id, a, b
374 FROM test1 NATURAL JOIN test2;
H A Dmjournal.test69 forcedelete test.db2-master test.db-journal test1
79 close [open test1 w]
80 hexio_write test1 0 abcd
H A Dexpr.test27 execsql {INSERT INTO test1 VALUES(1,2,'hello','world')}
32 execsql {BEGIN; UPDATE test1 SET %s; SELECT %s FROM test1; ROLLBACK;}
37 execsql {BEGIN; UPDATE test1 SET %s; SELECT %s FROM test1; ROLLBACK;}
740 execsql {DROP TABLE test1}
741 execsql {CREATE TABLE test1(a int, b int);}
743 execsql "INSERT INTO test1 VALUES($i,[expr {1<<$i}])"
745 execsql "INSERT INTO test1 VALUES(NULL,0)"
747 execsql {SELECT * FROM test1 ORDER BY a}
752 execsql {SELECT a FROM test1 WHERE %s ORDER BY a}
936 SELECT (CASE a>4 THEN 1 ELSE 0 END) FROM test1;
[all …]
H A Dauth.test1666 db eval {DETACH test1}
1672 db eval {DETACH test1}
1677 catchsql {DETACH DATABASE test1}
1693 catchsql {DETACH DATABASE test1}
1718 DETACH DATABASE test1;
1734 DETACH DATABASE test1;
1741 } {test1}
1752 DETACH DATABASE test1;
1758 } {test1}
1761 execsql {DETACH DATABASE test1}
[all …]
H A Dzipfile.test534 forcedelete test1.zip test2.zip
542 SELECT writefile('test1.zip', rt( zipfile(name, NULL, mtime, data) ) ),
548 exec $::UNZIP -d test_unzip test1.zip
570 SELECT name, mtime, data FROM zipfile('test1.zip')
H A Dindex7.test268 INSERT INTO t3(a,b) VALUES(150, 'test1');
275 INSERT INTO t3(a,b) VALUES(999, 'test1'), (999, 'test2');
H A Ddelete.test22 set v [catch {execsql {DELETE FROM test1}} msg]
24 } {1 {no such table: test1}}
H A Dincrvacuum.test334 forcedelete test1.db test1.db-journal test2.db test2.db-journal
335 sqlite3 db1 test1.db
H A Dindex6.test225 INSERT INTO t3(a,b) VALUES(150, 'test1');
232 INSERT INTO t3(a,b) VALUES(999, 'test1'), (999, 'test2');
H A Dcapi3.test248 # check_header test1.1 {1 2 3} {"" "" ""}
347 # check_header test1.1 {1 2 3} {"" "" ""}
442 # check_data test1.2 {TEXT REAL NULL} {0 1 0} {0 1.1 0} {hello 1.1 {}}
H A Dcapi3c.test229 # check_header test1.1 {1 2 3} {"" "" ""}
328 # check_header test1.1 {1 2 3} {"" "" ""}
424 # check_data test1.2 {TEXT REAL NULL} {0 1 0} {0 1.1 0} {hello 1.1 {}}
H A Dattach2.test93 # but we can still read from test1.db even though test2.db is locked.
H A Deqp.test638 # documentation page eqp.html works. The C code is duplicated in test1.c
/sqlite-3.40.0/ext/wasm/
H A Dscratchpad-wasmfs-main.js26 const test1 = function(db){ function
56 test1

12