[
https://issues.apache.org/jira/browse/IGNITE-22792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated IGNITE-22792:
----------------------------------------
Fix Version/s: 2.19
(was: 2.18)
> REPLICATED table left join PARTITIONED table return error resultset with
> PARALLELISM is set
> -------------------------------------------------------------------------------------------
>
> Key: IGNITE-22792
> URL: https://issues.apache.org/jira/browse/IGNITE-22792
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.16
> Reporter: YuJue Li
> Priority: Major
> Fix For: 2.19
>
>
> start 2 nodes by ignite.sh and execute the following SQL:
> CREATE TABLE TEST_B (
> PORT_ID VARCHAR,
> OUT_SEC_ID VARCHAR,
> CONSTRAINT PORT_ID PRIMARY KEY (PORT_ID)
> ) WITH "TEMPLATE=REPLICATED";
>
> CREATE TABLE TEST_C (
> SEC_ID VARCHAR,
> SEC_NAME VARCHAR,
> CONSTRAINT SEC_ID PRIMARY KEY (SEC_ID)
> ) WITH "TEMPLATE=PARTITIONED,PARALLELISM=6";
>
>
> INSERT INTO TEST_B VALUES ('PORT1','600030');
>
> INSERT INTO TEST_C VALUES ('600030','TTTT');
>
> SELECT tb1.PORT_ID,
> tb2.SEC_ID,
> tb2.SEC_NAME
> FROM TEST_B tb1 LEFT JOIN TEST_C tb2 ON tb1.OUT_SEC_ID=tb2.SEC_ID;
>
> Normally, this SQL should return one row, but it returned 6 rows.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
