Skip to content

sqlserver paging sql mergeResultSet.getValue has a error  #24037

@kittywu66

Description

@kittywu66

Bug Report we using shardingsphere-jdbc-core 5.1.2

Our sqlserver paging sql execution results are as follows
image
getIndexFromColumnLabelAndIndexMap("quoteMode") = 3,javaType of column quoteMode is Int,but javaType of column orderNo is String,
(int) The mergeResultSet. getValue method called in the ResultSetUtil. convertValue (mergeResultSet. getValue (columnIndex, int. class), int. class) statement returns the value of orderNo, resulting in an error when converting to int

image

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions