--- In ib-support@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> At 03:09 PM 8/05/2003 -0400, you wrote:
> >In Firebird 1.5 the following SQL statement "select CL_PERSON_NBR

from

> >CL_PERSON P join EE E on P.CL_PERSON_NBR=E.CL_PERSON_NBR" causes

an error

> >"Dynamic SQL Error SQL error code = -204 internal gds software

consistency

> >check (table CL_PERSON) CL_PERSON_NBR". If a table reference is

added to

> >the selected column (i.e. select P.CL_PERSON_NBR) the statement

works

> >fine. The same statement works in Interbase 6.01 without errors.

Please,

> >let me know if I need to submit this problem as a bug report.
>
> The bug is in IB 6.01. This is an ambiguous query which may or may

not

> return the correct results. In Firebird, you need to qualify

*every*

> column reference in a multi-table query, e.g.
>
> select P.CL_PERSON_NBR from CL_PERSON P
> join EE E
> on P.CL_PERSON_NBR=E.CL_PERSON_NBR
>
> heLen

This is all good and makes sense, but it basically means (despite all
claims) that Firebird is not 100% compatible with Interbase 6 and
earlier versions since ambiguous queries like the one above have
always worked in IB. Also the fact that the error message is so
obscure makes me think that this functionality was turned off by
mistake rather than intentionally. In any case, my project has
thousands of queries like the one above and this little thing will
basically prevent me from migrating to Firebird. Too bad...

Andrei