Subject Re: [firebird-support] Issues migrating from FB 1.5 to 2.5
Author Mark Rotteveel
On 23-6-2015 14:36, 'Thomas Steinmaurer' ts@...
[firebird-support] wrote:
>> Hi Karol, I think you are right on, I found this which is what I suspect is
>> throwing the error in 2.5 (but not so in 1.5). I might have to go back to my
>> old box running 1.5. Do you know if it is possible to convert and downgrade a
>> 2.5 *.fdb file to a 1.5 version ?
>> Multiple Hits to Same Column Now Illegal
>> It is no longer allowed to make multiple “hits” on the same column in an
>> INSERT or UPDATE statement. Thus, a statement like
>> INSERT INTO T(A, B, A) ...
>> or
>> UPDATE T SET A = x, B = y, A = z
>> will be rejected in Firebird 2.n, even though it was tolerated in
>> InterBase and previous Firebird versions.
> You may check out the "OldSetClauseSemantics" legacy configuration option in firebird.conf. Mind the note in the release notes that this configuration option might be removed in future releases.

It is certain: in Firebird 3 OldSetClauseSemantics has been removed.

Mark Rotteveel