Comment 2 for bug 1420523

It will insert into values to table 'trafodion."_MD_".columns' when execute 'create table...'. I found the inserted values is incorrect in it.

There is my operational procedure:
1). create table GTN2BSG5FQ (KXE2QSC7HC char(10) CHARACTER SET ISO88591,RMSYLIFAR4 varchar(10) CHARACTER SET ISO88591,E5IPGXAHNB long varchar CHARACTER SET ISO88591,ZQW9LNYDG3 decimal(10,5),UJZ_VWO6PF decimal(5,2) unsigned,OUDJTKTVBM numeric(10,5),FQVKTFH0RD numeric(5,2) unsigned,D93AO8UXJJ smallint,XY_L4PKEZB smallint unsigned,MAWIIS6VO7 integer,WHQLMPNEZC integer unsigned,URCY1GTN2B bigint,SG5FQVKTFH real,RDD93AO8UX float,JJXY_L4PKE double precision,ZBMAWIIS6V date,O7WHQLMPNE time,ZCURCY1GTN timestamp) no partition;

2). select column_name,fs_data_type,sql_data_type from trafodion."_MD_".columns where object_uid=(select object_uid from trafodion."_MD_".objects where object_name='GTN2BSG5FQ');
                Result after execute this select:
                       COLUMN_NAME FS_DATA_TYPE SQL_DATA_TYPE
                       D93AO8UXJJ 130 SIGNED SMALLINT
                       E5IPGXAHNB 70 LONG VARCHAR
                       FQVKTFH0RD 133 UNSIGNED INTEGER
                      JJXY_L4PKE 143 DOUBLE
                      KXE2QSC7HC 0 CHARACTER
                      MAWIIS6VO7 132 SIGNED INTEGER
                      O7WHQLMPNE 192 DATETIME
                      OUDJTKTVBM 134 SIGNED LARGEINT
                      RDD93AO8UX 143 DOUBLE
                      RMSYLIFAR4 64 VARCHAR
                      SG5FQVKTFH 142 REAL
                      SYSKEY 134 SIGNED LARGEINT
                      UJZ_VWO6PF 150 UNSIGNED DECIMAL
                      URCY1GTN2B 134 SIGNED LARGEINT
                      WHQLMPNEZC 133 UNSIGNED INTEGER
                      XY_L4PKEZB 131 UNSIGNED SMALLINT
                      ZBMAWIIS6V 192 DATETIME
                      ZCURCY1GTN 192 DATETIME
                      ZQW9LNYDG3 152 SIGNED DECIMAL

Don't understand:
1).The colum types are respectively numeric(5,2) unsigned and numeric(10,5) and float in ‘create table…’ sentence but its are UNSIGNED INTEGER and SIGNED LARGEINT and DOUBLE after execute ‘select… ‘sentence for column FQVKTFH0RD and OUDJTKTVBM and RDD93AO8UX at field SQL_DATA_TYPE value aspect.
Why do the SQL_DATA_TYPE value are not match between ‘create table…’ sentence and ‘select…’ sentence for ‘SQL_DATA_TYPE’?

2). The colum types are respectively time and date and timestamp in ‘create table…’ sentence but its are same value after ‘select…’ sentence for columns O7WHQLMPNE and ZBMAWIIS6V and ZCURCY1GTN at field ‘SQL_DATA_TYPE’ aspect,why do its produce this status?