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

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.8.1
• Component/s: thin client

Environment

Windows 10

• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Andrew
• Created: 29/Jun/20 22:03
• Updated: 29/Jun/20 22:03

Description

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?