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

Select query with 'where' and 'order by' on Spider engine table returns null records

    XMLWordPrintable

Details

    Description

      We created Spider engine table using partitioning by primary key.
      And tried to select from the table by query with 'WHERE' and 'ORDER BY' query.
      But returned result rows contain null value columns while such data does not exist.
      As I checked past issues , MDEV-6301 is simular issue.
      But it is checked as CLOSED.

      I attached reproducing script.
      If more information is necessary, please let me know.

      Attachments

        1. my.cnf
          2 kB
          Masanao Kitora
        2. result.txt
          2 kB
          Masanao Kitora
        3. spidertest.sql
          2 kB
          Masanao Kitora

        Activity

          People

            nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
            ktr Masanao Kitora
            Votes:
            0 Vote for this issue
            Watchers:
            6 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.