[ https://issues.apache.org/jira/browse/SQOOP-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16145272#comment-16145272 ]
ASF subversion and git services commented on SQOOP-3195: -------------------------------------------------------- Commit 1378520e498595bc46002395f2d50412a42a1df3 in sqoop's branch refs/heads/trunk from [~BoglarkaEgyed] [ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=1378520 ] SQOOP-3195: SQLServerDatatypeImportDelimitedFileTest can fail in some environments (Szabolcs Vasas via Boglarka Egyed) > SQLServerDatatypeImportDelimitedFileTest can fail in some environments > ---------------------------------------------------------------------- > > Key: SQOOP-3195 > URL: https://issues.apache.org/jira/browse/SQOOP-3195 > Project: Sqoop > Issue Type: Test > Reporter: Szabolcs Vasas > Assignee: Szabolcs Vasas > Attachments: SQOOP-3195.patch > > > I tried to execute the SQLServer third party tests with two different SQL > Server versions. With SQL Server 2014 Express edition all the tests were > successful however with SQL Server 2017 Developer edition I got the following > error: > [junit] Test > org.apache.sqoop.manager.sqlserver.SQLServerDatatypeImportDelimitedFileTest > FAILED > Failure for following Test Data : > FLOAT > SCALE : null > PREC : null > TO_INSERT : 1.7976931348623157 > DB_READBACK : 1.7976931348623155 > HDFS_READBACK : 1.7976931348623155 > NEG_POS_FLAG : POS > OFFSET : 8 > ----------------------------------------------------------- > Exception details : > expected a different string expected:<1.797693134862315[5]> but > was:<1.797693134862315[7]> > By looking at the test case I have found that it inserts 1.7976931348623157 > into the database but it expects 1.7976931348623155 (the last digit is 5 > instead of 7) probably because float is an approximate numeric data types on > MSSQL and on earlier versions this is how it worked but. > I suggest using a less precise float number in this test case to avoid > flakyness. -- This message was sent by Atlassian JIRA (v6.4.14#64029)