On Tue, 23 Dec 2014 17:06:08 -0200, "Hugo Eyng hugoe...@msn.com [firebird-support]" <firebird-support@yahoogroups.com> wrote: > Thank you for your answer Mark. > > You are right, 31 characters. > > And I agree that is not a good idea truncating like FB 2.5. > > I tested under FB 2.5.2.26539 and IBExpert. > > In the sql: > > select cd_ent as id_column_name_larger_than_31_test1, tp_ent as > id_column_name_larger_than_31_test2 > from dm100 > > IbExpert returned: > > id_column_name_larger_than_31*_t* for the first column and > id_column_name_larger_than_31*_1* for the second column
I don't use IB Expert, but I tried with flamerobin which didn't show this, so I think it is IB Expert that applies an extra transformation to the alias when there are duplicates (eg after truncation by Firebird). Mark