Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add test cases to this branch. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | tkt-61c853-A |
| Files: | files | file ages | folders |
| SHA3-256: |
f37317d81cc2864ed57c76a734735131 |
| User & Date: | dan 2019-08-05 20:45:53 |
Context
|
2019-08-05
| ||
| 20:53 | Ensure that columns of views and sub-queries that are expressions with no affinity are not assigned BLOB affinity. This matches the documentation. Fix for [61c853857f40da49]. (On a branch because there are still subtle issues.) check-in: e15a0977 user: dan tags: pending | |
| 20:45 | Add test cases to this branch. Closed-Leaf check-in: f37317d8 user: dan tags: tkt-61c853-A | |
| 19:44 | Fix the patch on this branch so that it works with sub-queries, as well as views. check-in: 7480db30 user: dan tags: tkt-61c853-A | |
Changes
Changes to test/view.test.
719 720 721 722 723 724 725 726 727 |
WITH v17(x,y) AS (SELECT max(a), min(b) FROM t16 GROUP BY c)
SELECT * FROM v17 AS one, v17 AS two WHERE one.x=1;
} {
1 1 1 1
1 1 2 2
1 1 3 3
}
finish_test
|
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 |
WITH v17(x,y) AS (SELECT max(a), min(b) FROM t16 GROUP BY c)
SELECT * FROM v17 AS one, v17 AS two WHERE one.x=1;
} {
1 1 1 1
1 1 2 2
1 1 3 3
}
#-------------------------------------------------------------------------
reset_db
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
} {}
do_execsql_test view-27.5 {
SELECT 1 FROM v0 WHERE c0<c1
} {1}
do_execsql_test view-27.6 {
SELECT c0<c1 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0)
} 1
do_execsql_test view-27.7 {
SELECT c1<c0 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0)
} 0
do_execsql_test view-27.8 {
SELECT 1 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0) WHERE c1<c0
} {}
do_execsql_test view-27.9 {
SELECT 1 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0) WHERE c0<c1
} {1}
finish_test
|
Changes to test/window9.test.
126 127 128 129 130 131 132 133 134 135 136 |
SELECT c IN (
SELECT min(a) OVER (),
(abs(row_number() OVER())+22)/19,
max(a) OVER () FROM t1
) AS y FROM t2
);
} {1 {sub-select returns 3 columns - expected 1}}
finish_test
|
> > > > > > > > > > > > > > > |
126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 |
SELECT c IN (
SELECT min(a) OVER (),
(abs(row_number() OVER())+22)/19,
max(a) OVER () FROM t1
) AS y FROM t2
);
} {1 {sub-select returns 3 columns - expected 1}}
#-------------------------------------------------------------------------
reset_db
do_execsql_test 4.0 {
CREATE TABLE t1(a, b TEXT);
INSERT INTO t1 VALUES('A', 1), ('A', 2), ('2', 1), ('2', 2);
}
do_execsql_test 4.1.1 {
SELECT b, b=count(*), '1,2' FROM t1 GROUP BY b;
} {1 0 1,2 2 1 1,2}
do_execsql_test 4.1.2 {
SELECT b, b=count(*), group_concat(b) OVER () FROM t1 GROUP BY b;
} {1 0 1,2 2 1 1,2}
finish_test
|