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 2022/12/01 13:57:16 UTC

[GitHub] [shardingsphere] peilinqian opened a new issue, #22576: In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is incorrect.

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

   ### Which version of ShardingSphere did you use?
   we find java version: java8, full_version=1.8.0_342, full_path=/home/peilq_sharding/bisheng-jdk1.8.0_342//bin/java
   ShardingSphere-5.2.2-SNAPSHOT
   Commit ID: dirty-753c0cee8ee6fd3db00536da55b64bc5198a3758
   Commit Message: Optimize sqlFederationExecutor init logic when sqlFederationType modify dynamically (https://github.com/apache/shardingsphere/pull/22209)
   Branch: https://github.com/apache/shardingsphere/commit/753c0cee8ee6fd3db00536da55b64bc5198a3758
   Build time: 2022-11-19T10:18:41+0800
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   ### Expected behavior
   In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is correct.
   
   ### Actual behavior
   In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is incorrect.
   
   ### Reason analyze (If you can)
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   ```
   (select * from t_order where order_id = 1500 union select * from t_order  where order_id = 1800 )INTERSECT select * from t_order  where status ='finish' order by order_id;
   select * from t_order where order_id = 1500 union (select * from t_order  where order_id = 1800 INTERSECT select * from t_order  where status ='finish' order by order_id);  --incorrect
   select * from t_order where order_id = 1500 union select * from t_order  where order_id = 1800 INTERSECT select * from t_order  where status ='finish' order by order_id; --incorrect
   
   ```
   **the result of ss**
   
   **test_db=> (select * from t_order where order_id = 1500 union select * from t_order  where order_id = 1800 )INTERSECT select * from t_order  where status ='finish' order by order_id;
    order_id | user_id | status | merchant_id | remark |     creation_date
   ----------+---------+--------+-------------+--------+-----------------------
        1800 |      18 | finish |          13 | test   | 2017-08-18 00:00:00.0
   (1 row)
   
   test_db=> select * from t_order where order_id = 1500 union (select * from t_order  where order_id = 1800 INTERSECT select * from t_order  where status ='finish' order by order_id);
    order_id | user_id | status | merchant_id | remark |     creation_date
   ----------+---------+--------+-------------+--------+-----------------------
        1800 |      18 | finish |          13 | test   | 2017-08-18 00:00:00.0
   (1 row)
   
   test_db=> select * from t_order where order_id = 1500 union select * from t_order  where order_id = 1800 INTERSECT select * from t_order  where status ='finish' order by order_id;
    order_id | user_id | status | merchant_id | remark |     creation_date
   ----------+---------+--------+-------------+--------+-----------------------
        1800 |      18 | finish |          13 | test   | 2017-08-18 00:00:00.0
   (1 row)**
   
   
   
   **the result of og**
   ```
   tpccdb=# (select * from t_order where order_id = 1500 union select * from t_order  where order_id = 1800 )INTERSECT select * from t_order  where status ='finish' order by order_id;
    order_id | user_id | status | merchant_id | remark |    creation_date
   ----------+---------+--------+-------------+--------+---------------------
        1800 |      18 | finish |          13 | test   | 2017-08-18 00:00:00
   (1 row)
   
   tpccdb=# select * from t_order where order_id = 1500 union (select * from t_order  where order_id = 1800 INTERSECT select * from t_order  where status ='finish' order by order_id);
    order_id | user_id | status | merchant_id | remark |    creation_date
   ----------+---------+--------+-------------+--------+---------------------
        1500 |      15 | init   |           1 |        | 2017-08-28 00:00:00
        1800 |      18 | finish |          13 | test   | 2017-08-18 00:00:00
   (2 rows)
   
   tpccdb=# select * from t_order where order_id = 1500 union select * from t_order  where order_id = 1800 INTERSECT select * from t_order  where status ='finish' order by order_id;
    order_id | user_id | status | merchant_id | remark |    creation_date
   ----------+---------+--------+-------------+--------+---------------------
        1500 |      15 | init   |           1 |        | 2017-08-28 00:00:00
        1800 |      18 | finish |          13 | test   | 2017-08-18 00:00:00
   (2 rows)
   ```
   
   ### Example codes for reproduce this issue (such as a github link).
   ```
   drop table if exists t_order; 
   create table t_order (order_id int primary key, user_id int not null, status varchar(50) not null, merchant_id int not null, remark varchar(50), creation_date date);
   insert into t_order values(1000, 10, 'init', 1, 'test', '2017-07-08');
   insert into t_order values(1001, 10, 'init', 2, 'test', '2017-07-08');
   insert into t_order values(2000, 20, 'init', 3, 'test', '2017-08-08');
   insert into t_order values(2001, 20, 'init', 4, 'test', '2017-08-08');
   insert into t_order values(1100, 11,  'init', 5, 'test', '2017-08-08');
   insert into t_order values(1101, 11, 'init', 6, 'test', '2017-08-08');
   insert into t_order values(2100, 21, 'finish', 7, 'test', '2017-08-08');
   insert into t_order values(2101, 21, 'finish', 8, 'test', '2017-08-08');
   insert into t_order values(1200, 12, 'finish', 9, 'finish', '2017-08-08');
   insert into t_order values(1201, 12, 'finish', 10, 'test22', '2017-08-18');
   insert into t_order values(2200, 22, 'finish', 11, 'test', '2017-08-18');
   insert into t_order values(2201, 22, 'finish', 12, 'test', '2017-08-18');
   insert into t_order values(1300, 13, 'finish', 13, '', '2017-08-18');
   insert into t_order values(1301, 13, 'finish', 14, 'test', '2017-08-18');
   insert into t_order values(2300, 23, 'finish ', 15, 'test', '2017-08-18');
   insert into t_order values(2301, 23, 'finish', 16, 'test', '2017-08-18');
   insert into t_order values(1400, 14, 'init', 17, '', '2017-08-18');
   insert into t_order values(1401, 14, 'init', 18, 'test', '2017-08-18');
   insert into t_order values(2400, 24, 'init', 19, 'test', '2017-08-18');
   insert into t_order values(2401, 24, 'init', 20, 'test', '2017-08-18');
   insert into t_order values(1500, 15, 'init', 1, '', '2017-08-28');
   insert into t_order values(1501, 15, 'init', 2, 'test', '2017-08-28');
   insert into t_order values(2500, 25, 'init', 3, 'test', '2017-08-28');
   insert into t_order values(2501, 25, 'init', 4, 'test', '2017-08-28');
   insert into t_order values(1600, 16, 'init', 5, 'test', '2017-08-28');
   insert into t_order values(1601, 16, 'init', 6, '', '2017-08-28');
   insert into t_order values(2600, 26, 'init', 7, 'test', '2017-08-28');
   insert into t_order values(2601, 26, 'init', 8);
   insert into t_order values(1700, 17, 'init', 9, 'test', '2017-08-28');
   insert into t_order values(1701, 17, 'finish', 10, 'test', '2017-08-18');
   insert into t_order values(2700, 27, 'finish', 11, 'test', '2017-08-18');
   insert into t_order values(2701, 27, 'finish', 12, 'test', '2017-08-18');
   insert into t_order values(1800, 18, 'finish', 13, 'test', '2017-08-18');
   insert into t_order values(1801, 18, 'finish', 14);
   insert into t_order values(2800, 28, 'finish', 15, 'test', '2017-08-18');
   insert into t_order values(2801, 28, 'finish', 16, 'test', '2017-08-18');
   insert into t_order values(1900, 19, 'init', 17, 'test', '2017-08-18');
   insert into t_order values(1901, 19, 'init', 18, 'test', '2017-08-18');
   insert into t_order values(2900, 29, 'init', 19, 'test', '2017-08-18');
   insert into t_order values(2901, 29, 'init', 20, 'test', '2017-08-18');
   insert into t_order values(1902, 19, 'init', 17, 'test11', '2017-08-18');
   insert into t_order values(1903, 19, 'init', 18, 'test12', '2017-08-18');
   insert into t_order values(2902, 29, 'init', 19, 'test', '2017-08-18');
   insert into t_order values(2903, 29, 'init', 20, 'test', '2017-08-18');
   ```
   
   ```
   schemaName: test_db
   dataSources:
     ds_0:
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 260
       minPoolSize: 10
       password: Test@123
       url: jdbc:opengauss://90.90.44.171:14000/test_db?batchMode=on
       username: tpccuser
     ds_1:
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 260
       minPoolSize: 10
       password: Test@123
       url: jdbc:opengauss://90.90.44.171:15000/test_db?batchMode=on
       username: tpccuser
   rules:
   - !SHARDING
     tables:
       t_user:
         actualDataNodes: ds_0.t_user
       t_product:
         actualDataNodes: ds_0.t_product
       t_merchant:
         actualDataNodes: ds_1.t_merchant
       t_product_detail:
         actualDataNodes: ds_1.t_product_detail
       t_order:
         actualDataNodes: ds_${0..1}.t_order
         databaseStrategy:
           standard:
             shardingColumn: user_id
             shardingAlgorithmName: database_inline
       t_order_item:
         actualDataNodes: ds_${0..1}.t_order_item
         databaseStrategy:
           standard:
             shardingColumn: user_id
             shardingAlgorithmName: database_inline
       t_order_item1:
         actualDataNodes: ds_${0..1}.t_order_item1
         databaseStrategy:
           standard:
             shardingColumn: user_id
             shardingAlgorithmName: database_inline
       t_new_order:
         actualDataNodes: ds_${0..1}.t_new_order_${0..1}
         databaseStrategy:
           standard:
             shardingAlgorithmName: database_inline
             shardingColumn: user_id
         tableStrategy:
           standard:
             shardingColumn: order_id
             shardingAlgorithmName: table_inline
     bindingTables:
       - t_order,t_order_item
     broadcastTables:
       - t_product_category
       - t_country
     shardingAlgorithms:
       database_inline:
         type: INLINE
         props:
           algorithm-expression: ds_${user_id % 2}
           allow-range-query-with-inline-sharding: true
       table_inline:
         type: INLINE
         props:
           algorithm-expression: t_new_order_${order_id % 2}
           allow-range-query-with-inline-sharding: true
   mode:
     type: Cluster
     repository:
       type: ZooKeeper
       props:
         namespace: governance_ds
         server-lists: 7.212.123.28:2181
         retryIntervalMilliseconds: 500
         timeToLiveSeconds: 60
         maxRetries: 3
         operationTimeoutMilliseconds: 500
   authority:
     users:
       - user: root@%
         password: root
       - user: sharding
         password: sharding
     privilege:
       type: ALL_PERMITTED
   rules:
   - !TRANSACTION
     defaultType: XA
     providerType: Atomikos
   props:
     sql-show: true
   ```


-- 
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] peilinqian commented on issue #22576: In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is incorrect.

