dolt
dolt copied to clipboard
DISTINCT returns incorrect result for decimal types
In MySQL:
>SELECT DISTINCT val FROM (values row(1.00), row(1), row(2), row(2)) a (val);
+------+
| val |
+------+
| 1.00 |
| 2.00 |
+------+
In Dolt:
>SELECT DISTINCT val FROM (values row(1.00), row(1), row(2), row(2)) a (val);
+------+
| val |
+------+
| 1.00 |
| 1 |
| 2 |
+------+