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

Daniel Barclay (Drill) commented on DRILL-2613:
-----------------------------------------------

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)

Reply via email to