Bug #81399 5.7 bug xxxxx test replace number round+gis precision differences (contribution)
Submitted: 12 May 2016 15:59 Modified: 24 Apr 2017 17:42
Reporter: OCA Admin (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[12 May 2016 15:59] OCA Admin
Description:
This bug tracks a contribution by Daniel Black (Github user: grooverdan) as described in http://github.com/mysql/mysql-server/pull/72

How to repeat:
See description

Suggested fix:
See contribution code attached
[12 May 2016 15:59] OCA Admin
Contribution submitted via Github - 5.7 bug xxxxx test replace number round+gis precision differences 
(*) Contribution by Daniel Black (Github grooverdan, mysql-server/pull/72#issuecomment-218622501): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_69624161.txt (text/plain), 641.16 KiB.

[13 May 2016 5:39] MySQL Verification Team
Hello Daniel,

Thank you for the report and contribution.

Thanks,
Umesh
[24 May 2016 13:28] OCA Admin
Contribution submitted via Github - bug #81399: Use numberic rounding in gis test cases (Part 2) 
(*) Contribution by Daniel Black (Github grooverdan, mysql-server/pull/76#issuecomment-221161604): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_71155263.txt (text/plain), 41.81 KiB.

[13 Jul 2016 10:03] Deepa Dixit
Hello,

Could you please give me a test case where regex did not correct this
discrepancy which you have mentioned in the description? I have come across
these differences in the results on ARM64 machines, and we have always used
regex to replace the results with a lower precision.
[24 Apr 2017 17:42] Paul Dubois
Posted by developer:
 
Noted in 5.7.19, 8.0.2 changelogs.

mysqltest now supports a replace_numeric_round command that takes an
argument value from 0 to 16 indicating the number of decimals to
round numeric values to. This can be used to help prevent result
content mismatch errors for tests in which slightly different results
are obtained across platforms due to precision differences. Thanks to
Daniel Black for the patch.