Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add test cases for the fix in the previous commit. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
c1057b2a60add08e5c80ef2a53932a69 |
| User & Date: | dan 2019-05-23 16:40:45.620 |
Context
|
2019-05-24
| ||
| 11:55 | Fix an fts5 segfault that could occur after parsing a corrupt structure record. (check-in: 600daa9c27 user: dan tags: trunk) | |
|
2019-05-23
| ||
| 16:40 | Add test cases for the fix in the previous commit. (check-in: c1057b2a60 user: dan tags: trunk) | |
| 16:38 | Improvements to the view-self-join optimization so that it works on all VIEWs, not just on Common Table Expressions. (check-in: d2fe370caf user: drh tags: trunk) | |
Changes
Changes to test/with1.test.
| ︙ | ︙ | |||
1112 1113 1114 1115 1116 1117 1118 1119 1120 |
)
SELECT D.Id Id, P.Name Protocol, T.Att Att, T.Val Val, T.Act Act
FROM t1 D
CROSS JOIN v2 P
CROSS JOIN t4 T;
SELECT * FROM v3;
} {1 A C D E 1 A F G H 1 B C D E 1 B F G H 2 A C D E 2 A F G H 2 B C D E 2 B F G H 3 A C D E 3 A F G H 3 B C D E 3 B F G H 4 A C D E 4 A F G H 4 B C D E 4 B F G H 5 A C D E 5 A F G H 5 B C D E 5 B F G H}
finish_test
| > > > > > > > > > > > > > > > > > > > > > > > | 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 |
)
SELECT D.Id Id, P.Name Protocol, T.Att Att, T.Val Val, T.Act Act
FROM t1 D
CROSS JOIN v2 P
CROSS JOIN t4 T;
SELECT * FROM v3;
} {1 A C D E 1 A F G H 1 B C D E 1 B F G H 2 A C D E 2 A F G H 2 B C D E 2 B F G H 3 A C D E 3 A F G H 3 B C D E 3 B F G H 4 A C D E 4 A F G H 4 B C D E 4 B F G H 5 A C D E 5 A F G H 5 B C D E 5 B F G H}
#-------------------------------------------------------------------------
reset_db
do_execsql_test 24.1 {
CREATE TABLE t1(a, b, c);
CREATE VIEW v1 AS SELECT max(a), min(b) FROM t1 GROUP BY c;
}
do_test 24.1 {
set program [db eval {EXPLAIN SELECT 1 FROM v1,v1,v1}]
expr [lsearch $program OpenDup]>0
} {1}
do_execsql_test 24.2 {
ATTACH "" AS aux;
CREATE VIEW aux.v3 AS VALUES(1);
CREATE VIEW main.v3 AS VALUES(3);
CREATE VIEW aux.v2 AS SELECT * FROM v3;
CREATE VIEW main.v2 AS SELECT * FROM v3;
SELECT * FROM main.v2 AS a, aux.v2 AS b, aux.v2 AS c, main.v2 AS d;
} {
3 1 1 3
}
finish_test
|