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 2022/01/10 09:49:41 UTC
[GitHub] [shardingsphere] xsong123 opened a new issue #14667: rename table error
xsong123 opened a new issue #14667:
URL: https://github.com/apache/shardingsphere/issues/14667
shardingsphere version 5.0.0
config as below：
rules:
tables:
basicinfo:
actualDataNodes: ds_${0..0}.basicinfo_${0..15}
...
sql as below：
rename table basicinfo to hisbasicinfo20210101;
ps: table[hisbasicinfo20210101] has no rule
error as below：
com.google.common.util.concurrent.UncheckedExecutionException: java.lang.IllegalArgumentException: Can not find visitor rule: `RenameTableContext`
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2051)
at com.google.common.cache.LocalCache.get(LocalCache.java:3951)
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974)
at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4958)
at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4964)
at org.apache.shardingsphere.infra.parser.sql.SQLStatementParserEngine.parse(SQLStatementParserEngine.java:48)
at org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse0(ShardingSphereSQLParserEngine.java:71)
at org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:60)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:157)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:128)
at org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection.prepareStatement(ShardingSphereConnection.java:78)
at org.seasar.extension.jdbc.util.ConnectionUtil.prepareStatement(ConnectionUtil.java:93)
at org.seasar.extension.jdbc.manager.JdbcContextImpl.getPreparedStatement(JdbcContextImpl.java:130)
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #14667: rename table error
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #14667:
URL: https://github.com/apache/shardingsphere/issues/14667#issuecomment-1010585259
>
@totalo Welcome.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #14667: rename table error
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #14667:
URL: https://github.com/apache/shardingsphere/issues/14667
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] totalo commented on issue #14667: rename table error
Posted by GitBox <gi...@apache.org>.
totalo commented on issue #14667:
URL: https://github.com/apache/shardingsphere/issues/14667#issuecomment-1010585137
I will look into this, please assign me.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #14667: rename table error
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #14667:
URL: https://github.com/apache/shardingsphere/issues/14667#issuecomment-1010581829
As @CrackerSuperior said, the rename statement is not currently supported. Are you interested in this task? @xsong123 @CrackerSuperior You are welcome to submit PRs to support the rename statement.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] CrackerSuperior commented on issue #14667: rename table error
Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #14667:
URL: https://github.com/apache/shardingsphere/issues/14667#issuecomment-1008720252
Sorry, if I remember correctly, the rename statement is not supported for the time being
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #14667: rename table error
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #14667:
URL: https://github.com/apache/shardingsphere/issues/14667#issuecomment-1010582919
By the way, you can try the `ALTER TABLE RENAME TO...` statement, which I remember is supported.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org