Loading...

XML

Word

Printable

Steps to Reproduce:
Hide

1. Create a test table containing a field with BigInteger type, for example, in PostgreSQL:

CREATE TABLE tableBI(id integer, i biginteger); INSERT INTO tableBI VALUES (1, 10000000000);

2. Add PostgreSQL containing the table as datasource in teiid.
2. Run the following query:

SELECT i FROM dsp.tableBI;

and check metadata of the returned field. It will be BigDecimal type instead of BigInteger. It's related to skipped handling BigInteger type in JDBCExecutionFactory in retrieveValue methods (for ResultSet and CallableStatement).
Show
1. Create a test table containing a field with BigInteger type, for example, in PostgreSQL: CREATE TABLE tableBI(id integer , i biginteger); INSERT INTO tableBI VALUES (1, 10000000000); 2. Add PostgreSQL containing the table as datasource in teiid. 2. Run the following query: SELECT i FROM dsp.tableBI; and check metadata of the returned field. It will be BigDecimal type instead of BigInteger. It's related to skipped handling BigInteger type in JDBCExecutionFactory in retrieveValue methods (for ResultSet and CallableStatement).

Fields of a table with BigInteger types are being presented as fields with BigDecimal types.