[jira] [Created] (IGNITE-14120) select count * returns multiple rows

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (IGNITE-14120) select count * returns multiple rows

Anton Vinogradov (Jira)
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)