|Subject||Re: [firebird-support] Issues migrating from FB 1.5 to 2.5|
On 23-6-2015 14:36, 'Thomas Steinmaurer' ts@...
>> Hi Karol, I think you are right on, I found this which is what I suspect isIt is certain: in Firebird 3 OldSetClauseSemantics has been removed.
>> 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) ...
>> 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.