summaryrefslogtreecommitdiff
path: root/src/tutorial
diff options
context:
space:
mode:
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>2025-05-19 18:49:12 +0300
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>2025-05-19 18:49:34 +0300
commit7ee00918f7cdd76c8c1120f019288dd71d48f42d (patch)
tree2a4898b640e1de848d13cadf0b0161746f1797fe /src/tutorial
parente323d9df002debb103a58ba2479368c46804a9b6 (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')
0 files changed, 0 insertions, 0 deletions