Re: SQL-standard function body - Mailing list pgsql-hackers

From Julien Rouhaud
Subject Re: SQL-standard function body
Date
Msg-id 20210606073220.42ytzr6r5bbhqh3q@nol
Whole thread Raw
In response to Re: SQL-standard function body  (Noah Misch <noah@leadboat.com>)
Responses Re: SQL-standard function body
List pgsql-hackers
On Sat, Jun 05, 2021 at 09:44:18PM -0700, Noah Misch wrote:
> On Wed, Apr 07, 2021 at 09:55:40PM +0200, Peter Eisentraut wrote:
> > Committed.  Thanks!
> 
> I get a NULL pointer dereference if the function body has a doubled semicolon:
> 
>   create function f() returns int language sql begin atomic select 1;; end;

You don't even need a statements to reproduce the problem, a body containing
only semi-colon(s) will behave the same.

Attached patch should fix the problem.

Attachment

pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Misplaced superuser check in pg_log_backend_memory_contexts()
Next
From: Omar Kilani
Date:
Subject: Strangeness with UNIQUE indexes and UTF-8