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 2021/03/23 10:02:27 UTC
[GitHub] [shardingsphere] JiekerTime opened a new issue #9782: Single table not
JiekerTime opened a new issue #9782:
URL: https://github.com/apache/shardingsphere/issues/9782
### Which version of ShardingSphere did you use?
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
### Expected behavior
### Actual behavior
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
### 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] jiang-wei commented on issue #9782: Single table not support DDL
Posted by GitBox <gi...@apache.org>.
jiang-wei commented on issue #9782:
URL: https://github.com/apache/shardingsphere/issues/9782#issuecomment-805122990
In 5.0.0, the default sharding datasource is removed.
SS loads all tables at startup and configure the sharding policy on them.
For newly created tables there's no way to tell SS to load them.
--
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] RaigorJiang commented on issue #9782: Single table not support DDL
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #9782:
URL: https://github.com/apache/shardingsphere/issues/9782#issuecomment-927276009
The problem no longer exists, close this issue.
--
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] jiang-wei commented on issue #9782: Single table not support DDL
Posted by GitBox <gi...@apache.org>.
jiang-wei commented on issue #9782:
URL: https://github.com/apache/shardingsphere/issues/9782#issuecomment-805122014
I guess the newly created table is not picked up by SS to save into "unconfiguredSchemaMetaDataMap"
--
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] RaigorJiang closed issue #9782: Single table not support DDL
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #9782:
URL: https://github.com/apache/shardingsphere/issues/9782
--
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] RaigorJiang commented on issue #9782: Single table not support DDL
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #9782:
URL: https://github.com/apache/shardingsphere/issues/9782#issuecomment-927275905
After verification, DDL has been supported, the following is the test record:
```sql
mysql> CREATE TABLE `t_single` (
-> `order_id` bigint(20) NOT NULL AUTO_INCREMENT,
-> `user_id` int(11) NOT NULL,
-> `status` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
-> PRIMARY KEY (`order_id`)
-> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
Query OK, 0 rows affected (0.10 sec)
mysql> show tables;
+-----------------------+
| Tables_in_sharding_db |
+-----------------------+
| t_order_item |
| t_order |
| t_single |
+-----------------------+
3 rows in set (0.00 sec)
mysql> ALTER TABLE t_single ADD remark varchar(20) DEFAULT NULL;
Query OK, 0 rows affected (0.13 sec)
mysql> TRUNCATE table t_single;
Query OK, 0 rows affected (0.04 sec)
mysql> DROP table t_single;
Query OK, 0 rows affected (0.04 sec)
```
--
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