/ Check-in [c1057b2a]
Login

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 | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: c1057b2a60add08e5c80ef2a53932a690b096f2eb03c7de863844deaa8fc9d53
User & Date: dan 2019-05-23 16:40:45
Context
2019-05-24
11:55
Fix an fts5 segfault that could occur after parsing a corrupt structure record. check-in: 600daa9c user: dan tags: trunk
2019-05-23
16:40
Add test cases for the fix in the previous commit. check-in: c1057b2a 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: d2fe370c user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/with1.test.

  1112   1112       )
  1113   1113       SELECT D.Id Id, P.Name Protocol, T.Att Att, T.Val Val, T.Act Act
  1114   1114       FROM t1 D
  1115   1115       CROSS JOIN v2 P
  1116   1116       CROSS JOIN t4 T;
  1117   1117     SELECT * FROM v3;
  1118   1118   } {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}
         1119  +
         1120  +#-------------------------------------------------------------------------
         1121  +reset_db
         1122  +do_execsql_test 24.1 {
         1123  +  CREATE TABLE t1(a, b, c);
         1124  +  CREATE VIEW v1 AS SELECT max(a), min(b) FROM t1 GROUP BY c;
         1125  +}
         1126  +do_test 24.1 {
         1127  +  set program [db eval {EXPLAIN SELECT 1 FROM v1,v1,v1}]
         1128  +  expr [lsearch $program OpenDup]>0
         1129  +} {1}
         1130  +do_execsql_test 24.2 {
         1131  +  ATTACH "" AS aux;
         1132  +  CREATE VIEW aux.v3 AS VALUES(1);
         1133  +  CREATE VIEW main.v3 AS VALUES(3);
         1134  +
         1135  +  CREATE VIEW aux.v2 AS SELECT * FROM v3;
         1136  +  CREATE VIEW main.v2 AS SELECT * FROM v3;
         1137  +
         1138  +  SELECT * FROM main.v2 AS a, aux.v2 AS b, aux.v2 AS c, main.v2 AS d;
         1139  +} {
         1140  +  3 1 1 3
         1141  +}
  1119   1142   
  1120   1143   finish_test