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/04 02:31:00 UTC
[jira] [Updated] (IGNITE-14120) select count * returns multiple
rows
[ https://issues.apache.org/jira/browse/IGNITE-14120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Isaac Zhu updated IGNITE-14120:
-------------------------------
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
was:
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
> 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
> Priority: Major
>
> 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)