diff options
author | Amit Kapila <akapila@postgresql.org> | 2018-09-14 09:51:47 +0530 |
---|---|---|
committer | Amit Kapila <akapila@postgresql.org> | 2018-09-14 09:51:47 +0530 |
commit | 830d7565902f8d1da5f07259982a6a54dc65e40d (patch) | |
tree | 392c153be00a17690f361a4f7b650b04ccbe8100 /src/backend/executor/nodeBitmapAnd.c | |
parent | a2afcdab8a1a90245cab3ed4b2d4bd0812d4955a (diff) | |
download | postgresql-830d7565902f8d1da5f07259982a6a54dc65e40d.tar.gz postgresql-830d7565902f8d1da5f07259982a6a54dc65e40d.zip |
Don't allow LIMIT/OFFSET clause within sub-selects to be pushed to workers.
Allowing sub-select containing LIMIT/OFFSET in workers can lead to
inconsistent results at the top-level as there is no guarantee that the
row order will be fully deterministic. The fix is to prohibit pushing
LIMIT/OFFSET within sub-selects to workers.
Reported-by: Andrew Fletcher
Bug: 15324
Author: Amit Kapila
Reviewed-by: Dilip Kumar
Backpatch-through: 9.6
Discussion: https://postgr.es/m/153417684333.10284.11356259990921828616@wrigleys.postgresql.org
Diffstat (limited to 'src/backend/executor/nodeBitmapAnd.c')
0 files changed, 0 insertions, 0 deletions