/ Check-in [fcb88dd6]
Login

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

Overview
Comment:Improved debugging output when the ".selecttrace" option is used in the shell.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: fcb88dd6b0f248f600c1158907889f6d5fa2c96eb4585221941da4673c6db6eb
User & Date: drh 2018-07-28 14:34:22
Context
2018-07-28
14:56
Fix an assert() statement that was made obsolete by the constant propagation enhancement. Problem discovered by OSSFuzz. check-in: e4b4737e user: drh tags: trunk
14:34
Improved debugging output when the ".selecttrace" option is used in the shell. check-in: fcb88dd6 user: drh tags: trunk
2018-07-27
23:33
Improvements to the parser to increase coverage. Fix the parser so that at least one expresssion is required after PARTITION BY and within the list of expressions on VALUES(). check-in: 02204f8b user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/select.c.

  5848   5848       */
  5849   5849       if( OptimizationEnabled(db, SQLITE_PushDown)
  5850   5850        && pushDownWhereTerms(pParse, pSub, p->pWhere, pItem->iCursor,
  5851   5851                              (pItem->fg.jointype & JT_OUTER)!=0)
  5852   5852       ){
  5853   5853   #if SELECTTRACE_ENABLED
  5854   5854         if( sqlite3SelectTrace & 0x100 ){
  5855         -        SELECTTRACE(0x100,pParse,p,("After WHERE-clause push-down:\n"));
         5855  +        SELECTTRACE(0x100,pParse,p,
         5856  +            ("After WHERE-clause push-down into subquery %d:\n", pSub->selId));
  5856   5857           sqlite3TreeViewSelect(0, p, 0);
  5857   5858         }
  5858   5859   #endif
  5859   5860       }else{
  5860   5861         SELECTTRACE(0x100,pParse,p,("Push-down not possible\n"));
  5861   5862       }
  5862   5863