Repository navigation
[Enhancement] java mysql jdbc cannot obtain the primary key information of the table #31206
Description
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
Activity
ihadoop commentedon Feb 21, 2024
let me see whether doris Implement that method in server side
liugddx commentedon Feb 21, 2024
Use ·SHOW FULL COLUMNS from cc_test.example_tbl_unique2·
ihadoop commentedon Feb 21, 2024
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 commentedon Feb 21, 2024
In the sample code, it shows that you support catalogs use
ResultSet rs = metaData.getPrimaryKeys(null, "cc_test", "example_tbl_unique2");
waywtdcc commentedon Feb 22, 2024
Is there any plan to support this? I can try to submit a PR
github-actions commentedon Sep 13, 2025
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!
[opt](compatibility) report MySQL-compatible key metadata so clients …