Posted by GitBox <gi...@apache.org>.
peilinqian commented on issue #22576:
URL: https://github.com/apache/shardingsphere/issues/22576#issuecomment-1348141112

   **version**
   ```
   we find java version: java8, full_version=1.8.0_282, full_path=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.282.b08-1.el7_9.x86_64/bin/java
   ShardingSphere-5.2.2-SNAPSHOT
   Commit ID: dirty-631fdf40f87223e176abe5c851a51b3287b4d6de
   Commit Message: Fix wrong decide result when execute same sharding condition subquery with sql federation (https://github.com/apache/shardingsphere/pull/22754)
   Branch: https://github.com/apache/shardingsphere/commit/631fdf40f87223e176abe5c851a51b3287b4d6de
   Build time: 2022-12-12T10:48:40+0800
   ```
   **result :pass**
   ```
   test_db=> (select * from t_order where order_id = 1500 union select * from t_order  where order_id = 1800 )INTERSECT select * from t_order  where status ='finish' order by order_id;
    order_id | user_id | status | merchant_id | remark |     creation_date
   ----------+---------+--------+-------------+--------+-----------------------
        1800 |      18 | finish |          13 | test   | 2017-08-18 00:00:00.0
   (1 row)
   
   test_db=> select * from t_order where order_id = 1500 union (select * from t_order  where order_id = 1800 INTERSECT select * from t_order  where status ='finish' ) order by order_id;
    order_id | user_id | status | merchant_id | remark |     creation_date
   ----------+---------+--------+-------------+--------+-----------------------
        1500 |      15 | init   |           1 |        | 2017-08-28 00:00:00.0
        1800 |      18 | finish |          13 | test   | 2017-08-18 00:00:00.0
   (2 rows)
   
   test_db=> select * from t_order where order_id = 1500 union select * from t_order  where order_id = 1800 INTERSECT select * from t_order  where status ='finish' order by order_id;
    order_id | user_id | status | merchant_id | remark |     creation_date
   ----------+---------+--------+-------------+--------+-----------------------
        1500 |      15 | init   |           1 |        | 2017-08-28 00:00:00.0
        1800 |      18 | finish |          13 | test   | 2017-08-18 00:00:00.0
   (2 rows)
   
   ```


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] strongduanmu commented on issue #22576: In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is incorrect.

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #22576:
URL: https://github.com/apache/shardingsphere/issues/22576#issuecomment-1340841671

   According to PostgreSQL document - https://www.postgresql.org/docs/current/queries-union.html, if we add order by segment in top level of sql, the results of set operations are not guaranteed to be ordered.
   
   > UNION effectively appends the result of query2 to the result of query1 (although there is no guarantee that this is the order in which the rows are actually returned). Furthermore, it eliminates duplicate rows from its result, in the same way as DISTINCT, unless UNION ALL is used.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] peilinqian commented on issue #22576: In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is incorrect.

