[
https://issues.apache.org/jira/browse/TRAFODION-306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arvind Narain closed TRAFODION-306.
-----------------------------------
Resolution: Fixed
> LP Bug: 1323868 - ODBC SQLGetTypeInfo api - all datatypes being returned as
> BIGINT
> ----------------------------------------------------------------------------------
>
> Key: TRAFODION-306
> URL: https://issues.apache.org/jira/browse/TRAFODION-306
> Project: Apache Trafodion
> Issue Type: Bug
> Components: connectivity-general
> Reporter: Aruna Sadashiva
> Assignee: Arvind Narain
> Priority: Critical
> Fix For: 2.1-incubating
>
>
> SQLGetTypeInfo tests in Coast are failing as all datatypes are being returned
> as BIGINT:
> 22:43:41 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_CHAR
> SQLGetTypeInfo(hstmt,1
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: CHAR are not matched
> ***ERROR: Data Type actual: -5 and expected: 1 are not matched
> ***ERROR: Precision actual: 19 and expected: 32000 are not matched
> ***ERROR: Literal Prefix actual: and expected: ' are not matched
> ***ERROR: Literal Suffix actual: and expected: ' are not matched
> ***ERROR: Create Params actual: and expected: max length are not matched
> ***ERROR: Case sensitive actual: 0 and expected: 1 are not matched
> ***ERROR: Searchable actual: 2 and expected: 3 are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: CHARACTER are not
> matched
> =======================================================================
> 22:43:41 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_WCHAR
> SQLGetTypeInfo(hstmt,-8
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: NCHAR are not matched
> ***ERROR: Data Type actual: -5 and expected: -8 are not matched
> ***ERROR: Precision actual: 19 and expected: 16000 are not matched
> ***ERROR: Literal Prefix actual: and expected: N' are not matched
> ***ERROR: Literal Suffix actual: and expected: ' are not matched
> ***ERROR: Create Params actual: and expected: max length are not matched
> ***ERROR: Case sensitive actual: 0 and expected: 1 are not matched
> ***ERROR: Searchable actual: 2 and expected: 3 are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: WIDE CHARACTER are
> not matched
> =======================================================================
> 22:43:42 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_VARCHAR
> SQLGetTypeInfo(hstmt,12
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: VARCHAR are not matched
> ***ERROR: Data Type actual: -5 and expected: 12 are not matched
> ***ERROR: Precision actual: 19 and expected: 32000 are not matched
> ***ERROR: Literal Prefix actual: and expected: ' are not matched
> ***ERROR: Literal Suffix actual: and expected: ' are not matched
> ***ERROR: Create Params actual: and expected: max length are not matched
> ***ERROR: Case sensitive actual: 0 and expected: 1 are not matched
> ***ERROR: Searchable actual: 2 and expected: 3 are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: VARCHAR are not
> matched
> =======================================================================
> 22:43:42 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_WVARCHAR
> SQLGetTypeInfo(hstmt,-9
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: NCHAR VARYING are not
> matched
> ***ERROR: Data Type actual: -5 and expected: -9 are not matched
> ***ERROR: Precision actual: 19 and expected: 16000 are not matched
> ***ERROR: Literal Prefix actual: and expected: N' are not matched
> ***ERROR: Literal Suffix actual: and expected: ' are not matched
> ***ERROR: Create Params actual: and expected: max length are not matched
> ***ERROR: Case sensitive actual: 0 and expected: 1 are not matched
> ***ERROR: Searchable actual: 2 and expected: 3 are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: WIDE VARCHAR are not
> matched
> =======================================================================
> 22:43:43 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_DECIMAL
> SQLGetTypeInfo(hstmt,3
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: DECIMAL are not matched
> ***ERROR: Data Type actual: -5 and expected: 3 are not matched
> ***ERROR: Precision actual: 19 and expected: 18 are not matched
> ***ERROR: Create Params actual: and expected: precision,scale are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: DECIMAL are not
> matched
> ***ERROR: Maximum Scale actual: 0 and expected: 18 are not matched
> =======================================================================
> 22:43:43 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_NUMERIC
> SQLGetTypeInfo(hstmt,2
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: NUMERIC are not matched
> ***ERROR: Data Type actual: -5 and expected: 2 are not matched
> ***ERROR: Precision actual: 19 and expected: 128 are not matched
> ***ERROR: Create Params actual: and expected: precision,scale are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: NUMERIC are not
> matched
> ***ERROR: Maximum Scale actual: 0 and expected: 128 are not matched
> =======================================================================
> 22:43:44 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_SMALLINT
> SQLGetTypeInfo(hstmt,5
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: SMALLINT are not matched
> ***ERROR: Data Type actual: -5 and expected: 5 are not matched
> ***ERROR: Precision actual: 19 and expected: 5 are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: SMALLINT are not
> matched
> =======================================================================
> 22:43:44 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_INTEGER
> SQLGetTypeInfo(hstmt,4
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: INTEGER are not matched
> ***ERROR: Data Type actual: -5 and expected: 4 are not matched
> ***ERROR: Precision actual: 19 and expected: 10 are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: INTEGER are not
> matched
> =======================================================================
> 22:43:45 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_REAL
> SQLGetTypeInfo(hstmt,7
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: REAL are not matched
> ***ERROR: Data Type actual: -5 and expected: 7 are not matched
> ***ERROR: Precision actual: 19 and expected: 7 are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: REAL are not matched
> =======================================================================
> 22:43:45 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_FLOAT
> SQLGetTypeInfo(hstmt,6
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: FLOAT are not matched
> ***ERROR: Data Type actual: -5 and expected: 6 are not matched
> ***ERROR: Precision actual: 19 and expected: 15 are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: FLOAT are not matched
> =======================================================================
> 22:43:46 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_DOUBLE
> SQLGetTypeInfo(hstmt,8
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: DOUBLE PRECISION are
> not matched
> ***ERROR: Data Type actual: -5 and expected: 8 are not matched
> ***ERROR: Precision actual: 19 and expected: 15 are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: DOUBLE are not
> matched
> =======================================================================
> 22:43:46 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_DATE
> SQLGetTypeInfo(hstmt,9
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: DATE are not matched
> ***ERROR: Data Type actual: -5 and expected: 9 are not matched
> ***ERROR: Precision actual: 19 and expected: 10 are not matched
> ***ERROR: Literal Prefix actual: and expected: {d ' are not matched
> ***ERROR: Literal Suffix actual: and expected: '} are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: DATE are not matched
> =======================================================================
> 22:43:47 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_TIME
> SQLGetTypeInfo(hstmt,10
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: TIME are not matched
> ***ERROR: Data Type actual: -5 and expected: 10 are not matched
> ***ERROR: Precision actual: 19 and expected: 8 are not matched
> ***ERROR: Literal Prefix actual: and expected: {t ' are not matched
> ***ERROR: Literal Suffix actual: and expected: '} are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: TIME are not matched
> =======================================================================
> 22:43:48 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_TIMESTAMP
> SQLGetTypeInfo(hstmt,11
> Comparing results
> ***ERROR: Data Type Name actual: BIGINT and expected: TIMESTAMP are not
> matched
> ***ERROR: Data Type actual: -5 and expected: 11 are not matched
> ***ERROR: Precision actual: 19 and expected: 26 are not matched
> ***ERROR: Literal Prefix actual: and expected: {ts ' are not matched
> ***ERROR: Literal Suffix actual: and expected: '} are not matched
> ***ERROR: Local Type name actual: LARGEINT and expected: TIMESTAMP are not
> matched
> ***ERROR: Maximum Scale actual: 0 and expected: 6 are not matched
> =======================================================================
> 22:43:48 Test Positive functionality of SQLGetTypeInfo for data type:
> SQL_BIGINT
> SQLGetTypeInfo(hstmt,-5
> Comparing results
> Data Type Name actual: BIGINT and expected: BIGINT are matched
> Data Type actual: -5 and expected: -5 are matched
> Precision actual: 19 and expected: 19 are matched
> Literal Prefix actual: and expected: are matched
> Literal Suffix actual: and expected: are matched
> Create Params actual: and expected: are matched
> Nullable actual: 1 and expected: 1 are matched
> Case sensitive actual: 0 and expected: 0 are matched
> Searchable actual: 2 and expected: 2 are matched
> Unsigned attribute actual: 0 and expected: 0 are matched
> Money actual: 0 and expected: 0 are matched
> Auto Increment actual: 0 and expected: 0 are matched
> Local Type name actual: LARGEINT and expected: LARGEINT are matched
> Minimum Scale actual: 0 and expected: 0 are matched
> Maximum Scale actual: 0 and expected: 0 are matched
> =======================================================================
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
