SingleStore 1.0.1 JDBC ResultsetMetadata getPrecision returning -1 for longtext type

Help
1

A query projects a longtext column and retrieves the precision from the ResultsetMetata.

A value of -1 is returned where 0 was expected.

https://docs.oracle.com/javase/8/docs/api/java/sql/ResultSetMetaData.html#getPrecision-int-

create table TCLOB ( RNUM integer not null , CCLOB longtext null ,
constraint CLOBPK primary key( RNUM ) , SHARD KEY ( RNUM ) ) ;

image
image977×121 11.7 KB

2

Hi @nigel.campbell,
Thank you for reporting this issue. I’ve opened an internal ticket to investigate this issue and the other issues that you’ve reported regarding JDBC.
~Julie