ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Kalashnikov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-5437) SQL: Incorrect partition is derived from query when argument type differs from column type
Date Wed, 07 Jun 2017 13:37:18 GMT
Sergey Kalashnikov created IGNITE-5437:
------------------------------------------

             Summary: SQL: Incorrect partition is derived from query when argument type differs
from column type
                 Key: IGNITE-5437
                 URL: https://issues.apache.org/jira/browse/IGNITE-5437
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.1
            Reporter: Sergey Kalashnikov
             Fix For: 2.1


Ignite SQL attempts to derive partition from the query in certain cases and sends the map
queries only to nodes which have those calculated partitions.
Such queries are limited to contain equality conditions over key or affinity key columns at
the left and constant or parameter at the right.
When the type of argument does not match the column type, the calculation leads to wrong result.

For example, the following query produces incomplete results when _key column is INTEGER and
the argument is CHAR. 

select * from test where _key = ?

However, this is valid and resultive query for H2, which does implicit conversion in such
cases.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message