lwtdev commented on issue #7918:
URL: https://github.com/apache/shardingsphere/issues/7918#issuecomment-719393178
@strongduanmu I have run test case use newest version(2020/10/30 15 master)。
All test cases intended to be supported are tested ok。Test results as fallow:
- **Results Summary**
|SQL Demo Title |SQL Demo |Sharding Column |ShardingProxy(4.1.1)No Sharding
|ShardingProxy(5.0.0.RC1)No Sharding |
|---- |---- |---- |---- |---- |
|truncate |TRUNCATE customer; |NONE |Y |Y |
|truncateTable |TRUNCATE TABLE customer; |NONE |Y |Y |
|createIndex |CREATE UNIQUE INDEX idx_customer_email using btree on
customer_email (email(10)) comment 'index for email'; |NONE |Y |Y |
|dropIndex |DROP INDEX idx_customer_email on customer_email; |NONE |Y |Y |
|dropIndexWithAlgorithm |DROP INDEX idx_customer_email on customer_email
algorithm = default; |NONE |Y |Y |
|dropIndexPrimary |DROP INDEX \`PRIMARY\` ON customer_email; |NONE |Y |Y |
|grant |GRANT SELECT ON db2.customer TO 'jeffrey'@'localhost'; |NONE |Y |Y |
|setPassword |SET PASSWORD FOR 'bob'@'%.example.org' = 'auth_string'; |NONE
|Y |Y |
|setPasswordWithPasswordFunction |SET PASSWORD FOR 'bob'@'%.example.org' =
PASSWORD('auth_string'); |NONE |Y |Y |
|setCharacterSet |SET Character Set 'utf8'; |NONE |Y |Y |
|showCreateEvent |SHOW CREATE EVENT event_name; |NONE |Y |N |
|showCreateUser |SHOW CREATE USER \`user\`; |NONE |Y |N |
|showCreateView |SHOW CREATE VIEW view_name; |NONE |Y |N |
|showIndexWithDb |SHOW INDEXES from customer in db1; |NONE |Y |Y |
|showKeysWithLike |SHOW KEYS in customer in db1 where column_name like
'%id%'; |NONE |Y |Y |
|startSlaveSqlThread |start slave sql_thread until MASTER_LOG_FILE =
'log_name', MASTER_LOG_POS = 4; |NONE |Y |Y |
|startSlaveIoThread |start slave io_thread until RELAY_LOG_FILE =
'log_name', RELAY_LOG_POS = 4; |NONE |Y |Y |
|stopSlave |stop slave io_thread for channel 'channel1'; |NONE |Y |Y |
|stopGroupReplication |STOP GROUP_REPLICATION; |NONE |Y |N |
- **Unsupported SQL Details**
```sql
ShardingProxy(4.1.1)No Sharding
showCreateEvent[hasShardingKey:none]; Support:true; SQL: SHOW
CREATE EVENT event_name;
ds_0|SHOW CREATE EVENT event_name|
ShardingProxy(5.0.0.RC1)No Sharding
showCreateEvent[hasShardingKey:none]; Support:false; SQL: SHOW
CREATE EVENT event_name;
java.sql.SQLException: 2Unknown exception: [null]
ShardingProxy(4.1.1)No Sharding
showCreateUser[hasShardingKey:none]; Support:true; SQL: SHOW CREATE USER
`user`;
ds_0|SHOW CREATE USER `user`|
ShardingProxy(5.0.0.RC1)No Sharding
showCreateUser[hasShardingKey:none]; Support:false; SQL: SHOW CREATE USER
`user`;
java.sql.SQLException: 2Unknown exception: [null]
ShardingProxy(4.1.1)No Sharding
showCreateView[hasShardingKey:none]; Support:true; SQL: SHOW CREATE VIEW
view_name;
ds_0|SHOW CREATE VIEW view_name|
ShardingProxy(5.0.0.RC1)No Sharding
showCreateView[hasShardingKey:none]; Support:false; SQL: SHOW CREATE VIEW
view_name;
java.sql.SQLException: 2Unknown exception: [null]
ShardingProxy(4.1.1)No Sharding
stopGroupReplication[hasShardingKey:none]; Support:true; SQL: STOP
GROUP_REPLICATION;
ds_0|STOP GROUP_REPLICATION|
ShardingProxy(5.0.0.RC1)No Sharding
stopGroupReplication[hasShardingKey:none]; Support:false; SQL: STOP
GROUP_REPLICATION;
java.sql.SQLException: 2Unknown exception: [null]
```
----------------------------------------------------------------
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]
