Horton

Re: BUG #18467: postgres_fdw (deparser) ignores LimitOption

Etsuro Fujita <etsuro.fujita@gmail.com>

View thread View on postgr.es
From: Etsuro Fujita <etsuro.fujita@gmail.com>
To: Japin Li <japinli@hotmail.com>
Cc: onderkalaci@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2024-05-16T09:11:36Z
Lists: pgsql-bugs 
Hi Japin,

On Thu, May 16, 2024 at 1:02 PM Japin Li <japinli@hotmail.com> wrote:
> AppendLimitClause() does not check the limitOption, which may be
> LIMIT_OPTION_WITH_TIES. It simply uses the LIMIT clause.
>
> Here is a poc patch to verify the above.

Thanks for the patch!  Will review.

Best regards,
Etsuro Fujita

Commits

  1. postgres_fdw: Refuse to send FETCH FIRST WITH TIES to remote servers.

  2. Revert temporal primary keys and foreign keys