diff options
author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2025-05-19 18:49:12 +0300 |
---|---|---|
committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2025-05-19 18:49:34 +0300 |
commit | 7ee00918f7cdd76c8c1120f019288dd71d48f42d (patch) | |
tree | 2a4898b640e1de848d13cadf0b0161746f1797fe /src/tutorial/advanced.source | |
parent | e323d9df002debb103a58ba2479368c46804a9b6 (diff) |
Fix deparsing FETCH FIRST <expr> ROWS WITH TIES
In the grammar, <expr> is a c_expr, which accepts only a limited set
of simple constants and expressions without parens. The deparsing
logic didn't quite match the grammar rule, and failed to use parens
e.g. for "5::bigint".
To fix, always surround the expression with parens. Would be nice to
omit the parens in simple cases, but unfortunately it's non-trivial to
detect such simple cases. Even if the expression is a simple literal
123 in the original query, after parse analysis it becomes a FuncExpr
with COERCE_IMPLICIT_CAST rather than a simple Const.
Reported-by: yonghao lee
Backpatch-through: 13
Discussion: https://www.postgresql.org/message-id/18929-077d6b7093b176e2@postgresql.org
Diffstat (limited to 'src/tutorial/advanced.source')
0 files changed, 0 insertions, 0 deletions