[
https://issues.apache.org/jira/browse/IGNITE-26968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-26968:
--------------------------------------
Description:
The problem was identified after running the test
{{ItJdbcJoinsSelfTest.testJoin()}} on 3 nodes (before that, this test was
performed only on a single node cluster).
We have 3 tables
PERSON
||ID||NAME||AGE||CITY_ID||
|1| 'Shravya'| 25| 1.1|
|2| 'Kiran'| 26| 1.1|
|3| 'Harika'| 26| 2.4|
|4| 'Srinivas'| 24| 3.2|
|5| 'Madhavi'| 23| 3.2|
|6| 'Deeps'| 28| 1.2|
|7| 'Hope'| 27| 1.2|
MEDICAL_INFO
||id||name||age||blood_group
|1|'Madhavi'|23|'A+'|
|2|'Diggi'|27|'B+'|
|3|'Kiran'|26|'O+'|
|4|'Harika'|26|'AB+'|
BLOOD_GROUP_INFO_P
||id||blood_group||universal_donor||
|1|'A+'|'A+AB+'|
|2|'O+'|'O+A+B+AB+'|
|3|'B+'|'B+AB+'|
|4|'AB+'|'AB+'|
|5|'O-'|'EveryOne'|
was:
The problem was identified after running the test
{{ItJdbcJoinsSelfTest.testJoin()}} on 3 nodes (before that, this test was
performed only on a single node cluster).
We have 3 tables
PERSON
||ID||NAME||AGE||CITY_ID||
|1| 'Shravya'| 25| 1.1|
|2| 'Kiran'| 26| 1.1|
|3| 'Harika'| 26| 2.4|
|4| 'Srinivas'| 24| 3.2|
|5| 'Madhavi'| 23| 3.2|
|6| 'Deeps'| 28| 1.2|
|7| 'Hope'| 27| 1.2|
MEDICAL_INFO
||id||name||age||blood_group
|1|'Madhavi'|23|'A+'|
|2|'Diggi'|27|'B+'|
|3|'Kiran'|26|'O+'|
|4|'Harika'|26|'AB+'|
> Sql. Left join of 3 tables produces incorrect result
> ----------------------------------------------------
>
> Key: IGNITE-26968
> URL: https://issues.apache.org/jira/browse/IGNITE-26968
> Project: Ignite
> Issue Type: Bug
> Components: sql ai3
> Reporter: Pavel Pereslegin
> Priority: Major
> Labels: ignite-3
>
> The problem was identified after running the test
> {{ItJdbcJoinsSelfTest.testJoin()}} on 3 nodes (before that, this test was
> performed only on a single node cluster).
> We have 3 tables
> PERSON
> ||ID||NAME||AGE||CITY_ID||
> |1| 'Shravya'| 25| 1.1|
> |2| 'Kiran'| 26| 1.1|
> |3| 'Harika'| 26| 2.4|
> |4| 'Srinivas'| 24| 3.2|
> |5| 'Madhavi'| 23| 3.2|
> |6| 'Deeps'| 28| 1.2|
> |7| 'Hope'| 27| 1.2|
> MEDICAL_INFO
> ||id||name||age||blood_group
> |1|'Madhavi'|23|'A+'|
> |2|'Diggi'|27|'B+'|
> |3|'Kiran'|26|'O+'|
> |4|'Harika'|26|'AB+'|
> BLOOD_GROUP_INFO_P
> ||id||blood_group||universal_donor||
> |1|'A+'|'A+AB+'|
> |2|'O+'|'O+A+B+AB+'|
> |3|'B+'|'B+AB+'|
> |4|'AB+'|'AB+'|
> |5|'O-'|'EveryOne'|
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
