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/11/09 06:53:01 UTC
[GitHub] [shardingsphere] duanzonglong opened a new issue #6759: SHOW FULL COLUMNS get wrong
duanzonglong opened a new issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759
## 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?
4.1.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
config-wms.yaml:
shardingRule:
defaultDatabaseStrategy:
standard:
shardingColumn: tenant_id
preciseAlgorithmClassName: com.hrsoft.sharding.strategy.core.DatabaseStrategy
tables:
databasechangeloglock:
actualDataNodes: wms_base.databasechangeloglock
databaseStrategy:
none:
tableStrategy:
none:
databasechangelog:
actualDataNodes: wms_base.databasechangelog
databaseStrategy:
none:
tableStrategy:
none:
### Actual behavior
Table 'wms_sd1.databasechangelog' doesn't exist
some times its ok,so i think the "DatabaseStrategy" got wrong
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
springliquibase:
SHOW FULL COLUMNS FROM `databasechangelog` FROM `sharding_wms` LIKE '%'
### 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuohai666 commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-682387555
I think we should not add 'wms_sd1.' into actual SQL. @tristaZero , can you have a look?
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-671773371
the full sql is : SHOW FULL COLUMNS FROM `databasechangelog` FROM `sharding_wms` LIKE '%'
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong closed issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong closed issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759
----------------------------------------------------------------
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
[GitHub] [shardingsphere] kimmking commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-696113786
any update
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong edited a comment 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
defaultDataSourceName: wms_base
tables:
ds_changelog:
actualDataNodes: wms_base. databasechangelog
databaseStrategy:
none:
tableStrategy:
none:
ds_changelog_lock:
actualDataNodes: wms_base. databasechangeloglock
databaseStrategy:
none:
tableStrategy:
none:
more....
bindingTables:
- xxxxx
defaultTableStrategy:
none:
the framework is liquibase-3.9.0 with shardingproxy;
if we don't use shardingproxy the liquibase is ok.
the actual sql is:
SHOW FULL COLUMNS FROM databasechangelog FROM sharding_wms LIKE '%'
it's create by mysql-connector-java-8.0.20.jar
![image](https://user-images.githubusercontent.com/15925454/93955399-3ed5db80-fd82-11ea-9eff-a559d616815e.png)
it's has this bug with mysql-connector-java-5.1.46.jar.
![image](https://user-images.githubusercontent.com/15925454/94116867-1f23dd80-fe7e-11ea-8631-e02d4b5790a8.png)
I only want databasechangelog route to wms_base.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] kimmking closed issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759
----------------------------------------------------------------
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
[GitHub] [shardingsphere] kimmking closed issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-763481518
Hi,this is the whole yaml.
`
schemaName: sharding_wms
dataSources:
wms_base:
url: jdbc:mysql://172.172.172.213:3360/scms_wms?useUnicode=true&characterEncoding=UTF8
username: root
password: xxxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 65
wms_sd0:
url: jdbc:mysql://172.172.172.213:3360/wms_sd0?useUnicode=true&characterEncoding=UTF8
username: root
password: xxxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 65
wms_sd1:
url: jdbc:mysql://172.172.172.213:3360/wms_sd1?useUnicode=true&characterEncoding=UTF8
username: root
password: xxxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 65
shardingRule:
defaultDatabaseStrategy:
standard:
shardingColumn: tenant_id
preciseAlgorithmClassName: com.hrsoft.sharding.strategy.core.DatabaseStrategy
tables:
ds_changelog_lock:
actualDataNodes: wms_base.ds_changelog_lock
databaseStrategy:
none:
tableStrategy:
none:
ds_changelog:
actualDataNodes: wms_base.ds_changelog
databaseStrategy:
none:
tableStrategy:
none:
bindingTables:
- ds_changelog_lock,ds_changelog
defaultTableStrategy:
none:
`
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
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
[GitHub] [shardingsphere] duanzonglong commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-707452218
> what's wrong with mysql-connector-java-5.1.46.jar ?
I only want ds_changelog route to wms_base,but sometimes it's wrong,please see image.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong edited a comment 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
defaultDataSourceName: wms_base
tables:
ds_changelog:
actualDataNodes: wms_base. databasechangelog
databaseStrategy:
none:
tableStrategy:
none:
ds_changelog_lock:
actualDataNodes: wms_base. databasechangeloglock
databaseStrategy:
none:
tableStrategy:
none:
more....
bindingTables:
- xxxxx
defaultTableStrategy:
none:
the framework is liquibase-3.9.0 with shardingproxy;
if we don't use shardingproxy the liquibase is ok.
the actual sql is:
SHOW FULL COLUMNS FROM databasechangelog FROM sharding_wms LIKE '%'
it's create by mysql-connector-java-8.0.20.jar
![image](https://user-images.githubusercontent.com/15925454/93955399-3ed5db80-fd82-11ea-9eff-a559d616815e.png)
it's has this bug with mysql-connector-java-5.1.46.jar.
![image](https://user-images.githubusercontent.com/15925454/94114971-a6bc1d00-fe7b-11ea-84bb-fc89bf83d537.png)
I only want databasechangeloglock route to wms_base.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong edited a comment 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
defaultDataSourceName: wms_base
tables:
ds_changelog:
actualDataNodes: wms_base. databasechangelog
databaseStrategy:
none:
tableStrategy:
none:
ds_changelog_lock:
actualDataNodes: wms_base. databasechangeloglock
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)
mysql8 is
![image](https://user-images.githubusercontent.com/15925454/93955399-3ed5db80-fd82-11ea-9eff-a559d616815e.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
[GitHub] [shardingsphere] duanzonglong edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong edited a comment 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
defaultDataSourceName: wms_base
tables:
ds_changelog:
actualDataNodes: wms_base. databasechangelog
databaseStrategy:
none:
tableStrategy:
none:
ds_changelog_lock:
actualDataNodes: wms_base. databasechangeloglock
databaseStrategy:
none:
tableStrategy:
none:
more....
bindingTables:
- xxxxx
defaultTableStrategy:
none:
the framework is liquibase-3.9.0 with shardingproxy;
if we don't use shardingproxy the liquibase is ok.
the actual sql is:
SHOW FULL COLUMNS FROM databasechangelog FROM sharding_wms LIKE '%'
it's create by mysql-connector-java-8.0.20.jar
![image](https://user-images.githubusercontent.com/15925454/93955399-3ed5db80-fd82-11ea-9eff-a559d616815e.png)
it's has this bug with mysql-connector-java-5.1.46.jar.
![image](https://user-images.githubusercontent.com/15925454/94116867-1f23dd80-fe7e-11ea-8631-e02d4b5790a8.png)
I only want databasechangeloglock route to wms_base.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] kimmking commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-699645777
what's wrong with mysql-connector-java-5.1.46.jar ?
----------------------------------------------------------------
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
[GitHub] [shardingsphere] kimmking commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-719447169
As this issue have no more infomation for a long time, we close it now.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong edited a comment 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
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)
mysql8 is
![image](https://user-images.githubusercontent.com/15925454/93955322-0f26d380-fd82-11ea-9a56-5a793482f145.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
[GitHub] [shardingsphere] kimmking edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-719447169
any update, guys?
@duanzonglong
I guess there are someting configuration wrong to route to 2 ds with mysql-connector-java-5.1.46.jar, not the driver.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] tuohai666 commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-671694114
I'd like to add this issue to `Usability test of ShardingSphere-Proxy` (#6690)
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong edited a comment 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
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)
mysql8 is
![image](https://user-images.githubusercontent.com/15925454/93955399-3ed5db80-fd82-11ea-9eff-a559d616815e.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
[GitHub] [shardingsphere] duanzonglong edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong edited a comment on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-697070898
----------------------------------------------------------------
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
[GitHub] [shardingsphere] tristaZero commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-683285648
Hi @duanzonglong @tuohai666
First, let me collect your thoughts,
`sharding_wms` is a logic DB name, and `wms_sd1` is an actual one? We expected that this SQL is supposed to rewrite. However, we got an incorrect rewritten SQL, right?
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong closed issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong closed issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-764208997
Hi,I have solved this problem.
the config is:
defaultDataSourceName: wms_base
and
liquibase.setLiquibaseSchema("wms_base");
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
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
[GitHub] [shardingsphere] kimmking commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-679542058
the correct sql is:
> SHOW FULL COLUMNS FROM sharding_wms.databasechangelog LIKE '%'
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong edited a comment 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
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
[GitHub] [shardingsphere] duanzonglong edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong edited a comment 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
defaultDataSourceName: wms_base
tables:
ds_changelog:
actualDataNodes: wms_base. databasechangelog
databaseStrategy:
none:
tableStrategy:
none:
ds_changelog_lock:
actualDataNodes: wms_base. databasechangeloglock
databaseStrategy:
none:
tableStrategy:
none:
more....
bindingTables:
- xxxxx
defaultTableStrategy:
none:
the framework is liquibase-3.9.0 with shardingproxy;
if we don't use shardingproxy the liquibase is ok.
the actual sql is:
SHOW FULL COLUMNS FROM databasechangelog FROM sharding_wms LIKE '%'
it's create bymysql-connector-java-8.0.20.jar
![image](https://user-images.githubusercontent.com/15925454/93955399-3ed5db80-fd82-11ea-9eff-a559d616815e.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
[GitHub] [shardingsphere] duanzonglong edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong edited a comment on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-763481518
Hi,this is the whole yaml.
I have two tables don't need sharding,how to config?
`
schemaName: sharding_wms
dataSources:
wms_base:
url: jdbc:mysql://172.172.172.213:3360/scms_wms?useUnicode=true&characterEncoding=UTF8
username: root
password: xxxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 65
wms_sd0:
url: jdbc:mysql://172.172.172.213:3360/wms_sd0?useUnicode=true&characterEncoding=UTF8
username: root
password: xxxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 65
wms_sd1:
url: jdbc:mysql://172.172.172.213:3360/wms_sd1?useUnicode=true&characterEncoding=UTF8
username: root
password: xxxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 65
shardingRule:
defaultDatabaseStrategy:
standard:
shardingColumn: tenant_id
preciseAlgorithmClassName: com.hrsoft.sharding.strategy.core.DatabaseStrategy
tables:
ds_changelog_lock:
actualDataNodes: wms_base.ds_changelog_lock
databaseStrategy:
none:
tableStrategy:
none:
ds_changelog:
actualDataNodes: wms_base.ds_changelog
databaseStrategy:
none:
tableStrategy:
none:
bindingTables:
- ds_changelog_lock,ds_changelog
defaultTableStrategy:
none:
`
----------------------------------------------------------------
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
[GitHub] [shardingsphere] tuohai666 commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-671693553
Is `SHOW FULL COLUMNS FROM sharding_wms LIKE '%'` works well?
----------------------------------------------------------------
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
[GitHub] [shardingsphere] kimmking commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-696113786
any update
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong edited a comment 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
defaultDataSourceName: wms_base
tables:
ds_changelog:
actualDataNodes: wms_base. databasechangelog
databaseStrategy:
none:
tableStrategy:
none:
ds_changelog_lock:
actualDataNodes: wms_base. databasechangeloglock
databaseStrategy:
none:
tableStrategy:
none:
more....
bindingTables:
- xxxxx
defaultTableStrategy:
none:
the framework is liquibase-3.9.0 with shardingproxy;
if we don't use shardingproxy the liquibase is ok.
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)
mysql8 is
![image](https://user-images.githubusercontent.com/15925454/93955399-3ed5db80-fd82-11ea-9eff-a559d616815e.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
[GitHub] [shardingsphere] duanzonglong commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-671773679
some times its ok,but some times got wrong.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-764208997
Hi,I have solved this problem.
the config is:
defaultDataSourceName: wms_base
and
liquibase.setLiquibaseSchema("wms_base");
----------------------------------------------------------------
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
[GitHub] [shardingsphere] duanzonglong edited a comment on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
duanzonglong edited a comment on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-697070898
----------------------------------------------------------------
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
[GitHub] [shardingsphere] tuohai666 commented on issue #6759: SHOW FULL COLUMNS get wrong
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #6759:
URL: https://github.com/apache/shardingsphere/issues/6759#issuecomment-694665851
@Lucas-307 subscribed.
----------------------------------------------------------------
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