[GitHub] [shardingsphere] jxch-1024 opened a new issue, #23968: SQLSERVER Page query field return error

["jxch-1024 (via GitHub)" <gi...@apache.org>]

jxch-1024 opened a new issue, #23968:
URL: https://github.com/apache/shardingsphere/issues/23968

   The sql server paging sql I use is as follows：
   _select  * from ( select TOP 30 ROW_NUMBER() OVER(ORDER BY P.BIZDATE DESC ) AS rownum,  P.* FROM (select * from (
           select
           tao.dealType,
           tao.orderNo,
           tao.SourceNo，...
           from TradeApi_Order tao
           ) f ) P ) as temp  where temp.rownum > 0 ORDER BY temp.rownum_
   
   The result field of the sql query is：
   top(index:1), dealType(index:2) ,orderNo(index:3), SourceNo(index4)
   
   However, the dealType index of shardingsphere record is as follows:
   ![0091d288fed8e44475145569486d09a](https://user-images.githubusercontent.com/28945646/216561616-ba316004-a791-4cf7-875f-51940169b91b.png)
   He seems to have skipped the index of the top field。
   
   This causes all obtained field indexes to be reduced by 1.
   
   version: 5.1.2
   
   
   
   
   
   


-- 
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