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

Different results when change select in simple query

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.1.16
    • N/A
    • Optimizer

    Description

      Hi
      I run two query
      First
      SELECT id FROM employee ORDER BY first_name DESC LIMIT 1,1
      Result Id : 61394
      Second
      SELECT * FROM employee ORDER BY first_name DESC LIMIT 1,1
      Result Id : 128257

      Also when i run this queries
      SELECT id FROM employee ORDER BY first_name DESC LIMIT 20 OFFSET 0
      SELECT id FROM employee ORDER BY first_name DESC LIMIT 20 OFFSET 20
      Id 80129 exists in both query (id is primary key)

      The table is exist in attachment.

      Attachments

        1. employee.sql.gz
          4.10 MB
          masoud sabaghi

        Activity

          People

            Unassigned Unassigned
            masoud.sabaghi masoud sabaghi
            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.