Home
last modified time | relevance | path

Searched refs:insert (Results 1 – 25 of 112) sorted by relevance

12345

/sqlite-3.40.0/test/
H A Dinsert.test20 do_test insert-1.1 {
27 do_test insert-1.2 {
34 do_test insert-1.3 {
39 do_test insert-1.3b {
43 do_test insert-1.3c {
47 do_test insert-1.3d {
54 do_test insert-1.4 {
61 do_test insert-1.5 {
74 do_test insert-1.6 {
90 do_test insert-2.1 {
[all …]
H A Dlaststmtchanges.test31 # changes() set properly after insert
35 insert into t0 values (1);
36 insert into t0 values (1);
37 insert into t0 values (2);
38 insert into t0 values (2);
39 insert into t0 values (1);
40 insert into t0 values (1);
41 insert into t0 values (1);
42 insert into t0 values (2);
113 insert into t1 values (77);
[all …]
H A Dtrigger4.test34 insert into test values(1,2,3);
47 insert into test values(4,5,6);
90 insert into test values(7,8,9);
97 insert into test values(7,8,9);
113 insert into test values(7,8,9);
147 insert into tbl values (new.a,new.b);
149 insert into tbl values(101,1001);
150 insert into tbl values(102,1002);
172 #test insert into view
175 insert into vw values(102,1002);
[all …]
H A Dlastinsert.test32 insert into t1 values (1);
33 insert into t1 values (NULL);
34 insert into t1 values (NULL);
45 insert into t1w values (123456);
91 # 2.x - tests with after insert trigger
102 insert into t1 values (13);
114 # LIRID changed properly by insert within context of after insert trigger
168 # 4.x - tests with instead of insert trigger
183 insert into v values (15);
319 insert into t1 values (77);
[all …]
H A Dtkt3419.test29 insert into a values (1);
30 insert into a values (2);
32 insert into b values (3, 1);
33 insert into b values (4, 1);
34 insert into b values (5, 1);
35 insert into b values (6, 1);
36 insert into b values (9, 2);
38 insert into c values (4, 3);
39 insert into c values (5, 5);
40 insert into c values (6, 4);
[all …]
H A Djoin4.test25 insert into t1 values(1,'one');
26 insert into t1 values(2,'two');
27 insert into t1 values(3,'three');
28 insert into t1 values(4,'four');
31 insert into t2 values(2,'niban','ok');
32 insert into t2 values(4,'yonban','err');
42 insert into t1 values(1,'one');
43 insert into t1 values(2,'two');
44 insert into t1 values(3,'three');
45 insert into t1 values(4,'four');
[all …]
H A Dupsert2.test66 # On an ON CONFLICT DO UPDATE, the before-insert, before-update, and
75 VALUES('before-insert',format('%d,%d,%d',new.a,new.b,new.c));
79 VALUES('after-insert',printf('%d,%d,%d',new.a,new.b,new.c));
98 # On an ON CONFLICT DO NOTHING, only the before-insert trigger fires.
104 } {before-insert 1,2,0}
114 } {before-insert 1,2,0}
126 VALUES('before-insert',format('%d,%d,%d',new.a,new.b,new.c));
130 VALUES('after-insert',printf('%d,%d,%d',new.a,new.b,new.c));
149 # On an ON CONFLICT DO NOTHING, only the before-insert trigger fires.
155 } {before-insert 1,2,0}
[all …]
H A Dnull.test26 insert into t1 values(1,0,0);
27 insert into t1 values(2,0,1);
28 insert into t1 values(3,1,0);
29 insert into t1 values(4,1,1);
30 insert into t1 values(5,null,0);
31 insert into t1 values(6,null,1);
32 insert into t1 values(7,null,null);
200 insert into t2 values(1,1);
203 insert into t2 values(4,1);
210 insert into t3 values(1,1,1);
[all …]
H A Dtkt2339.test26 insert into t1 values (1);
27 insert into t1 values (2);
28 insert into t1 values (3);
29 insert into t1 values (4);
32 insert into t2 values (11);
33 insert into t2 values (12);
34 insert into t2 values (13);
35 insert into t2 values (14);
H A Dschema4.test40 INSERT INTO log VALUES('after insert', new.a, new.b);
56 } {{after insert} 1 2 {after update} 2 3 {after delete} 2 3}
70 } {{after insert} 1 2 {after update} 2 3 {after delete} 2 3}
81 } {{after insert} 1 2 {after update} 2 3 {after delete} 2 3}
102 } {{after insert} 1 2 {after update} 2 3 {after delete} 2 3}
117 INSERT INTO log VALUES('after insert', new.a, new.b);
130 } {{after insert} a b {after delete} a b}
140 } {{after insert} c d {after delete} c d}
167 } {{after insert} e f {after update} g h {after delete} g h}
H A Dmalloctraceviewer.tcl57 $::O(text) insert end "$L\n" highlight
59 $::O(text) insert end "$L\n"
72 $::O(text) insert end "\n\n"
75 $::O(text) insert end $L
76 $::O(text) insert end " [string repeat - 64]\n"
93 $::O(text) insert end $L $tags
171 $::O(tree) insert $parent_id end -id $stack -text $line -values $v
H A DcorruptC.test95 # insert corrupt byte(s)
114 # insert corrupt byte(s)
136 # insert corrupt byte(s)
148 # insert corrupt byte(s)
160 # insert corrupt byte(s)
180 # insert corrupt byte(s)
193 # insert corrupt byte(s)
209 # insert corrupt byte(s)
230 # insert corrupt byte(s)
242 # insert corrupt byte(s)
[all …]
H A Dmisc4.test144 insert into a values('01','data01');
145 insert into a values('+1','data+1');
147 insert into b values ('01',1);
148 insert into b values ('01',2);
149 insert into b values ('+1',3);
150 insert into b values ('+1',4);
180 insert into t4 values (1,2);
181 insert into t5 values (1,3);
H A Dsort.test225 insert into t3 values(5,NULL);
226 insert into t3 values(6,NULL);
227 insert into t3 values(3,NULL);
228 insert into t3 values(4,'cd');
229 insert into t3 values(1,'ab');
230 insert into t3 values(2,NULL);
447 insert into t8 values(1,2,3);
448 insert into t8 values(2,3,4);
450 insert into t9 values(2,4);
451 insert into t9 values(2,3);
[all …]
H A Dmain.test450 insert into T1 values(0.5);
451 insert into T1 values(0.5e2);
452 insert into T1 values(0.5e-002);
453 insert into T1 values(5e-002);
454 insert into T1 values(-5.0e-2);
455 insert into T1 values(-5.1e-2);
456 insert into T1 values(0.5e2);
457 insert into T1 values(0.5E+02);
458 insert into T1 values(5E+02);
459 insert into T1 values(5.0E+03);
H A Dtkt2942.test38 insert into t1 values (2);
39 insert into t1 values (1);
40 insert into t1 values (3);
41 insert into t1 values (4);
H A Dconflict3.test39 # Insert a row that conflicts on column B. The insert should be ignored.
69 # Insert a row that conflicts on column B. The insert should be ignored.
99 # Insert a row that conflicts on column B. The insert should be ignored.
129 # Insert a row that conflicts on column B. The insert should be ignored.
159 # Insert a row that conflicts on column B. The insert should be ignored.
189 # Insert a row that conflicts on column B. The insert should be ignored.
219 # Insert a row that conflicts on column B. The insert should be ignored.
249 # Insert a row that conflicts on column B. The insert should be ignored.
279 # Insert a row that conflicts on column B. The insert should be ignored.
309 # Insert a row that conflicts on column B. The insert should be ignored.
[all …]
H A Dmisc5.test50 insert into t2 values(1);
51 insert or ignore into t2 select x*2 from t2;
52 insert or ignore into t2 select x*4 from t2;
53 insert or ignore into t2 select x*16 from t2;
57 insert or ignore into t2 select x-1 from t2;
58 insert or ignore into t2 select x+1 from t2;
59 insert or ignore into t2 select -x from t2;
69 insert into t2_temp values(1);
70 insert into t2_temp select x*2 from t2_temp;
71 insert into t2_temp select x*4 from t2_temp;
[all …]
H A Dtkt3357.test24 insert into a(b_id, myvalue) values(1,'Test');
25 insert into a(b_id, myvalue) values(1,'Test2');
26 insert into a(b_id, myvalue) values(1,'Test3');
27 insert into b(bvalue) values('btest');
H A DcorruptE.test75 # insert corrupt byte(s)
87 # insert corrupt byte(s)
99 # insert corrupt byte(s)
112 # insert corrupt byte(s)
142 # insert corrupt byte(s)
H A DselectC.test221 insert into t_distinct_bug values ('1', '1', 'a');
222 insert into t_distinct_bug values ('1', '2', 'b');
223 insert into t_distinct_bug values ('1', '3', 'c');
224 insert into t_distinct_bug values ('1', '1', 'd');
225 insert into t_distinct_bug values ('1', '2', 'e');
226 insert into t_distinct_bug values ('1', '3', 'f');
H A Dshell1.test207 catchcmd "test.db" ".mode \"insert FOO"
210 catchcmd "test.db" ".mode \'insert FOO"
430 # insert SQL insert statements for TABLE
451 catchcmd "test.db" ".mode insert"
917 # Test the output of ".mode insert"
920 catchcmd test.db ".mode insert t1\nselect * from t1;"
928 # Test the output of ".mode insert" with headers
931 catchcmd test.db ".mode insert t1\n.headers on\nselect * from t1;"
939 # Test the output of ".mode insert"
942 catchcmd test.db ".mode insert t3\nselect * from t3;"
[all …]
H A DselectG.test21 # that this insert happens quickly (in less than 10 seconds). Actually, the
22 # insert will normally happen in less than 0.5 seconds on a workstation, but
25 # the insert run for over a minute.
/sqlite-3.40.0/contrib/
H A Dsqlitecon.tcl131 $w insert insert $a
132 $w yview insert
161 $w delete insert {insert lineend}
174 $w delete insert
188 $w mark set insert {insert lineend}
216 $w insert end \n
238 $w insert end $x
242 $w yview insert
428 $w yview insert
588 $w insert insert $line
[all …]
/sqlite-3.40.0/ext/rbu/
H A Drbu10.test58 INSERT INTO data_ft VALUES('a', 'b', 22, 1, 0); -- insert
59 INSERT INTO data_ft VALUES('a', 'b', 23, 10, 0); -- insert
60 INSERT INTO data_ft VALUES('a', 'b', 24, 100, 0); -- insert
75 INSERT INTO data_ft VALUES('a', 'b', 25, 0); -- insert

12345