[jira] [Created] (IGNITE-13196) Greater than Where condition on secondary column in Primary key does not work when also filtering on primary column in primary key

["Andrew (Jira)" <ji...@apache.org>]

Andrew created IGNITE-13196:
-------------------------------

             Summary: Greater than Where condition on secondary column in Primary key does not work when also filtering on primary column in primary key
                 Key: IGNITE-13196
                 URL: https://issues.apache.org/jira/browse/IGNITE-13196
             Project: Ignite
          Issue Type: Bug
          Components: thin client
    Affects Versions: 2.8.1
         Environment: Windows 10
            Reporter: Andrew


Using the Java Thin Client when I try to use the SQL API, I have an issue where I am unable to query by both columns in a composite primary key when one of those conditions is a greater than condition.

 

For example if I create a table: "Create Table If Not Exists test (foo varchar, bar int, biz int, PRIMARY KEY( foo, bar))

And then insert the following data: INSERT INTO test VALUES ('key1', 1, 2), ('key2', 2, 3 )

 

The following queries return the same result (('key2', 2, 3)):

"Select * from test where foo = 'key2'"

"Select * from test where bar > 1"

 

However the following query returns no data:

"Select * from test where foo = 'key2' and bar > 1"

 

For reference each query is executed using: igniteClient.query( new SqlFieldsQuery( Query) ).getAll()

Could you help explain why this is happening and if there are any workarounds? 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)