You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "kittywu66 (via GitHub)" <gi...@apache.org> on 2023/02/07 02:59:34 UTC

[GitHub] [shardingsphere] kittywu66 opened a new issue, #24037: sqlserver paging sql mergeResultSet.getValue has a error

kittywu66 opened a new issue, #24037:
URL: https://github.com/apache/shardingsphere/issues/24037

   ## Bug Report we using shardingsphere-jdbc-core 5.1.2
   Our sqlserver paging sql execution results are as follows
   ![image](https://user-images.githubusercontent.com/23444920/217134727-98eae9f7-6a3a-473b-b71e-d9f97e4dcc83.png)
   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](https://user-images.githubusercontent.com/23444920/217135343-5fe01234-0e4f-41b4-bb6f-b9c719a1b97e.png)
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] zhaojinchao95 commented on issue #24037: sqlserver paging sql mergeResultSet.getValue has a error

Posted by "zhaojinchao95 (via GitHub)" <gi...@apache.org>.
zhaojinchao95 commented on issue #24037:
URL: https://github.com/apache/shardingsphere/issues/24037#issuecomment-1420221366

   @kittywu66 Can you try ShardingSphere` 5.3.1` version?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org