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