Searched refs:test1 (Results 1 – 25 of 106) sorted by relevance
12345
| /illumos-gate/usr/src/lib/libsqlite/test/ |
| H A D | update.test | 25 } {1 {no such table: test1}}
43 execsql {SELECT * FROM test1 ORDER BY f1}
64 execsql {UPDATE test1 SET f2=f2*3}
67 execsql {SELECT * FROM test1 ORDER BY f1}
86 execsql {UPDATE test1 SET F2=f1, F1=f2}
93 execsql {UPDATE test1 SET F2=f1, F1=f2}
104 DELETE FROM test1 WHERE f1<=5;
141 SELECT * FROM test1 ORDER BY f1,f2
203 SELECT * FROM test1 ORDER BY f1,f2
392 UPDATE test1 SET x=11 WHERE f1=1025
[all …]
|
| H A D | select1.test | 81 execsql {SELECT test1.f1, test2.r1 FROM test1, test2}
84 execsql {SELECT test1.f1, test2.r1 FROM test2, test1}
90 execsql {SELECT * FROM test1 AS a, test1 AS b}
356 } {0 {test1.f1 11 test1.f1 33}}
364 } {0 {test1.f1 11 test1.f2 22}}
369 } {0 {test1.f1 11 test1.f2 22}}
401 } {0 {test1.f1+F2 33 test1.f1+F2 77}}
407 } {0 {test1.f1+F2 33 test1.f1+F2 77}}
412 } {0 {test1.f1+F2 33 t1 abc test1.f1+F2 77 t1 abc}}
440 SELECT f1 FROM test1 UNION SELECT f2 FROM test1
[all …]
|
| H A D | index.test | 26 } {index1 test1}
30 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
36 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
41 } {index1 test1}
46 execsql {DROP TABLE test1}
55 } {1 {no such table: test1}}
116 } {index9 indext test1}
181 } {index1 test1 test2}
188 } {index1 test1 test2}
200 DROP TABLE test1;
[all …]
|
| H A D | insert.test | 25 } {1 {no such table: test1}}
59 } {1 {table test1 has no column named four}}
64 execsql {INSERT INTO test1 VALUES(1,2,3)}
65 execsql {SELECT * FROM test1}
68 execsql {INSERT INTO test1 VALUES(4,5,6)}
69 execsql {SELECT * FROM test1 ORDER BY one}
72 execsql {INSERT INTO test1 VALUES(7,8,9)}
73 execsql {SELECT * FROM test1 ORDER BY one}
77 execsql {DELETE FROM test1}
79 execsql {SELECT * FROM test1 ORDER BY one}
[all …]
|
| H A D | copy.test | 58 } {1 {no such table: test1}}
71 execsql {COPY test1 FROM 'data1.txt'}
72 execsql {SELECT * FROM test1 ORDER BY one}
78 execsql {DELETE FROM test1}
79 execsql {COPY test1 FROM 'data2.txt'}
80 execsql {SELECT * FROM test1 ORDER BY one}
86 execsql {DELETE FROM test1}
91 execsql {DELETE FROM test1}
96 execsql {DELETE FROM test1}
104 execsql {DELETE FROM test1}
[all …]
|
| H A D | trigger4.test | 19 create table test1(id integer primary key,a);
22 select test1.id as id,a as a,b as b
23 from test1 join test2 on test2.id = test1.id;
26 insert into test1 (id,a) values (NEW.id,NEW.a);
30 select * from test1;
43 select * from test1;
56 update test1 set a=NEW.a where id=NEW.id;
60 select * from test1;
73 select * from test1;
102 select * from test1;
[all …]
|
| /illumos-gate/usr/src/test/util-tests/tests/grep_xpg4/files/ |
| H A D | gout.t1.7 | 8 test1:a1
9 test1:a2
10 test1-b
11 test1:a3
12 test1-b
13 test1-b
15 test1-b
16 test1-b
17 test1-b
19 test1-b
[all …]
|
| H A D | gout.t1.8 | 8 test1:1:a1
9 test1:2:a2
10 test1-3-b
11 test1:4:a3
12 test1-5-b
13 test1-6-b
14 test1:7:a4
15 test1-8-b
16 test1-9-b
17 test1-10-b
[all …]
|
| H A D | gout.t1.56 | 9 test1:a1
10 test1:a2
11 test1-b
12 test1:a3
13 test1-b
14 test1-b
16 test1-b
17 test1-b
18 test1-b
20 test1-b
[all …]
|
| H A D | gout.t1.57 | 9 test1:1:a1
10 test1:2:a2
11 test1-3-b
12 test1:4:a3
13 test1-5-b
14 test1-6-b
15 test1:7:a4
16 test1-8-b
17 test1-9-b
18 test1-10-b
[all …]
|
| H A D | gout.t1.69 | 5 test1:0:a1
6 test1:0:a2
7 test1-0-b
8 test1:0:a3
9 test1-0-b
10 test1-0-b
11 test1:0:a4
12 test1-0-b
14 test1-0-b
16 test1-0-b
[all …]
|
| H A D | gout.t1.70 | 5 test1:0:1:a1
6 test1:0:2:a2
7 test1-0-3-b
8 test1:0:4:a3
9 test1-0-5-b
10 test1-0-6-b
11 test1:0:7:a4
12 test1-0-8-b
14 test1-0-10-b
16 test1-0-12-b
[all …]
|
| H A D | gout.t1.14 | 8 test1:a1
9 test1:a2
10 test1-b
11 test1:a3
12 test1-b
13 test1-b
15 test1-b
16 test1-b
17 test1-b
19 test1-b
[all …]
|
| H A D | gout.t1.15 | 8 test1:1:a1
9 test1:2:a2
10 test1-3-b
11 test1:4:a3
12 test1-5-b
13 test1-6-b
14 test1:7:a4
15 test1-8-b
16 test1-9-b
17 test1-10-b
[all …]
|
| H A D | gout.t1.21 | 13 test1:a1
14 test1:a2
15 test1-b
16 test1:a3
17 test1-b
18 test1-b
20 test1-b
21 test1-b
22 test1-b
24 test1-b
[all …]
|
| H A D | gout.t1.22 | 13 test1:1:a1
14 test1:2:a2
15 test1-3-b
16 test1:4:a3
17 test1-5-b
18 test1-6-b
19 test1:7:a4
20 test1-8-b
21 test1-9-b
22 test1-10-b
[all …]
|
| H A D | gout.t1.42 | 13 test1:a1
14 test1:a2
15 test1-b
16 test1:a3
17 test1-b
18 test1-b
20 test1-b
21 test1-b
22 test1-b
24 test1-b
[all …]
|
| H A D | gout.t1.43 | 13 test1:1:a1
14 test1:2:a2
15 test1-3-b
16 test1:4:a3
17 test1-5-b
18 test1-6-b
19 test1:7:a4
20 test1-8-b
21 test1-9-b
22 test1-10-b
[all …]
|
| H A D | gout.t1.28 | 10 test1:a1
11 test1:a2
12 test1-b
13 test1:a3
14 test1-b
15 test1-b
17 test1-b
18 test1-b
19 test1-b
21 test1-b
[all …]
|
| H A D | gout.t1.29 | 10 test1:1:a1
11 test1:2:a2
12 test1-3-b
13 test1:4:a3
14 test1-5-b
15 test1-6-b
16 test1:7:a4
17 test1-8-b
18 test1-9-b
19 test1-10-b
[all …]
|
| H A D | gout.t1.35 | 10 test1:a1
11 test1:a2
12 test1-b
13 test1:a3
14 test1-b
15 test1-b
17 test1-b
18 test1-b
19 test1-b
21 test1-b
[all …]
|
| H A D | gout.t1.36 | 10 test1:1:a1
11 test1:2:a2
12 test1-3-b
13 test1:4:a3
14 test1-5-b
15 test1-6-b
16 test1:7:a4
17 test1-8-b
18 test1-9-b
19 test1-10-b
[all …]
|
| H A D | gout.t1.4 | 13 test1:b
14 test1:b
15 test1:b
16 test1:b
17 test1:b
18 test1:b
19 test1:b
20 test1:b
21 test1:b
22 test1:b
[all …]
|
| H A D | gout.t1.5 | 13 test1:3:b
14 test1:5:b
15 test1:6:b
16 test1:8:b
17 test1:9:b
18 test1:10:b
19 test1:12:b
20 test1:13:b
21 test1:14:b
22 test1:15:b
[all …]
|
| H A D | gout.t1.18 | 15 test1-a1
16 test1-a2
17 test1:b
18 test1-a3
19 test1:b
20 test1:b
22 test1:b
23 test1:b
24 test1:b
26 test1:b
[all …]
|
12345