[GitHub] [shardingsphere] JiekerTime opened a new issue #11365: PostgreSQL does not support broadcast tables under sharding conditions

Fri, 16 Jul 2021 00:36:33 -0700 


JiekerTime opened a new issue #11365:
URL: https://github.com/apache/shardingsphere/issues/11365


   ### Which version of ShardingSphere did you use?
   5.0.0-RC1-SNAPSHOT
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Expected behavior
   
   
![image](https://user-images.githubusercontent.com/76552510/125909217-4ed455bd-f87f-4a42-babc-081538e3651a.png)
   
   ### Actual behavior
   
![image](https://user-images.githubusercontent.com/76552510/125909256-f23637cc-5bcb-42d9-81c3-684d8eaa2717.png)
   
![image](https://user-images.githubusercontent.com/76552510/125909301-9d2c4149-d1a8-4fb0-a947-a20e977e41b5.png)
   
   ### Reason analyze (If you can)
   Metadata order error in proxy scenario.
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule 
configuration, when exception occur etc.
   #### The first way
   Modify the integration test configuration file as follows：
   
![image](https://user-images.githubusercontent.com/76552510/125909527-1a20dd58-4c84-4d1e-8f7a-d0667951d83d.png)
   Execute case as follow:
   
![image](https://user-images.githubusercontent.com/76552510/125909605-e10253da-a909-4171-8860-625efa2820c5.png)
   #### The Second way
   
   Start a proxy service with the configuration file in 
[SS](https://github.com/apache/shardingsphere/blob/master/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/db/postgresql/proxy/conf/config-db.yaml).
   
   Initialize the database using the 
[init.sql](https://github.com/apache/shardingsphere/blob/master/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/db/init-sql/postgresql/init.sql);
   
   Execute statement “SELECT * FROM t_broadcast_table”
   
   Observation metadata：
   
   
![image](https://user-images.githubusercontent.com/76552510/125910117-e0964903-0360-48f8-84bd-5161465508c4.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