Home
last modified time | relevance | path

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

12

/titanic_44/usr/src/lib/libsqlite/test/
H A Dupdate.test25 set v [catch {execsql {UPDATE test1 SET f2=5 WHERE f1<1}} msg]
27 } {1 {no such table: test1}}
40 execsql {CREATE TABLE test1(f1 int,f2 int)}
42 set sql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])"
45 execsql {SELECT * FROM test1 ORDER BY f1}
51 set v [catch {execsql {UPDATE test1 SET f1=f3*2 WHERE f2==32}} msg]
55 set v [catch {execsql {UPDATE test1 SET f1=test2.f1*2 WHERE f2==32}} msg]
59 set v [catch {execsql {UPDATE test1 SET f3=f1*2 WHERE f2==32}} msg]
66 execsql {UPDATE test1 SET f2=f2*3}
69 execsql {SELECT * FROM test1 ORDER BY f1}
[all …]
H A Dselect1.test25 set v [catch {execsql {SELECT * FROM test1}} msg]
27 } {1 {no such table: test1}}
29 execsql {CREATE TABLE test1(f1 int, f2 int)}
32 set v [catch {execsql {SELECT * FROM test1, test2}} msg]
36 set v [catch {execsql {SELECT * FROM test2, test1}} msg]
40 execsql {INSERT INTO test1(f1,f2) VALUES(11,22)}
46 execsql {SELECT f1 FROM test1}
49 execsql {SELECT f2 FROM test1}
52 execsql {SELECT f2, f1 FROM test1}
55 execsql {SELECT f1, f2 FROM test1}
[all …]
H A Dindex.test25 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
26 execsql {CREATE INDEX index1 ON test1(f1)}
28 } {index1 test1}
32 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
38 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
43 } {index1 test1}
48 execsql {DROP TABLE test1}
55 set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
57 } {1 {no such table: test1}}
63 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
[all …]
H A Dcopy.test58 set v [catch {execsql {COPY test1 FROM 'data1.txt'}} msg]
60 } {1 {no such table: test1}}
72 execsql {CREATE TABLE test1(one int, two int, three int)}
73 execsql {COPY test1 FROM 'data1.txt'}
74 execsql {SELECT * FROM test1 ORDER BY one}
80 execsql {DELETE FROM test1}
81 execsql {COPY test1 FROM 'data2.txt'}
82 execsql {SELECT * FROM test1 ORDER BY one}
88 execsql {DELETE FROM test1}
89 execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS ' | '}
[all …]
H A Dinsert.test25 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3)}} msg]
27 } {1 {no such table: test1}}
39 execsql {CREATE TABLE test1(one int, two int, three int)}
40 set v [catch {execsql {INSERT INTO test1 VALUES(1,2)}} msg]
42 } {1 {table test1 has 3 columns but 2 values were supplied}}
44 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3,4)}} msg]
46 } {1 {table test1 has 3 columns but 4 values were supplied}}
48 set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1,2,3,4)}} msg]
52 set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1)}} msg]
59 set v [catch {execsql {INSERT INTO test1(one,four) VALUES(1,2)}} msg]
[all …]
H A Dtrigger4.test21 create table test1(id integer primary key,a);
24 select test1.id as id,a as a,b as b
25 from test1 join test2 on test2.id = test1.id;
28 insert into test1 (id,a) values (NEW.id,NEW.a);
32 select * from test1;
45 select * from test1;
58 update test1 set a=NEW.a where id=NEW.id;
62 select * from test1;
75 select * from test1;
104 select * from test1;
[all …]
H A Dtable.test26 CREATE TABLE test1 (
34 } {{CREATE TABLE test1 (
44 } {test1 test1 table}
53 } {test1 test1 table}
58 execsql {DROP TABLE test1}
82 execsql {CREATE TABLE test1("f1 ho" int)}
84 } {test1}
260 execsql {EXPLAIN CREATE TABLE test1(f1 int)}
267 execsql {CREATE TABLE test1(f1 int)}
268 execsql {EXPLAIN DROP TABLE test1}
[all …]
H A Dview.test259 CREATE TABLE test1(id integer primary key, a);
261 INSERT INTO test1 VALUES(1,2);
264 SELECT test1.id, a, b
265 FROM test1 JOIN test2 ON test2.id=test1.id;
280 SELECT test1.id, a, b
281 FROM test1 JOIN test2 USING(id);
296 SELECT test1.id, a, b
297 FROM test1 NATURAL JOIN test2;
H A Dbtree4.test31 file delete -force test1.bt
32 file delete -force test1.bt-journal
33 set b1 [btree_open test1.bt]
H A Dbtree3.test36 file delete -force test1.bt
37 file delete -force test1.bt-journal
38 set b1 [btree_open test1.bt]
H A Dpragma.test389 CREATE TEMP TABLE test1(a,b,c);
392 } {test1}
401 CREATE TEMP TABLE test1(a,b,c);
404 } {test1}
H A Dbtree.test29 file delete -force test1.bt
30 file delete -force test1.bt-journal
31 set rc [catch {btree_open test1.bt} ::b1]
44 set rc [catch {btree_open test1.bt} ::b2]
84 file size test1.bt
213 file size test1.bt
345 set ::b1 [btree_open test1.bt]
638 set ::b1 [btree_open test1.bt]
H A Dexpr.test24 execsql {CREATE TABLE test1(i1 int, i2 int, r1 real, r2 real, t1 text, t2 text)}
25 execsql {INSERT INTO test1 VALUES(1,2,1.1,2.2,'hello','world')}
28 execsql {BEGIN; UPDATE test1 SET %s; SELECT %s FROM test1; ROLLBACK;}
435 execsql {DROP TABLE test1}
436 execsql {CREATE TABLE test1(a int, b int);}
438 execsql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])"
440 execsql "INSERT INTO test1 VALUES(NULL,0)"
442 execsql {SELECT * FROM test1 ORDER BY a}
447 execsql {SELECT a FROM test1 WHERE %s ORDER BY a}
H A Dauth.test1613 ATTACH DATABASE ':memory:' AS test1
1620 catchsql {DETACH DATABASE test1}
1629 ATTACH DATABASE ':memory:' AS test1;
1636 catchsql {DETACH DATABASE test1}
1645 ATTACH DATABASE ':memory:' AS test1;
1659 execsql {ATTACH DATABASE ':memory:' AS test1}
1661 DETACH DATABASE test1;
1668 execsql {ATTACH DATABASE ':memory:' AS test1}
1677 DETACH DATABASE test1;
1682 } {test1}
[all …]
/titanic_44/usr/src/cmd/sgs/libelf/demo/
H A DMakefile45 test: test1 test2 test3 test4 test5 test6
47 test1: pcom FRC target
/titanic_44/usr/src/lib/libshell/common/tests/
H A Dsun_solaris_compound_nameref.sh95 function test1
103 test1
H A Dsun_solaris_command_substitution.sh62 compound test1=(
98 nameref currtst=test1.testcases[testid]
H A Dsun_solaris_cr_6904557_wc_no_longer_counts_number_of_bytes_correctly.sh89 function test1 function
H A Dfunctions.sh90 > $tmp/test1
93 if [ -r $tmp/test1 ]
94 then rm -r $tmp/test1
H A Dsun_solaris_cr_6904575_cut_-d_with_multibyte_character_no_longer_works.sh87 function test1 function
H A Dsun_solaris_cr_6904878_join_-t_no_longer_works_with_multibyte_char_separator.sh83 function test1 function
/titanic_44/usr/src/test/util-tests/tests/xargs/
H A Dxargs_test.ksh45 test1() { function
46 t=test1
245 test1
/titanic_44/usr/src/lib/efcode/fcode_test/
H A Diftest.fth61 : if-test1 ( -- )
72 ; if-test1 space
/titanic_44/usr/src/lib/libsqlite/
H A DMakefile.com127 $(SRCDIR)/test1.c \
134 TESTCLEAN = $(TESTOBJS) test.db test.tcl test1.bt test2.db testdb
/titanic_44/usr/src/cmd/perl/contrib/Sun/Solaris/Project/t/
H A DProject.t212 test1:123:project one:root,bin:adm:attr1=a;attr2=b
223 test1:123:project one:root,bin:adm:attr1=a;attr2=b
226 test1:678:project four:root:root:
234 test1:123:project one:root,bin:adm:attr1=a;attr2=b
250 test1:123:project one:root,bin:adm:attr1=a;attr2=b
261 test1:123:project one:root,bin:adm:attr1=a;attr2=b

12