[Enhancement] java mysql jdbc cannot obtain the primary key information of the table

[waywtdcc]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Description

CREATE TABLE IF NOT EXISTS cc_test.example_tbl_unique2 ( user_id LARGEINT NOT NULL COMMENT "用户id", username VARCHAR(50) NOT NULL COMMENT "用户昵称", city VARCHAR(20) COMMENT "用户所在城市" ) UNIQUE KEY(user_id) DISTRIBUTED BY HASH(user_id) BUCKETS 1 PROPERTIES ( "replication_allocation" = "tag.location.default: 1" );

DatabaseMetaData metaData = dbConn.getMetaData(); ResultSet rs = metaData.getPrimaryKeys(“cc_test”, null, "example_tbl_unique2");

result is empty.

Solution

No response

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[ihadoop]

let me see whether doris Implement that method in server side

[liugddx]

Use ·SHOW FULL COLUMNS from cc_test.example_tbl_unique2·

[ihadoop]

mysql jdbc driver use command "show key from xx.xxx" to get PK.doris don't implement method,and then return EMPTY_SET

[Isaac-Whiz]

In the sample code, it shows that you support catalogs use ResultSet rs = metaData.getPrimaryKeys(null, "cc_test", "example_tbl_unique2");

[waywtdcc]

mysql jdbc driver use command "show key from xx.xxx" to get PK.doris don't implement method,and then return EMPTY_SET

Is there any plan to support this? I can try to submit a PR