/ Check-in [f16d127c]
Login

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

Overview
Comment:Enhance the xBestIndex method on delta_parse() to return SQLITE_CONSTRAINT if no delta argument is supplied.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: f16d127c3b4a735afae1fc236bcf90f31adff079c7d3a896f901d908ff8b8532
User & Date: drh 2019-02-19 20:29:05
Context
2019-02-20
12:52
When an IN operator drives a query loop, mark it as "CODED" so that it will not be used afterwards for a (pointless) membership test. This is a better fix for ticket [df46dfb631f75694] than the previous fix that is now on a branch as it preserves the full optimization of check-in [e130319317e76119]. check-in: fa792714 user: drh tags: trunk
03:38
Back off the optimization of check-in [e130319317e76119] slightly so that it only applies to IN operators that are used for membership tests. Proposed fix for ticket [df46dfb631f75694]. Closed-Leaf check-in: b5f90bfe user: drh tags: tkt-df46dfb631
2019-02-19
20:29
Enhance the xBestIndex method on delta_parse() to return SQLITE_CONSTRAINT if no delta argument is supplied. check-in: f16d127c user: drh tags: trunk
20:19
Add the delta_parse(DELTA) table-valued function to the fossildelta extension. check-in: d91fcc26 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to ext/misc/fossildelta.c.

   970    970       pIdxInfo->estimatedRows = 10;
   971    971       pIdxInfo->idxNum = 1;
   972    972       return SQLITE_OK;
   973    973     }
   974    974     pIdxInfo->idxNum = 0;
   975    975     pIdxInfo->estimatedCost = (double)0x7fffffff;
   976    976     pIdxInfo->estimatedRows = 0x7fffffff;
   977         -  return SQLITE_OK;
          977  +  return SQLITE_CONSTRAINT;
   978    978   }
   979    979   
   980    980   /*
   981    981   ** This following structure defines all the methods for the 
   982    982   ** virtual table.
   983    983   */
   984    984   static sqlite3_module deltaparsevtabModule = {