| Index: third_party/sqlite/sqlite-src-3100200/test/insert2.test
|
| diff --git a/third_party/sqlite/sqlite-src-3080704/test/insert2.test b/third_party/sqlite/sqlite-src-3100200/test/insert2.test
|
| similarity index 93%
|
| copy from third_party/sqlite/sqlite-src-3080704/test/insert2.test
|
| copy to third_party/sqlite/sqlite-src-3100200/test/insert2.test
|
| index 6876d538ae5cce42a5da56f4a86f5d92bffc488d..977fbc584ac2d2a8705f9c258087a87a2eb0595c 100644
|
| --- a/third_party/sqlite/sqlite-src-3080704/test/insert2.test
|
| +++ b/third_party/sqlite/sqlite-src-3100200/test/insert2.test
|
| @@ -16,6 +16,7 @@
|
|
|
| set testdir [file dirname $argv0]
|
| source $testdir/tester.tcl
|
| +set testprefix insert2
|
|
|
| # Create some tables with data that we can select against
|
| #
|
| @@ -275,4 +276,23 @@ ifcapable subquery {
|
| } {1 2 1 3 1 4}
|
| }
|
|
|
| +do_execsql_test 6.0 {
|
| + CREATE TABLE t5(a, b, c DEFAULT 'c', d);
|
| +}
|
| +do_execsql_test 6.1 {
|
| + INSERT INTO t5(a) SELECT 456 UNION ALL SELECT 123 ORDER BY 1;
|
| + SELECT * FROM t5 ORDER BY rowid;
|
| +} {123 {} c {} 456 {} c {}}
|
| +
|
| +ifcapable fts3 {
|
| + do_execsql_test 6.2 {
|
| + CREATE VIRTUAL TABLE t0 USING fts4(a);
|
| + }
|
| + do_execsql_test 6.3 {
|
| + INSERT INTO t0 SELECT 0 UNION SELECT 0 AS 'x' ORDER BY x;
|
| + SELECT * FROM t0;
|
| + } {0}
|
| +}
|
| +
|
| +
|
| finish_test
|
|
|