SingleStore 1.0.1 JDBC user defined constraint name not returned

Help
1

The constraint name defined for the primary key is not returned via DatabaseMetadata.getPrimaryKeys, instead the value PRIMARY is returned. Does SingleStore ignore the user defined constraint name by design?

create table TBLOB ( RNUM integer not null , CBLOB blob null ,
constraint BLOBPK primary key( RNUM ) , SHARD KEY ( RNUM ) ) ;

https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#getPrimaryKeys-java.lang.String-java.lang.String-java.lang.String-

image

2

Hi Nigel.
Our team suggests that CONSTRAINT syntax in SingleStore is ignored. Instead, you can simply define Primary Key and Shard Key without this syntax and you will get the intended result.

This may help with some of your other posts that are similar to this one, but we will give the community a chance to chime in with their feedback too.

Best of luck :four_leaf_clover: