Home
last modified time | relevance | path

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

12345678910>>...25

/external/chromium_org/third_party/sqlite/src/test/
Dmisc5.test31 set sql2 {INSERT INTO t1 VALUES}
79 INSERT INTO t2 SELECT DISTINCT(x) FROM t2_temp;
470 INSERT INTO songs VALUES(1,'one',1);
471 INSERT INTO songs VALUES(2,'one',2);
472 INSERT INTO songs VALUES(3,'two',3);
473 INSERT INTO songs VALUES(4,'three',5);
474 INSERT INTO songs VALUES(5,'one',7);
475 INSERT INTO songs VALUES(6,'two',11);
576 set sql "INSERT INTO t1 VALUES("
627 INSERT INTO t3 VALUES(-18);
[all …]
Dfuzzer1.test34 INSERT INTO f1(cfrom, cto, cost) VALUES('e','a',1);
35 INSERT INTO f1(cfrom, cto, cost) VALUES('a','e',10);
36 INSERT INTO f1(cfrom, cto, cost) VALUES('e','o',100);
50 INSERT INTO f2(cFrom,cTo,cost) VALUES('a','e',24);
51 INSERT INTO f2(cFrom,cTo,cost) VALUES('a','o',47);
52 INSERT INTO f2(cFrom,cTo,cost) VALUES('a','u',50);
53 INSERT INTO f2(cFrom,cTo,cost) VALUES('e','a',23);
54 INSERT INTO f2(cFrom,cTo,cost) VALUES('e','i',33);
55 INSERT INTO f2(cFrom,cTo,cost) VALUES('e','o',37);
56 INSERT INTO f2(cFrom,cTo,cost) VALUES('i','e',33);
[all …]
De_insert.test25 # e_insert-1.*: Test statements of the form "INSERT ... VALUES(...)".
27 # e_insert-2.*: Test statements of the form "INSERT ... SELECT ...".
29 # e_insert-3.*: Test statements of the form "INSERT ... DEFAULT VALUES".
51 1 "INSERT INTO a1 DEFAULT VALUES" {}
52 2 "INSERT INTO main.a1 DEFAULT VALUES" {}
53 3 "INSERT OR ROLLBACK INTO main.a1 DEFAULT VALUES" {}
54 4 "INSERT OR ROLLBACK INTO a1 DEFAULT VALUES" {}
55 5 "INSERT OR ABORT INTO main.a1 DEFAULT VALUES" {}
56 6 "INSERT OR ABORT INTO a1 DEFAULT VALUES" {}
57 7 "INSERT OR REPLACE INTO main.a1 DEFAULT VALUES" {}
[all …]
Dtkt-3998683a16.test24 INSERT INTO t1 VALUES(1, '1.0');
25 INSERT INTO t1 VALUES(2, '.125');
26 INSERT INTO t1 VALUES(3, '123.');
27 INSERT INTO t1 VALUES(4, '123.e+2');
28 INSERT INTO t1 VALUES(5, '.125e+3');
29 INSERT INTO t1 VALUES(6, '123e4');
30 INSERT INTO t1 VALUES(11, ' 1.0');
31 INSERT INTO t1 VALUES(12, ' .125');
32 INSERT INTO t1 VALUES(13, ' 123.');
33 INSERT INTO t1 VALUES(14, ' 123.e+2');
[all …]
Ddelete3.test25 INSERT INTO t1 VALUES(1);
26 INSERT INTO t1 VALUES(2);
27 INSERT INTO t1 SELECT x+2 FROM t1;
28 INSERT INTO t1 SELECT x+4 FROM t1;
29 INSERT INTO t1 SELECT x+8 FROM t1;
30 INSERT INTO t1 SELECT x+16 FROM t1;
31 INSERT INTO t1 SELECT x+32 FROM t1;
32 INSERT INTO t1 SELECT x+64 FROM t1;
33 INSERT INTO t1 SELECT x+128 FROM t1;
34 INSERT INTO t1 SELECT x+256 FROM t1;
[all …]
Dsavepoint3.test21 INSERT INTO t1 VALUES(1, 2, 3);
24 INSERT INTO t1 VALUES(4, 5, 6);
34 INSERT INTO t1 VALUES(randstr(400,400), randstr(400,400), randstr(400,400));
35 INSERT INTO t1 SELECT
37 INSERT INTO t1
39 INSERT INTO t1
41 INSERT INTO t1
43 INSERT INTO t1
45 INSERT INTO t1
47 INSERT INTO t1
[all …]
Dconflict.test39 # cmd An INSERT or REPLACE command to execute against table t1
46 1 INSERT 1 {} 1 0
47 2 {INSERT OR IGNORE} 0 3 1 0
48 3 {INSERT OR REPLACE} 0 4 1 0
50 5 {INSERT OR FAIL} 1 {} 1 0
51 6 {INSERT OR ABORT} 1 {} 1 0
52 7 {INSERT OR ROLLBACK} 1 {} {} 0
59 INSERT INTO t1 VALUES(1,2,3);
61 INSERT INTO t2 VALUES(1);
87 # cmd An INSERT or REPLACE command to execute against table t1
[all …]
Dwalfault.test74 INSERT INTO x VALUES(randomblob(100), randomblob(100));
78 INSERT INTO x SELECT randomblob(100), randomblob(100) FROM x;
79 INSERT INTO x SELECT randomblob(100), randomblob(100) FROM x;
80 INSERT INTO x SELECT randomblob(100), randomblob(100) FROM x;
109 INSERT INTO abc VALUES(randomblob(1500));
139 INSERT INTO t1 VALUES('a', 'b');
167 INSERT INTO t1 VALUES(randomblob(400)); /* 1 */
168 INSERT INTO t1 SELECT randomblob(400) FROM t1; /* 2 */
169 INSERT INTO t1 SELECT randomblob(400) FROM t1; /* 4 */
170 INSERT INTO t1 SELECT randomblob(400) FROM t1; /* 8 */
[all …]
Dioerr.test36 INSERT INTO t1 VALUES(1,2,3);
37 INSERT INTO t1 VALUES(4,5,6);
41 INSERT INTO t1 VALUES(1,2,3);
42 INSERT INTO t1 VALUES(4,5,6);
61 INSERT INTO t1 VALUES(1, randstr(50,50), randstr(50,50));
62 INSERT INTO t1 SELECT a+2, b||'-'||rowid, c||'-'||rowid FROM t1;
63 INSERT INTO t1 SELECT a+4, b||'-'||rowid, c||'-'||rowid FROM t1;
64 INSERT INTO t1 SELECT a+8, b||'-'||rowid, c||'-'||rowid FROM t1;
65 INSERT INTO t1 SELECT a+16, b||'-'||rowid, c||'-'||rowid FROM t1;
66 INSERT INTO t1 SELECT a+32, b||'-'||rowid, c||'-'||rowid FROM t1;
[all …]
Dpagerfault.test39 INSERT INTO t1 VALUES(a_string(200), a_string(300));
40 INSERT INTO t1 SELECT a_string(200), a_string(300) FROM t1;
41 INSERT INTO t1 SELECT a_string(200), a_string(300) FROM t1;
43 INSERT INTO t1 SELECT a_string(201), a_string(301) FROM t1;
44 INSERT INTO t1 SELECT a_string(202), a_string(302) FROM t1;
45 INSERT INTO t1 SELECT a_string(203), a_string(303) FROM t1;
46 INSERT INTO t1 SELECT a_string(204), a_string(304) FROM t1;
79 INSERT INTO abc VALUES('o', 't', 't');
80 INSERT INTO abc VALUES('f', 'f', 's');
81 INSERT INTO abc SELECT * FROM abc; -- 4
[all …]
Dtkt-cbd054fa6b.test28 INSERT INTO t1 VALUES (NULL, '');
29 INSERT INTO t1 VALUES (NULL, 'A');
30 INSERT INTO t1 VALUES (NULL, 'B');
31 INSERT INTO t1 VALUES (NULL, 'C');
32 INSERT INTO t1 VALUES (NULL, 'D');
33 INSERT INTO t1 VALUES (NULL, 'E');
34 INSERT INTO t1 VALUES (NULL, 'F');
35 INSERT INTO t1 VALUES (NULL, 'G');
36 INSERT INTO t1 VALUES (NULL, 'H');
37 INSERT INTO t1 VALUES (NULL, 'I');
[all …]
Dfts3defer2.test35 do_execsql_test 1.1.2 "INSERT INTO t1 VALUES('[string repeat {a } 20000]')"
36 do_execsql_test 1.1.3 "INSERT INTO t1 VALUES('[string repeat {z } 20000]')"
38 INSERT INTO t1 VALUES('a b c d e f a x y');
39 INSERT INTO t1 VALUES('');
40 INSERT INTO t1 VALUES('');
41 INSERT INTO t1 VALUES('');
42 INSERT INTO t1 VALUES('');
43 INSERT INTO t1 VALUES('');
44 INSERT INTO t1(t1) VALUES('optimize');
79 do_execsql_test 2.1.2 "INSERT INTO t2 VALUES('[string repeat {a } 10000]')"
[all …]
Dfts1e.test23 # which are used for the rowid. There are a total of 30 INSERT and
29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
34 INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
35 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
36 INSERT INTO t1 (rowid, content) VALUES(7, 'one two three');
38 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
39 INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
[all …]
Dfts1f.test23 # which are used for the rowid. There are a total of 31 INSERT,
29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
33 INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
34 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
35 INSERT INTO t1 (rowid, content) VALUES(7, 'one two three');
37 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
39 INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
[all …]
Dfts3ae.test23 # which are used for the rowid. There are a total of 30 INSERT and
29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
34 INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
35 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
36 INSERT INTO t1 (rowid, content) VALUES(7, 'one two three');
38 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
39 INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
[all …]
Dfts3af.test23 # which are used for the rowid. There are a total of 31 INSERT,
29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
33 INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
34 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
35 INSERT INTO t1 (rowid, content) VALUES(7, 'one two three');
37 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
39 INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
[all …]
Dfts2e.test23 # which are used for the rowid. There are a total of 30 INSERT and
29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
34 INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
35 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
36 INSERT INTO t1 (rowid, content) VALUES(7, 'one two three');
38 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
39 INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
[all …]
Dfts2f.test23 # which are used for the rowid. There are a total of 31 INSERT,
29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
33 INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
34 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
35 INSERT INTO t1 (rowid, content) VALUES(7, 'one two three');
37 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
39 INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
[all …]
DtriggerD.test32 CREATE TRIGGER r1 BEFORE INSERT ON t1 BEGIN
33 INSERT INTO log VALUES('r1', new.rowid, new.oid, new._rowid_, new.x);
35 CREATE TRIGGER r2 AFTER INSERT ON t1 BEGIN
36 INSERT INTO log VALUES('r2', new.rowid, new.oid, new._rowid_, new.x);
39 INSERT INTO log VALUES('r3.old', old.rowid, old.oid, old._rowid_, old.x);
40 INSERT INTO log VALUES('r3.new', new.rowid, new.oid, new._rowid_, new.x);
43 INSERT INTO log VALUES('r4.old', old.rowid, old.oid, old._rowid_, old.x);
44 INSERT INTO log VALUES('r4.new', new.rowid, new.oid, new._rowid_, new.x);
47 INSERT INTO log VALUES('r5', old.rowid, old.oid, old._rowid_, old.x);
50 INSERT INTO log VALUES('r6', old.rowid, old.oid, old._rowid_, old.x);
[all …]
Dmisc2.test32 CREATE TRIGGER foo_insert BEFORE INSERT ON foo BEGIN
36 INSERT INTO foo(bar) VALUES (1);
41 INSERT INTO foo(bar) VALUES (111);
51 INSERT INTO t1 VALUES(1,2,3);
53 INSERT INTO t2 VALUES(7,8,9);
94 INSERT INTO t1 VALUES(4000000000,'a','b');
100 INSERT INTO t1 VALUES(2147483648,'b2','c2');
101 INSERT INTO t1 VALUES(2147483647,'b3','c3');
153 INSERT INTO t1 VALUES(1,2);
172 INSERT INTO t1 VALUES(1);
[all …]
Dnotnull.test40 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
47 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5);
54 INSERT OR IGNORE INTO t1(b,c,d,e) VALUES(2,3,4,5);
61 INSERT OR REPLACE INTO t1(b,c,d,e) VALUES(2,3,4,5);
68 INSERT OR ABORT INTO t1(b,c,d,e) VALUES(2,3,4,5);
75 INSERT INTO t1(a,c,d,e) VALUES(1,3,4,5);
82 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5);
89 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
96 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,3,4,5);
103 INSERT INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
[all …]
Dinsert3.test12 # focus of this file is testing corner cases of the INSERT statement.
30 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
32 INSERT OR IGNORE INTO log VALUES(new.a, 1);
34 INSERT INTO t1 VALUES('hello','world');
35 INSERT INTO t1 VALUES(5,10);
41 INSERT INTO t1 SELECT a, b+10 FROM t1;
48 CREATE TRIGGER r2 BEFORE INSERT ON t1 BEGIN
50 INSERT OR IGNORE INTO log2 VALUES(new.b,1);
52 INSERT INTO t1 VALUES(453,'hi');
64 INSERT INTO t1 SELECT * FROM t1;
[all …]
Dminmax2.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 …]
Dinsert2.test12 # focus of this file is testing the INSERT statement that takes is
26 execsql "INSERT INTO d1 VALUES($i,$j)"
40 EXPLAIN INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
44 INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
59 INSERT INTO t1
74 INSERT INTO t1
93 INSERT INTO t1 SELECT log, count() FROM d1 GROUP BY log;
104 INSERT INTO t4 VALUES(1,2);
110 INSERT INTO t3(a,c) SELECT * FROM t4;
117 INSERT INTO t3(c,b) SELECT * FROM t4;
[all …]
/external/google-diff-match-patch/name/fraser/neil/plaintext/
Ddiff_match_patch_test.java42 private diff_match_patch.Operation INSERT = diff_match_patch.Operation.INSERT; field in diff_match_patch_test
132 …LinkedList<Diff> diffs = diffList(new Diff(EQUAL, "\u0001\u0002\u0001"), new Diff(INSERT, "\u0002\… in testDiffCharsToLines()
138 …arsToLines:", diffList(new Diff(EQUAL, "alpha\nbeta\nalpha\n"), new Diff(INSERT, "beta\nalpha\nbet… in testDiffCharsToLines()
166 diffs = diffList(new Diff(EQUAL, "a"), new Diff(DELETE, "b"), new Diff(INSERT, "c")); in testDiffCleanupMerge()
168 …hange case.", diffList(new Diff(EQUAL, "a"), new Diff(DELETE, "b"), new Diff(INSERT, "c")), diffs); in testDiffCleanupMerge()
178 diffs = diffList(new Diff(INSERT, "a"), new Diff(INSERT, "b"), new Diff(INSERT, "c")); in testDiffCleanupMerge()
180 assertEquals("diff_cleanupMerge: Merge insertions.", diffList(new Diff(INSERT, "abc")), diffs); in testDiffCleanupMerge()
182 …diffs = diffList(new Diff(DELETE, "a"), new Diff(INSERT, "b"), new Diff(DELETE, "c"), new Diff(INS… in testDiffCleanupMerge()
184 …anupMerge: Merge interweave.", diffList(new Diff(DELETE, "ac"), new Diff(INSERT, "bd"), new Diff(E… in testDiffCleanupMerge()
186 diffs = diffList(new Diff(DELETE, "a"), new Diff(INSERT, "abc"), new Diff(DELETE, "dc")); in testDiffCleanupMerge()
[all …]

12345678910>>...25