Submitted by: @asfernandes

Field changes from BIGINT to INTEGER even when specifying BIGINT in the ALTER command:

SQL> create table t2 (n1 integer, n2 bigint computed by (1));
SQL> set sqlda_display on;
SQL> select * from t2;

INPUT message field count: 0

OUTPUT message field count: 2
01: sqltype: 496 LONG Nullable scale: 0 subtype: 0 len: 4
: name: N1 alias: N1
: table: T2 owner: SYSDBA
02: sqltype: 580 INT64 Nullable scale: 0 subtype: 0 len: 8
: name: N2 alias: N2
: table: T2 owner: SYSDBA
SQL>
SQL> commit;
SQL>
SQL> alter table t2 alter n2 type bigint computed by (2);
SQL>
SQL> select * from t2;

INPUT message field count: 0

OUTPUT message field count: 2
01: sqltype: 496 LONG Nullable scale: 0 subtype: 0 len: 4
: name: N1 alias: N1
: table: T2 owner: SYSDBA
02: sqltype: 496 LONG Nullable scale: 0 subtype: 0 len: 4
: name: N2 alias: N2
: table: T2 owner: SYSDBA

Commits: 36ac140 FirebirdSQL/fbt-repository@8f92253

====== Test Details ======

NB. It is possible that this test need to be adjusted soon for FB 3.0, because current SQLDA
output is not affected by changing of field character set (adding or removing or updating).
Sent letter to Adriano, 02-feb-2015 15:25, waiting for reply.