Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit74f770e

Browse files
committed
Re-disallow Memoize for parameterized nested loops with join filters
This was previously fixed in9e21537 but got broken again as a resultof2489d76. It seems that commit causes ppi_clauses to containduplicate clauses and it's no longer safe to check the list_length ofthat list to determine if there are join conditions other than what'smentioned in ppi_clauses.Here we adjust the check to count the distinct rinfo_serial mentioned inppi_clauses. We expect that extra->restrictlist won't have duplicaterinfo_serials.Reported-by: Amadeo GallardoAuthor: Richard GuoDiscussion:https://postgr.es/m/CADFREbW-BLJd7-a5J%2B5wjVumeFG1ByXiSOFzMtkmY_SDWckTxw%40mail.gmail.comBackpatch-through: 16, where2489d76 was introduced.
1 parent5b5318c commit74f770e

File tree

1 file changed

+1
-1
lines changed

1 file changed

+1
-1
lines changed

‎src/backend/optimizer/path/joinpath.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -651,7 +651,7 @@ get_memoize_path(PlannerInfo *root, RelOptInfo *innerrel,
651651
*/
652652
if (extra->inner_unique&&
653653
(inner_path->param_info==NULL||
654-
list_length(inner_path->param_info->ppi_clauses)<
654+
bms_num_members(inner_path->param_info->ppi_serials)<
655655
list_length(extra->restrictlist)))
656656
returnNULL;
657657

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp