|
Thanks! MDEV-23702 was reported for the same bug, If you'd like to follow the progress, please, watch task MDEV-23702.
As a temporary workaround, one could change div_precision_increment:
MariaDB [(none)]> SELECT 6/101*100;
|
+-----------+
|
| 6/101*100 |
|
+-----------+
|
| 5.9400 |
|
+-----------+
|
1 row in set (0.001 sec)
|
|
MariaDB [(none)]> set div_precision_increment=8;
|
Query OK, 0 rows affected (0.001 sec)
|
|
MariaDB [(none)]> SELECT 6/101*100;
|
+------------+
|
| 6/101*100 |
|
+------------+
|
| 5.94059400 |
|
+------------+
|
1 row in set (0.000 sec)
|
|
variables.txt