[IGNITE-13765] Incorrect work of predicates (< and >) in where clause with compound primary key.

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 2.9, 2.8.1
• Fix Version/s: 2.10, 2.9.1
• Component/s: sql
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Konstantin Orlov
• Reporter: Ilya Kazakov
• Created: 26/Nov/20 03:04
• Updated: 01/Dec/20 09:32
• Resolved: 01/Dec/20 09:28

Description

The combination of these two conditions always gives an empty selection, but the result must not be empty.

• Compound primary key (2 or more columns)
• In select query in where clause use condition on every pk-column only once and one of this conditions should be < or > 

The reproducer is attached.

 

Issue Links

• links to: GitHub Pull Request #8510