[jira] [Created] (IGNITE-5437) SQL: Incorrect partition is derived from query when argument type differs from column type

["Sergey Kalashnikov (JIRA)" <ji...@apache.org>]

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)