[GitHub] [shardingsphere] xueshiji commented on issue #9569: Pagination problems

[GitBox <gi...@apache.org>]

xueshiji commented on issue #9569:
URL: https://github.com/apache/shardingsphere/issues/9569#issuecomment-790206530


   
   @yu199195 
   **1.the complete Logic SQL and Actual SQL**
   
   Logic:`select * from ( select row_.*, rownum rownum_ from ( select loginfo0_.ZCTYPE as col_0_0_, loginfo0_.BIZCODE as col_1_0_, loginfo0_.GID as col_2_0_, loginfo0_.JID as col_3_0_, loginfo0_.KEY as col_4_0_, loginfo0_.OPERATOR as col_5_0_, loginfo0_.DJTSZT as col_6_0_, loginfo0_.DJTSSJ as col_7_0_ from DB.tablename loginfo0_ where loginfo0_.KEY>-1 ) row_ where rownum <= ?) where rownum_ > ? ::: [3, 2]`
   
   Actual :`select * from ( select row_.*, rownum rownum_ from ( select loginfo0_.ZCTYPE as col_0_0_, loginfo0_.BIZCODE as col_1_0_, loginfo0_.GID as col_2_0_, loginfo0_.JID as col_3_0_, loginfo0_.KEY as col_4_0_, loginfo0_.OPERATOR as col_5_0_, loginfo0_.DJTSZT as col_6_0_, loginfo0_.DJTSSJ as col_7_0_ from tablename_44 loginfo0_ where loginfo0_.KEY>-1 ) row_ where rownum <= ?) where rownum_ > ? ::: [3, 2]
   `
   **2.the sharding-config:**
   `@Bean(name = "shardingDatasource")
       DataSource getDataSourceBean(@Qualifier("dataSource") DataSource dataSource1) {
           Map<String, DataSource> dataSourceMap = new HashMap<>();
           dataSourceMap.put("ds0", dataSource1);
           ShardingTableRuleConfiguration orderTableRuleConfig = new ShardingTableRuleConfiguration("tablename", getActualDataNodes());
           orderTableRuleConfig.setTableShardingStrategy(new StandardShardingStrategyConfiguration("key", "tableShardingAlgorithm"));
           ShardingRuleConfiguration shardingRuleConfig = new ShardingRuleConfiguration();
           shardingRuleConfig.getTables().add(orderTableRuleConfig);
           Properties tableShardingAlgorithmrProps = new Properties();
           tableShardingAlgorithmrProps.setProperty("algorithm-expression", "tablename_${key}");
           tableShardingAlgorithmrProps.setProperty("allow-range-query-with-inline-sharding", "true");
           shardingRuleConfig.getShardingAlgorithms().put("tableShardingAlgorithm", new ShardingSphereAlgorithmConfiguration("INLINE", tableShardingAlgorithmrProps));
   
           Properties properties = new Properties();
           properties.setProperty("sql-show", "true");
           DataSource dataSource = null;
           try {
               dataSource = ShardingSphereDataSourceFactory.createDataSource(dataSourceMap, Collections.singleton(shardingRuleConfig), properties);
           } catch (Exception throwables) {
               log.error(throwables.toString());
           }
           return dataSource;
       }`
   
   


----------------------------------------------------------------
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:
users@infra.apache.org