<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="replication-features-floatvalues">
      </a>
      19.5.1.12 Replication and Floating-Point Values
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045135629056">
  </a>
  <a class="indexterm" name="idm46045135627552">
  </a>
  <p>
   With statement-based replication, values are converted from
        decimal to binary. Because conversions between decimal and
        binary representations of them may be approximate, comparisons
        involving floating-point values are inexact. This is true for
        operations that use floating-point values explicitly, or that
        use values that are converted to floating-point implicitly.
        Comparisons of floating-point values might yield different
        results on source and replica servers due to differences in
        computer architecture, the compiler used to build MySQL, and so
        forth. See
   <a class="xref" href="type-conversion.html" title="14.3 Type Conversion in Expression Evaluation">
    Section 14.3, “Type Conversion in Expression Evaluation”
   </a>
   , and
   <a class="xref" href="problems-with-float.html" title="B.3.4.8 Problems with Floating-Point Values">
    Section B.3.4.8, “Problems with Floating-Point Values”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
