Subject | Re: [ib-support] FB & IB Compatibility |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-04-01T15:38:44Z |
Hello Hugh,
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
> What sort of compatibility is supported between IB 6.0.x (OpenYes
> Sourced) and FireBird 1.0.x (is ODS the same?;
> language/syntax identical?;Firebird has some extras, but that shouldn't harm anyone.
> will client software interoperate with either release?; etc.)?The one thing I'm aware of is that FB rejects queries with
> What, if any, incompatibilities exist?
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