Subject | Re: Firebird Versus Interbase 7.1 |
---|---|
Author | Svein Erling Tysvær |
Post date | 2005-06-29T07:46:13Z |
--- In firebird-support@yahoogroups.com, "Adam" wrote:
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
> Firebird 1.0 was based on Interbase 6.5, so the two are pretty muchI think this should be InterBase 6.0, which was the (somewhat buggy)
> identical featurewise, although FB 1.0 is a lot more bug free than
> IB 6.5.
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