Roman Kondakov created IGNITE-11839:
---------------------------------------
Summary: SQL: table join order changes may lead to incorrect result
Key: IGNITE-11839
URL: https://issues.apache.org/jira/browse/IGNITE-11839
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 2.7
Reporter: Roman Kondakov
Fix For: 2.8
Under some circumstances table join order changes may lead to incorrect result.
For example if one of joining tables is {{REPLICATED}} and another has
{{queryparallelism > 1}}.
This problem can be reproduced in test
{{IgniteSqlSegmentedIndexSelfTest#testSegmentedPartitionedWithReplicated}} if
swap tables {{Person}} and {{Organization}} in the method
{{IgniteSqlSegmentedIndexSelfTest#checkLocalQueryWithSegmentedIndex}} and set
{{enforceJoinOrder}} flag to {{true}}.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
