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

[waywtdcc]

Search before asking

• 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

• 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

[github-actions]

We're closing this issue because it hasn't been updated in a while.
If you'd like to revive this issue, please reopen it and feel free a maintainer to remove the Stale tag!