|
MariaDB [test]> select 0.00000000000000000000000001035 * 100000000000000000000000000000000000000000000;
|
+---------------------------------------------------------------------------------+
|
| 0.00000000000000000000000001035 * 100000000000000000000000000000000000000000000 |
|
+---------------------------------------------------------------------------------+
|
| 1000000000000000000.00000000000000000000000000000 |
|
+---------------------------------------------------------------------------------+
|
Same result on MySQL.
Both values are within DECIMAL range, so there should be no loss.
PostgeSQL returns the precise result:
postgres=# select 0.000000000000000000000000001035 * 100000000000000000000000000000000000000000000000000;
|
?column?
|
---------------------------------------------------------
|
103500000000000000000000.000000000000000000000000000000
|
(1 row)
|
|