| Index: third_party/sqlite/sqlite-src-3100200/test/vtabA.test
|
| diff --git a/third_party/sqlite/src/test/vtabA.test b/third_party/sqlite/sqlite-src-3100200/test/vtabA.test
|
| similarity index 88%
|
| copy from third_party/sqlite/src/test/vtabA.test
|
| copy to third_party/sqlite/sqlite-src-3100200/test/vtabA.test
|
| index 928cc2b703a0b129ff765f16c50e9e68d2371228..eddaa70d1f098eb239a2273405e7ec181220db5e 100644
|
| --- a/third_party/sqlite/src/test/vtabA.test
|
| +++ b/third_party/sqlite/sqlite-src-3100200/test/vtabA.test
|
| @@ -74,28 +74,39 @@ do_test vtabA-1.6 {
|
| SELECT * FROM t1e;
|
| }
|
| } {{value a} {value c}}
|
| +do_execsql_test vtabA-1.7 {
|
| + DELETE FROM t1e;
|
| + INSERT INTO t1e SELECT 'abc','def';
|
| +} {}
|
| +do_execsql_test vtabA-1.8 {
|
| + INSERT INTO t1e VALUES('ghi','jkl'),('mno','pqr'),('stu','vwx');
|
| +} {}
|
| +do_execsql_test vtabA-1.9 {
|
| + SELECT a,b,c, '|' FROM t1e ORDER BY 1;
|
| +} {abc {} def | ghi {} jkl | mno {} pqr | stu {} vwx |}
|
| +
|
|
|
| # Test that the expansion of a '*' expression in the result set of
|
| # a SELECT does not include the hidden column.
|
| #
|
| -do_test vtabA-1.7 {
|
| +do_test vtabA-1.20 {
|
| execsql {
|
| INSERT INTO t1e SELECT * FROM t1e;
|
| }
|
| } {}
|
| -do_test vtabA-1.8 {
|
| +do_test vtabA-1.21 {
|
| execsql {
|
| - SELECT * FROM t1e;
|
| + SELECT * FROM t1e ORDER BY 1;
|
| }
|
| -} {{value a} {value c} {value a} {value c}}
|
| +} {abc def abc def ghi jkl ghi jkl mno pqr mno pqr stu vwx stu vwx}
|
|
|
| # Test that the declaration type of the hidden column does not include
|
| # the token "HIDDEN".
|
| #
|
| -do_test vtabA-1.9 {
|
| +do_test vtabA-1.22 {
|
| get_decltype t1e b
|
| } {VARCHAR}
|
| -do_test vtabA-1.10 {
|
| +do_test vtabA-1.23 {
|
| get_collist t1e
|
| } {a c}
|
|
|
|
|