[
https://issues.apache.org/jira/browse/CALCITE-2211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16399040#comment-16399040
]
Eyal Segal edited comment on CALCITE-2211 at 3/14/18 6:23 PM:
--------------------------------------------------------------
It is also reproduced on MySql, with unsigned bigint column.
Consider this table:
{code:java}
create table test_table (id bigint(20) unsigned not null);
insert into test_table values (1);
{code}
Then when we fetch the result using JDBC:
{code:java}
try (Connection conn = new JDBC4Connection(db, 3306, p, "common",
"jdbc:apache:commons:dbcp:/db")) {
try (ResultSet rs = conn.prepareStatement("SELECT id FROM common.test_table
WHERE id=1").executeQuery()) {
while (rs.next()) {
System.out.print(rs.getObject("id").getClass());
}
}
}{code}
This will print "class java.math.BigInteger"
was (Author: eysegal):
It is also reproduced on MySql, with unsigned bigint column.
Consider this table:
{code:java}
create table test_table (id bigint(20) unsigned not null);
insert into test_table values (1);
{code}
Then when we fetch the result using JDBC:
{code:java}
try (Connection conn = new JDBC4Connection(db, 3306, p, "common",
"jdbc:apache:commons:dbcp:/db")) {
try (ResultSet rs = conn.prepareStatement("SELECT id FROM common.test_table
WHERE id=1").executeQuery()) {
while (rs.next()) {
System.out.print(rs.getObject("id").getClass());
}
}
}{code}
This will print java.math.BigInteger
> Type of BigInteger should be BIGINT
> -----------------------------------
>
> Key: CALCITE-2211
> URL: https://issues.apache.org/jira/browse/CALCITE-2211
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.15.0
> Reporter: Eyal Segal
> Assignee: Julian Hyde
> Priority: Major
>
> Vertica DB returns BigInteger values as BigInteger. It seems that
> JavaToSqlTypeConversionRules doesn't support mapping between BigInteger to
> BIGINT.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
