Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9285

Select count(*) on spider table gives wrong result

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.0.21
    • N/A
    • Spider node: mariadb 10.0.21, spider version 3.2.21, so windows server 2007
      data nodes: mariadb 10.0.21, so RHEL 6.6

    Description

      I have a cluster with a master node running spider engine + 3 data nodes. I created a table (test_table)sharded on the three data nodes, with one (or more) secondary index. Running a select count(*) where ... from test_table on the spider node I have a result different from the sum of the same query executed directly on the three data nodes. Removing the secondary index from the table the query gives the right result.

      Attachments

        Activity

          People

            Unassigned Unassigned
            mauro.odino Mauro Odino
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.