Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Modify the test cases in tkt1444.test that were failing. I am convinced that the test cases were incorrect. (CVS 3288) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 0534f6e15b84560124c3f1abd05f2967 |
| User & Date: | danielk1977 2006-06-23 14:43:30 |
Context
|
2006-06-24
| ||
| 06:36 | Clean up and clarify code in test8.c. (CVS 3289) check-in: 4acf7594 user: danielk1977 tags: trunk | |
|
2006-06-23
| ||
| 14:43 | Modify the test cases in tkt1444.test that were failing. I am convinced that the test cases were incorrect. (CVS 3288) check-in: 0534f6e1 user: danielk1977 tags: trunk | |
| 14:32 | Allow xDestroy methods to execute "DROP TABLE" statements. (CVS 3287) check-in: a56bfa56 user: danielk1977 tags: trunk | |
Changes
Changes to test/tkt1444.test.
35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 |
SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView ORDER BY 1;
}
} {1 2 3.0 1 2 3.0 9 8 7.0 9 8 7.0}
do_test tkt1444-1.2 {
execsql {
SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView;
}
} {9 8 7.0 1 2 3.0 1 2 3 9 8 7}
do_test tkt1444-1.3 {
execsql {
DROP VIEW DemoView;
CREATE VIEW DemoView AS SELECT * FROM DemoTable;
SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView ORDER BY 1;
}
} {1 2 3.0 1 2 3 9 8 7.0 9 8 7}
do_test tkt1444-1.4 {
execsql {
SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView;
}
} {9 8 7.0 1 2 3.0 9 8 7 1 2 3}
finish_test
|
| | | |
35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 |
SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView ORDER BY 1;
}
} {1 2 3.0 1 2 3.0 9 8 7.0 9 8 7.0}
do_test tkt1444-1.2 {
execsql {
SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView;
}
} {9 8 7.0 1 2 3.0 1 2 3.0 9 8 7.0}
do_test tkt1444-1.3 {
execsql {
DROP VIEW DemoView;
CREATE VIEW DemoView AS SELECT * FROM DemoTable;
SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView ORDER BY 1;
}
} {1 2 3.0 1 2 3.0 9 8 7.0 9 8 7.0}
do_test tkt1444-1.4 {
execsql {
SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView;
}
} {9 8 7.0 1 2 3.0 9 8 7.0 1 2 3.0}
finish_test
|