{"push_id":782093309,"size":46,"distinct_size":2,"ref":"refs/heads/master","head":"9c5ef80605ea983a644deb744e45d6c8147f6171","before":"4d47f30faaf052338d1ff9c10899941d80f74bac","commits":[{"sha":"ed18865f21d1aaff84090d642ddedc9ceadb04f6","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Changes toward being abld to process indexes on expressions.  Not there yet - \nthis check-in is just movement in that direction.  Some tests are failing.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/ed18865f21d1aaff84090d642ddedc9ceadb04f6"},{"sha":"b1886ff7e19992bf766558532e05df4a2733db03","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Add code to maintain indexes with expression arguments across DELETE, INSERT,\nand UPDATE statements.  Legacy tests pass, but the new code paths are still\nlargely untested.  The query planner currently makes no effort to use\nexpression indexes.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/b1886ff7e19992bf766558532e05df4a2733db03"},{"sha":"707a789c37aba3075c8bb90e47426011a257050b","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Merge trunk enhancements.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/707a789c37aba3075c8bb90e47426011a257050b"},{"sha":"bad07ff8197b0a0dafce03efc59b17c99ddf851d","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Merge enhancements from trunk.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/bad07ff8197b0a0dafce03efc59b17c99ddf851d"},{"sha":"e2a81a18a52ab882914b971279392527be3b265b","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Adjustments to the WHERE term scanning, to better handle scanning terms of\nan index.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/e2a81a18a52ab882914b971279392527be3b265b"},{"sha":"6fb1426f802ed031446eb8f605ece1bc16f9c4ee","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Merge changes from trunk.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/6fb1426f802ed031446eb8f605ece1bc16f9c4ee"},{"sha":"77d72440c30771eb969ef8884ea98887908ce4d9","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Activate the ability to use expressions in indexes in a query.  There are some\ntest failures, but mostly this seems to work.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/77d72440c30771eb969ef8884ea98887908ce4d9"},{"sha":"42c94c1809d4906db9f4eb351e124aa54f6ef99e","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Fix problems in the indexed-expression handling in the optimizer.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/42c94c1809d4906db9f4eb351e124aa54f6ef99e"},{"sha":"4f8dff3bbd38024f4e17c345cb0a0f6040f3607a","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Fix EXPLAIN QUERY PLAN output for indexed-expressions.  Fix another\nobscure fault in the WHERE term scanner.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/4f8dff3bbd38024f4e17c345cb0a0f6040f3607a"},{"sha":"bda6c9884784842f42bc5a8788d93322e98c0bb3","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Fix the OR-optimization so that it always ignores subplans that do not use an index.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/bda6c9884784842f42bc5a8788d93322e98c0bb3"},{"sha":"49443a74a4941832166c5d55edeeec8129bbf6e6","author":{"email":"a4aac279ee5b55b5f0af80a0fcf06b2bad2cf62e@gmail.com","name":"Dan Kennedy"},"message":"Change the fts5 tokenizer API to allow more than one token to occupy a single position within a document.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/49443a74a4941832166c5d55edeeec8129bbf6e6"},{"sha":"2c55ea99675f1bf584b16ce87b68f75237adacf8","author":{"email":"a4aac279ee5b55b5f0af80a0fcf06b2bad2cf62e@gmail.com","name":"Dan Kennedy"},"message":"Another change to the fts5 tokenizer API.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/2c55ea99675f1bf584b16ce87b68f75237adacf8"},{"sha":"90a2f58f58e516d91b3715c31b1e6f753604590e","author":{"email":"a4aac279ee5b55b5f0af80a0fcf06b2bad2cf62e@gmail.com","name":"Dan Kennedy"},"message":"Add a test for an fts5 tokenizer that supports synonyms by adding multiple entries to the fts index.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/90a2f58f58e516d91b3715c31b1e6f753604590e"},{"sha":"89c8186fe47f51eddd6f0d1890a55b18358f9135","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Merge the latest enhancements from trunk.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/89c8186fe47f51eddd6f0d1890a55b18358f9135"},{"sha":"be009533a126e8761f84706e640776891ad24ed5","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Improved analysis and usage of indexed expressions in the query planner.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/be009533a126e8761f84706e640776891ad24ed5"},{"sha":"c7ead3484c3b63c2f16d8a3ca50cd9b0cc4d04c8","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Make the distinction between truly deterministic functions and date/time\nfunctions which only return the same answer for a single query.  Only truly\ndeterministic functions are allowed in indexes.  Add new expression index\ntest cases.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/c7ead3484c3b63c2f16d8a3ca50cd9b0cc4d04c8"},{"sha":"30aac35f69410cddb9a7193c98e039f46344755e","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Case should not be significant when comparing function names.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/30aac35f69410cddb9a7193c98e039f46344755e"},{"sha":"882cea16aae5a0cba0e05124aa45d554de7f9c2d","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Always assume that indexed expressions can generate a NULL.  Get\nindexed expressions working for the case of two or more expressions in\nthe same index.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/882cea16aae5a0cba0e05124aa45d554de7f9c2d"},{"sha":"31cd8277953b4eda81e249d1c077c0c496ef837f","author":{"email":"a4aac279ee5b55b5f0af80a0fcf06b2bad2cf62e@gmail.com","name":"Dan Kennedy"},"message":"Begin changes to allow synonym support by adding multiple terms to a query (an alternative to adding multiple terms to the FTS index).","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/31cd8277953b4eda81e249d1c077c0c496ef837f"},{"sha":"1fd8afe35d9b0060c32a6ef416457d0f951a20ab","author":{"email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com","name":"D. Richard Hipp"},"message":"Not only date/time functions, but also functions like sqlite_version() and\nchanges() need to be prohibited from use inside of indexes.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/1fd8afe35d9b0060c32a6ef416457d0f951a20ab"}]}