Subject | Firebird join error |
---|---|
Author | Andrei Babyuk |
Post date | 2003-05-08T18:57:50Z |
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]
Thank you,
Andrei Babyuk
[Non-text portions of this message have been removed]