{"push_id":3290011042,"size":867,"distinct_size":0,"ref":"refs/heads/left-join-omit-fix","head":"cc19a8fa4c500a1d9ade841290040b0e0c8b1363","before":"185026640ab13222434d0e0ccebe6a20d3d4b7d9","commits":[{"sha":"0aa0b680f68c0bcec48cc0514c187d4b31987adf","author":{"name":"D. Richard Hipp","email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com"},"message":"When evaluating a query that uses an index on an expression,\ntry to use the expression values read directly from the index\nrather than reevaluating the expression.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/0aa0b680f68c0bcec48cc0514c187d4b31987adf"},{"sha":"e349881ead156752eb3063b320b3267940d07ed2","author":{"name":"Dan Kennedy","email":"a4aac279ee5b55b5f0af80a0fcf06b2bad2cf62e@gmail.com"},"message":"Fix a segfault that could occur if an indexed expression was used in a\ncomparison operation within the result-set of a SELECT statement.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/e349881ead156752eb3063b320b3267940d07ed2"},{"sha":"098ed37f0664dc158d7ea87192f8819749ec1013","author":{"name":"D. Richard Hipp","email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com"},"message":"Add an ALWAYS() around an unreachable condition in sqlite3VdbeMemGrow().","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/098ed37f0664dc158d7ea87192f8819749ec1013"},{"sha":"9b9ed0013d131156fbd582378fcec8b0c3d80ecc","author":{"name":"D. Richard Hipp","email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com"},"message":"Very slight smaller and faster sqlite3SelectNew()","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/9b9ed0013d131156fbd582378fcec8b0c3d80ecc"},{"sha":"dcef968d27049ca1e6c29629f8fb775a844bdca3","author":{"name":"D. Richard Hipp","email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com"},"message":"Smaller and faster implementation of exprMightBeIndexed().","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/dcef968d27049ca1e6c29629f8fb775a844bdca3"},{"sha":"f272614160d2e09e70e93de8820190520c199415","author":{"name":"D. Richard Hipp","email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com"},"message":"Limit the depth of recursion for valid JSON in the JSON1 extension in order\nto avoid using excess stack space in the recursive descent parser.\nFix for ticket [981329adeef51011052667a9].","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/f272614160d2e09e70e93de8820190520c199415"},{"sha":"b188c5f47442989d210e4281ec11ed1b3b85c03d","author":{"name":"Dan Kennedy","email":"a4aac279ee5b55b5f0af80a0fcf06b2bad2cf62e@gmail.com"},"message":"Avoid updating unaffected indexes on a table as part of an UPDATE that requires\nforeign key processing in some cases.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/b188c5f47442989d210e4281ec11ed1b3b85c03d"},{"sha":"8e31af044562d22aeeab32fc52b560c7e126155c","author":{"name":"Dan Kennedy","email":"a4aac279ee5b55b5f0af80a0fcf06b2bad2cf62e@gmail.com"},"message":"Avoid updating unaffected indexes on a table as part of an UPDATE that\nrequires foreign key processing in some cases.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/8e31af044562d22aeeab32fc52b560c7e126155c"},{"sha":"ca5ea4cf46a1c755c5e191e862abd79ce516ccd8","author":{"name":"D. Richard Hipp","email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com"},"message":"Improved \\n and \\r escapes in the ext/misc/dbdump.c utility function.  The\nimplementation of dbdump.c now matches the implementation in the CLI.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/ca5ea4cf46a1c755c5e191e862abd79ce516ccd8"},{"sha":"fef9b0b77f62e7de26fbaf682ebaf7afcec166a9","author":{"name":"Dan Kennedy","email":"a4aac279ee5b55b5f0af80a0fcf06b2bad2cf62e@gmail.com"},"message":"Update fts5 to support \"<colset> : ( <expr> )\" for column filtering, as well\nas \"<colset> : NEAR(...)\" and \"<colset> : <phrase>\".","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/fef9b0b77f62e7de26fbaf682ebaf7afcec166a9"},{"sha":"97a551d8d70f22a735288796037534ae5ce6a58b","author":{"name":"D. Richard Hipp","email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com"},"message":"Fix a regression caused by the fix for ticket [6c9b5514077fed34551f98e64c09a1] -\ncontrol characters allowed in JSON.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/97a551d8d70f22a735288796037534ae5ce6a58b"},{"sha":"b7ffb8e97685f09bc5c67c0fcad8c047a65b46cd","author":{"name":"D. Richard Hipp","email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com"},"message":"Forward port the skip-ahead-distinct branch which was abandoned for some reason\nthat I do not recall.  This port should have been achived by a merge of trunk\ninto the previous head of skip-ahead-distinct, but that did not work.  So I had\nto manually \"rebase\" the changes.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/b7ffb8e97685f09bc5c67c0fcad8c047a65b46cd"},{"sha":"70770420812f5c693a77dc7758cfee5a5854d169","author":{"name":"Dan Kennedy","email":"a4aac279ee5b55b5f0af80a0fcf06b2bad2cf62e@gmail.com"},"message":"Allow a user column name to be used on the LHS of a MATCH operator in FTS5.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/70770420812f5c693a77dc7758cfee5a5854d169"},{"sha":"cf698b3e53e9d08c37142d5c64c19d9868094637","author":{"name":"D. Richard Hipp","email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com"},"message":"Only use the skip-ahead-distinct optimization if the index has been analyzed\nand we know that a skip-head is likely to skip over at least 11 rows.  The\nmagic number 11 was determined by experimentation.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/cf698b3e53e9d08c37142d5c64c19d9868094637"},{"sha":"2e630aa5abc056ed41e9b099e28baa83b7688fb3","author":{"name":"Dan Kennedy","email":"a4aac279ee5b55b5f0af80a0fcf06b2bad2cf62e@gmail.com"},"message":"Update the code in test_delete.c to use the \"win32\" VFS if SQLITE_OS_WIN is\ndefined.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/2e630aa5abc056ed41e9b099e28baa83b7688fb3"},{"sha":"618f7f4d14dd4badbbbf6e34c52398e50c1b7ad4","author":{"name":"Dan Kennedy","email":"a4aac279ee5b55b5f0af80a0fcf06b2bad2cf62e@gmail.com"},"message":"Reinstate the SQLITE_API qualifier on the sqlite3_delete_database() method in\ntest_delete.c. Accidentally removed by the previous commit.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/618f7f4d14dd4badbbbf6e34c52398e50c1b7ad4"},{"sha":"5de320e77e113af62c6c69babb549f521149c65a","author":{"name":"Dan Kennedy","email":"a4aac279ee5b55b5f0af80a0fcf06b2bad2cf62e@gmail.com"},"message":"New test cases and minor fixes for the optimization on this branch.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/5de320e77e113af62c6c69babb549f521149c65a"},{"sha":"85d4692deb18376d62af5ebac89cb7955612d0d0","author":{"name":"D. Richard Hipp","email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com"},"message":"Simplification of the skip-ahead-distinct logic.  There is still an issue\nwith handling COLLATE.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/85d4692deb18376d62af5ebac89cb7955612d0d0"},{"sha":"4d3caf85074e91630bf575d6b683106b1379c143","author":{"name":"D. Richard Hipp","email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com"},"message":"Fix the skip-ahead-distinct optimization so that it works with indexes that\nhave repeated columns with different collating sequences.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/4d3caf85074e91630bf575d6b683106b1379c143"},{"sha":"30a93080a11aa63664b463d966c59730f9e78313","author":{"name":"D. Richard Hipp","email":"19e8170b3975f5a24906acea19ec2df9a77a603a@hwaci.com"},"message":"Fix a couple of unreachable branches.","distinct":false,"url":"https://api.github.com/repos/mackyle/sqlite/commits/30a93080a11aa63664b463d966c59730f9e78313"}]}
{"actor":{"display_login":"mackyle"}}