-
-
Notifications
You must be signed in to change notification settings - Fork 51
Open
Labels
bugSomething isn't workingSomething isn't working
Description
These queries are valid in Postgres
postgres=# create table t(a decimal(6, 2), b decimal(8, 5), c decimal(5, 1));
CREATE TABLE
postgres=# insert into t values (2.75, 8.8, 3.1);
INSERT 0 1
postgres=# select greatest(a, b, c), least(a, b, c) from t;
greatest | least
----------+-------
8.80000 | 2.75
(1 row)However, the same queries (added as a test in dolthub/go-mysql-server#3447) fails in Doltgres with the following error message
Unexpected error for query select greatest(a, b, c), least(a, b, c) from t;: ERROR: unsupported type for greatest/least argument: *types.DoltgresType
This is because we don't handle Doltgres types in the greatest/least implementation in dolthub/go-mysql-server.
Note that the decimal precision in Postgres is different from the precision in MySQL (dolthub/dolt#10567)
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't working