ODBC SQLGetTypeInfo api - all datatypes being returned as BIGINT

[Aruna Sadashiva]

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
=======================================================================

[Arvind Narain (arvind-narain)]

All records were being returned back rather than the just the type being asked.