Subject Re: Firebird Versus Interbase 7.1
Author Svein Erling Tysvær
--- In firebird-support@yahoogroups.com, "Adam" wrote:
> Firebird 1.0 was based on Interbase 6.5, so the two are pretty much
> identical featurewise, although FB 1.0 is a lot more bug free than
> IB 6.5.

I think this should be InterBase 6.0, which was the (somewhat buggy)
version that Borland opensourced.

We moved from InterBase 5.6 to Firebird 0.9.4 and have never looked
back since. Hence I cannot comment too much on InterBase. Though I do
know there are some differences by now, e.g. Firebird uses SELECT
FIRST ... SKIP ... whereas InterBase uses SELECT TOP ... LIMIT ... (or
similar). Another difference should be that Firebird is stricter with
the syntax, InterBase tries to (or at least tried to) do the best when
you gave it an ambiguous query - possibly leading to wrong results,
whereas Firebird gives you an error - forcing you to fix your query
(even on a few not semantically ambiguous queries like "select MyField
from A join B on A.MyField=B.MyField").

Set