dolt icon indicating copy to clipboard operation
dolt copied to clipboard

DISTINCT returns incorrect result for decimal types

Open jennifersp opened this issue 3 years ago • 0 comments

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    |
+------+

jennifersp avatar Sep 08 '22 22:09 jennifersp