Re: Fix for FETCH FIRST syntax problems
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
Peter Geoghegan <pg@bowt.ie>, Vik Fearing <vik.fearing@2ndquadrant.com>,
Andrew Gierth <andrew@tao11.riddles.org.uk>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2018-05-22T12:59:17Z
Lists: pgsql-hackers
On Sun, May 20, 2018 at 5:16 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > "David G. Johnston" <david.g.johnston@gmail.com> writes: >> The risk here is significantly reduced since the existing user-visible >> behavior is an error which presumably no one is relying upon. Between that >> and being able to conform to the standard syntax for a long-standing >> feature I would say the benefit outweighs the cost and risk. > > The risk you're ignoring is that this patch will break something that > *did* work before. Given that the first version did exactly that, > I do not think that risk should be considered negligible. I'm going > to change my vote for back-patching from -0.5 to -1. I'm also -1 for back-patching, although it seems that the ship has already sailed. I don't think that the failure of something to work that could have been made to work if the original feature author had tried harder rises to the level of a bug. If we start routinely back-patching things that fall into that category, we will certainly manage to destabilize older releases on a regular basis. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Commits
-
Fix SQL:2008 FETCH FIRST syntax to allow parameters.
- 89b09db01b43 9.3.24 landed
- 769e6fcd1a35 9.4.19 landed
- 3b0fb2529fdf 9.5.14 landed
- 7a0aa8d12ace 9.6.10 landed
- cf516dc9d690 10.5 landed
- 1da162e1f5a7 11.0 landed
-
SQL:2008 alternative syntax for LIMIT/OFFSET:
- 361bfc35724a 8.4.0 cited