/ Check-in [3d3b142f]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:If the query flattener detects an error, cause the SELECT code generator to abort immediately.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 3d3b142f1045080beb775a9cfe88ec143aa460750132e20059fd510291449850
User & Date: drh 2019-02-06 00:55:47
Context
2019-02-06
01:18
When extending the size of SrcList objects, do not attempt to use extra space on the end of the allocation, as that provides scarcely any performance benefit but does greatly complicate cross-platform testing. check-in: 3087a0c3 user: drh tags: trunk
00:55
If the query flattener detects an error, cause the SELECT code generator to abort immediately. check-in: 3d3b142f user: drh tags: trunk
00:11
Back out check-in [008112bcef561a8], reenabling deprecated PRAGMAs when the SQLITE_OMIT_DEPRECATED compile-time option is used, because way too many TH3 tests depend on those deprecated PRAGMAs. check-in: 9dbf512d user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/select.c.

  5739   5739        && (pTabList->nSrc==1
  5740   5740            || (pTabList->a[1].fg.jointype&(JT_LEFT|JT_CROSS))!=0)
  5741   5741       ){
  5742   5742         continue;
  5743   5743       }
  5744   5744   
  5745   5745       if( flattenSubquery(pParse, p, i, isAgg) ){
         5746  +      if( pParse->nErr ) goto select_end;
  5746   5747         /* This subquery can be absorbed into its parent. */
  5747   5748         i = -1;
  5748   5749       }
  5749   5750       pTabList = p->pSrc;
  5750   5751       if( db->mallocFailed ) goto select_end;
  5751   5752       if( !IgnorableOrderby(pDest) ){
  5752   5753         sSort.pOrderBy = p->pOrderBy;

Changes to test/with1.test.

  1085   1085              SELECT 1 FROM c,c,c,c,c,c,c,c,c
  1086   1086           )
  1087   1087           SELECT  2 FROM c,c,c,c,c,c,c,c,c
  1088   1088        )
  1089   1089        SELECT 3 FROM c,c,c,c,c,c,c,c,c
  1090   1090     )
  1091   1091     SELECT 4 FROM c,c,c,c,c,c,c,c,c;
  1092         -} {1 {at most 64 tables in a join}}
         1092  +} {1 {too many FROM clause terms, max: 200}}
  1093   1093   
  1094   1094   finish_test