Home
last modified time | relevance | path

Searched refs:test2 (Results 1 – 22 of 22) sorted by relevance

/titanic_44/usr/src/lib/libsqlite/test/
H A Dtrigger4.test22 create table test2(id integer,b);
25 from test1 join test2 on test2.id = test1.id;
29 insert into test2 (id,b) values (NEW.id,NEW.b);
37 select * from test2;
50 select * from test2;
59 update test2 set b=NEW.b where id=NEW.id;
67 select * from test2;
80 select * from test2;
86 drop table test2;
89 } {1 {no such table: main.test2}}
[all …]
H A Dattach2.test32 file delete -force test2.db
33 file delete -force test2.db-journal
34 sqlite db2 test2.db
40 ATTACH 'test2.db' AS t2;
55 # lock test2.db then try to attach it. Should get an error.
58 ATTACH 'test2.db' AS t2;
62 # make sure test2.db did not get attached.
66 # unlock test2.db and try to attach again. should work this time.
69 ATTACH 'test2.db' AS t2;
81 # lock test2.db and try to read from it. should get an error.
[all …]
H A Dinsert.test96 CREATE TABLE test2(
103 execsql {SELECT * from test2}
106 execsql {INSERT INTO test2(f1,f3) VALUES(+10,-10)}
107 execsql {SELECT * FROM test2}
110 execsql {INSERT INTO test2(f2,f4) VALUES(1.23,-3.45)}
111 execsql {SELECT * FROM test2 WHERE f1==-111}
114 execsql {INSERT INTO test2(f1,f2,f4) VALUES(77,+1.23,3.45)}
115 execsql {SELECT * FROM test2 WHERE f1==77}
119 DROP TABLE test2;
120 CREATE TABLE test2(
[all …]
H A Dbtree2.test38 file delete -force test2.bt
39 file delete -force test2.bt-journal
40 set ::b [btree_open test2.bt]
285 set hash [md5file test2.bt]
303 md5file test2.bt
347 set hash [md5file test2.bt]
349 set ::b [btree_open test2.bt]
365 # exec cp test2.bt test2.bt.bu1
379 md5file test2.bt
381 # exec cp test2.bt test2.bt.bu2
[all …]
H A Dselect1.test32 set v [catch {execsql {SELECT * FROM test1, test2}} msg]
34 } {1 {no such table: test2}}
36 set v [catch {execsql {SELECT * FROM test2, test1}} msg]
38 } {1 {no such table: test2}}
70 execsql {CREATE TABLE test2(r1 real, r2 real)}
71 execsql {INSERT INTO test2(r1,r2) VALUES(1.1,2.2)}
74 execsql {SELECT * FROM test1, test2}
77 execsql {SELECT *, 'hi' FROM test1, test2}
80 execsql {SELECT 'one', *, 'two', * FROM test1, test2}
83 execsql {SELECT test1.f1, test2.r1 FROM test1, test2}
[all …]
H A Dattach.test38 sqlite db2 test2.db
48 ATTACH DATABASE 'test2.db' AS two;
233 ATTACH 'test2.db' AS db2;
293 ATTACH 'test2.db' AS db2;
302 sqlite db2 test2.db
314 ATTACH DATABASE 'test2.db' AS db2;
319 # Even though main has a transaction, test2.db should not be locked.
327 # Reading from db2 should not lock test2.db
335 # Making a change to db2 causes test2.ddb to become locked.
383 sqlite db2 test2.db
[all …]
H A Dmisuse.test28 catch {file delete -force test2.db}
29 set ::DB [sqlite db test2.db]
69 set ::DB [sqlite db test2.db]
98 set ::DB [sqlite db test2.db]
127 set ::DB [sqlite db test2.db]
156 set ::DB [sqlite db test2.db]
H A Dview.test260 CREATE TABLE test2(id integer, b);
262 INSERT INTO test2 VALUES(1,3);
265 FROM test1 JOIN test2 ON test2.id=test1.id;
281 FROM test1 JOIN test2 USING(id);
297 FROM test1 NATURAL JOIN test2;
H A Dtable.test96 set v [catch {execsql {CREATE TABLE test2(two text)}} msg]
98 } {1 {table test2 already exists}}
110 execsql {DROP TABLE test2; SELECT name FROM sqlite_master WHERE type!='meta'}
116 execsql {CREATE TABLE test2(one text); CREATE INDEX test3 ON test2(one)}
128 } {test2 test3}
136 } {test2 test3}
138 execsql {DROP TABLE test2; DROP TABLE test3}
H A Dindex.test176 execsql {CREATE TABLE test2(g1 real, g2 real)}
178 set v [catch {execsql {CREATE INDEX index1 ON test2(g1)}} msg]
183 } {index1 test1 test2}
185 set v [catch {execsql {CREATE INDEX test1 ON test2(g1)}} msg]
190 } {index1 test1 test2}
193 execsql {DROP TABLE test2}
H A Dcopy.test131 execsql {CREATE TABLE test2(a int, x text)}
135 execsql {COPY test2 FROM 'data21.txt'}
136 execsql {SELECT x from test2}
H A Dtrigger1.test432 file delete -force test2.db
433 file delete -force test2.db-journal
434 sqlite db2 test2.db
438 ATTACH 'test2.db' AS aux;
H A Dformat3.test727 file delete -force test2.db
728 sqlite db2 test2.db
736 ATTACH DATABASE 'test2.db' AS test2;
H A Dmisc1.test502 CREATE TABLE test2(a text primary key, b text, primary key(a,b));
504 } {1 {table "test2" has more than one primary key}}
H A Dupdate.test55 set v [catch {execsql {UPDATE test1 SET f1=test2.f1*2 WHERE f2==32}} msg]
57 } {1 {no such column: test2.f1}}
/titanic_44/usr/src/lib/efcode/fcode_test/
H A Diftest.fth78 : if-test2 ( x x x -- )
110 " if-test2.0" 0 0 0 if-test2 0 = .passed?
111 " if-test2.1" 1 0 0 if-test2 1 = .passed?
112 " if-test2.2" 0 1 0 if-test2 2 = .passed?
113 " if-test2.3" 1 1 0 if-test2 3 = .passed?
114 " if-test2.4" 0 0 1 if-test2 4 = .passed?
115 " if-test2.5" 1 0 1 if-test2 5 = .passed?
116 " if-test2.6" 0 1 1 if-test2 6 = .passed?
117 " if-test2.7" 1 1 1 if-test2 7 = .passed?
H A Daccess.fth30 0 value end-test2
40 here to end-test2
46 " ,+" end-test cell+ end-test2 = .passed?
/titanic_44/usr/src/cmd/sgs/libelf/demo/
H A DMakefile45 test: test1 test2 test3 test4 test5 test6
56 test2: dcom pcom FRC target
63 test3: pcom acom test2 FRC
/titanic_44/usr/src/test/util-tests/tests/xargs/
H A Dxargs_test.ksh55 test2() { function
56 t=test2
246 test2
/titanic_44/usr/src/lib/libsqlite/
H A DMakefile.com128 $(SRCDIR)/test2.c \
134 TESTCLEAN = $(TESTOBJS) test.db test.tcl test1.bt test2.db testdb
H A Dmain.mk116 $(TOP)/src/test2.c \
/titanic_44/usr/src/cmd/perl/contrib/Sun/Solaris/Project/t/
H A DProject.t213 user.test2:456:project two:adm,uucp:staff:attr1=p;attr2=q
224 user.test2:456:project two:adm,uucp:staff:attr1=p;attr2=q
235 user.test2:456:project two:adm,uucp:staff:attr1=p;attr2=q
251 user.test2:456:project two:adm,uucp:staff:attr1=p;attr2=q
262 user.test2:456:project two:adm,uucp:staff:attr1=p;attr2=q