From issues-return-121124-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Wed Jun 16 12:18:04 2021 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mxout1-ec2-va.apache.org (mxout1-ec2-va.apache.org [3.227.148.255]) by mx-eu-01.ponee.io (Postfix) with ESMTPS id 48D6E18063B for ; Wed, 16 Jun 2021 14:18:04 +0200 (CEST) Received: from mail.apache.org (mailroute1-lw-us.apache.org [207.244.88.153]) by mxout1-ec2-va.apache.org (ASF Mail Server at mxout1-ec2-va.apache.org) with SMTP id 868264035F for ; Wed, 16 Jun 2021 12:18:03 +0000 (UTC) Received: (qmail 57033 invoked by uid 500); 16 Jun 2021 12:18:03 -0000 Mailing-List: contact issues-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ignite.apache.org Delivered-To: mailing list issues@ignite.apache.org Received: (qmail 56846 invoked by uid 99); 16 Jun 2021 12:18:02 -0000 Received: from mailrelay1-he-de.apache.org (HELO mailrelay1-he-de.apache.org) (116.203.21.61) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Jun 2021 12:18:02 +0000 Received: from jira2-he-de.apache.org (jira2-he-de.apache.org [168.119.33.54]) by mailrelay1-he-de.apache.org (ASF Mail Server at mailrelay1-he-de.apache.org) with ESMTPS id 0674F3E8D2 for ; Wed, 16 Jun 2021 12:18:01 +0000 (UTC) Received: from jira2-he-de.apache.org (localhost.localdomain [127.0.0.1]) by jira2-he-de.apache.org (ASF Mail Server at jira2-he-de.apache.org) with ESMTP id A9864C81590 for ; Wed, 16 Jun 2021 12:18:00 +0000 (UTC) Date: Wed, 16 Jun 2021 12:18:00 +0000 (UTC) From: "Peter Ivanov (Jira)" To: issues@ignite.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Assigned] (IGNITE-14120) select count * returns multiple rows MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/IGNITE-14120?page=3Dcom.atlass= ian.jira.plugin.system.issuetabpanels:all-tabpanel ] Peter Ivanov reassigned IGNITE-14120: ------------------------------------- Assignee: Vladimir Ermakov (was: Peter Ivanov) > 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 > Assignee: Vladimir Ermakov > Priority: Major > Time Spent: 1h 50m > Remaining Estimate: 0h > > I have a partitioned table which has 1 backup, the *queryParallelism* is = set to 4. > The table primary key is column "ID",=C2=A0 > If I do this query: > =C2=A0 =C2=A0 =C2=A0 =C2=A0 select count( * )=C2=A0from my_table where ID= =3D 1000; > It will return 4 rows: > =C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A01 > =C2=A0 =C2=A0 =C2=A0 =C2=A0 0 > =C2=A0 =C2=A0 =C2=A0 =C2=A0 0 > =C2=A0 =C2=A0 =C2=A0 =C2=A0 0 > =C2=A0 > If I query by other not primary-key columns of this table, the result is = good, like: > =C2=A0 =C2=A0 =C2=A0 =C2=A0 select count( *)=C2=A0from my_table where nam= e =3D 'abcd' > result is: > =C2=A0 =C2=A0 =C2=A0 =C2=A0 0 -- This message was sent by Atlassian Jira (v8.3.4#803005)