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

wrong result order when using SQL_BUFFER_RESULT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Won't Fix
    • 10.0.30-galera
    • N/A
    • Temporal Types
    • debian 3.16.39-1

    Description

      When using ORDER BY together with SQL_BUFFER_RESULT the result is often ordered the wrong way. When ommitting SQL_BUFFER_RESULT everything works fine.
      I tested this with different database engines like MyISAM, ARIA, InnoDB. All have the same miss behavior.
      It seems that the content of text fields influences the order of the result. Miss behavior could vanish by editing text fields of miss ordered items.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-2832 LP:992405 - Wrong result when using SQL_BUFFER_RESULT if min/max loose scan is chosen

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              elenst Elena Stepanova
              mannialb Manfred Albracht
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.