Mod(%) operator meets inconsistent 0 results.

[SunRunAway]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. What did you do?
   If possible, provide a recipe for reproducing the error.

select 0.000 % 0.11234500000000000000;
select 1.099 % 0.00000001000000000000;

2. What did you expect to see?

In MySQL,

mysql> select 0.000 % 0.11234500000000000000;
+--------------------------------+
| 0.000 % 0.11234500000000000000 |
+--------------------------------+
|         0.00000000000000000000 |
+--------------------------------+
1 row in set (0.00 sec)

mysql> select 1.099 % 0.00000001000000000000;
+--------------------------------+
| 1.099 % 0.00000001000000000000 |
+--------------------------------+
|         0.00000000000000000000 |
+--------------------------------+
1 row in set (0.00 sec)

3. What did you see instead?

In TiDB,

mysql> select 0.000 % 0.11234500000000000000;
+--------------------------------+
| 0.000 % 0.11234500000000000000 |
+--------------------------------+
|                              0 |
+--------------------------------+
1 row in set (0.00 sec)

mysql> select 1.099 % 0.00000001000000000000;
+--------------------------------+
| 1.099 % 0.00000001000000000000 |
+--------------------------------+
|         0.00000000000000000000 |
+--------------------------------+
1 row in set (0.00 sec)

4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?
   0ea1bf0