/ Check-in [0c946f08]
Login

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

Overview
Comment:Fix an obsolete comment that defines the meaning of one of the parameters to the sqlite3FindInIndex() subroutine. No changes to code.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 0c946f0846b2835f8facca806a4d4ecc2b2e97343de245a0d91716d998b2a829
User & Date: drh 2019-09-02 01:25:07
Context
2019-09-02
02:21
When applying the IN_INDEX_NOOP optimization and the LHS has REAL affinity, also apply REAL affinity to each element of the RHS. Ticket [2841e99d104c6436]. check-in: 88833a9c user: drh tags: trunk
01:25
Fix an obsolete comment that defines the meaning of one of the parameters to the sqlite3FindInIndex() subroutine. No changes to code. check-in: 0c946f08 user: drh tags: trunk
00:58
When computing an expression value for an index-on-expression or a CHECK constraint and the expressions uses a REAL table column, but the value of that column is an integer (in other words, when it is using the store-real-as-integer optimization) be sure to promote the value to real before evaluating the expression. Ticket [57af00b6642ecd68]. check-in: 0658c16e user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/expr.c.

  2395   2395   **   CREATE INDEX i1 ON t1(b, c, a);
  2396   2396   **
  2397   2397   ** then aiMap[] is populated with {2, 0, 1}.
  2398   2398   */
  2399   2399   #ifndef SQLITE_OMIT_SUBQUERY
  2400   2400   int sqlite3FindInIndex(
  2401   2401     Parse *pParse,             /* Parsing context */
  2402         -  Expr *pX,                  /* The right-hand side (RHS) of the IN operator */
         2402  +  Expr *pX,                  /* The IN expression */
  2403   2403     u32 inFlags,               /* IN_INDEX_LOOP, _MEMBERSHIP, and/or _NOOP_OK */
  2404   2404     int *prRhsHasNull,         /* Register holding NULL status.  See notes */
  2405   2405     int *aiMap,                /* Mapping from Index fields to RHS fields */
  2406   2406     int *piTab                 /* OUT: index to use */
  2407   2407   ){
  2408   2408     Select *p;                            /* SELECT to the right of IN operator */
  2409   2409     int eType = 0;                        /* Type of RHS table. IN_INDEX_* */