You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Sandhya Sundaresan (JIRA)" <ji...@apache.org> on 2015/11/17 08:41:11 UTC
[jira] [Commented] (TRAFODION-994) LP Bug: 1420523 - ODBC: Several
values returned by SQLColumns are incorrect
[ https://issues.apache.org/jira/browse/TRAFODION-994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15008206#comment-15008206 ]
Sandhya Sundaresan commented on TRAFODION-994:
----------------------------------------------
The LP bug describes some missing FS datatype values that may be causing this problem for the SQLQColumns API. The values seem fine from this execution sequence below :
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;
select substr(column_name,0,20),fs_data_type,sql_data_type from trafodion."_MD_".columns where object_uid=(select object_uid from trafodion."_MD_".objects where object_name='GTN2BSG5FQ');
#> sqlci
Apache Trafodion Conversational Interface 2.0.0
Copyright (c) 2015 Apache Software Foundation
>>invoke TRAFODION."_MD_".columns;
-- Definition of Trafodion table TRAFODION."_MD_".COLUMNS
-- Definition current Tue Nov 17 07:31:56 2015
(
OBJECT_UID LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
NOT SERIALIZED
, COLUMN_NAME VARCHAR(256 BYTES) CHARACTER SET UTF8
COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, COLUMN_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, COLUMN_CLASS CHAR(2) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, FS_DATA_TYPE INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, SQL_DATA_TYPE CHAR(32) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, COLUMN_SIZE INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, COLUMN_PRECISION INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, COLUMN_SCALE INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, DATETIME_START_FIELD INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, DATETIME_END_FIELD INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, IS_UPSHIFTED CHAR(2) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, COLUMN_FLAGS INT UNSIGNED NO DEFAULT NOT NULL NOT
DROPPABLE NOT SERIALIZED
, NULLABLE INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, CHARACTER_SET CHAR(40) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, DEFAULT_CLASS INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, DEFAULT_VALUE VARCHAR(1024 BYTES) CHARACTER SET UTF8
COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, COLUMN_HEADING VARCHAR(256 BYTES) CHARACTER SET UTF8
COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, HBASE_COL_FAMILY VARCHAR(40) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, HBASE_COL_QUALIFIER VARCHAR(40) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, DIRECTION CHAR(2) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, IS_OPTIONAL CHAR(2) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
, FLAGS LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
NOT SERIALIZED
)
PRIMARY KEY (OBJECT_UID ASC, COLUMN_NAME ASC)
--- SQL operation complete.
>>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;
--- SQL operation complete.
>> select substr(column_name,0,20),fs_data_type,sql_data_type from trafodion."_MD_".columns where object_uid=(select object_uid from trafodion."_MD_".objects where object_name='GTN2BSG5FQ');
(EXPR) 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
--- 19 row(s) selected.
>>
> LP Bug: 1420523 - ODBC: Several values returned by SQLColumns are incorrect
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-994
> URL: https://issues.apache.org/jira/browse/TRAFODION-994
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmu
> Reporter: JiepingZhang
> Assignee: Sandhya Sundaresan
> Priority: Critical
> Fix For: 2.0-incubating
>
>
> Below are the failures in SQLColumn API testing:
> 1. In the resultset returned by SQLColumn API, value of column ColNullable is 2 rather than 1, column REMARK is empty.
> Test create table =>create table GTN2BSG5FQ (KXE2QSC7HC char(10) CHARACTER SET ISO88591) no partition
> =======================================================================
> SQLColumns: compare results of columns fetched for following column
> The Column Name is KXE2QSC7HC and column type is char
> ***ERROR: ColNullable expect: 1 and actual: 2 are not matched
> ***ERROR: Remark expect: CHARACTER CHARACTER SET ISO88591 and actual: are not matched
> Number of rows fetched: 1
> 2. Somehow if the table has more than 3 columns, the 3rd column seems got lost as nothing regarding the 3rd column is returned in the resultset. For test case below, 3rd column E5IPGXAHNB has no info in the resultset.
> 19:18:38 Test create table =>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)) no partition
> =======================================================================
> 19:18:40 SQLColumns: Test #3
> SQLColumns: SQLColumns function call executed correctly.
> SQLColumns: compare results of columns fetched for following column
> The Column Name is KXE2QSC7HC and column type is char
> ***ERROR: ColNullable expect: 1 and actual: 2 are not matched
> ***ERROR: Remark expect: CHARACTER CHARACTER SET ISO88591 and actual: are not matched
> SQLColumns: compare results of columns fetched for following column
> The Column Name is RMSYLIFAR4 and column type is varchar
> ***ERROR: ColNullable expect: 1 and actual: 2 are not matched
> ***ERROR: Remark expect: VARCHAR CHARACTER SET ISO88591 and actual: are not matched
> SQLColumns: compare results of columns fetched for following column
> The Column Name is E5IPGXAHNB and column type is long varchar
> ***ERROR: ColName expect: E5IPGXAHNB and actual: ZQW9LNYDG3 are not matched
> ***ERROR: ColDataType expect: 12 and actual: 3 are not matched
> ***ERROR: ColTypeName expect: VARCHAR and actual: DECIMAL are not matched
> ***ERROR: ColPrec expect: 2000 and actual: 10 are not matched
> ***ERROR: ColLen expect: 2000 and actual: 12 are not matched
> ***ERROR: ColScale expect: 0 and actual: 5 are not matched
> ***ERROR: ColRadix expect: 0 and actual: 10 are not matched
> ***ERROR: ColNullable expect: 1 and actual: 2 are not matched
> ***ERROR: Remark expect: VARCHAR CHARACTER SET ISO88591 and actual: are not matched
> Number of rows fetched: 3
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)