On Tue, 23 Dec 2014 17:06:08 -0200, "Hugo Eyng hugoeyng@...
[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