{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":9342529,"defaultBranch":"master","name":"crate","ownerLogin":"crate","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2013-04-10T09:17:16.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/4048232?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1717612474.0","currentOid":""},"activityList":{"items":[{"before":"d348c3073f65ecd0d51213977be68b2cfaec5cb6","after":"403f92c16fb2115bd589cbf1d2a2af5c6229a887","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T19:43:27.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Enable push down of constant join conditions down in outer/cross joins\n\nThis pr changes optimizer_move_constant_join_conditions_beneath_join\nso the constant join condition is extracted from inner/outer/cross joins\nto a filter on top of the join which can then be pushed by\noptimizer_move_filter_beneath_join.","shortMessageHtmlLink":"Enable push down of constant join conditions down in outer/cross joins"}},{"before":"ea3688d18ed80999ac665492c35e72ba941f8996","after":null,"ref":"refs/heads/mergify/bp/5.7/pr-16098","pushedAt":"2024-06-05T19:42:29.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"mergify[bot]","name":null,"path":"/apps/mergify","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/10562?s=80&v=4"}},{"before":"1123154796f4ded3559a7ae474bc9af4c29b27cd","after":"8d5755a28897d9d86b5188558eecad850ead4d17","ref":"refs/heads/5.7","pushedAt":"2024-06-05T19:42:29.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"mergify[bot]","name":null,"path":"/apps/mergify","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/10562?s=80&v=4"},"commit":{"message":"Fix issue with slow query because of PK extraction\n\nWhen a query in the `WHERE` clause uses PK columns and combines them\ninto complex expressions using logical operators, `EqualityExtractor`,\nwhich calculates a cartesian product over those sub-expressions, can\nend up using lots of time because of the large number of iterations\nover this product.\n\nAdd an iteration counter and a limit of 10k iterations to break early\nand avoid spending too much time during this pk extraction phase. If\nafter those 10k iterations not all PKs are detected, then a `Collect`\nplan will be used instead of a `Get`.\n\nRelates: #16066\n(cherry picked from commit 2d40b150bdd47224c8c7d865ddb6699fb112262f)","shortMessageHtmlLink":"Fix issue with slow query because of PK extraction"}},{"before":"38c7b65d4e4eaa41ee5b11ace57e133b51a91f0c","after":"ea3688d18ed80999ac665492c35e72ba941f8996","ref":"refs/heads/mergify/bp/5.7/pr-16098","pushedAt":"2024-06-05T19:31:24.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"BaurzhanSakhariev","name":"Baur","path":"/BaurzhanSakhariev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7446940?s=80&v=4"},"commit":{"message":"Merge branch '5.7' into mergify/bp/5.7/pr-16098","shortMessageHtmlLink":"Merge branch '5.7' into mergify/bp/5.7/pr-16098"}},{"before":"7abddd1d781a89140d9c68cc35d30e75d9c60cb6","after":"d348c3073f65ecd0d51213977be68b2cfaec5cb6","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T19:09:29.000Z","pushType":"push","commitsCount":4,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Merge branch 'master' into mkleen/constant-outer-joins","shortMessageHtmlLink":"Merge branch 'master' into mkleen/constant-outer-joins"}},{"before":"c855e38f62f7c8869d63e1efd32bba77f4f5063d","after":"7abddd1d781a89140d9c68cc35d30e75d9c60cb6","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T19:01:29.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Enable push down of constant join conditions down in outer/cross joins\n\nThis pr changes optimizer_move_constant_join_conditions_beneath_join\nso the constant join condition is extracted from inner/outer/cross joins\nto a filter on top of the join which can then be pushed by\noptimizer_move_filter_beneath_join.","shortMessageHtmlLink":"Enable push down of constant join conditions down in outer/cross joins"}},{"before":"58fb86524342a5cf8fc8c66d8a6dd1369cce8117","after":"1123154796f4ded3559a7ae474bc9af4c29b27cd","ref":"refs/heads/5.7","pushedAt":"2024-06-05T18:34:34.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"mergify[bot]","name":null,"path":"/apps/mergify","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/10562?s=80&v=4"},"commit":{"message":"Always check session user existence\n\nSuperuser can use SET SESSION AUTHORIZATION and then drop the active user.\n\nHowever, it was still possible to execute some queries under the dropped user session.\n\nAnalyze now checks for user existence to avoid confusion.\n\n(cherry picked from commit ecc5aaa80447d950508e1c3b7be939fe91afdf54)","shortMessageHtmlLink":"Always check session user existence"}},{"before":"b95e5230392e4cd90d583ab3208ef39d3111dd3a","after":null,"ref":"refs/heads/mergify/bp/5.7/pr-16100","pushedAt":"2024-06-05T18:34:34.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"mergify[bot]","name":null,"path":"/apps/mergify","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/10562?s=80&v=4"}},{"before":"6361aa250b31437e2c88e129b51dd43d21e914a7","after":"38c7b65d4e4eaa41ee5b11ace57e133b51a91f0c","ref":"refs/heads/mergify/bp/5.7/pr-16098","pushedAt":"2024-06-05T18:14:17.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"mergify[bot]","name":null,"path":"/apps/mergify","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/10562?s=80&v=4"},"commit":{"message":"Merge branch '5.7' into mergify/bp/5.7/pr-16098","shortMessageHtmlLink":"Merge branch '5.7' into mergify/bp/5.7/pr-16098"}},{"before":"d3d12daed31fa11fe7618afbff5903552e0a1d11","after":"a11c33309dbca7ddf75083736146782fd77340be","ref":"refs/heads/jeeminso/table-is-visible","pushedAt":"2024-06-05T17:56:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jeeminso","name":null,"path":"/jeeminso","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7191458?s=80&v=4"},"commit":{"message":"Fix tests","shortMessageHtmlLink":"Fix tests"}},{"before":"18398bbf44605f330d74b78eafa2dc9e9225aeaf","after":"c855e38f62f7c8869d63e1efd32bba77f4f5063d","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T17:32:05.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Enable push down of constant join conditions down in outer/cross joins\n\nThis pr changes optimizer_move_constant_join_conditions_beneath_join\nso the constant join condition is extracted from inner/outer/cross joins\nto a filter on top of the join which can then be pushed by\noptimizer_move_filter_beneath_join.","shortMessageHtmlLink":"Enable push down of constant join conditions down in outer/cross joins"}},{"before":"d8292eab81edd1d0089a8786098f534b71e6d231","after":"18398bbf44605f330d74b78eafa2dc9e9225aeaf","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T17:21:33.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Enable push down of constant join conditions down in outer/cross joins\n\nThis pr changes optimizer_move_constant_join_conditions_beneath_join\nso the constant join condition is extracted from inner/outer/cross joins\nto a filter on top of the join which can then be pushed by\noptimizer_move_filter_beneath_join.","shortMessageHtmlLink":"Enable push down of constant join conditions down in outer/cross joins"}},{"before":"69e365386cd0b4f5354ef75cc00e094f938da128","after":"d8292eab81edd1d0089a8786098f534b71e6d231","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T15:13:43.000Z","pushType":"push","commitsCount":4,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Merge branch 'master' into mkleen/constant-outer-joins","shortMessageHtmlLink":"Merge branch 'master' into mkleen/constant-outer-joins"}},{"before":null,"after":"b95e5230392e4cd90d583ab3208ef39d3111dd3a","ref":"refs/heads/mergify/bp/5.7/pr-16100","pushedAt":"2024-06-05T15:13:37.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"mergify[bot]","name":null,"path":"/apps/mergify","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/10562?s=80&v=4"},"commit":{"message":"Always check session user existence\n\nSuperuser can use SET SESSION AUTHORIZATION and then drop the active user.\n\nHowever, it was still possible to execute some queries under the dropped user session.\n\nAnalyze now checks for user existence to avoid confusion.\n\n(cherry picked from commit ecc5aaa80447d950508e1c3b7be939fe91afdf54)","shortMessageHtmlLink":"Always check session user existence"}},{"before":"88b20f905fc1a0986cccf59e8346a88720d63e09","after":"69e365386cd0b4f5354ef75cc00e094f938da128","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T15:12:43.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Enable push down of constant join conditions down in outer/cross joins\n\nThis pr changes optimizer_move_constant_join_conditions_beneath_join\nso the constant join condition is extracted from inner/outer/cross joins\nto a filter on top of the join which can then be pushed by\noptimizer_move_filter_beneath_join.","shortMessageHtmlLink":"Enable push down of constant join conditions down in outer/cross joins"}},{"before":"7dd1c51daa6c353da4dec97220e386c74864f48c","after":null,"ref":"refs/heads/b/set-session-fix","pushedAt":"2024-06-05T15:11:58.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"mergify[bot]","name":null,"path":"/apps/mergify","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/10562?s=80&v=4"}},{"before":"0b32256cb69bf0dfe3b0a56b9605be5a19774d69","after":"ecc5aaa80447d950508e1c3b7be939fe91afdf54","ref":"refs/heads/master","pushedAt":"2024-06-05T15:11:57.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"mergify[bot]","name":null,"path":"/apps/mergify","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/10562?s=80&v=4"},"commit":{"message":"Always check session user existence\n\nSuperuser can use SET SESSION AUTHORIZATION and then drop the active user.\n\nHowever, it was still possible to execute some queries under the dropped user session.\n\nAnalyze now checks for user existence to avoid confusion.","shortMessageHtmlLink":"Always check session user existence"}},{"before":"e47571bd1f55321a2be765f6e59aa9510ffa79f3","after":"88b20f905fc1a0986cccf59e8346a88720d63e09","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T15:04:32.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Merge branch 'master' into mkleen/constant-outer-joins","shortMessageHtmlLink":"Merge branch 'master' into mkleen/constant-outer-joins"}},{"before":"5276faa219c784873166cfad473144c551a9f9da","after":"e47571bd1f55321a2be765f6e59aa9510ffa79f3","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T15:01:38.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Enable push down of constant join conditions down in outer joins\n\nThis pr changes optimizer_move_constant_join_conditions_beneath_join\nso the constant join condition is extracted from inner/outer joins\nto a filter on top of the join which can then be pushed by\noptimizer_move_filter_beneath_join.","shortMessageHtmlLink":"Enable push down of constant join conditions down in outer joins"}},{"before":"bf58342f43f51dadc5ab36bad124e0284d72b6e3","after":"7dd1c51daa6c353da4dec97220e386c74864f48c","ref":"refs/heads/b/set-session-fix","pushedAt":"2024-06-05T14:54:45.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"mergify[bot]","name":null,"path":"/apps/mergify","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/10562?s=80&v=4"},"commit":{"message":"Merge branch 'master' into b/set-session-fix","shortMessageHtmlLink":"Merge branch 'master' into b/set-session-fix"}},{"before":"42635c4706940bee48b4e6aa721156d251e339e3","after":"5276faa219c784873166cfad473144c551a9f9da","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T14:53:46.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Enable push down of constant join conditions down in outer joins\n\nThis pr changes optimizer_move_constant_join_conditions_beneath_join\nso the constant join condition is extracted to a filter on top of the\njoin which can then be pushed by optimizer_move_filter_beneath_join.","shortMessageHtmlLink":"Enable push down of constant join conditions down in outer joins"}},{"before":"bfcaab6b8563d8198ee64dcbb3462486e4ac0d23","after":null,"ref":"refs/heads/j/rm-fieldmappers","pushedAt":"2024-06-05T14:46:24.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"mergify[bot]","name":null,"path":"/apps/mergify","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/10562?s=80&v=4"}},{"before":"aa1aaa6a8dd6254060508be3af176ba3f4b07bb9","after":"0b32256cb69bf0dfe3b0a56b9605be5a19774d69","ref":"refs/heads/master","pushedAt":"2024-06-05T14:46:23.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"mergify[bot]","name":null,"path":"/apps/mergify","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/10562?s=80&v=4"},"commit":{"message":"Remove FieldMapper leftovers\n\nFollow up to https://github.com/crate/crate/pull/16102","shortMessageHtmlLink":"Remove FieldMapper leftovers"}},{"before":"0b8b0255cd6d552859bb099ce792cf9b2373f1cb","after":"42635c4706940bee48b4e6aa721156d251e339e3","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T14:45:10.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Enable push down of constant join conditions down in outer joins\n\nThis pr changes optimizer_move_constant_join_conditions_beneath_join\nso the constant join condition is extracted to a filter on top of the\njoin which can then be pushed by optimizer_move_filter_beneath_join.","shortMessageHtmlLink":"Enable push down of constant join conditions down in outer joins"}},{"before":"682443b3ba45d347d3e1a95bdddd49add9047030","after":"0b8b0255cd6d552859bb099ce792cf9b2373f1cb","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T14:38:47.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Enable push down of constant join conditions down in outer joins","shortMessageHtmlLink":"Enable push down of constant join conditions down in outer joins"}},{"before":"217497e12e9ebc56379e7a5cbdb1a0dfb40d3dcd","after":"bf58342f43f51dadc5ab36bad124e0284d72b6e3","ref":"refs/heads/b/set-session-fix","pushedAt":"2024-06-05T14:37:50.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"BaurzhanSakhariev","name":"Baur","path":"/BaurzhanSakhariev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7446940?s=80&v=4"},"commit":{"message":"Always check session user existence\n\nSuperuser can use SET SESSION AUTHORIZATION and then drop the active user.\n\nHowever, it was still possible to execute some queries under the dropped user session.\n\nAnalyze now checks for user existence to avoid confusion.","shortMessageHtmlLink":"Always check session user existence"}},{"before":"7a9756c9efc1d042af969c3feb848ca91a8c89d6","after":"682443b3ba45d347d3e1a95bdddd49add9047030","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T14:35:01.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Enable push down of constant join conditions down in outer joins","shortMessageHtmlLink":"Enable push down of constant join conditions down in outer joins"}},{"before":"febb192a2f758071319a5cfe9824948f20504e9e","after":"bfcaab6b8563d8198ee64dcbb3462486e4ac0d23","ref":"refs/heads/j/rm-fieldmappers","pushedAt":"2024-06-05T14:29:02.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"mfussenegger","name":"Mathias Fußenegger","path":"/mfussenegger","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/38700?s=80&v=4"},"commit":{"message":"Merge branch 'master' into j/rm-fieldmappers","shortMessageHtmlLink":"Merge branch 'master' into j/rm-fieldmappers"}},{"before":"d5a2c49013c3e9bed74abb312a34d30e376c73e8","after":"7a9756c9efc1d042af969c3feb848ca91a8c89d6","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T14:27:04.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Enable push down of constant join conditions down in outer joins","shortMessageHtmlLink":"Enable push down of constant join conditions down in outer joins"}},{"before":"a26c486a90f8dfa7737e43352a1afe52d3309f93","after":"d5a2c49013c3e9bed74abb312a34d30e376c73e8","ref":"refs/heads/mkleen/constant-outer-joins","pushedAt":"2024-06-05T14:25:14.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"mkleen","name":"Michael Kleen","path":"/mkleen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/338234?s=80&v=4"},"commit":{"message":"Enable push down of constant join conditions down in outer joins","shortMessageHtmlLink":"Enable push down of constant join conditions down in outer joins"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEXX_TNQA","startCursor":null,"endCursor":null}},"title":"Activity · crate/crate"}