drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Barclay (Drill) (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (DRILL-2613) Implement (higher-priority) ResultSet.getXxx(...) data conversions
Date Fri, 27 Mar 2015 23:54:52 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384911#comment-14384911
] 

Daniel Barclay (Drill) edited comment on DRILL-2613 at 3/27/15 11:54 PM:
-------------------------------------------------------------------------

MySQL JDBC notes:
- [http://dev.mysql.com/doc/connector-j/en/connector-j-reference-type-conversions.html]
- " any numeric type can be converted to any of the Java numeric types, although round-off,
overflow, or loss of precision may occur. "
- "the JDBC driver issues warnings or throws DataTruncation exceptions as is required by the
JDBC specification"

SQL Server JDBC notes:
- [https://msdn.microsoft.com/en-us/library/ms378680%28v=sql.110%29.aspx] (matrix of conversions,
including notes of lossy vs. non-lossy)
- [http://classic.csc.no/sqljdbc_1.1/enu/help/html/98fa7488-aac3-45b4-8aa4-83ed6ab638b4.htm]
- DECIMAL-to-INTEGER getInt(...) truncates (doesn't round)

UNSORTED:

- [http://support.guptatechnologies.com/Docs/SQLBase/Books/connecting/connecting_jdbc.htm]


was (Author: dsbos):
MySQL JDBC notes:
- [http://dev.mysql.com/doc/connector-j/en/connector-j-reference-type-conversions.html]
- " any numeric type can be converted to any of the Java numeric types, although round-off,
overflow, or loss of precision may occur. "
- "the JDBC driver issues warnings or throws DataTruncation exceptions as is required by the
JDBC specification"

SQL Server JDBC notes:
- [https://msdn.microsoft.com/en-us/library/ms378680%28v=sql.110%29.aspx] (matrix of conversions,
including notes of lossy vs. non-lossy)
- DECIMAL-to-INTEGER getInt(...) truncates (doesn't round)

UNSORTED:

- [http://support.guptatechnologies.com/Docs/SQLBase/Books/connecting/connecting_jdbc.htm]

> Implement (higher-priority) ResultSet.getXxx(...) data conversions
> ------------------------------------------------------------------
>
>                 Key: DRILL-2613
>                 URL: https://issues.apache.org/jira/browse/DRILL-2613
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Daniel Barclay (Drill)
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message