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

Query returns wrong number of records

    XMLWordPrintable

    Details

      Description

      Attached query started to return wrong number of records after update to 10.9.2 from 10.8.3 (10.8.4 also fails, didn't tested other 10.x supported branches).

      Looked through release notes and don't see anything that could cause it from changes description.

      Query itself doesn't have any practical use for us, just one of test cases and works correctly for at least 6 other RDBMS

        Attachments

        1. bad-result.txt
          1 kB
        2. data.sql
          0.4 kB
        3. good-result.txt
          1 kB
        4. query.sql
          0.9 kB

          Activity

            People

            Assignee:
            psergei Sergei Petrunia
            Reporter:
            dluk Dmitry
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.