search

oceanbase / obconnector-j

OceanBase Client for Java is a JDBC 4.2 compatible driver, used to connect applications developed in Java to OceanBase Database Server.
GNU Lesser General Public License v2.1
28 stars 10 forks source link

[Bug]: JDBC查询BINARY_FLOAT类型时出错 #1

Open jiangtao69039 opened 1 year ago

jiangtao69039 commented 1 year ago

Describe the bug

create table T4(ID BINARY_FLOAT);
insert into T4 values(1.2);

然后通过jdbc 使用select 查询这个表,当调用resultSet.getObject()方法时驱动会报错,驱动用的oceanbase-client:2.4.3 错误的位置在下面截图这里: image 这里直接new String(bytes) 没看懂..

下面用Float.intBitsToFloat转换能正常显示出插入值 1.2 image

hnwyllmm commented 1 year ago

JDBC的issue，直接转到jdbc社区了

jiangtao69039 commented 1 year ago

似乎这样处理之后, 是ieee 754 格式 image