You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/04/24 08:05:09 UTC

[GitHub] [shardingsphere] tristaZero opened a new issue #10171: Bad rewritten result for foreign key SQL

tristaZero opened a new issue #10171:
URL: https://github.com/apache/shardingsphere/issues/10171


   ### DB
   PostgreSQL
   
   ### SQL
   ```sql
   alter table bmsql_district add constraint d_warehouse_fkey foreign key (d_w_id) references bmsql_warehouse (w_id);
   ```
   
   ### Intro
   - `bmsql_district` and `bmsql_warehouse` are sharding tables.
   
   ### Actual rewritten result
   alter table bmsql_district_0 add constraint d_warehouse_fkey foreign key (d_w_id) references bmsql_warehouse (w_id);
   
   ### Expected rewritten result
   alter table bmsql_district_0 add constraint d_warehouse_fkey foreign key (d_w_id) references bmsql_warehouse_0 (w_id);
   


-- 
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:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero closed issue #10171: Bad rewritten result for foreign key SQL

Posted by GitBox <gi...@apache.org>.

tristaZero closed issue #10171:
URL: https://github.com/apache/shardingsphere/issues/10171


   


-- 
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:
users@infra.apache.org