dolthub / dolthub/dolt

`DECIMAL` value in `union` query loses precision and scale information

Open
#4,331 0 comments 0 reactions 2 assignees Claimed by @zachmu View on GitHub
bug sql
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 5h
Merged PRs (30d)
108

Description

In MySQL:
```
mysql> with recursive t (n) as (select sum(1) from dual union all select (2.00) from dual) select sum(n) from t;
+--------+
| sum(n) |
+--------+
| 3.00 |
+--------+
1 row in set (0.00 sec)
```
In Dolt:
```
mydb1> with recursive t (n) as (select sum(1) from dual union all select (2.00) from dual) select sum(n) from t;
+--------+
| sum(n) |
+--------+
| 3 |
+--------+
```

This is from `mergeUnionSchemas` rule, decimal type is cast to string.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.