Changes between Version 80 and Version 81 of DatabaseBasedAnalysis
- Timestamp:
- 08/06/18 16:57:06 (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseBasedAnalysis
v80 v81 778 778 A very interesting read is https://dev.mysql.com/doc/refman/5.7/en/precision-math.html (and its sub-sections! Click on ''NEXT''). 779 779 780 In short: A value like 1.234 is an ''exact'' value and exact math calculation are performed. If a value is given as an approximate ''floating-point'' value (which all '''DOUBLE''' columns are), for example 1.234e0, the calculation is ''not exact''. ''Not exact'' means that it using (faster) ''floating-point'' arithmetic rather than (slower) ''exact'' arithmetic.780 In short: A value like 1.234 is an ''exact'' value and exact arithmetic calculations are performed utilizing a dedicated library. If a value is given as an approximate ''floating-point'' value (which all '''DOUBLE''' columns are), for example 1.234e0, the calculation is ''not exact''. ''Not exact'' means that it using (faster) ''floating-point'' arithmetic rather than (slower) ''exact'' arithmetic. 781 781 782 782 Now, any mathematical operation which at least contains one ''floating-point'' number is evaluated as a floating-point approximation. This sounds very simple and as if it has nothing to do with our analysis, but it has: