| Subject | Re: [firebird-support] Issues migrating from FB 1.5 to 2.5 |
|---|---|
| Author | |
| Post date | 2015-06-23T12:31:08Z |
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.