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

Spider Order By column[datatime] limit 5 returns 3 rows

    XMLWordPrintable

Details

    Description

      when quering with innodb table:
      SELECT *
      FROM phms_family
      WHERE region_code LIKE "%510411106%"
      AND region = 510411
      AND delete_status != 1
      ORDER BY update_date LIMIT 5 OFFSET 1
      return 5 rows;
      but spider table ,return 3 rows;
      update_date is a datatime column, with null field.

      Attachments

        1. phms_family_spider_dll.sql
          3 kB
          LostInForest
        2. phms_family.sql
          4.08 MB
          LostInForest

        Activity

          People

            jacob-mathew Jacob Mathew (Inactive)
            LIFMaDBRp LostInForest
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.