通过DatabaseMetaData.getPrimaryKeys(), getIndexInfo() 获取分区表的pk,index信息会多返回系统生成的隐藏列

【标题描述】: 使用JDBC中的DatabaseMetaData 对象获取分区表上的primaryKey 时返回了系统增加的隐藏列
【测试类型：SQL功能/存储功能/接口功能/工具功能/性能/并发/压力长稳/故障注入/安全/资料/编码规范】
【测试版本：3.1.0-og】

【操作步骤】(请填写详细的操作步骤):
```
创建测试表结构:
CREATE TABLE test_data.test_metadata (
    col_pk numeric NOT NULL primary key,
    partition_col character varying(30) NOT NULL
    
)
WITH (orientation=row, compression=no)
PARTITION BY LIST (partition_col)
(
    PARTITION partition_col_id_0100 VALUES ('0100') ,
    PARTITION partition_col_id_0110 VALUES ('0110') ,
    PARTITION partition_col_id_other VALUES (DEFAULT)
);

public void testMetadata() throws SQLException {
        DatabaseMetaData metaData = openGaussConnection.getMetaData();
        String catalog = "";
        String schema = "test_data";
        String table = "test_metadata";
        ResultSet rs = metaData.getPrimaryKeys(catalog, schema, table);
        System.out.println("--------get primaryKey  begin");
        while (rs.next()) {
            String columnName = rs.getString(4);
            int columnIndex = rs.getInt(5);
            System.out.println(String.format("columnIndex: %s , columnName: %s", columnIndex, columnName));
        }
        System.out.println("--------get primaryKey end");
        
        try (ResultSet rs1 = metaData.getIndexInfo(catalog, schema, table, true, true)) {
            System.out.println("--------get index info begin");
            while (rs1.next()) {
                final String indexName = rs1.getString(6);
                final String columnName = rs1.getString(9);
                System.out.println(String.format("indexName: %s, columnName: %s", indexName, columnName));
            }
            System.out.println("--------get index info end");
        }
    }

```

【预期输出】:
--------get primaryKey  begin
columnIndex: 1 , columnName: col_pk
--------get primaryKey end

--------get index info begin
indexName: test_metadata_pkey, columnName: col_pk
--------get index info end

【实际输出】:
--------get primaryKey  begin
columnIndex: 1 , columnName: col_pk
columnIndex: 2 , columnName: tableoid
--------get primaryKey end
--------get index info begin
indexName: test_metadata_pkey, columnName: col_pk
indexName: test_metadata_pkey, columnName: null
--------get index info end

【原因分析】:
1. 应该是去数据字典查询的时候查询条件没有过滤 系统生成的列

【日志信息】(请附上日志文件、截图、coredump信息):

【测试代码】:

openGauss/openGauss-connector-jdbc

内容风险标识

评论 (3)

openGauss/openGauss-connector-jdbc .gitee-modal { width: 500px !important; }

内容风险标识