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 [mai
Firebird UPDATE supports ORDER BY clause.
Feladó: marius adrian popa [mailto:map...@gmail.com]
Küldve: 2019. november 19., kedd 10:48
Címzett: For discussion among Firebird Developers
Tárgy: [Firebird-devel] interesting test fails with Firebird 3.0
https://twitter.com/FranckPachot/status/119641
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
