Subject Re: [ib-support] FB & IB Compatibility
Author Paul Vinkenoog
Hello Hugh,

> What sort of compatibility is supported between IB 6.0.x (Open
> Sourced) and FireBird 1.0.x (is ODS the same?;

Yes

> language/syntax identical?;

Firebird has some extras, but that shouldn't harm anyone.

> will client software interoperate with either release?; etc.)?
> What, if any, incompatibilities exist?

The one thing I'm aware of is that FB rejects queries with
syntactically/semantically ambiguous fieldnames, even if they are
not pragmatically ambiguous. E.g.:

select animal_id, catname, dogname
from cats, dogs
where cats.animal_id = dogs.animal_id

is OK in IB, but not in FB because it considers the unqualified
animal_id ambiguous here. (Even though in this query, the value is
necessarily the same.)


Don't know about 1.5


Greetings,
Paul Vinkenoog