You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anuradha Hegde (JIRA)" <ji...@apache.org> on 2016/05/12 18:08:12 UTC
[jira] [Updated] (TRAFODION-306) LP Bug: 1323868 - ODBC
SQLGetTypeInfo api - all datatypes being returned as BIGINT
[ https://issues.apache.org/jira/browse/TRAFODION-306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anuradha Hegde updated TRAFODION-306:
-------------------------------------
Fix Version/s: (was: 2.0-incubating)
2.1-incubating
> 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.3.4#6332)