[GitHub] [shardingsphere] hehua2018 opened a new issue, #19035: Shardingsphere-proxy Can not support multiple different database error

Sun, 09 Oct 2022 23:38:06 -0700 


hehua2018 opened a new issue, #19035:
URL: https://github.com/apache/shardingsphere/issues/19035

   ## Bug Report
   ### Shardingsphere-proxy An error occurred in a cross-database query:
   ### Shardingsphere-proxy version: 5.1.2
   ### mysql version: 8.0.27
   ### error sql:
   ##### mysql databases: product;finance
   ```
    select tso.store_id,dept.pk_org,dept.code,dept.name,dept.shortname, 
dept.parent_pk_dept,dept.pk_org,dept.pk_dept from product.t_store_options tso 
inner join finance.nc_dept dept on tso.nc_pk_org = dept.pk_org where 
tso.store_id = ? and parent_pk_dept = '~'
   ```
   #### The error is shown below
   
![image](https://user-images.githubusercontent.com/36179722/178256563-f51fd8f4-8b24-4d5a-bb1a-ffb2dc41b853.png)
   
   


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