Re: Assert failure in base_yyparse - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Assert failure in base_yyparse
Date
Msg-id CAMbWs49Z4OV77=9mD0BgHqSUOdLdO3YkbQVunCAgfFKU2WcjVA@mail.gmail.com
Whole thread Raw
In response to Re: Assert failure in base_yyparse  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: Assert failure in base_yyparse
List pgsql-hackers
On Fri, Mar 28, 2025 at 6:05 PM Richard Guo <guofenglinux@gmail.com> wrote:
> Nice catch.  Yeah, is_not_null is a valid column option in xmltable.
> In you example, the value of the is_not_null option is "|| 'c'", which
> is interpreted as an A_Expr.
>
> I wonder if the value's type should be checked earlier, rather than at
> the last minute.

Hmm, I wonder if we should allow the use of the 'is_not_null' keyword
in xmltable.  According to the doc, it seems that users should declare
NULL or NOT NULL for a column by specifying [NOT NULL | NULL] for the
column.

Thanks
Richard



pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: Test to dump and restore objects left behind by regression
Next
From: Pavel Luzanov
Date:
Subject: Re: making EXPLAIN extensible