为了更快的定位您的问题，请提供以下信息，谢谢
【详述】starrocks使用oracle jdbc catalog查询报错ERROR 1064 (HY000): DECIMAL’s precision should range from 1 to 38
【背景】无
【业务影响】
【是否存算分离】否
【StarRocks版本】3.3.2
【集群规模】例如：1fe+1be（fe与be混部）
【机器信息】24C/100G/千兆
建表语句
create table BIZ_CUSTOMER_ONLINE_SVIP_D
(
cus_id NUMBER,
vip_buy_time DATE,
vip_invalid_time DATE,
vip_cus_status NUMBER,
add_time DATE default sysdate,
id NUMBER,
trial_status NUMBER default 0,
staff_id NVARCHAR2(20),
renew NUMBER,
card_type NUMBER,
order_id NUMBER,
refund_order_id NUMBER,
vip_buy_datetime DATE,
vip_invalid_datetime DATE
)
tablespace TB01
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
)
nologging;
创建catalog的语句
CREATE EXTERNAL CATALOG apppri
PROPERTIES
(
“type”=“jdbc”,
“user”=“xxx”,
“password”=“xxxxx”,
“jdbc_uri”=“jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.208)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = apppri)))”,
“driver_url”=“file:///usr/local/software/jdbc_driver/ojdbc8-21.1.0.0.jar”,
“driver_class”=“oracle.jdbc.driver.OracleDriver”
);
查询报错
select * from apppri.TSCM.BIZ_CUSTOMER_ONLINE_SVIP_D where id = 27598;
ERROR 1064 (HY000): DECIMAL’s precision should range from 1 to 38
在oracle查询是对的
