Home
last modified time | relevance | path

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

12345

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dupdate.test23 set v [catch {execsql {UPDATE test1 SET f2=5 WHERE f1<1}} msg]
25 } {1 {no such table: test1}}
38 execsql {CREATE TABLE test1(f1 int,f2 int)}
40 set sql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])"
43 execsql {SELECT * FROM test1 ORDER BY f1}
49 set v [catch {execsql {UPDATE test1 SET f1=f3*2 WHERE f2==32}} msg]
53 set v [catch {execsql {UPDATE test1 SET f1=test2.f1*2 WHERE f2==32}} msg]
57 set v [catch {execsql {UPDATE test1 SET f3=f1*2 WHERE f2==32}} msg]
64 execsql {UPDATE test1 SET f2=f2*3}
67 execsql {SELECT * FROM test1 ORDER BY f1}
[all …]
H A Dselect1.test23 set v [catch {execsql {SELECT * FROM test1}} msg]
25 } {1 {no such table: test1}}
27 execsql {CREATE TABLE test1(f1 int, f2 int)}
30 set v [catch {execsql {SELECT * FROM test1, test2}} msg]
34 set v [catch {execsql {SELECT * FROM test2, test1}} msg]
38 execsql {INSERT INTO test1(f1,f2) VALUES(11,22)}
44 execsql {SELECT f1 FROM test1}
47 execsql {SELECT f2 FROM test1}
50 execsql {SELECT f2, f1 FROM test1}
53 execsql {SELECT f1, f2 FROM test1}
[all …]
H A Dindex.test23 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
24 execsql {CREATE INDEX index1 ON test1(f1)}
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}
53 set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
55 } {1 {no such table: test1}}
61 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
[all …]
H A Dinsert.test23 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3)}} msg]
25 } {1 {no such table: test1}}
37 execsql {CREATE TABLE test1(one int, two int, three int)}
38 set v [catch {execsql {INSERT INTO test1 VALUES(1,2)}} msg]
40 } {1 {table test1 has 3 columns but 2 values were supplied}}
42 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3,4)}} msg]
44 } {1 {table test1 has 3 columns but 4 values were supplied}}
46 set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1,2,3,4)}} msg]
50 set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1)}} msg]
57 set v [catch {execsql {INSERT INTO test1(one,four) VALUES(1,2)}} msg]
[all …]
H A Dcopy.test56 set v [catch {execsql {COPY test1 FROM 'data1.txt'}} msg]
58 } {1 {no such table: test1}}
70 execsql {CREATE TABLE test1(one int, two int, three int)}
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}
87 execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS ' | '}
[all …]
H A Dtrigger4.test19 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 Dgout.t1.78 test1:a1
9 test1:a2
10 test1-b
11 test1:a3
12 test1-b
13 test1-b
14 test1:a4
15 test1-b
16 test1-b
17 test1-b
[all …]
H A Dgout.t1.88 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 Dgout.t1.569 test1:a1
10 test1:a2
11 test1-b
12 test1:a3
13 test1-b
14 test1-b
15 test1:a4
16 test1-b
17 test1-b
18 test1-b
[all …]
H A Dgout.t1.579 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 Dgout.t1.148 test1:a1
9 test1:a2
10 test1-b
11 test1:a3
12 test1-b
13 test1-b
14 test1:a4
15 test1-b
16 test1-b
17 test1-b
[all …]
H A Dgout.t1.158 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 Dgout.t1.695 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
15 test1:0:a5
[all …]
H A Dgout.t1.705 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
15 test1:0:11:a5
[all …]
H A Dgout.t1.2113 test1:a1
14 test1:a2
15 test1-b
16 test1:a3
17 test1-b
18 test1-b
19 test1:a4
20 test1-b
21 test1-b
22 test1-b
[all …]
H A Dgout.t1.2213 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 Dgout.t1.4213 test1:a1
14 test1:a2
15 test1-b
16 test1:a3
17 test1-b
18 test1-b
19 test1:a4
20 test1-b
21 test1-b
22 test1-b
[all …]
H A Dgout.t1.4313 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 Dgout.t1.2810 test1:a1
11 test1:a2
12 test1-b
13 test1:a3
14 test1-b
15 test1-b
16 test1:a4
17 test1-b
18 test1-b
19 test1-b
[all …]
H A Dgout.t1.2910 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 Dgout.t1.3510 test1:a1
11 test1:a2
12 test1-b
13 test1:a3
14 test1-b
15 test1-b
16 test1:a4
17 test1-b
18 test1-b
19 test1-b
[all …]
H A Dgout.t1.3610 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 Dgout.t1.413 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 Dgout.t1.513 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 Dgout.t1.1815 test1-a1
16 test1-a2
17 test1:b
18 test1-a3
19 test1:b
20 test1:b
21 test1-a4
22 test1:b
23 test1:b
24 test1:b
[all …]

12345