修复PostgreSQL中DECIMAL、NUMERIC没有小数位问题。

tmlx1990 · tmlx1990 · commit 97cf17ffe21f · 2024-09-25T20:22:48.000+08:00
diff --git a/chat2db-server/chat2db-plugins/chat2db-postgresql/src/main/java/ai/chat2db/plugin/postgresql/type/PostgreSQLColumnTypeEnum.java b/chat2db-server/chat2db-plugins/chat2db-postgresql/src/main/java/ai/chat2db/plugin/postgresql/type/PostgreSQLColumnTypeEnum.java
@@ -22,7 +22,7 @@ public enum PostgreSQLColumnTypeEnum implements ColumnBuilder {
     CIDR("CIDR", false, false, true, false, false, false, true, true, false, false),
     CIRCLE("CIRCLE", false, false, true, false, false, false, true, true, false, false),
     DATE("DATE", false, false, true, false, false, false, true, true, false, false),
-    DECIMAL("DECIMAL", true, false, true, false, false, false, true, true, false, false),
+    DECIMAL("DECIMAL", true, true, true, false, false, false, true, true, false, false),
     FLOAT4("FLOAT4", false, false, true, false, false, false, true, true, false, false),
     FLOAT8("FLOAT8", false, false, true, false, false, false, true, true, false, false),
     INET("INET", false, false, true, false, false, false, true, true, false, false),
@@ -36,7 +36,7 @@ public enum PostgreSQLColumnTypeEnum implements ColumnBuilder {
     LSEG("LSEG", false, false, true, false, false, false, true, true, false, false),
     MACADDR("MACADDR", false, false, true, false, false, false, true, true, false, false),
     MONEY("MONEY", false, false, true, false, false, false, true, true, false, false),
-    NUMERIC("NUMERIC", true, false, true, false, false, false, true, true, false, false),
+    NUMERIC("NUMERIC", true, true, true, false, false, false, true, true, false, false),
     PATH("PATH", false, false, true, false, false, false, true, true, false, false),
     POINT("POINT", false, false, true, false, false, false, true, true, false, false),
     POLYGON("POLYGON", false, false, true, false, false, false, true, true, false, false),
