tristaZero opened a new issue #9498:
URL: https://github.com/apache/shardingsphere/issues/9498
Different databases have their specific SQLs. Therefore we have `data-types`
to distinguish test SQLS. Similarly, we still need `scenarios-type` to pick up
SQLs running for some specific scenarios.
For instance,
```
<test-case sql="SELECT * FROM (SELECT TOP (?) row_number() OVER (ORDER BY
i.item_id DESC) AS rownum_, i.item_id, o.order_id as order_id, o.status as
status, o.user_id as user_id FROM t_order o JOIN t_order_item i ON o.user_id =
i.user_id AND o.order_id = i.order_id WHERE o.user_id IN (?, ?) AND o.order_id
BETWEEN ? AND ?) AS row_" db-types="SQLServer">
<assertion parameters="2:int, 10:int, 19:int, 1000:int, 1909:int"
expected-data-file="select_pagination_with_row_count.xml" />
</test-case>
```
Please imitate `data-types` to implement `scenarios-type` in
`IntegrationTestCase.class`.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
