You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/09/23 01:39:27 UTC
[GitHub] [shardingsphere] duanzonglong commented on issue #6759: SHOW FULL COLUMNS get wrong
duanzonglong commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-697070898
config-wms.yaml:
schemaName: sharding_wms
dataSources:
wms_base:
-----
wms_sd0:
-----
wms_sd1:
-----
wms_sd2:
shardingRule:
defaultDatabaseStrategy:
standard:
shardingColumn: tenant_id
preciseAlgorithmClassName: com.hrsoft.sharding.strategy.core.DatabaseStrategy
broadcastTables:
- ds_changelog,ds_changelog_lock
defaultDataSourceName: wms_base
tables:
ds_changelog:
actualDataNodes: wms_base.ds_changelog
databaseStrategy:
none:
tableStrategy:
none:
ds_changelog_lock:
actualDataNodes: wms_base.ds_changelog_lock
databaseStrategy:
none:
tableStrategy:
none:
more....
bindingTables:
- xxxxx
defaultTableStrategy:
none:
the actual sql is:
SHOW FULL COLUMNS FROM databasechangelog FROM sharding_wms LIKE '%'
it's create bymysql-connector-java-5.1.46.jar
![image](https://user-images.githubusercontent.com/15925454/93954606-a12ddc80-fd80-11ea-8598-8c2a5320d4b6.png)
----------------------------------------------------------------
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