Adam wrote:

> Two considerations:
>
> 1. Firebird 2 rejects some queries 1.5 accepts, especially if you
> declare aliases for tables then use the table name elsewhere in the query.
>
> 2. A lot of the improvements in Firebird 2 (garbage collection, index
> size restrictions, etc) are unavailable until you change the ODS.
>
> So if you have already installed FB 2 and your queries have already
> been confirmed to work under FB 2, then you might as well switch them
> completely over.
>
> Adam
>

One more consideration:

FB 1.5 allows these two queries and FB 2.0 rejects it

update Table Foo set bar =1, bar =2
insert into foo (bar, bar) values (1, 2)

or

update Table Foo set bar =1, bar =1
insert into foo (bar, bar) values (1, 1)

doesn't matter if you provide a consistent value for the same column, if
it is declared twice it will be rejected.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br