Hello,

I have a very anoying behaviour with Firebird 2.1. Consider following
select:

SELECT E.BOLD_ID, E.BOLD_TYPE,
E.account,
E.additionalName, E.bankname, E.blz, E.companyName,
E.customSortorder,
E.dateOfBirth, E.externalID, E.externalSyncType, E.forename,
E.freelance,
E.functionName, E.isSysadmin, E.ris_description1, E.ris_description2,
E.ris_description3, E.ris_description4, E.ris_image, E.roomNumber,
E.salutationType, E.salutationTypePostalAddress, E.saveasUpper,
E.shortFunctionName, E.shortName, E.surname, E.title,
E.additionalAddress,
E.postalAddress, E.contactsaveastype, E.workflowcontext
FROM Contact E

This select works fine with Firebird 2.0.3 but with 2.1 it produces
an error:

ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -206
Column unknown
CONTACT.DB_KEY
At line 12, column 16

STATEMENT:
TIBOInternalDataset: "<TApplication>.frmMain.dlgWisql.<TIBOQuery>.<TIB
OInternalDataset>."

If I remove the Alias E in the select the select runs fine in
Firebird 2.1 too but that's no option for me because the above select
is part of an bigger select in which aliases are needed...


Thanks

Stefan