Subject Firebird join error
Author Andrei Babyuk
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.

Thank you,

Andrei Babyuk



[Non-text portions of this message have been removed]