m-lvqingyu opened a new issue, #37536:
URL: https://github.com/apache/shardingsphere/issues/37536
Hello, my current version setup is as follows: Spring Boot 3.5.8 +
ShardingSphere-JDBC 5.5.2 + Druid 1.2.23 + MyBatis-Plus-Spring-Boot3-Starter
3.5.1. When I enable the props-related configuration, I encounter the error
"Table or view 'xxxxx' does not exist." However, when I disable the props
configuration, the query works normally. Could you please help me identify what
might be wrong with my configuration?
The configuration is as follows：
spring:
datasource:
driver-class-name: org.apache.shardingsphere.driver.ShardingSphereDriver
url: jdbc:shardingsphere:classpath:sharding-standalone.yml
mode:
type: Standalone
repository:
type: JDBC
#
org.apache.shardingsphere.mode.repository.standalone.jdbc.JDBCRepository
# props:
# provider: MySQL
# driverClassName: com.mysql.cj.jdbc.Driver
# jdbc_url:
jdbc:mysql://localhost:3306/phoenix?useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
# username: root
# password: 123456
dataSources:
ds_0:
dataSourceClassName: com.alibaba.druid.pool.DruidDataSource
driverClassName: com.mysql.cj.jdbc.Driver
url:
jdbc:mysql://localhost:3306/phoenix?useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
username: root
password: 123456
rules:
- !SHARDING
tables:
user_info:
actualDataNodes: ds_0.user_info_${0..4}
tableStrategy:
standard:
shardingColumn: id
shardingAlgorithmName: table_inline
shardingAlgorithms:
table_inline:
type: INLINE
props:
algorithm-expression: user_info_${id % 4}
- !SINGLE
tables:
- "*.*"
props:
sql-show: true
<img width="1809" height="926" alt="Image"
src="https://github.com/user-attachments/assets/db534299-04f4-49d5-abf6-18dcf32edfc3";
/>
<img width="1810" height="885" alt="Image"
src="https://github.com/user-attachments/assets/1f22c746-e0a7-456b-a20b-a4a24d012df3";
/>
--
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]
