Documentation Source Text

Check-in [be35c1ae8e]
Login

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

Overview
Comment:Enhance the comment on the sqlite3_index_constraint.iColumn field to help bring attention to the fact that it can be negative for a rowid column.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: be35c1ae8eff7940de37725bdda3bbaddf1e6537
User & Date: drh 2016-02-02 02:05:07.812
Context
2016-02-02
03:15
Update the change log. (check-in: 430d0b230f user: drh tags: trunk)
02:05
Enhance the comment on the sqlite3_index_constraint.iColumn field to help bring attention to the fact that it can be negative for a rowid column. (check-in: be35c1ae8e user: drh tags: trunk)
2016-01-26
15:04
Update the file format document to indicate that the number of rows in an index in sqlite_stat1 can be less than the number of table rows in the case of a partial index. (check-in: 42f14ae85f user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/vtab.in.
︙︙
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592

forms the reply. The [sqlite3_index_info] structure looks like this:

<blockquote><pre>
  struct sqlite3_index_info {
    /* Inputs */
    const int nConstraint;     /* Number of entries in aConstraint */
    const struct sqlite3_index_constraint {
       int iColumn;              /* Column on left-hand side of constraint */
       unsigned char op;         /* Constraint operator */
       unsigned char usable;     /* True if this constraint is usable */
       int iTermOffset;          /* Used internally - xBestIndex should ignore */
    } *const aConstraint;      /* Table of WHERE clause constraints */
    const int nOrderBy;        /* Number of terms in the ORDER BY clause */
    const struct sqlite3_index_orderby {
       int iColumn;              /* Column number */








|








578
579
580
581
582
583
584
585
586
587
588
589
590
591
592

forms the reply. The [sqlite3_index_info] structure looks like this:

<blockquote><pre>
  struct sqlite3_index_info {
    /* Inputs */
    const int nConstraint;     /* Number of entries in aConstraint */
    const struct sqlite3_index_constraint {
       int iColumn;              /* Column constrained.  -1 for ROWID */
       unsigned char op;         /* Constraint operator */
       unsigned char usable;     /* True if this constraint is usable */
       int iTermOffset;          /* Used internally - xBestIndex should ignore */
    } *const aConstraint;      /* Table of WHERE clause constraints */
    const int nOrderBy;        /* Number of terms in the ORDER BY clause */
    const struct sqlite3_index_orderby {
       int iColumn;              /* Column number */
︙︙