Re: [Firebird-devel] Null validation error for comparing columns in UPDATE OR INSERT

2020-11-20 Thread Mark Rotteveel
Never mind, I withdraw my question, I had overlooked the fact that this is a direct equivalent of INSERT INTO (id, colval) values (null, 'abc'), which doesn't make much sense either. Mark On 20-11-2020 10:01, Mark Rotteveel wrote: Triggered by the question by Walter R. Ojeda Valient on firebi

[Firebird-devel] Null validation error for comparing columns in UPDATE OR INSERT

2020-11-20 Thread Mark Rotteveel
Triggered by the question by Walter R. Ojeda Valient on firebird-support, I'm wondering if the null validation error that occurs in Firebird 3 with UPDATE OR INSERT is intentional. Specifically, with table: ``` create table uoi_example2 ( id integer generated by default as identity constrain