On 2019-11-19 10:56, Molnár Attila wrote:
Firebird UPDATE supports ORDER BY clause.
The point of that tweet is that according to the standard, that constraint should not fail even without ordering an update (which - iirc - is not even in the standard).
Mark
FELADÓ: marius adrian popa [mailto:[email protected]] KÜLDVE: 2019. november 19., kedd 10:48 CÍMZETT: For discussion among Firebird Developers <[email protected]> TÁRGY: [Firebird-devel] interesting test fails with Firebird 3.0 https://twitter.com/FranckPachot/status/1196415263031414786 update demo set n=n+1; violation of PRIMARY or UNIQUE KEY constraint "INTEG_2" on table "DEMO" Problematic key value is ("N" = 2) Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
