Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Remove use of the affinity() function from view.test, as it is only available in SQLITE_DEBUG builds. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
7f2246a17be9915b3492624a3d8deff5 |
| User & Date: | dan 2019-08-07 19:57:21 |
Context
|
2019-08-08
| ||
| 01:39 | Remove a NEVER() that is reachable from a corrupt database. check-in: 30e6ee27a9 user: drh tags: trunk | |
|
2019-08-07
| ||
| 19:57 | Remove use of the affinity() function from view.test, as it is only available in SQLITE_DEBUG builds. check-in: 7f2246a17b user: dan tags: trunk | |
| 18:34 | Add "set TMP=%CD%" to the start of each msvc script output by releasetest_data.tcl. Otherwise, since binaries compiled with SQLITE_TEST all choose the same sequence of pseudo-random numbers, collisions between temp file names cause errors when running multiple tests in parallel. check-in: f5d0436d8d user: dan tags: trunk | |
Changes
Changes to test/view.test.
729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 |
do_execsql_test view-27.0 {
CREATE TABLE t0(c0 TEXT, c1);
INSERT INTO t0(c0, c1) VALUES (-1, 0);
CREATE VIEW v0(c0, c1) AS SELECT t0.c0, AVG(t0.c1) FROM t0;
}
do_execsql_test view-27.1 {
SELECT c0, typeof(c0), affinity(c0), c1, typeof(c1), affinity(c1) FROM v0;
} {
-1 text text
0.0 real none
}
do_execsql_test view-27.2 { SELECT c0<c1 FROM v0 } 1
do_execsql_test view-27.3 { SELECT c1<c0 FROM v0 } 0
do_execsql_test view-27.4 {
SELECT 1 FROM v0 WHERE c1<c0
} {}
|
| | | |
729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 |
do_execsql_test view-27.0 {
CREATE TABLE t0(c0 TEXT, c1);
INSERT INTO t0(c0, c1) VALUES (-1, 0);
CREATE VIEW v0(c0, c1) AS SELECT t0.c0, AVG(t0.c1) FROM t0;
}
do_execsql_test view-27.1 {
SELECT c0, typeof(c0), c1, typeof(c1) FROM v0;
} {
-1 text
0.0 real
}
do_execsql_test view-27.2 { SELECT c0<c1 FROM v0 } 1
do_execsql_test view-27.3 { SELECT c1<c0 FROM v0 } 0
do_execsql_test view-27.4 {
SELECT 1 FROM v0 WHERE c1<c0
} {}
|