You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Isaac Zhu (Jira)" <ji...@apache.org> on 2021/02/03 06:52:00 UTC

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

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)