apecloud / myduckserver

MySQL & Postgres Analytics, Reimagined
182 stars 8 forks source link

Numbers are garbled when using psql #164

Closed NoyException closed 3 days ago

NoyException commented 3 days ago

For example, I create a table as follow:

create table account(
  id int, 
  name char(16) unique, 
  balance float, 
  primary key(id)
);
insert into account values(12500000, 'name0', 514.35);

in mysql client:

MySQL [main]> select * from my_table;
+----------+-------+---------+
| id       | name  | balance |
+----------+-------+---------+
| 12500001 | name1 |  103.14 |
+----------+-------+---------+

but in psql:

main=> select * from my_table;
 id | name  |  balance
----+-------+------------
    | name1 | @Y\u008F\)
(1 row)