[ 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:53 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) - 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) > 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)