ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Roman Kondakov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-11839) SQL: table join order changes may lead to incorrect result
Date Tue, 07 May 2019 16:00:04 GMT
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)

Mime
View raw message