{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":176278485,"defaultBranch":"master","name":"sqlite","ownerLogin":"sqlite","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2019-03-18T12:21:01.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/48680494?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1714133282.0","currentOid":""},"activityList":{"items":[{"before":"b95c1d0ac9d020a9abd51c221194e188f25b69a9","after":"b11daa50f9ea11c332bb5913a071c5a0fd6c9993","ref":"refs/heads/master","pushedAt":"2024-04-26T20:08:01.000Z","pushType":"push","commitsCount":9,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Fix issues in [/info/1e227ad9f413227f|LIMIT/OFFSET support for virtual tables].\nThe first problem was reported by\n[forum:/forumpost/c243b8f856|forum post c243b8f856].  That report prompted\nan enhancement to the generate_series() (also included in this merge) which\nin turn identified other similar issues.\n\nFossilOrigin-Name: 5f6c079d847e3664ec5acaf1b3e989efe0d548c211ae4a18936162b36df89065","shortMessageHtmlLink":"Fix issues in [/info/1e227ad9f413227f|LIMIT/OFFSET support for virtua…"}},{"before":"297472a2fcae79eb2e531d8c93fdb7f36725afdb","after":"4c3ab545a91d50fd13e711dc250cce6927407ca2","ref":"refs/heads/vtab-limit-fix","pushedAt":"2024-04-26T19:08:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Allow virtual table implementations to handle OFFSET but not LIMIT, but not LIMIT but not OFFSET.\n\nFossilOrigin-Name: 90e5c8226a695e838e8c1703a9b8598e654d216799e8806c4d1a1f20c28c6486","shortMessageHtmlLink":"Allow virtual table implementations to handle OFFSET but not LIMIT, b…"}},{"before":"fed13d50a98b1c173449e0626dd3bb19f791e495","after":"b95c1d0ac9d020a9abd51c221194e188f25b69a9","ref":"refs/heads/master","pushedAt":"2024-04-26T19:08:01.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Internal JS doc touchups. No functional changes.\n\nFossilOrigin-Name: 626b997b4e727554d7ec8b60fb37b2a94cb861a87325da4ae484bd9aa8961ca5","shortMessageHtmlLink":"Internal JS doc touchups. No functional changes."}},{"before":"84a231eb619f462ea183969eb29be23f5f4ecdda","after":"297472a2fcae79eb2e531d8c93fdb7f36725afdb","ref":"refs/heads/vtab-limit-fix","pushedAt":"2024-04-26T18:08:03.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Have where.c ignore any plan from a virtual table that tries to use LIMIT/OFFSET without also using all WHERE constraints.\n\nFossilOrigin-Name: 7d30596496c6a7a37b925f13d8d94d5de224ec31bb86594fa4cc07b10082e776","shortMessageHtmlLink":"Have where.c ignore any plan from a virtual table that tries to use L…"}},{"before":"99ac2324aa7f52713d4a14b29e0dde6f2c9479aa","after":"84a231eb619f462ea183969eb29be23f5f4ecdda","ref":"refs/heads/vtab-limit-fix","pushedAt":"2024-04-26T15:08:00.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Use hex flag masks rather than decimals in ext/misc/series.c.\n\nFossilOrigin-Name: a94e2cd02873c283d46bf6c21d0306ad454881d7882bb167d043cc79f79a2396","shortMessageHtmlLink":"Use hex flag masks rather than decimals in ext/misc/series.c."}},{"before":"d591a5b93d4f84c3e0a3080109936be22292607f","after":"99ac2324aa7f52713d4a14b29e0dde6f2c9479aa","ref":"refs/heads/vtab-limit-fix","pushedAt":"2024-04-26T14:08:02.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Fix handling of LIMIT and OFFSET in virtual tables that are part of\na compound SELECT.\n\nFossilOrigin-Name: 40421c1c4ed5bb1ed79ad7ee37cb5a4f0b7864c1eb94abd8ee357ab2202cad30","shortMessageHtmlLink":"Fix handling of LIMIT and OFFSET in virtual tables that are part of"}},{"before":null,"after":"d591a5b93d4f84c3e0a3080109936be22292607f","ref":"refs/heads/vtab-limit-fix","pushedAt":"2024-04-26T12:08:02.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Add test demonstrating the problem at [forum:/forumpost/c243b8f856|forum post c243b8f856]. No fix yet.\n\nFossilOrigin-Name: 1685495c0a00238c9c92cce01af8108204a2fad22433ed3e7bba3c9da9ee0766","shortMessageHtmlLink":"Add test demonstrating the problem at [forum:/forumpost/c243b8f856|fo…"}},{"before":"ec14ef80b03eb0b7bd05a6ce3beb07c9601bde63","after":"fed13d50a98b1c173449e0626dd3bb19f791e495","ref":"refs/heads/master","pushedAt":"2024-04-26T12:08:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Fix the TreeView display of a LIMIT clause on a compound query.  Debugging\ncode only - not part of production builds.\n\nFossilOrigin-Name: 38f1e5ce4eedd59fbeb0a0d676d26dfe8a3313189ab9b9e4a5a1ed6721b73a14","shortMessageHtmlLink":"Fix the TreeView display of a LIMIT clause on a compound query. Debug…"}},{"before":"c859f0267c3f53a0bb8ee92125ee9a5d2a6153ee","after":"ec14ef80b03eb0b7bd05a6ce3beb07c9601bde63","ref":"refs/heads/master","pushedAt":"2024-04-26T00:08:02.000Z","pushType":"push","commitsCount":4,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Improvement to the way that affinity is determined for columns of a\ncompound subquery.  The affinity is the affinity of the left-most\narm of the compound subquery that has an affinity other than NONE, adjusted\nto accommodate the data types coming out of the other arms.\n\nFossilOrigin-Name: e6df846f36209bac3e420dd80ce2bbbd87ab7a20b8063fce05f78a3c7ab6027e","shortMessageHtmlLink":"Improvement to the way that affinity is determined for columns of a"}},{"before":"23afc2c4ec1abc95f61e75411926527e93ebb500","after":"ddc6bd9f21ab9420eb91beec3f2e49f595116eb2","ref":"refs/heads/compound-subquery-affinity","pushedAt":"2024-04-25T18:07:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Further improvements to the computation of affinity for compound subqueries:\nmake sure that the selected affinity is compatible with a literal values in\narms to the left of the arm that is used to determine affinity.\n\nFossilOrigin-Name: bbdf22e3d989f42b963f1f2f219dfeac11db786f17ac27097ab72f72e7638a2a","shortMessageHtmlLink":"Further improvements to the computation of affinity for compound subq…"}},{"before":"f8e195159f933d310587bd991f66965ba184c252","after":"23afc2c4ec1abc95f61e75411926527e93ebb500","ref":"refs/heads/compound-subquery-affinity","pushedAt":"2024-04-25T17:07:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Back out the previous change on this branch.  In its place:  Determine the\naffinity of a subquery by the left-most arm of the subquery that has an\naffinity other than NONE.  In other words, scan from left to right looking\nfor an arm of the compound subquery with an affinity of BLOB, TEXT, INTEGER,\nor REAL and pick the first one found.  Or stay with NONE if no arm has a\ndefined affinity.  Test cases added.\n\nFossilOrigin-Name: b8ec8511b1968bbc1472b3e2e21f0fef1d5becebeb31f9d13ee3ca9e13abb1e5","shortMessageHtmlLink":"Back out the previous change on this branch. In its place: Determine the"}},{"before":"0868d58e2caa16f19e843602bf2ca58653653162","after":"c859f0267c3f53a0bb8ee92125ee9a5d2a6153ee","ref":"refs/heads/master","pushedAt":"2024-04-25T07:08:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"wasm: add a makefile comment about the static sqlite3.h/c version info injected into the JS files possibly differing from the runtime-emited version info when a user provides their own sqlite3.c.\n\nFossilOrigin-Name: d99a01a0f6e1f70f70c9a0625aeaa8a8015eba352bcfb3978eafca6df10ba5a8","shortMessageHtmlLink":"wasm: add a makefile comment about the static sqlite3.h/c version inf…"}},{"before":null,"after":"f8e195159f933d310587bd991f66965ba184c252","ref":"refs/heads/compound-subquery-affinity","pushedAt":"2024-04-24T20:07:57.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"An experimental minor tweak to the way affinities are computed for compound\nsubqueries, when the actual affinity is ambiguous.\n\nFossilOrigin-Name: 779723ad792ca24dd07b7a1425303c76b44bb173e718a33c26c9f7644e9912cb","shortMessageHtmlLink":"An experimental minor tweak to the way affinities are computed for co…"}},{"before":"dfa628915328180a3cbb96d4407c11212258db94","after":"0868d58e2caa16f19e843602bf2ca58653653162","ref":"refs/heads/master","pushedAt":"2024-04-24T17:07:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"If a RETURNING clause contains a subquery that references the table that is\nbeing updated in the statement that includes the RETURNING clause, then mark\nthe subquery as correlated sot hat it is recomputed for each result and not\njust computed once and reused.  See\n[forum:/forumpost/2c83569ce8945d39|forum post 2c83569ce8945d39].\n\nFossilOrigin-Name: 9ea6bcc8fdf6aadb756ec5bcaaa7af314167f8973bdd32fd23f83bd964f0c21e","shortMessageHtmlLink":"If a RETURNING clause contains a subquery that references the table t…"}},{"before":"35b771e221a5e70d7dc758d6a797c63e80a98fb0","after":"dfa628915328180a3cbb96d4407c11212258db94","ref":"refs/heads/master","pushedAt":"2024-04-24T15:07:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Fix a case where a corrupt stat4 record could go unrecognized due to integer overflow.\n\nFossilOrigin-Name: 240a4a48b27a2b1070bba6d7da76a8df8e3f1808e262045d7ad2cf910df08f3d","shortMessageHtmlLink":"Fix a case where a corrupt stat4 record could go unrecognized due to …"}},{"before":"99200b2f07034d516e863e32cc35ff0cc4c0a653","after":"35b771e221a5e70d7dc758d6a797c63e80a98fb0","ref":"refs/heads/master","pushedAt":"2024-04-24T12:07:55.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Add comments linking the assert() added in [cef4d9e3ba586735] to the places\nwhere the precondition that the assert() tests are actually required.\n\nFossilOrigin-Name: 6f0e7e195275aeb4aefd9da20348af35e3ef7f0a6b2768a34824daeace16eff1","shortMessageHtmlLink":"Add comments linking the assert() added in [cef4d9e3ba586735] to the …"}},{"before":"14602eafa74c2551deeb606b8de2ff9e4190be46","after":"99200b2f07034d516e863e32cc35ff0cc4c0a653","ref":"refs/heads/master","pushedAt":"2024-04-24T07:07:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Remove an undocumented feature from the JS Worker1.open API because it relies on broken behavior which has no VFS-agnostic workaround.\n\nFossilOrigin-Name: 3a640038c70c8511e7051af83aa35d163c4f96f05c5064cffd3e4e2e63cd44a9","shortMessageHtmlLink":"Remove an undocumented feature from the JS Worker1.open API because i…"}},{"before":"5749e1ee4386a2a6c436dfeb45770f8352abdb65","after":"0309fb919aef74ee2df3b87871c43da025cefeb4","ref":"refs/heads/vector-in-fix","pushedAt":"2024-04-23T12:07:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Fix an uninitialized variable problem in the new code on this branch.\n\nFossilOrigin-Name: 85625b38718c6e4cf7aa97fa3c52153bd25c810b68f19e7924e1f4b709c6a05d","shortMessageHtmlLink":"Fix an uninitialized variable problem in the new code on this branch."}},{"before":"3ac612dd7d242c5ed0d23000b7cb212e75a10874","after":"14602eafa74c2551deeb606b8de2ff9e4190be46","ref":"refs/heads/master","pushedAt":"2024-04-23T12:07:54.000Z","pushType":"push","commitsCount":4,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Fix a problem with vector IN operators used with an index where the affinities\nand collations for the various vector terms are different.\n\nFossilOrigin-Name: 86e8c782e7494377de3c27b750cd83a7eb2302c1182ee2004d3864db50fca557","shortMessageHtmlLink":"Fix a problem with vector IN operators used with an index where the a…"}},{"before":"6e6dfd6a236396b58b06d7636233f7687eea37b2","after":"3ac612dd7d242c5ed0d23000b7cb212e75a10874","ref":"refs/heads/master","pushedAt":"2024-04-23T07:07:53.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Remove some dead WASM-side code.\n\nFossilOrigin-Name: 0a07ee27bd6021a6fc1d81133012592351530ffcf6ae09322ea74624cff910df","shortMessageHtmlLink":"Remove some dead WASM-side code."}},{"before":"46435a04fd295e325f7d25839abd85be49d1d6d2","after":"6e6dfd6a236396b58b06d7636233f7687eea37b2","ref":"refs/heads/master","pushedAt":"2024-04-23T06:07:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"When running the 'dist' target in ext/wasm for an SEE-capable build, ensure that the resulting zip file and directory name include '-see'.\n\nFossilOrigin-Name: 04c552b12e3b77b9dfd83838d35ce19a37ed024a8c18a2000ada10cf3d1eb6ad","shortMessageHtmlLink":"When running the 'dist' target in ext/wasm for an SEE-capable build, …"}},{"before":"5d8daf184d94e86695f45ea8b8b37e9517f7b000","after":"46435a04fd295e325f7d25839abd85be49d1d6d2","ref":"refs/heads/master","pushedAt":"2024-04-22T21:07:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Add extra tests for aborting conflicts in the sessions module.\n\nFossilOrigin-Name: b4a6d32662acacb7767cfb9b8e040e6eb1f99322cb7d0cd44e6265e9ac2fb2e8","shortMessageHtmlLink":"Add extra tests for aborting conflicts in the sessions module."}},{"before":"4f2f6c74cab89f6075bc77e1ea0ba128ee8f91bf","after":"5d8daf184d94e86695f45ea8b8b37e9517f7b000","ref":"refs/heads/master","pushedAt":"2024-04-22T17:07:55.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Minor cleanups to [8fbda563d2f5].\n\nFossilOrigin-Name: 5ee2594b657b96aea9e482a175820dcbacfa9298da45b38cf17f39ad076d3f7f","shortMessageHtmlLink":"Minor cleanups to [8fbda563d2f5]."}},{"before":"2469350ad9f84d902793d9c8c6b8caeffd4c0a7c","after":"4f2f6c74cab89f6075bc77e1ea0ba128ee8f91bf","ref":"refs/heads/master","pushedAt":"2024-04-22T14:07:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Extra robustness in the code that causes cursors to return NULL when they\nare participating in an OUTER JOIN.\n\nFossilOrigin-Name: 672c2869ef48e08447d37b0d76a1850cdafbe30ca1906ec98c55e3ab496fd9a6","shortMessageHtmlLink":"Extra robustness in the code that causes cursors to return NULL when …"}},{"before":"2c26adb87397842f90122a1029cb84d3f45a4090","after":"2469350ad9f84d902793d9c8c6b8caeffd4c0a7c","ref":"refs/heads/master","pushedAt":"2024-04-22T12:07:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"For sqlite3.oo1.DB JavaScript classes, bypass execution of any on-open() SQL in SEE-capable builds because it would necessarily run before the client has an opportunity to provide their decryption key, which would leave the db handle in an unusable state and cause the ctor to throw. This currently affects only the OPFS VFSes. We may want to consider extending the ctor options object to optionally accept an SEE key and apply it when opening the db.\n\nFossilOrigin-Name: 5c505ee8a73f4b4a7053d98a12024d98340676f6ae9982311f9f88a9b46c8ae2","shortMessageHtmlLink":"For sqlite3.oo1.DB JavaScript classes, bypass execution of any on-ope…"}},{"before":"db2a33a3dd9ea37180f22dce60c2b6bbbfd781bf","after":"2c26adb87397842f90122a1029cb84d3f45a4090","ref":"refs/heads/master","pushedAt":"2024-04-22T01:07:48.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Continuation of the fix at [8c0f69e0e4ae0a44]: If a viaCoroutine FROM clause\nterm is participating in a RIGHT or FULL JOIN, we have to create an\nalways-NULL pseudo-cursor for that term when processing the RIGHT join.\ndbsqlfuzz 6fd1ff3a64bef4a6c092e8d757548e95698b0df5.\n\nFossilOrigin-Name: e1040e51ebd04f2a076f477b6f240f849afb10f543ebe518e09d6842cc3cb38e","shortMessageHtmlLink":"Continuation of the fix at [8c0f69e0e4ae0a44]: If a viaCoroutine FROM…"}},{"before":"0526db32e2657b2b16fa3333e5b8c6e24754eaf2","after":"db2a33a3dd9ea37180f22dce60c2b6bbbfd781bf","ref":"refs/heads/master","pushedAt":"2024-04-22T00:07:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Fix an indentation problem in debugging routine sqlite3ShowSrcList().  No\nchanges to production code.\n\nFossilOrigin-Name: 5560df2726fed215c98d602c5f6ebbf3c5ae23f8ba1074291c509bf446fdfe66","shortMessageHtmlLink":"Fix an indentation problem in debugging routine sqlite3ShowSrcList(). No"}},{"before":"d737feeacfdbf6ea5d44e383647ea6ced390c3ab","after":"5749e1ee4386a2a6c436dfeb45770f8352abdb65","ref":"refs/heads/vector-in-fix","pushedAt":"2024-04-20T20:07:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Slight performance improvement for the new code on this branch.\n\nFossilOrigin-Name: 500c67f1341fe2a7e7333d525c90df201cc73a683b943ad5c1e41d4a4f639043","shortMessageHtmlLink":"Slight performance improvement for the new code on this branch."}},{"before":"0c699385111dceb708dd493fa14ecf19f3737e8f","after":"d737feeacfdbf6ea5d44e383647ea6ced390c3ab","ref":"refs/heads/vector-in-fix","pushedAt":"2024-04-20T16:08:01.000Z","pushType":"push","commitsCount":2442,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Fix a problem where an expression like (a, b) IN (SELECT ...) might not use an index on (a, b) if the affinities and collation sequences of \"a\" and \"b\" are not identical.\n\nFossilOrigin-Name: 4d870fd8b5450047a7486fc023d1ac9439642e8ed91eadfd5026c4cda7cc9179","shortMessageHtmlLink":"Fix a problem where an expression like (a, b) IN (SELECT ...) might n…"}},{"before":"06915d014545ebf1b00163351e76fbaa6a3ba7b8","after":"0526db32e2657b2b16fa3333e5b8c6e24754eaf2","ref":"refs/heads/master","pushedAt":"2024-04-18T17:07:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"sqlite","name":"The SQLite Development Team","path":"/sqlite","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48680494?s=80&v=4"},"commit":{"message":"Correct handling of OUTER JOIN when on or the other operand is a subquery\nimplemented using the VALUES-as-coroutine optimization.\ndbsqlfuzz bde3bf80aedf25afa56e2997a0545a314765d3f8.\n\nFossilOrigin-Name: 8c0f69e0e4ae0a446838cc193bfd4395fd251f3c7659b35ac388e5a0a7650a66","shortMessageHtmlLink":"Correct handling of OUTER JOIN when on or the other operand is a subq…"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEO348pQA","startCursor":null,"endCursor":null}},"title":"Activity · sqlite/sqlite"}