ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ignite TC Bot (Jira)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-14120) select count * returns multiple rows
Date Tue, 15 Jun 2021 17:22:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-14120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17363798#comment-17363798
] 

Ignite TC Bot commented on IGNITE-14120:
----------------------------------------

{panel:title=Branch: [pull/9164/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/9164/head] Base: [master] : New Tests (3)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Continuous Query 4{color} [[tests 3|https://ci.ignite.apache.org/viewLog.html?buildId=6048731]]
* {color:#013220}IgniteCacheQuerySelfTestSuite6: IgniteSqlSinglePartitionMultiParallelismTest.testSimpleCountQuery
- PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6: IgniteSqlSinglePartitionMultiParallelismTest.testWhereCountMultiPartitionsQuery
- PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6: IgniteSqlSinglePartitionMultiParallelismTest.testWhereCountFirstPartitionQuery
- PASSED{color}

{panel}
[TeamCity *--&gt; Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=6048766&amp;buildTypeId=IgniteTests24Java8_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", 
> 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)

Mime
View raw message