From issues-return-121072-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Tue Jun 15 17:22:02 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 90D3C18066B for ; Tue, 15 Jun 2021 19:22:02 +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 C66003EF0F for ; Tue, 15 Jun 2021 17:22:01 +0000 (UTC) Received: (qmail 47703 invoked by uid 500); 15 Jun 2021 17:22:01 -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 47688 invoked by uid 99); 15 Jun 2021 17:22:01 -0000 Received: from ec2-52-204-25-47.compute-1.amazonaws.com (HELO mailrelay1-ec2-va.apache.org) (52.204.25.47) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Jun 2021 17:22:01 +0000 Received: from jira2-he-de.apache.org (jira2-he-de.apache.org [168.119.33.54]) by mailrelay1-ec2-va.apache.org (ASF Mail Server at mailrelay1-ec2-va.apache.org) with ESMTPS id 7D5B33E8F2 for ; Tue, 15 Jun 2021 17:22: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 9203FC8067C for ; Tue, 15 Jun 2021 17:22:00 +0000 (UTC) Date: Tue, 15 Jun 2021 17:22:00 +0000 (UTC) From: "Ignite TC Bot (Jira)" To: issues@ignite.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (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.atlassi= an.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D17= 363798#comment-17363798 ]=20 Ignite TC Bot commented on IGNITE-14120: ---------------------------------------- {panel:title=3DBranch: [pull/9164/head] Base: [master] : No blockers found!= |borderStyle=3Ddashed|borderColor=3D#ccc|titleBGColor=3D#D6F7C1}{panel} {panel:title=3DBranch: [pull/9164/head] Base: [master] : New Tests (3)|bord= erStyle=3Ddashed|borderColor=3D#ccc|titleBGColor=3D#D6F7C1} {color:#00008b}Continuous Query 4{color} [[tests 3|https://ci.ignite.apache= .org/viewLog.html?buildId=3D6048731]] * {color:#013220}IgniteCacheQuerySelfTestSuite6: IgniteSqlSinglePartitionMu= ltiParallelismTest.testSimpleCountQuery - PASSED{color} * {color:#013220}IgniteCacheQuerySelfTestSuite6: IgniteSqlSinglePartitionMu= ltiParallelismTest.testWhereCountMultiPartitionsQuery - PASSED{color} * {color:#013220}IgniteCacheQuerySelfTestSuite6: IgniteSqlSinglePartitionMu= ltiParallelismTest.testWhereCountFirstPartitionQuery - PASSED{color} {panel} [TeamCity *--> Run :: All* Results|https://ci.ignite.apache.org/viewLog.= html?buildId=3D6048766&buildTypeId=3DIgniteTests24Java8_RunAll] > 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 40m > 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)