[IGNITE-14120] select count * returns multiple rows

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.8.1
• Fix Version/s: 2.12
• Component/s: sql
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Vladimir Ermakov
• Reporter: Isaac Zhu
• Reviewer: Konstantin Orlov
• Created: 03/Feb/21 06:51
• Updated: 18/Nov/21 05:58
• Resolved: 15/Jun/21 18:09

Description

I have a partitioned table which has 1 backup, the queryParallelism is set to 4.

The table primary key is column "ID", 

If I do this query:

        select count( * ) from my_table where ID = 1000;

It will return 4 rows:

        1
        0
        0
        0

 

If I query by other not primary-key columns of this table, the result is good, like:

        select count( *) from my_table where name = 'abcd'

result is:

        0

Issue Links

• links to: GitHub Pull Request #9164
• links to: TCBot