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
        2. result.txt
          2 kB
        3. spidertest.sql
          2 kB

          Activity

            People

            Assignee:
            nayuta-yanagisawa Nayuta Yanagisawa
            Reporter:
            ktr Masanao Kitora
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration