Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
30 check-ins related to "index-expr"
|
2015-09-04
| ||
| 17:32 | Add support for CREATE INDEX statements that use deterministic expressions rather than only column names. (check-in: 2131a5ca53 user: drh tags: trunk) | |
| 13:02 | Merge trunk enhancements, and espeically the fix for allowing strings as column identifers in CREATE INDEX statements. (Closed-Leaf check-in: 5ff8552938 user: drh tags: index-expr) | |
| 12:54 | Continue to support the (broken) legacy syntax of allowing strings for column names in CREATE INDEX statements and in UNIQUE and PRIMARY KEY constraints. (check-in: 3d3df79bfa user: drh tags: trunk) | |
|
2015-09-03
| ||
| 14:18 | Merge enhancements from trunk. (check-in: 1ab10cbf27 user: drh tags: index-expr) | |
| 13:46 | Add the sqlite3VdbeLoadString() and sqlite3VdbeMultiLoad() routines to help with code generation, especially on PRAGMAs. Rename sqlite3VdbeAddGoto() to just sqlite3VdbeGoto(). (check-in: 847387ec8e user: drh tags: trunk) | |
|
2015-09-01
| ||
| 13:17 | Rename SQLITE_FUNC_VARYING to SQLITE_FUNC_SLOCHNG - a more descriptive name for what that bit means. (check-in: ff5137a6dd user: drh tags: index-expr) | |
| 00:42 | Remove unreachable branches. (check-in: fd4da2318c user: drh tags: index-expr) | |
|
2015-08-31
| ||
| 23:09 | Fix a bug in error reporting when a UNIQUE index on expressions fails its uniqueness test. (check-in: 5a2c0e90a1 user: drh tags: index-expr) | |
| 21:16 | Not only date/time functions, but also functions like sqlite_version() and changes() need to be prohibited from use inside of indexes. (check-in: 4871313039 user: drh tags: index-expr) | |
| 19:38 | Always assume that indexed expressions can generate a NULL. Get indexed expressions working for the case of two or more expressions in the same index. (check-in: cc60321a67 user: drh tags: index-expr) | |
| 18:13 | Case should not be significant when comparing function names. (check-in: e2f1caf117 user: drh tags: index-expr) | |
| 17:34 | Make the distinction between truly deterministic functions and date/time functions which only return the same answer for a single query. Only truly deterministic functions are allowed in indexes. Add new expression index test cases. (check-in: c77554b5c4 user: drh tags: index-expr) | |
| 15:58 | Improved analysis and usage of indexed expressions in the query planner. (check-in: f889369638 user: drh tags: index-expr) | |
| 14:27 | Merge the latest enhancements from trunk. (check-in: 7bde6d4d8c user: drh tags: index-expr) | |
|
2015-08-29
| ||
| 19:41 | Enhance the json_extract() function so that if given multiple PATH arguments it will return a JSON array with all of the answers. Also update comments within the json1 extension to reflect stricter interpretation of JSON and PATH arguments. (check-in: 1da60c3dda user: drh tags: trunk) | |
|
2015-08-27
| ||
| 23:42 | Fix the OR-optimization so that it always ignores subplans that do not use an index. (check-in: cf452028d1 user: drh tags: index-expr) | |
| 23:18 | Fix the OR-optimization so that it always ignores subplans that do not use an index. (check-in: 66f92a1686 user: drh tags: trunk) | |
| 20:33 | Fix EXPLAIN QUERY PLAN output for indexed-expressions. Fix another obscure fault in the WHERE term scanner. (check-in: 73d361ce9e user: drh tags: index-expr) | |
| 19:56 | Fix problems in the indexed-expression handling in the optimizer. (check-in: 0337501769 user: drh tags: index-expr) | |
| 18:24 | Activate the ability to use expressions in indexes in a query. There are some test failures, but mostly this seems to work. (check-in: 42f93f582e user: drh tags: index-expr) | |
| 16:07 | Merge changes from trunk. (check-in: c80e9e8e8c user: drh tags: index-expr) | |
| 15:58 | Adjustments to the WHERE term scanning, to better handle scanning terms of an index. (check-in: 5611130a59 user: drh tags: index-expr) | |
|
2015-08-26
| ||
| 21:08 | Reduce the size of the WhereScan object by 24 bytes while also clarifying its operation. (check-in: cbc3c9a8bf user: drh tags: trunk) | |
| 18:04 | Merge enhancements from trunk. (check-in: ec6ddb3d48 user: drh tags: index-expr) | |
| 14:01 | Evaluate expressions only once when the same expression is used in both the result set and in the ORDER BY clause. (check-in: c2f3bbad77 user: drh tags: trunk) | |
|
2015-08-25
| ||
| 19:24 | Merge trunk enhancements. (check-in: e8b02902c4 user: drh tags: index-expr) | |
| 19:20 | Use the sqlite3IndexColumnAffinity() routine to quickly and correctly find the affinity of an index column. (check-in: 1ee089a72d user: drh tags: trunk) | |
| 16:57 | Add code to maintain indexes with expression arguments across DELETE, INSERT, and UPDATE statements. Legacy tests pass, but the new code paths are still largely untested. The query planner currently makes no effort to use expression indexes. (check-in: efaabdb716 user: drh tags: index-expr) | |
| 00:27 | Changes toward being able to process indexes on expressions. Not there yet - this check-in is just movement in that direction. Some tests are failing. (check-in: 0ad0f8d77d user: drh tags: index-expr) | |
|
2015-08-24
| ||
| 20:54 | Remove some redundant code: Call sqlite3ResolveExprListNames() rather than calling sqlite3ResolveExprNames() in a loop - in two places. (check-in: bdaf66465b user: drh tags: trunk) | |