Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-14120

select count * returns multiple rows

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.8.1
    • Fix Version/s: None
    • Component/s: sql
    • Labels:
      None
    • Ignite Flags:
      Docs Required, Release Notes Required

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              nifeng2xing Isaac Zhu

              Dates

              • Created:
                Updated:

                Issue deployment