Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix a couple of problems in estimating the number of rows visited by a range query that uses a skip-scan. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | stat4-skipscan |
Files: | files | file ages | folders |
SHA1: |
219736f54dcd1448af3400e699f1c207 |
User & Date: | dan 2014-06-27 20:14:25.215 |
Context
2014-06-28
| ||
14:25 | Merge fixes from trunk with this branch. (check-in: 6af219d1b8 user: dan tags: stat4-skipscan) | |
2014-06-27
| ||
20:14 | Fix a couple of problems in estimating the number of rows visited by a range query that uses a skip-scan. (check-in: 219736f54d user: dan tags: stat4-skipscan) | |
2014-06-26
| ||
21:32 | Fix compilation issue when STAT4 is not enabled. (check-in: 74a5454a71 user: mistachkin tags: stat4-skipscan) | |
Changes
Changes to src/vdbemem.c.
︙ | |||
1292 1293 1294 1295 1296 1297 1298 | 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 | - + | int iField; int i; u8 *a = (u8*)pRec; iHdr = getVarint32(a, nHdr); iField = nHdr; for(i=0; i<iCol; i++){ |
︙ |
Changes to src/where.c.
︙ | |||
2041 2042 2043 2044 2045 2046 2047 | 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 | - - + + + + - + - + - + + + + + + + - - + + + + + + + | WhereTerm *pUpper, /* Upper bound on the range. ex: "x<455" Might be NULL */ WhereLoop *pLoop, /* Update the .nOut value of this loop */ int *pbDone /* Set to true if at least one expr. value extracted */ ){ Index *p = pLoop->u.btree.pIndex; int nEq = pLoop->u.btree.nEq; sqlite3 *db = pParse->db; |
︙ |
Added test/skipscan5.test.