GisDeng opened a new issue #8069:
URL: https://github.com/apache/shardingsphere/issues/8069
here is my application.yml
` shardingsphere:
datasource:
names: d1
d1:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: net.sf.log4jdbc.sql.jdbcapi.DriverSpy
url:
jdbc:log4jdbc:mysql://ip:3306/eladmin?serverTimezone=Asia/Shanghai&characterEncoding=utf8&useSSL=false
username: username
password: password
sharding:
tables:
user:
actual-data-nodes: d1.user_$->{0..9}
key-generator:
column: id
type: SNOWFLAKE
#指定分片策略 id
table-strategy:
inline:
sharding-column: user_id
algorithm-expression: user_$->{user_id % 10}
#打开sql输出日志
props:
sql:
show: true`
When I use this sql to query the database for all table names:
`select table_name ,create_time , engine, table_collation, table_comment
from information_schema.tables
where table_schema = (select database()) order by create_time desc`
A bug appears that does not exist with table 'tables'
The prefix INFORMATION_SCHEMA appears to have been removed from SQL
----------------------------------------------------------------
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]
