Home
last modified time | relevance | path

Searched refs:INSERT (Results 1 – 25 of 81) sorted by relevance

1234

/titanic_41/usr/src/lib/libsqlite/test/
H A Dconflict.test38 # cmd An INSERT or REPLACE command to execute against table t1
44 1 {} INSERT 1 {} 1
45 2 {} {INSERT OR IGNORE} 0 3 1
46 3 {} {INSERT OR REPLACE} 0 4 1
48 5 {} {INSERT OR FAIL} 1 {} 1
49 6 {} {INSERT OR ABORT} 1 {} 1
50 7 {} {INSERT OR ROLLBACK} 1 {} {}
51 8 IGNORE INSERT 0 3 1
52 9 IGNORE {INSERT OR IGNORE} 0 3 1
53 10 IGNORE {INSERT OR REPLACE} 0 4 1
[all …]
H A Dtrigger2.test21 # trigger2-1.3.*: INSERT trigger execution model.
25 # trigger program can correctly execute INSERT, UPDATE, DELETE * SELECT
47 # trigger2-6.1[a-f]: INSERT statements
79 INSERT INTO tbl VALUES(1, 2);
80 INSERT INTO tbl VALUES(3, 4);
87 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
95 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
104 INSERT INTO clog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM clog),
126 INSERT INTO tbl VALUES (100, 100);
127 INSERT INTO tbl VALUES (300, 200);
[all …]
H A Dmemdb.test36 INSERT INTO t3 VALUES(randstr(10,400));
37 INSERT INTO t3 VALUES(randstr(10,400));
38 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
39 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
40 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
41 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
42 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
43 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
44 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
45 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
[all …]
H A Dminmax.test28 INSERT INTO t1 VALUES(1,1);
29 INSERT INTO t1 VALUES(2,2);
30 INSERT INTO t1 VALUES(3,2);
31 INSERT INTO t1 VALUES(4,3);
32 INSERT INTO t1 VALUES(5,3);
33 INSERT INTO t1 VALUES(6,3);
34 INSERT INTO t1 VALUES(7,3);
35 INSERT INTO t1 VALUES(8,4);
36 INSERT INTO t1 VALUES(9,4);
37 INSERT INTO t1 VALUES(10,4);
[all …]
H A Dmisc3.test30 INSERT INTO t1
37 INSERT INTO t1 VALUES(2,'x');
54 INSERT INTO t1
56 INSERT INTO t1 SELECT a+1, b||b FROM t1;
57 INSERT INTO t1 SELECT a+2, b||b FROM t1;
58 INSERT INTO t1 SELECT a+4, b FROM t1;
59 INSERT INTO t1 SELECT a+8, b FROM t1;
60 INSERT INTO t1 SELECT a+16, b FROM t1;
61 INSERT INTO t1 SELECT a+32, b FROM t1;
62 INSERT INTO t1 SELECT a+64, b FROM t1;
[all …]
H A Dnotnull.test38 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
45 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5);
52 INSERT OR IGNORE INTO t1(b,c,d,e) VALUES(2,3,4,5);
59 INSERT OR REPLACE INTO t1(b,c,d,e) VALUES(2,3,4,5);
66 INSERT OR ABORT INTO t1(b,c,d,e) VALUES(2,3,4,5);
73 INSERT INTO t1(a,c,d,e) VALUES(1,3,4,5);
80 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5);
87 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
94 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,3,4,5);
101 INSERT INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
[all …]
H A Dinsert2.test15 # focus of this file is testing the INSERT statement that takes is
29 execsql "INSERT INTO d1 VALUES($i,$j)"
40 INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
54 INSERT INTO t1
69 INSERT INTO t1
85 INSERT INTO t1 SELECT log, count() FROM d1 GROUP BY log;
96 INSERT INTO t4 VALUES(1,2);
102 INSERT INTO t3(a,c) SELECT * FROM t4;
109 INSERT INTO t3(c,b) SELECT * FROM t4;
116 INSERT INTO t3(c,a,b) SELECT x, 'hi', y FROM t4;
[all …]
H A Dtrigger3.test24 CREATE TRIGGER before_tbl_insert BEFORE INSERT ON tbl BEGIN SELECT CASE
28 CREATE TRIGGER after_tbl_insert AFTER INSERT ON tbl BEGIN SELECT CASE
38 INSERT INTO tbl VALUES (5, 5, 6);
39 INSERT INTO tbl VALUES (1, 5, 6);
56 INSERT INTO tbl VALUES (5, 5, 6);
57 INSERT INTO tbl VALUES (2, 5, 6);
70 INSERT INTO tbl VALUES (5, 5, 6);
71 INSERT INTO tbl VALUES (3, 5, 6);
83 INSERT INTO tbl VALUES (5, 5, 6);
84 INSERT INTO tbl VALUES (4, 5, 6);
[all …]
H A Dinsert.test15 # focus of this file is testing the INSERT statement.
25 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]
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)}
70 execsql {INSERT INTO test1 VALUES(4,5,6)}
[all …]
H A Djoin.test26 INSERT INTO t1 VALUES(1,2,3);
27 INSERT INTO t1 VALUES(2,3,4);
28 INSERT INTO t1 VALUES(3,4,5);
35 INSERT INTO t2 VALUES(1,2,3);
36 INSERT INTO t2 VALUES(2,3,4);
37 INSERT INTO t2 VALUES(3,4,5);
114 INSERT INTO t3 VALUES(2,3,4);
115 INSERT INTO t3 VALUES(3,4,5);
116 INSERT INTO t3 VALUES(4,5,6);
133 INSERT INTO t4 VALUES(2,3,4);
[all …]
H A Dtrigger1.test55 CREATE TRIGGER tr1 INSERT ON t1 BEGIN
56 INSERT INTO t1 values(1);
70 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
73 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
197 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
204 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
218 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
219 INSERT INTO t2 VALUES(NEW.a,NEW.b);
225 INSERT INTO t1 VALUES(1,2);
237 INSERT INTO t1 VALUES(1,2);
[all …]
H A Dmisc1.test34 set cmd "INSERT INTO manycol VALUES(0"
47 set cmd "INSERT INTO manycol VALUES($j"
95 INSERT INTO agger VALUES(1, 'one', 'hello', 'yes');
96 INSERT INTO agger VALUES(2, 'two', 'howdy', 'no');
97 INSERT INTO agger VALUES(3, 'thr', 'howareya', 'yes');
98 INSERT INTO agger VALUES(4, 'two', 'lothere', 'yes');
99 INSERT INTO agger VALUES(5, 'one', 'atcha', 'yes');
100 INSERT INTO agger VALUES(6, 'two', 'hello', 'no');
120 INSERT INTO t1 VALUES('hi');
134 INSERT INTO t2 VALUES('This is a long string to use up a lot of disk -');
[all …]
H A Dprogress.test27 INSERT INTO t1 VALUES(1);
28 INSERT INTO t1 VALUES(2);
29 INSERT INTO t1 VALUES(3);
30 INSERT INTO t1 VALUES(4);
31 INSERT INTO t1 VALUES(5);
32 INSERT INTO t1 VALUES(6);
33 INSERT INTO t1 VALUES(7);
34 INSERT INTO t1 VALUES(8);
35 INSERT INTO t1 VALUES(9);
36 INSERT INTO t1 VALUES(10);
[all …]
H A Dunique.test46 INSERT INTO t1(a,b,c) VALUES(1,2,3)
51 INSERT INTO t1(a,b,c) VALUES(1,3,4)
61 INSERT INTO t1(a,b,c) VALUES(3,2,4)
71 INSERT INTO t1(a,b,c) VALUES(3,4,5)
85 INSERT INTO t2(a,b) VALUES(1,2);
86 INSERT INTO t2(a,b) VALUES(3,4);
102 INSERT INTO t2 VALUES(1,5);
118 INSERT INTO t2 VALUES(1,5)
153 INSERT INTO t3(a,b,c,d) VALUES(1,2,3,4);
159 INSERT INTO t3(a,b,c,d) VALUES(1,2,3,5);
[all …]
H A Djoin2.test26 INSERT INTO t1 VALUES(1,11);
27 INSERT INTO t1 VALUES(2,22);
28 INSERT INTO t1 VALUES(3,33);
35 INSERT INTO t2 VALUES(11,111);
36 INSERT INTO t2 VALUES(33,333);
37 INSERT INTO t2 VALUES(44,444);
44 INSERT INTO t3 VALUES(111,1111);
45 INSERT INTO t3 VALUES(444,4444);
46 INSERT INTO t3 VALUES(555,5555);
H A Dindex.test113 execsql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])"
214 execsql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])"
260 INSERT INTO t1 VALUES(1,2);
261 INSERT INTO t1 VALUES(2,4);
262 INSERT INTO t1 VALUES(3,8);
263 INSERT INTO t1 VALUES(1,12);
287 INSERT INTO t1 VALUES (1,1);
288 INSERT INTO t1 VALUES (1,2);
289 INSERT INTO t1 VALUES (1,3);
290 INSERT INTO t1 VALUES (1,4);
[all …]
H A Dcrashme2.off13 INSERT INTO t1 VALUES(1);
14 INSERT INTO t1 VALUES(2);
15 INSERT INTO t1 VALUES(3);
16 INSERT INTO t1 VALUES(4);
22 INSERT INTO t3 SELECT a FROM t1;
24 INSERT INTO t1 SELECT * FROM t1;
39 INSERT INTO t3 SELECT a FROM t1;
H A Dmisc2.test29 CREATE TRIGGER foo_insert BEFORE INSERT ON foo BEGIN
33 INSERT INTO foo(bar) VALUES (1);
38 INSERT INTO foo(bar) VALUES (111);
47 INSERT INTO t1 VALUES(1,2,3);
49 INSERT INTO t2 VALUES(7,8,9);
73 INSERT INTO t1 VALUES(4000000000,'a','b');
79 INSERT INTO t1 VALUES(2147483648,'b2','c2');
80 INSERT INTO t1 VALUES(2147483647,'b3','c3');
130 INSERT INTO t1 VALUES(1,2);
145 INSERT INTO t1 VALUES(1);
[all …]
H A Dioerr.test44 INSERT INTO t1 VALUES(1,2,3);
45 INSERT INTO t1 VALUES(4,5,6);
49 INSERT INTO t1 VALUES(1,2,3);
50 INSERT INTO t1 VALUES(4,5,6);
86 INSERT INTO t1 VALUES(1, randstr(5,50), randstr(5,50));
87 INSERT INTO t1 SELECT a+2, b||'-'||rowid, c||'-'||rowid FROM t1;
88 INSERT INTO t1 SELECT a+4, b||'-'||rowid, c||'-'||rowid FROM t1;
89 INSERT INTO t1 SELECT a+8, b||'-'||rowid, c||'-'||rowid FROM t1;
90 INSERT INTO t1 SELECT a+16, b||'-'||rowid, c||'-'||rowid FROM t1;
91 INSERT INTO t1 SELECT a+32, b||'-'||rowid, c||'-'||rowid FROM t1;
[all …]
H A Dtrans.test29 INSERT INTO one VALUES(1,'one');
30 INSERT INTO one VALUES(2,'two');
31 INSERT INTO one VALUES(3,'three');
38 INSERT INTO two VALUES(1,'I');
39 INSERT INTO two VALUES(5,'V');
40 INSERT INTO two VALUES(10,'X');
111 INSERT INTO one VALUES(4,'four');
129 INSERT INTO two VALUES(4,'IV');
270 execsql {INSERT INTO one(a,b) VALUES('hello', 1)}
363 INSERT INTO t2 VALUES(1,2,3);
[all …]
H A Dvacuum.test38 INSERT INTO t1 VALUES(NULL,randstr(10,100),randstr(5,50));
39 INSERT INTO t1 VALUES(123456,randstr(10,100),randstr(5,50));
40 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
41 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
42 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
43 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
44 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
45 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
46 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
157 INSERT INTO Test VALUES (NULL);
[all …]
H A Ddelete.test40 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)}
94 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
105 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
120 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
192 execsql {INSERT INTO table1 VALUES(2,3)}
200 execsql {INSERT INTO table2 VALUES(2,3)}
208 INSERT INTO t3 VALUES(1);
[all …]
H A Dversion.test31 INSERT INTO t1 VALUES(1);
32 INSERT INTO t1 SELECT x+1 FROM t1;
33 INSERT INTO t1 SELECT x+2 FROM t1;
34 INSERT INTO t1 SELECT x+4 FROM t1;
103 INSERT INTO cnt VALUES('t1',0,0);
104 INSERT INTO cnt VALUES('t2',0,0);
105 CREATE TRIGGER r1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
111 CREATE TRIGGER r3 AFTER INSERT ON t2 FOR EACH ROW BEGIN
119 INSERT INTO t1 VALUES(1);
120 INSERT INTO t1 SELECT x+1 FROM t1;
[all …]
H A Drowid.test28 INSERT INTO t1 VALUES(1,2);
29 INSERT INTO t1 VALUES(3,4);
97 INSERT INTO t1(rowid,x,y) VALUES(1234,5,6);
109 INSERT INTO t1(y,x,oid) VALUES(8,7,1235);
121 INSERT INTO t1(x,_rowid_,y) VALUES(9,1236,10);
173 INSERT INTO t2 VALUES(0,2,3);
174 INSERT INTO t2 VALUES(4,5,6);
175 INSERT INTO t2 VALUES(7,8,9);
206 execsql "INSERT INTO t1(x,y) VALUES($i,[expr {$i*$i}])"
208 execsql {INSERT INTO t2 SELECT _rowid_, x*y, y*y FROM t1}
[all …]
H A Dlimit.test100 INSERT INTO t3 SELECT x FROM t1 ORDER BY x LIMIT 10 OFFSET 1;
101 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
102 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
103 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
104 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
105 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
106 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
107 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
108 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
109 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
[all …]

1234