Home
last modified time | relevance | path

Searched refs:execsql (Results 1 – 25 of 70) sorted by relevance

123

/titanic_44/usr/src/lib/libsqlite/test/
H A Ddelete.test25 set v [catch {execsql {DELETE FROM test1}} msg]
32 set v [catch {execsql {DELETE FROM sqlite_master}} msg]
39 execsql {CREATE TABLE table1(f1 int, f2 int)}
40 execsql {INSERT INTO table1 VALUES(1,2)}
41 execsql {INSERT INTO table1 VALUES(2,4)}
42 execsql {INSERT INTO table1 VALUES(3,8)}
43 execsql {INSERT INTO table1 VALUES(4,16)}
44 execsql {SELECT * FROM table1 ORDER BY f1}
47 execsql {DELETE FROM table1 WHERE f1=3}
50 execsql {SELECT * FROM table1 ORDER BY f1}
[all …]
H A Dupdate.test25 set v [catch {execsql {UPDATE test1 SET f2=5 WHERE f1<1}} msg]
33 {execsql {UPDATE sqlite_master SET name='xyz' WHERE name='123'}} msg]
40 execsql {CREATE TABLE test1(f1 int,f2 int)}
43 execsql $sql
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 Drowid.test26 execsql {
34 set r [execsql {SELECT rowid FROM t1 ORDER BY x}]
45 execsql $sql
50 execsql $sql
55 execsql $sql
60 execsql $sql
65 execsql $sql
72 execsql "SELECT x FROM t1 WHERE rowid=$norow"
76 set v [execsql {SELECT x, oid FROM t1 order by x}]
82 set v [execsql {SELECT x, RowID FROM t1 order by x}]
[all …]
H A Dindex.test25 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
26 execsql {CREATE INDEX index1 ON test1(f1)}
27 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
30 execsql {SELECT name, sql, tbl_name, type FROM sqlite_master
36 execsql {SELECT name, sql, tbl_name, type FROM sqlite_master
42 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
48 execsql {DROP TABLE test1}
49 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
55 set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
63 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
[all …]
H A Dinsert.test25 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3)}} msg]
32 set v [catch {execsql {INSERT INTO sqlite_master VALUES(1,2,3,4)}} msg]
39 execsql {CREATE TABLE test1(one int, two int, three int)}
40 set v [catch {execsql {INSERT INTO test1 VALUES(1,2)}} msg]
44 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3,4)}} msg]
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]
66 execsql {INSERT INTO test1 VALUES(1,2,3)}
67 execsql {SELECT * FROM test1}
[all …]
H A Dsort.test35 execsql {
46 execsql {SELECT count(*) FROM t1}
50 execsql {SELECT n FROM t1 ORDER BY n}
53 execsql {SELECT n FROM t1 ORDER BY n ASC}
56 execsql {SELECT ALL n FROM t1 ORDER BY n ASC}
59 execsql {SELECT n FROM t1 ORDER BY n DESC}
62 execsql {SELECT v FROM t1 ORDER BY v}
65 execsql {SELECT n FROM t1 ORDER BY v}
68 execsql {SELECT n FROM t1 ORDER BY v DESC}
71 execsql {SELECT flt FROM t1 ORDER BY flt}
[all …]
H A Dfunc.test25 execsql {CREATE TABLE tbl1(t1 text)}
27 execsql "INSERT INTO tbl1 VALUES('$word')"
29 execsql {SELECT t1 FROM tbl1 ORDER BY t1}
32 execsql {
46 execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
49 set r [catch {execsql {SELECT length(*) FROM tbl1 ORDER BY t1}} msg]
53 set r [catch {execsql {SELECT length(t1,5) FROM tbl1 ORDER BY t1}} msg]
57 execsql {SELECT length(t1), count(*) FROM tbl1 GROUP BY length(t1)
61 execsql {SELECT coalesce(length(a),-1) FROM t2}
67 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
[all …]
H A Dpragma.test31 execsql {
39 execsql {
50 execsql {
58 execsql {
67 execsql {
76 execsql {
87 execsql {
95 execsql {
104 execsql {
115 execsql {
[all …]
H A Dminmax.test25 execsql {
55 execsql {SELECT min(x) FROM t1}
62 execsql {SELECT max(x) FROM t1}
68 execsql {CREATE INDEX t1i1 ON t1(x)}
70 execsql {SELECT min(x) FROM t1}
77 execsql {SELECT max(x) FROM t1}
84 execsql {SELECT max(y) FROM t1}
91 execsql {
96 execsql {SELECT min(a) FROM t2}
103 execsql {SELECT max(a) FROM t2}
[all …]
H A Din.test30 execsql {
35 execsql {SELECT count(*) FROM t1}
41 execsql {SELECT a FROM t1 WHERE b BETWEEN 10 AND 50 ORDER BY a}
44 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN 10 AND 50 ORDER BY a}
47 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 ORDER BY a}
50 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN a AND a*5 ORDER BY a}
53 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 OR b=512 ORDER BY a}
56 execsql {SELECT a+ 100*(a BETWEEN 1 and 3) FROM t1 ORDER BY b}
63 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) ORDER BY a}
66 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) ORDER BY a}
[all …]
H A Dtrans.test27 execsql {
36 execsql {
46 execsql {SELECT b FROM one ORDER BY a} altdb
49 execsql {SELECT b FROM two ORDER BY a} altdb
56 set v [catch {execsql {BEGIN}} msg]
60 set v [catch {execsql {END}} msg]
64 set v [catch {execsql {BEGIN TRANSACTION}} msg]
68 set v [catch {execsql {COMMIT TRANSACTION}} msg]
72 set v [catch {execsql {BEGIN TRANSACTION 'foo'}} msg]
76 set v [catch {execsql {ROLLBACK TRANSACTION 'foo'}} msg]
[all …]
H A Dbigrow.test37 execsql {
49 execsql $sql
50 execsql {SELECT a, c FROM t1}
53 execsql {SELECT b FROM t1}
59 set r [catch {execsql $sql} msg]
63 execsql {SELECT b FROM t1 ORDER BY c}
66 execsql {SELECT c FROM t1 ORDER BY c}
69 execsql {DELETE FROM t1 WHERE a='abc2'}
70 execsql {SELECT c FROM t1}
74 execsql {
[all …]
H A Dselect1.test25 set v [catch {execsql {SELECT * FROM test1}} msg]
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}
58 execsql {SELECT * FROM test1}
[all …]
H A Dlimit.test31 execsql {
38 execsql {SELECT count(*) FROM t1}
41 execsql {SELECT count(*) FROM t1 LIMIT 5}
44 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5}
47 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 2}
50 execsql {SELECT x FROM t1 ORDER BY x LIMIT 2, 5}
53 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 5}
56 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 30}
59 execsql {SELECT x FROM t1 ORDER BY x LIMIT 30, 50}
62 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 50}
[all …]
H A Dcopy.test58 set v [catch {execsql {COPY test1 FROM 'data1.txt'}} msg]
65 set v [catch {execsql {COPY sqlite_master FROM 'data2.txt'}} msg]
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 Dnull.test26 execsql {
44 execsql {
49 execsql {
59 execsql {
64 execsql {
69 execsql {
74 execsql {
79 execsql {
84 execsql {
89 execsql {
[all …]
H A Dintpkey.test28 execsql {
36 execsql {
46 execsql {
58 execsql {
64 execsql {
69 execsql {
78 set r [catch {execsql {
84 execsql {
89 set r [catch {execsql {
98 execsql {
[all …]
H A Dmisc3.test28 execsql {
42 execsql {
49 execsql {
67 execsql {
77 execsql {SELECT 2e-25*0.5e25}
80 execsql {SELECT 2.0e-25*000000.500000000000000000000000000000e+00025}
83 execsql {SELECT 000000000002e-0000000025*0.5e25}
86 execsql {SELECT 2e-25*0.5e250}
89 execsql {SELECT 2.0e-250*0.5e25}
92 execsql {SELECT '-2.0e-127' * '-0.5e27'}
[all …]
H A Dinsert2.test26 execsql {CREATE TABLE d1(n int, log int);}
29 execsql "INSERT INTO d1 VALUES($i,$j)"
31 execsql {SELECT * FROM d1 ORDER BY n}
37 execsql {
47 execsql {SELECT * FROM t1 ORDER BY log}
51 catch {execsql {DROP TABLE t1}}
52 execsql {
60 execsql {
65 catch {execsql {DROP TABLE t1}}
66 execsql {
[all …]
H A Dtable.test25 execsql {
31 execsql {
43 execsql {SELECT name, tbl_name, type FROM sqlite_master WHERE type!='meta'}
52 execsql {SELECT name, tbl_name, type from sqlite_master WHERE type!='meta'}
58 execsql {DROP TABLE test1}
59 execsql {SELECT * FROM sqlite_master WHERE type!='meta'}
68 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
74 execsql {CREATE TABLE "create" (f1 int)}
75 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
78 execsql {DROP TABLE "create"}
[all …]
H A Dsubselect.test26 execsql {
32 execsql {SELECT * FROM t1 WHERE a = (SELECT count(*) FROM t1)}
38 set v [catch {execsql {SELECT * FROM t1 WHERE a = (SELECT * FROM t1)}} msg]
45 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=2)}
48 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=4)}
51 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6)}
54 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=8)}
61 execsql {SELECT b from t1 where a = coalesce((SELECT a FROM t1 WHERE b=5),1)}
67 execsql {
74 execsql {
[all …]
H A Dselect3.test32 execsql {
37 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
43 execsql {SELECT count(*) FROM t1}
46 execsql {
52 execsql {SELECT max(n)/avg(n), max(log)/avg(log) FROM t1}
58 execsql {SELECT log, count(*) FROM t1 GROUP BY log ORDER BY log}
61 execsql {SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log}
64 execsql {SELECT log, avg(n) FROM t1 GROUP BY log ORDER BY log}
67 execsql {SELECT log, avg(n)+1 FROM t1 GROUP BY log ORDER BY log}
70 execsql {SELECT log, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
[all …]
H A Dlock.test30 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name}
33 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name} db2
36 execsql {CREATE TABLE t1(a int, b int)}
37 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name}
51 execsql {INSERT INTO t1 VALUES(1,2)}
52 execsql {SELECT * FROM t1}
55 execsql {SELECT * FROM t1} db2
58 execsql {UPDATE t1 SET a=b, b=a} db2
59 execsql {SELECT * FROM t1} db2
62 execsql {SELECT * FROM t1}
[all …]
H A Dview.test22 execsql {
32 execsql {
45 execsql {
53 execsql {
64 execsql {
76 execsql {
87 execsql {
93 execsql {
116 execsql {
122 execsql {
[all …]
H A Dselect4.test31 execsql {
38 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
44 lsort [execsql {SELECT DISTINCT log FROM t1}]
47 lsort [execsql {SELECT n FROM t1 WHERE log=3}]
50 execsql {
58 execsql {
67 execsql {DROP TABLE t2}
69 execsql {
78 execsql {DROP TABLE t2}
80 execsql {
[all …]

123