Subject Re: [firebird-support] FB 3.0 SQL Error.
Author Mark Rotteveel
On Tue, 23 Dec 2014 17:06:08 -0200, "Hugo Eyng hugoeyng@...
[firebird-support]" <> 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 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).