| /illumos-gate/usr/src/lib/libsqlite/test/ |
| H A D | trigger4.test | 20 create table test2(id integer,b);
23 from test1 join test2 on test2.id = test1.id;
27 insert into test2 (id,b) values (NEW.id,NEW.b);
35 select * from test2;
48 select * from test2;
57 update test2 set b=NEW.b where id=NEW.id;
65 select * from test2;
78 select * from test2;
84 drop table test2;
87 } {1 {no such table: main.test2}}
[all …]
|
| H A D | attach2.test | 30 file delete -force test2.db
31 file delete -force test2.db-journal
32 sqlite db2 test2.db
38 ATTACH 'test2.db' AS t2;
53 # lock test2.db then try to attach it. Should get an error.
56 ATTACH 'test2.db' AS t2;
60 # make sure test2.db did not get attached.
64 # unlock test2.db and try to attach again. should work this time.
67 ATTACH 'test2.db' AS t2;
79 # lock test2.db and try to read from it. should get an error.
[all …]
|
| H A D | insert.test | 94 CREATE TABLE test2(
101 execsql {SELECT * from test2}
104 execsql {INSERT INTO test2(f1,f3) VALUES(+10,-10)}
105 execsql {SELECT * FROM test2}
108 execsql {INSERT INTO test2(f2,f4) VALUES(1.23,-3.45)}
109 execsql {SELECT * FROM test2 WHERE f1==-111}
112 execsql {INSERT INTO test2(f1,f2,f4) VALUES(77,+1.23,3.45)}
113 execsql {SELECT * FROM test2 WHERE f1==77}
117 DROP TABLE test2;
118 CREATE TABLE test2(
[all …]
|
| H A D | btree2.test | 36 file delete -force test2.bt
37 file delete -force test2.bt-journal
38 set ::b [btree_open test2.bt]
283 set hash [md5file test2.bt]
301 md5file test2.bt
345 set hash [md5file test2.bt]
347 set ::b [btree_open test2.bt]
363 # exec cp test2.bt test2.bt.bu1
377 md5file test2.bt
379 # exec cp test2.bt test2.bt.bu2
[all …]
|
| H A D | select1.test | 30 set v [catch {execsql {SELECT * FROM test1, test2}} msg]
32 } {1 {no such table: test2}}
34 set v [catch {execsql {SELECT * FROM test2, test1}} msg]
36 } {1 {no such table: test2}}
68 execsql {CREATE TABLE test2(r1 real, r2 real)}
69 execsql {INSERT INTO test2(r1,r2) VALUES(1.1,2.2)}
72 execsql {SELECT * FROM test1, test2}
75 execsql {SELECT *, 'hi' FROM test1, test2}
78 execsql {SELECT 'one', *, 'two', * FROM test1, test2}
81 execsql {SELECT test1.f1, test2.r1 FROM test1, test2}
[all …]
|
| H A D | attach.test | 36 sqlite db2 test2.db
46 ATTACH DATABASE 'test2.db' AS two;
231 ATTACH 'test2.db' AS db2;
291 ATTACH 'test2.db' AS db2;
300 sqlite db2 test2.db
312 ATTACH DATABASE 'test2.db' AS db2;
317 # Even though main has a transaction, test2.db should not be locked.
325 # Reading from db2 should not lock test2.db
333 # Making a change to db2 causes test2.ddb to become locked.
381 sqlite db2 test2.db
[all …]
|
| H A D | misuse.test | 26 catch {file delete -force test2.db}
27 set ::DB [sqlite db test2.db]
67 set ::DB [sqlite db test2.db]
96 set ::DB [sqlite db test2.db]
125 set ::DB [sqlite db test2.db]
154 set ::DB [sqlite db test2.db]
|
| H A D | view.test | 258 CREATE TABLE test2(id integer, b);
260 INSERT INTO test2 VALUES(1,3);
263 FROM test1 JOIN test2 ON test2.id=test1.id;
279 FROM test1 JOIN test2 USING(id);
295 FROM test1 NATURAL JOIN test2;
|
| H A D | table.test | 94 set v [catch {execsql {CREATE TABLE test2(two text)}} msg]
96 } {1 {table test2 already exists}}
108 execsql {DROP TABLE test2; SELECT name FROM sqlite_master WHERE type!='meta'}
114 execsql {CREATE TABLE test2(one text); CREATE INDEX test3 ON test2(one)}
126 } {test2 test3}
134 } {test2 test3}
136 execsql {DROP TABLE test2; DROP TABLE test3}
|
| /illumos-gate/usr/src/tools/smatch/src/validation/ |
| H A D | sm_implied9.c | 7 int test2; in func() local
9 if (({int test2 = !!(y < 0 || y >= 10); frob(); frob(); frob(); test2;})) in func()
14 test2 = (y < 3 || y >= 5); in func()
15 if (test2) in func()
|
| H A D | sm_implied10.c | 9 if (({int test2 = !!(!y || !*y); frob(); frob(); frob(); test2;})) in func()
14 if (({int test2 = !!(offset >= 10u || x[offset] == 1); frob(); frob(); frob(); test2;})) in func()
|
| H A D | sm_implied8.c | 5 int test, test2; variable
16 if (({test2 = !(x == 3); frob(); frob(); frob(); test2;})) in func()
|
| /illumos-gate/usr/src/test/util-tests/tests/grep_xpg4/ |
| H A D | grep_test.ksh | 210 run_tests 0 t1 a test0 test1 test2 test3 test4 test5 test6 test7
211 run_tests 0 t1 -E a test0 test1 test2 test3 test4 test5 test6 test7
212 run_tests 0 t1 -F a test0 test1 test2 test3 test4 test5 test6 test7
214 run_tests 0 t1 a test0 test1 test2 test3 test4 test5 test6 test7
215 run_tests 0 t1 -E a test0 test1 test2 test3 test4 test5 test6 test7
216 run_tests 0 t1 -F a test0 test1 test2 test3 test4 test5 test6 test7
|
| /illumos-gate/usr/src/test/util-tests/tests/awk/gnu/ |
| H A D | arrayref.awk | 3 test2(foo2); print foo2[1]
8 test2(foo)
10 function test2(bar) function
|
| /illumos-gate/usr/src/test/util-tests/tests/awk/syn/ |
| H A D | gsubasgn.awk | 8 function test2 () { gsub(/a/, "x", test2) } function
9 BEGIN { test2() } function
|
| /illumos-gate/usr/src/cmd/sgs/libelf/demo/ |
| H A D | Makefile | 45 test: test1 test2 test3 test4 test5 test6
56 test2: dcom pcom FRC target
63 test3: pcom acom test2 FRC
|
| /illumos-gate/usr/src/contrib/ast/src/cmd/ksh93/tests/ |
| H A D | statics.sh | 85 function test2 function
654 test2
|
| /illumos-gate/usr/src/test/util-tests/tests/xargs/ |
| H A D | xargs_test.ksh | 56 test2() { function
57 t=test2
280 test2
|
| /illumos-gate/usr/src/test/util-tests/tests/grep_xpg4/files/ |
| H A D | gout.t1.4 | 148 test2:0
149 test2:1
150 test2:2
151 test2:3
152 test2:4
153 test2:5
154 test2:6
155 test2:7
156 test2:8
157 test2:9
[all …]
|
| H A D | gout.t1.5 | 148 test2:1:0
149 test2:2:1
150 test2:3:2
151 test2:4:3
152 test2:5:4
153 test2:6:5
154 test2:8:6
155 test2:9:7
156 test2:10:8
157 test2:11:9
[all …]
|
| H A D | gout.t1.21 | 146 test2-1
147 test2-2
148 test2-3
149 test2-4
150 test2-5
151 test2:a
152 test2-6
153 test2-7
154 test2-8
155 test2-9
[all …]
|
| H A D | gout.t1.22 | 146 test2-2-1
147 test2-3-2
148 test2-4-3
149 test2-5-4
150 test2-6-5
151 test2:7:a
152 test2-8-6
153 test2-9-7
154 test2-10-8
155 test2-11-9
[all …]
|
| H A D | gout.t1.42 | 146 test2-1
147 test2-2
148 test2-3
149 test2-4
150 test2-5
151 test2:a
152 test2-6
153 test2-7
154 test2-8
155 test2-9
[all …]
|
| H A D | gout.t1.43 | 146 test2-2-1
147 test2-3-2
148 test2-4-3
149 test2-5-4
150 test2-6-5
151 test2:7:a
152 test2-8-6
153 test2-9-7
154 test2-10-8
155 test2-11-9
[all …]
|
| H A D | gout.t1.13 | 3 test2:38
|