Decimal is not supported on SELECT but ok on CREATE TABLE

apecloud / myduckserver

MySQL & Postgres Analytics, Reimagined

182 stars 8 forks source link

Decimal is not supported on SELECT but ok on CREATE TABLE #186

Open NoyException opened 1 day ago

NoyException commented 1 day ago

Connect with psql. The log is as follows.

main=> create table test (pk int, value int, d1 decimal(4,2), c1 char(10), primary key(pk));
CREATE TABLE
main=> insert into test (pk, value, d1, c1) values (0,1,2.3,'hi');
INSERT 0 1
main=> select * from test;
ERROR:  unsupported type DECIMAL(4,2) (errno 1105) (sqlstate HY000)

fanyang01 commented 1 day ago

Yeah, the Postgres protocol side does not support DECIMAL yet. I will address this issue today.