pgsql: Don't search for volatile expr in find_em_expr_usable_for_sortin - Mailing list pgsql-committers

From Tomas Vondra
Subject pgsql: Don't search for volatile expr in find_em_expr_usable_for_sortin
Date
Msg-id E1krR9m-0006Ho-7x@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Don't search for volatile expr in find_em_expr_usable_for_sorting_rel

While prepare_sort_from_pathkeys has to be concerned about matching up
a volatile expression to the proper tlist entry, we don't need to do
that in find_em_expr_usable_for_sorting_rel becausee such a sort will
have to be postponed anyway.

Author: James Coleman
Reviewed-by: Tomas Vondra
Backpatch-through: 13
Discussion: https://postgr.es/m/CAAaqYe8cK3g5CfLC4w7bs%3DhC0mSksZC%3DH5M8LSchj5e5OxpTAg%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/9aff4dc01fbb9e126efafd839ae8541362328f1a

Modified Files
--------------
src/backend/optimizer/path/equivclass.c | 28 +++++-----------------------
1 file changed, 5 insertions(+), 23 deletions(-)


pgsql-committers by date:

Previous
From: Tomas Vondra
Date:
Subject: pgsql: Disallow SRFs when considering sorts below Gather Merge
Next
From: Tomas Vondra
Date:
Subject: pgsql: Don't search for volatile expr in find_em_expr_usable_for_sortin