Home
last modified time | relevance | path

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

1234

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dconflict.test36 # cmd An INSERT or REPLACE command to execute against table t1
42 1 {} INSERT 1 {} 1
43 2 {} {INSERT OR IGNORE} 0 3 1
44 3 {} {INSERT OR REPLACE} 0 4 1
46 5 {} {INSERT OR FAIL} 1 {} 1
47 6 {} {INSERT OR ABORT} 1 {} 1
48 7 {} {INSERT OR ROLLBACK} 1 {} {}
49 8 IGNORE INSERT 0 3 1
50 9 IGNORE {INSERT OR IGNORE} 0 3 1
51 10 IGNORE {INSERT OR REPLACE} 0 4 1
[all …]
H A Dtrigger2.test19 # trigger2-1.3.*: INSERT trigger execution model.
23 # trigger program can correctly execute INSERT, UPDATE, DELETE * SELECT
45 # trigger2-6.1[a-f]: INSERT statements
77 INSERT INTO tbl VALUES(1, 2);
78 INSERT INTO tbl VALUES(3, 4);
85 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
93 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
102 INSERT INTO clog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM clog),
124 INSERT INTO tbl VALUES (100, 100);
125 INSERT INTO tbl VALUES (300, 200);
[all …]
H A Dmemdb.test34 INSERT INTO t3 VALUES(randstr(10,400));
35 INSERT INTO t3 VALUES(randstr(10,400));
36 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
37 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
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;
[all …]
H A Dminmax.test26 INSERT INTO t1 VALUES(1,1);
27 INSERT INTO t1 VALUES(2,2);
28 INSERT INTO t1 VALUES(3,2);
29 INSERT INTO t1 VALUES(4,3);
30 INSERT INTO t1 VALUES(5,3);
31 INSERT INTO t1 VALUES(6,3);
32 INSERT INTO t1 VALUES(7,3);
33 INSERT INTO t1 VALUES(8,4);
34 INSERT INTO t1 VALUES(9,4);
35 INSERT INTO t1 VALUES(10,4);
[all …]
H A Dmisc3.test28 INSERT INTO t1
35 INSERT INTO t1 VALUES(2,'x');
52 INSERT INTO t1
54 INSERT INTO t1 SELECT a+1, b||b FROM t1;
55 INSERT INTO t1 SELECT a+2, b||b FROM t1;
56 INSERT INTO t1 SELECT a+4, b FROM t1;
57 INSERT INTO t1 SELECT a+8, b FROM t1;
58 INSERT INTO t1 SELECT a+16, b FROM t1;
59 INSERT INTO t1 SELECT a+32, b FROM t1;
60 INSERT INTO t1 SELECT a+64, b FROM t1;
[all …]
H A Dnotnull.test36 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
43 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5);
50 INSERT OR IGNORE INTO t1(b,c,d,e) VALUES(2,3,4,5);
57 INSERT OR REPLACE INTO t1(b,c,d,e) VALUES(2,3,4,5);
64 INSERT OR ABORT INTO t1(b,c,d,e) VALUES(2,3,4,5);
71 INSERT INTO t1(a,c,d,e) VALUES(1,3,4,5);
78 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5);
85 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
92 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,3,4,5);
99 INSERT INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
[all …]
H A Djoin.test24 INSERT INTO t1 VALUES(1,2,3);
25 INSERT INTO t1 VALUES(2,3,4);
26 INSERT INTO t1 VALUES(3,4,5);
33 INSERT INTO t2 VALUES(1,2,3);
34 INSERT INTO t2 VALUES(2,3,4);
35 INSERT INTO t2 VALUES(3,4,5);
112 INSERT INTO t3 VALUES(2,3,4);
113 INSERT INTO t3 VALUES(3,4,5);
114 INSERT INTO t3 VALUES(4,5,6);
131 INSERT INTO t4 VALUES(2,3,4);
[all …]
H A Dinsert.test13 # focus of this file is testing the INSERT statement.
23 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3)}} msg]
30 set v [catch {execsql {INSERT INTO sqlite_master VALUES(1,2,3,4)}} msg]
38 set v [catch {execsql {INSERT INTO test1 VALUES(1,2)}} msg]
42 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3,4)}} msg]
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]
64 execsql {INSERT INTO test1 VALUES(1,2,3)}
68 execsql {INSERT INTO test1 VALUES(4,5,6)}
[all …]
H A Dinsert2.test13 # focus of this file is testing the INSERT statement that takes is
27 execsql "INSERT INTO d1 VALUES($i,$j)"
38 INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
52 INSERT INTO t1
67 INSERT INTO t1
83 INSERT INTO t1 SELECT log, count() FROM d1 GROUP BY log;
94 INSERT INTO t4 VALUES(1,2);
100 INSERT INTO t3(a,c) SELECT * FROM t4;
107 INSERT INTO t3(c,b) SELECT * FROM t4;
114 INSERT INTO t3(c,a,b) SELECT x, 'hi', y FROM t4;
[all …]
H A Dtrigger3.test22 CREATE TRIGGER before_tbl_insert BEFORE INSERT ON tbl BEGIN SELECT CASE
26 CREATE TRIGGER after_tbl_insert AFTER INSERT ON tbl BEGIN SELECT CASE
36 INSERT INTO tbl VALUES (5, 5, 6);
37 INSERT INTO tbl VALUES (1, 5, 6);
54 INSERT INTO tbl VALUES (5, 5, 6);
55 INSERT INTO tbl VALUES (2, 5, 6);
68 INSERT INTO tbl VALUES (5, 5, 6);
69 INSERT INTO tbl VALUES (3, 5, 6);
81 INSERT INTO tbl VALUES (5, 5, 6);
82 INSERT INTO tbl VALUES (4, 5, 6);
[all …]
H A Dtrigger1.test53 CREATE TRIGGER tr1 INSERT ON t1 BEGIN
54 INSERT INTO t1 values(1);
68 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
71 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
195 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
202 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
216 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
217 INSERT INTO t2 VALUES(NEW.a,NEW.b);
223 INSERT INTO t1 VALUES(1,2);
235 INSERT INTO t1 VALUES(1,2);
[all …]
H A Dmisc1.test32 set cmd "INSERT INTO manycol VALUES(0"
45 set cmd "INSERT INTO manycol VALUES($j"
93 INSERT INTO agger VALUES(1, 'one', 'hello', 'yes');
94 INSERT INTO agger VALUES(2, 'two', 'howdy', 'no');
95 INSERT INTO agger VALUES(3, 'thr', 'howareya', 'yes');
96 INSERT INTO agger VALUES(4, 'two', 'lothere', 'yes');
97 INSERT INTO agger VALUES(5, 'one', 'atcha', 'yes');
98 INSERT INTO agger VALUES(6, 'two', 'hello', 'no');
118 INSERT INTO t1 VALUES('hi');
132 INSERT INTO t2 VALUES('This is a long string to use up a lot of disk -');
[all …]
H A Dprogress.test25 INSERT INTO t1 VALUES(1);
26 INSERT INTO t1 VALUES(2);
27 INSERT INTO t1 VALUES(3);
28 INSERT INTO t1 VALUES(4);
29 INSERT INTO t1 VALUES(5);
30 INSERT INTO t1 VALUES(6);
31 INSERT INTO t1 VALUES(7);
32 INSERT INTO t1 VALUES(8);
33 INSERT INTO t1 VALUES(9);
34 INSERT INTO t1 VALUES(10);
[all …]
H A Dunique.test44 INSERT INTO t1(a,b,c) VALUES(1,2,3)
49 INSERT INTO t1(a,b,c) VALUES(1,3,4)
59 INSERT INTO t1(a,b,c) VALUES(3,2,4)
69 INSERT INTO t1(a,b,c) VALUES(3,4,5)
83 INSERT INTO t2(a,b) VALUES(1,2);
84 INSERT INTO t2(a,b) VALUES(3,4);
100 INSERT INTO t2 VALUES(1,5);
116 INSERT INTO t2 VALUES(1,5)
151 INSERT INTO t3(a,b,c,d) VALUES(1,2,3,4);
157 INSERT INTO t3(a,b,c,d) VALUES(1,2,3,5);
[all …]
H A Dindex.test111 execsql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])"
212 execsql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])"
258 INSERT INTO t1 VALUES(1,2);
259 INSERT INTO t1 VALUES(2,4);
260 INSERT INTO t1 VALUES(3,8);
261 INSERT INTO t1 VALUES(1,12);
285 INSERT INTO t1 VALUES (1,1);
286 INSERT INTO t1 VALUES (1,2);
287 INSERT INTO t1 VALUES (1,3);
288 INSERT INTO t1 VALUES (1,4);
[all …]
H A Djoin2.test24 INSERT INTO t1 VALUES(1,11);
25 INSERT INTO t1 VALUES(2,22);
26 INSERT INTO t1 VALUES(3,33);
33 INSERT INTO t2 VALUES(11,111);
34 INSERT INTO t2 VALUES(33,333);
35 INSERT INTO t2 VALUES(44,444);
42 INSERT INTO t3 VALUES(111,1111);
43 INSERT INTO t3 VALUES(444,4444);
44 INSERT INTO t3 VALUES(555,5555);
H A Dcrashme2.off9 INSERT INTO t1 VALUES(1);
10 INSERT INTO t1 VALUES(2);
11 INSERT INTO t1 VALUES(3);
12 INSERT INTO t1 VALUES(4);
18 INSERT INTO t3 SELECT a FROM t1;
20 INSERT INTO t1 SELECT * FROM t1;
35 INSERT INTO t3 SELECT a FROM t1;
H A Dmisc2.test27 CREATE TRIGGER foo_insert BEFORE INSERT ON foo BEGIN
31 INSERT INTO foo(bar) VALUES (1);
36 INSERT INTO foo(bar) VALUES (111);
45 INSERT INTO t1 VALUES(1,2,3);
47 INSERT INTO t2 VALUES(7,8,9);
71 INSERT INTO t1 VALUES(4000000000,'a','b');
77 INSERT INTO t1 VALUES(2147483648,'b2','c2');
78 INSERT INTO t1 VALUES(2147483647,'b3','c3');
128 INSERT INTO t1 VALUES(1,2);
143 INSERT INTO t1 VALUES(1);
[all …]
H A Dioerr.test42 INSERT INTO t1 VALUES(1,2,3);
43 INSERT INTO t1 VALUES(4,5,6);
47 INSERT INTO t1 VALUES(1,2,3);
48 INSERT INTO t1 VALUES(4,5,6);
84 INSERT INTO t1 VALUES(1, randstr(5,50), randstr(5,50));
85 INSERT INTO t1 SELECT a+2, b||'-'||rowid, c||'-'||rowid FROM t1;
86 INSERT INTO t1 SELECT a+4, b||'-'||rowid, c||'-'||rowid FROM t1;
87 INSERT INTO t1 SELECT a+8, b||'-'||rowid, c||'-'||rowid FROM t1;
88 INSERT INTO t1 SELECT a+16, b||'-'||rowid, c||'-'||rowid FROM t1;
89 INSERT INTO t1 SELECT a+32, b||'-'||rowid, c||'-'||rowid FROM t1;
[all …]
H A Dtrans.test27 INSERT INTO one VALUES(1,'one');
28 INSERT INTO one VALUES(2,'two');
29 INSERT INTO one VALUES(3,'three');
36 INSERT INTO two VALUES(1,'I');
37 INSERT INTO two VALUES(5,'V');
38 INSERT INTO two VALUES(10,'X');
109 INSERT INTO one VALUES(4,'four');
127 INSERT INTO two VALUES(4,'IV');
268 execsql {INSERT INTO one(a,b) VALUES('hello', 1)}
361 INSERT INTO t2 VALUES(1,2,3);
[all …]
H A Ddelete.test38 execsql {INSERT INTO table1 VALUES(1,2)}
39 execsql {INSERT INTO table1 VALUES(2,4)}
40 execsql {INSERT INTO table1 VALUES(3,8)}
41 execsql {INSERT INTO table1 VALUES(4,16)}
92 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
103 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
118 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
190 execsql {INSERT INTO table1 VALUES(2,3)}
198 execsql {INSERT INTO table2 VALUES(2,3)}
206 INSERT INTO t3 VALUES(1);
[all …]
H A Dvacuum.test36 INSERT INTO t1 VALUES(NULL,randstr(10,100),randstr(5,50));
37 INSERT INTO t1 VALUES(123456,randstr(10,100),randstr(5,50));
38 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
39 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
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;
155 INSERT INTO Test VALUES (NULL);
[all …]
H A Drowid.test26 INSERT INTO t1 VALUES(1,2);
27 INSERT INTO t1 VALUES(3,4);
95 INSERT INTO t1(rowid,x,y) VALUES(1234,5,6);
107 INSERT INTO t1(y,x,oid) VALUES(8,7,1235);
119 INSERT INTO t1(x,_rowid_,y) VALUES(9,1236,10);
171 INSERT INTO t2 VALUES(0,2,3);
172 INSERT INTO t2 VALUES(4,5,6);
173 INSERT INTO t2 VALUES(7,8,9);
204 execsql "INSERT INTO t1(x,y) VALUES($i,[expr {$i*$i}])"
206 execsql {INSERT INTO t2 SELECT _rowid_, x*y, y*y FROM t1}
[all …]
H A Dversion.test29 INSERT INTO t1 VALUES(1);
30 INSERT INTO t1 SELECT x+1 FROM t1;
31 INSERT INTO t1 SELECT x+2 FROM t1;
32 INSERT INTO t1 SELECT x+4 FROM t1;
101 INSERT INTO cnt VALUES('t1',0,0);
102 INSERT INTO cnt VALUES('t2',0,0);
103 CREATE TRIGGER r1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
109 CREATE TRIGGER r3 AFTER INSERT ON t2 FOR EACH ROW BEGIN
117 INSERT INTO t1 VALUES(1);
118 INSERT INTO t1 SELECT x+1 FROM t1;
[all …]
H A Dattach.test30 INSERT INTO t1 VALUES(1,2);
31 INSERT INTO t1 VALUES(3,4);
39 INSERT INTO t2 VALUES(1,'x');
40 INSERT INTO t2 VALUES(2,'y');
212 INSERT INTO tx(x1,x2,y1,y2) VALUES(OLD.x,NEW.x,OLD.y,NEW.y);
385 INSERT INTO t3 VALUES(1,2);
393 INSERT INTO t3 VALUES(9,10);
410 INSERT INTO db2.t3 VALUES(9,10);
420 CREATE TRIGGER t3r3 AFTER INSERT ON t3 BEGIN
421 INSERT INTO t4 VALUES('db2.' || NEW.x);
[all …]

1234