study-renjie opened a new issue, #28601:
URL: https://github.com/apache/shardingsphere/issues/28601

   ## The rewrite method will remove the schema from SQL, resulting in SQL 
execution errors
   sql如下
   
![image](https://github.com/apache/shardingsphere/assets/43563096/4cf73d68-bf15-433d-bfeb-a31d3d706af1)
   报错如下
   `{
       "message": "\r\n### Error querying database.  Cause: 
java.sql.SQLSyntaxErrorException: Table 'servicedb.partitions' doesn't 
exist\r\n### The error may exist in file 
[D:\\CBC_Project\\SpringBootDemo\\target\\classes\\mapper\\TestDao.xml]\r\n### 
The error may involve defaultParameterMap\r\n### The error occurred while 
setting parameters\r\n### SQL: SELECT partition_name partitionName, 
partition_description partitionDesc, table_rows rowCount         FROM 
INFORMATION_SCHEMA.PARTITIONS         WHERE TABLE_SCHEMA = SCHEMA ()           
AND TABLE_NAME ='t_operationlog'           AND partition_name = ?\r\n### Cause: 
java.sql.SQLSyntaxErrorException: Table 'cbclogmgrservicedb.partitions' doesn't 
exist\n; bad SQL grammar []; nested exception is 
java.sql.SQLSyntaxErrorException: Table 'cbclogmgrservicedb.partitions' doesn't 
exist"
   }`


-- 
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]

Reply via email to