linghengqian opened a new issue #13002:
URL: https://github.com/apache/shardingsphere/issues/13002


   ## Bug Report
   
   **For English only**, other languages will not accept.
   
   Before report a bug, make sure you have:
   
   - Searched open and closed [GitHub 
issues](https://github.com/apache/shardingsphere/issues).
   - Read documentation: [ShardingSphere 
Doc](https://shardingsphere.apache.org/document/current/en/overview).
   
   Please pay attention on issues you submitted, because we maybe need more 
details. 
   If no response anymore and we cannot reproduce it on current information, we 
will **close it**.
   
   Please answer these questions before submitting your issue. Thanks!
   
   ### Which version of ShardingSphere did you use?
   5.0.0-beta
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-JDBC
   ### Expected behavior
   When configuring a property after the table name in YAML or Properties, the 
part after the table name is displayed normally, as 
sharding-jdbC-spring-boot-starter 4.1.1 does not give a warning. Sample source 
code for the project is provided 
   from https://github.com/qiuxiaotong2021/catfish-sharding . The following is 
the application.
   ```properties
   server.port=8080
   spring.application.name=catfish-sharding
   spring.main.allow-bean-definition-overriding=true
   
   spring.jpa.database=mysql
   spring.jpa.hibernate.ddl-auto=none
   spring.jpa.show-sql=false
   spring.jpa.open-in-view=true
   spring.jpa.properties.hibernate.format_sql=true
   spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect
   
   spring.shardingsphere.datasource.names=ds-0,ds-1
   
spring.shardingsphere.datasource.ds-0.jdbc-url=jdbc:mysql://localhost:3306/ds0?serverTimezone=GMT%2B8&useSSL=false&useUnicode=true&characterEncoding=UTF-8
   spring.shardingsphere.datasource.ds-0.type=com.zaxxer.hikari.HikariDataSource
   
spring.shardingsphere.datasource.ds-0.driver-class-name=com.mysql.cj.jdbc.Driver
   spring.shardingsphere.datasource.ds-0.username=root
   spring.shardingsphere.datasource.ds-0.password=root1234
   spring.shardingsphere.datasource.ds-0.minimum-idle=5
   spring.shardingsphere.datasource.ds-0.maximum-pool-size=10
   
   
spring.shardingsphere.datasource.ds-1.jdbc-url=jdbc:mysql://localhost:3306/ds1?serverTimezone=GMT%2B8&useSSL=false&useUnicode=true&characterEncoding=UTF-8
   spring.shardingsphere.datasource.ds-1.type=com.zaxxer.hikari.HikariDataSource
   
spring.shardingsphere.datasource.ds-1.driver-class-name=com.mysql.cj.jdbc.Driver
   spring.shardingsphere.datasource.ds-1.username=root
   spring.shardingsphere.datasource.ds-1.password=root1234
   spring.shardingsphere.datasource.ds-1.minimum-idle=5
   spring.shardingsphere.datasource.ds-1.maximum-pool-size=10
   
   spring.shardingsphere.props.sql-show=true
   spring.shardingsphere.props.max-connections-size-per-query=5
   spring.shardingsphere.props.executor.size=5
   
   
spring.shardingsphere.rules.sharding.default-database-strategy.complex.sharding-columns=user_id,order_id
   
spring.shardingsphere.rules.sharding.default-database-strategy.complex.sharding-algorithm-name=order-db-complex
   
spring.shardingsphere.rules.sharding.sharding-algorithms.order-db-complex.type=OrderDbComplex
   
spring.shardingsphere.rules.sharding.sharding-algorithms.order-db-complex.props.algorithm-expression=com.catfish.sharding.algorithm.OrderDbComplexShardingAlgorithm
   
   spring.shardingsphere.rules.sharding.binding-tables[0]=t_order,t_order_item
   spring.shardingsphere.rules.sharding.broadcast-tables[0]=t_address
   
   
spring.shardingsphere.rules.sharding.tables.t_order.actual-data-nodes=ds-$->{0..1}.t_order_$->{0..1}
   
   
spring.shardingsphere.rules.sharding.tables.t_order.table-strategy.standard.sharding-column=order_id
   
spring.shardingsphere.rules.sharding.tables.t_order.table-strategy.standard.sharding-algorithm-name=order-volume-range-table
   
spring.shardingsphere.rules.sharding.sharding-algorithms.order-volume-range-table.type=VOLUME_RANGE
   
spring.shardingsphere.rules.sharding.sharding-algorithms.order-volume-range-table.props.range-lower=5
   
spring.shardingsphere.rules.sharding.sharding-algorithms.order-volume-range-table.props.range-upper=10
   
spring.shardingsphere.rules.sharding.sharding-algorithms.order-volume-range-table.props.sharding-volume=5
   
   
spring.shardingsphere.rules.sharding.tables.t_order_item.actual-data-nodes=ds-$->{0..1}.t_order_item_$->{0..1}
   
spring.shardingsphere.rules.sharding.tables.t_order_item.table-strategy.standard.sharding-column=order_id
   
spring.shardingsphere.rules.sharding.tables.t_order_item.table-strategy.standard.sharding-algorithm-name=t-order-item-inline
   
spring.shardingsphere.rules.sharding.sharding-algorithms.t-order-item-inline.type=INLINE
   
spring.shardingsphere.rules.sharding.sharding-algorithms.t-order-item-inline.props.algorithm-expression=t_order_item_$->{order_id
 % 2}
   
   
spring.shardingsphere.rules.sharding.tables.t_address.key-generate-strategy.column=id
   
spring.shardingsphere.rules.sharding.tables.t_address.key-generate-strategy.key-generator-name=snowflake
   
spring.shardingsphere.rules.sharding.tables.t_order.key-generate-strategy.column=order_id
   
spring.shardingsphere.rules.sharding.tables.t_order.key-generate-strategy.key-generator-name=snowflake
   
spring.shardingsphere.rules.sharding.tables.t_order_item.key-generate-strategy.column=order_item_id
   
spring.shardingsphere.rules.sharding.tables.t_order_item.key-generate-strategy.key-generator-name=snowflake
   spring.shardingsphere.rules.sharding.key-generators.snowflake.type=SNOWFLAKE
   
spring.shardingsphere.rules.sharding.key-generators.snowflake.props.worker-id=123
   ```
   ### Actual behavior
   Most attributes throw a warning that the configuration key cannot be found.
   ```text
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.default-database-strategy.complex.sharding-columns'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.default-database-strategy.complex.sharding-algorithm-name'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.sharding-algorithms.order-db-complex.type'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.sharding-algorithms.order-db-complex.props.algorithm-expression'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.binding-tables[0]'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.broadcast-tables[0]'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.tables.t_order.actual-data-nodes'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.tables.t_order.table-strategy.standard.sharding-column'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.tables.t_order.table-strategy.standard.sharding-algorithm-name'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.sharding-algorithms.order-volume-range-table.type'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.sharding-algorithms.order-volume-range-table.props.range-lower'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.sharding-algorithms.order-volume-range-table.props.range-upper'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.sharding-algorithms.order-volume-range-table.props.sharding-volume'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.tables.t_order_item.actual-data-nodes'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.tables.t_order_item.table-strategy.standard.sharding-column'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.tables.t_order_item.table-strategy.standard.sharding-algorithm-name'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.sharding-algorithms.t-order-item-inline.type'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.sharding-algorithms.t-order-item-inline.props.algorithm-expression'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.tables.t_address.key-generate-strategy.column'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.tables.t_address.key-generate-strategy.key-generator-name'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.tables.t_order.key-generate-strategy.column'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.tables.t_order.key-generate-strategy.key-generator-name'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.tables.t_order_item.key-generate-strategy.column'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.tables.t_order_item.key-generate-strategy.key-generator-name'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.key-generators.snowflake.type'
   Cannot resolve configuration property 
'spring.shardingsphere.rules.sharding.key-generators.snowflake.props.worker-id'
   ```
   
   
![image](https://user-images.githubusercontent.com/20187731/136948031-e959b83f-7bc2-444f-a079-862b8145df6b.png)
   
   
![image](https://user-images.githubusercontent.com/20187731/136947942-f63b4339-5b85-41ed-949e-f616f3c9228e.png)
   
   ### Reason analyze (If you can)
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule 
configuration, when exception occur etc.
   
   ### Example codes for reproduce this issue (such as a github link).
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to