Posted by GitBox <gi...@apache.org>.
peilinqian commented on issue #22576:
URL: https://github.com/apache/shardingsphere/issues/22576#issuecomment-1333808206

   ![image](https://user-images.githubusercontent.com/97432411/205071791-2fb9a8d7-d6fd-48e7-bbbd-64205514cc72.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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] wsm12138 commented on issue #22576: In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is incorrect.

Posted by GitBox <gi...@apache.org>.
wsm12138 commented on issue #22576:
URL: https://github.com/apache/shardingsphere/issues/22576#issuecomment-1341889998

   ### version
   ```
   ShardingSphere-5.2.2-SNAPSHOT
   Commit ID: 9f94090137cdc4b325901d624d90a135f01adad1
   Commit Message: Comply with the code style. (#22730)
   Branch: master
   Build time: 2022-12-08T10:03:19+0800
   ```
   ### Proxy
   <img width="1397" alt="image" src="https://user-images.githubusercontent.com/86462784/206340859-d420dd65-1c19-410a-a3a6-a95e0c27e53c.png">
   
   ### og
   <img width="1310" alt="image" src="https://user-images.githubusercontent.com/86462784/206340891-8075094a-0b75-4a37-b800-7552ac369bb3.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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] peilinqian commented on issue #22576: In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is incorrect.

Posted by GitBox <gi...@apache.org>.
peilinqian commented on issue #22576:
URL: https://github.com/apache/shardingsphere/issues/22576#issuecomment-1334846671

   ```
   <?xml version="1.0" encoding="UTF-8"?>
   <ROOT>
     <CLUSTER>
       <PARAM name="clusterName" value="dbCluster" />
       <PARAM name="master" value="linux188" />
       <PARAM name="nodeNames" value="linux188,linux189,linux192" />
       <PARAM name="gaussdbAppPath" value="/data1/opengauss/app/gaussdb" />
       <PARAM name="gaussdbLogPath" value="/data1/opengauss/log/gaussdb" />
       <PARAM name="gaussdbToolPath" value="/data1/opengauss/tool/huawei/wisequery" />
       <PARAM name="corePath" value="/data1/core" />
       <PARAM name="backIp1s" value="192.168.97.30,192.168.97.31,192.168.97.32"/>
       <PARAM name="clusterType" value="single-inst"/>
       <PARAM name="GaussVT" value="Fusion"/>
       <PARAM name="enable_dss" value="on"/>
       <PARAM name="dss_home" value="/data1/opengauss/home/data/dss_home"/>
       <PARAM name="dss_vg_info" value="data:/dev/sdc,log0:/dev/sdd,log1:/dev/sde,log2:/dev/sdf"/>
       <PARAM name="votingDiskPath" value="/dev/sdg"/>
       <PARAM name="shareDiskDir" value="/dev/sdh"/>
       <PARAM name="ss_dss_vg_name" value="data"/>
     </CLUSTER>
     <DEVICELIST>
           <DEVICE sn="linux188">
           <PARAM name="name" value="linux188"/>
           <PARAM name="backIp1" value="192.168.97.30"/>
           <PARAM name="sshIp1" value="192.168.97.30"/>
           <PARAM name="azName" value="AZ1"/>
           <PARAM name="azPriority" value="1"/>
           <!-- cm -->
           <PARAM name="cmDir" value="/data1/opengauss/home/data/cm"/>
           <PARAM name="cmsNum" value="1"/>
           <PARAM name="cmServerPortBase" value="27000"/>
           <PARAM name="cmServerListenIp1" value="192.168.97.30,192.168.97.31,192.168.97.32"/>
           <PARAM name="cmServerlevel" value="1"/>
           <PARAM name="cmServerRelation" value="linux188,linux189,linux192"/>
           <PARAM name="dataNum" value="1"/>
           <PARAM name="dataPortBase" value="26200"/>
           <PARAM name="dataNode1" value="/data1/opengauss/home/data/db1,linux189,/data1/opengauss/home/data/db1,linux192,/data1/opengauss/home/data/db1"/>
   
       </DEVICE>
       <DEVICE sn="linux189">
           <PARAM name="name" value="linux189"/>
           <PARAM name="azName" value="AZ1"/>
           <PARAM name="azPriority" value="1"/>
           <PARAM name="backIp1" value="192.168.97.31"/>
           <PARAM name="sshIp1" value="192.168.97.31"/>
           <PARAM name="test_ip" value="192.168.97.31"/>
           <PARAM name="root" value="huawei"/>
           <PARAM name="cmDir" value="/data1/opengauss/home/data/cm"/>
       </DEVICE>
       <DEVICE sn="linux192">
           <PARAM name="name" value="linux192"/>
           <PARAM name="azName" value="AZ1"/>
           <PARAM name="azPriority" value="1"/>
           <PARAM name="backIp1" value="192.168.97.32"/>
           <PARAM name="sshIp1" value="192.168.97.32"/>
           <PARAM name="test_ip" value="192.168.97.32"/>
           <PARAM name="root" value="huawei"/>
           <PARAM name="cmDir" value="/data1/opengauss/home/data/cm"/>
   
       </DEVICE>
     </DEVICELIST>
   </ROOT>
   
   ```


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] strongduanmu commented on issue #22576: In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is incorrect.

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #22576:
URL: https://github.com/apache/shardingsphere/issues/22576#issuecomment-1340843258

   Following is the latest result.
   
   ```sql
   sharding_db=> (select * from t_order where order_id = 1500 union select * from t_order  where order_id = 1800 )INTERSECT select * from t_order  where status ='finish' order by order_id;
    order_id | user_id | status | merchant_id | remark | creation_date
   ----------+---------+--------+-------------+--------+---------------
        1800 |      18 | finish |          13 | test   | 2017-08-18
   (1 row)
   
   sharding_db=> select * from t_order where order_id = 1500 union (select * from t_order  where order_id = 1800 INTERSECT select * from t_order  where status ='finish' order by order_id);  --incorrect
    order_id | user_id | status | merchant_id | remark | creation_date
   ----------+---------+--------+-------------+--------+---------------
        1800 |      18 | finish |          13 | test   | 2017-08-18
        1500 |      15 | init   |           1 |        | 2017-08-28
   (2 rows)
   
   sharding_db=> select * from t_order where order_id = 1500 union select * from t_order  where order_id = 1800 INTERSECT select * from t_order  where status ='finish' order by order_id; --incorrect
    order_id | user_id | status | merchant_id | remark | creation_date
   ----------+---------+--------+-------------+--------+---------------
        1500 |      15 | init   |           1 |        | 2017-08-28
        1800 |      18 | finish |          13 | test   | 2017-08-18
   (2 rows)
   ```


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] strongduanmu commented on issue #22576: In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is incorrect.

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #22576:
URL: https://github.com/apache/shardingsphere/issues/22576#issuecomment-1334700859

   @peilinqian Thank you for your feedback, I will check this issue.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] peilinqian commented on issue #22576: In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is incorrect.

Posted by GitBox <gi...@apache.org>.
peilinqian commented on issue #22576:
URL: https://github.com/apache/shardingsphere/issues/22576#issuecomment-1333811136

   ![image](https://user-images.githubusercontent.com/97432411/205072176-cc852157-edd3-4fcb-9364-d77af2a03e2a.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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] peilinqian commented on issue #22576: In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is incorrect.

Posted by GitBox <gi...@apache.org>.
peilinqian commented on issue #22576:
URL: https://github.com/apache/shardingsphere/issues/22576#issuecomment-1333809220

   ![image](https://user-images.githubusercontent.com/97432411/205071977-06b8dba2-bc3e-4e15-9b69-45223f41c40d.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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] taojintianxia closed issue #22576: In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is incorrect.

Posted by GitBox <gi...@apache.org>.
taojintianxia closed issue #22576: In the federation scenario,the priority of ‘UNION/EXCEPT/INTERSECT ’ is incorrect.
URL: https://github.com/apache/shardingsphere/issues/22576


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org