yuyongxing opened a new issue, #34002:
URL: https://github.com/apache/shardingsphere/issues/34002
### **Title**
`[ShardingProxy 5.5.1] Unable to query existing table after registering a
new storage unit`
---
### **Description**
#### **ShardingSphere Version:**
5.5.1
#### **Problem Description:**
When using ShardingProxy 5.5.1, after registering a new storage unit and
attempting to query an existing table in the corresponding database, the
following error occurs:
[42S02][10002] Table or view 'a_table' does not exist.
However, the table `a_table` does exist in the `test` database.
#### **Steps to Reproduce:**
1. Execute the following SQL statements:
```sql
create database `test` default charset utf8mb4 collate utf8mb4_general_ci;
use test;
REGISTER STORAGE UNIT test (
URL="jdbc:mysql://xxxx:3306/test?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true",
USER="xxxx",
PASSWORD="xxxx",
PROPERTIES("maximumPoolSize"=10,"idleTimeout"=30000)
);
However, the table `a_table` does exist in the `test` database.
2. Then execute the following query:
```sql
select * from a_table;
```
3. Error Message:
[42S02][10002] Table or view 'a_table' does not exist.
5. Expected Behavior:
The query should return data from the a_table table in the test database.
--
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:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
