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?
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: 10,5),UJZ_ VWO6PF decimal(5,2) unsigned,OUDJTKTVBM numeric( 10,5),FQVKTFH0R D 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;
1). create table GTN2BSG5FQ (KXE2QSC7HC char(10) CHARACTER SET ISO88591,RMSYLIFAR4 varchar(10) CHARACTER SET ISO88591,E5IPGXAHNB long varchar CHARACTER SET ISO88591,ZQW9LNYDG3 decimal(
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='GTN2BSG5F Q');
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?