Isaac Zhu created IGNITE-14120:
----------------------------------

             Summary: select count * returns multiple rows
                 Key: IGNITE-14120
                 URL: https://issues.apache.org/jira/browse/IGNITE-14120
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.8.1
            Reporter: Isaac Zhu


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



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

Reply via email to